926: -----------------------------------------------------------------
927: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
928: SET UAI.ORGANIZATION_ID =
929: (SELECT MP.ORGANIZATION_ID
930: FROM MTL_PARAMETERS MP
931: WHERE MP.ORGANIZATION_CODE = UAI.ORGANIZATION_CODE)
932: WHERE UAI.DATA_SET_ID = p_data_set_id
933: AND UAI.PROCESS_STATUS = G_PS_IN_PROCESS
934: AND UAI.ORGANIZATION_CODE IS NOT NULL
933: AND UAI.PROCESS_STATUS = G_PS_IN_PROCESS
934: AND UAI.ORGANIZATION_CODE IS NOT NULL
935: AND UAI.ORGANIZATION_ID IS NULL;
936: /* AND EXISTS (SELECT MP2.ORGANIZATION_ID
937: FROM MTL_PARAMETERS MP2
938: WHERE MP2.ORGANIZATION_CODE = UAI.ORGANIZATION_CODE
939: AND ((UAI.REVISION_ID IS NOT NULL
940: OR
941: UAI.REVISION IS NOT NULL)
1548: AND UAI2.PROCESS_STATUS = G_PS_IN_PROCESS
1549: AND UAI2.ORGANIZATION_ID IS NOT NULL
1550: AND NOT EXISTS
1551: (SELECT 'X'
1552: FROM MTL_PARAMETERS MP
1553: WHERE MP.ORGANIZATION_ID = UAI2.ORGANIZATION_ID
1554: AND (UAI2.REVISION_ID IS NOT NULL
1555: OR
1556: UAI2.REVISION IS NOT NULL
1676: WHERE UAI.DATA_SET_ID = p_data_set_id
1677: AND UAI.PROCESS_STATUS = G_PS_IN_PROCESS
1678: AND UAI.DATA_LEVEL_ID IN (43101, 43103,43104,43107,43108)
1679: AND EXISTS (SELECT MP2.ORGANIZATION_ID
1680: FROM MTL_PARAMETERS MP2
1681: WHERE MP2.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1682: AND MP2.ORGANIZATION_ID <> MP2.MASTER_ORGANIZATION_ID);
1683:
1684: