Modification for CMO List

Regarding the CMO list,

We identified 2 sources of CMO list, ECC (list maintain site legal entity) and SMS (list maintain actual site location). They are Many to Many relationship

i.e.  It can be 1 legal entity site names linked with 3 different SMS site location. OR 2 legal entity site name linked with 4 SMS site location.

So  we have 2 issues now.

1. To confirm the list of CMO need to add in OpU hierarchy.

We will have a call to discuss with External supply team to confirm the list of CMO need to add.

Most likely, we will add the ECC list with legal entity in the OpU hierarchy.

1. To add SMS site list in PAC

If we confirmed to add ECC site list, Vanesa requests to have add the SMS (actual site location) as well as part of the PAC information, so when user create PAC, after they select the Originating site ( legal entity), they can also pick the actual site from SMS list.

Table name: PGSUDH_CDM.ECC_SUPPLIER_QUALIFICATION