771: -----------------------------------------------------------------
772: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
773: SET UAI.ORGANIZATION_ID =
774: (SELECT MP.ORGANIZATION_ID
775: FROM MTL_PARAMETERS MP
776: WHERE MP.ORGANIZATION_CODE = UAI.ORGANIZATION_CODE)
777: WHERE UAI.DATA_SET_ID = p_data_set_id
778: AND UAI.PROCESS_STATUS = G_PS_IN_PROCESS
779: AND UAI.ORGANIZATION_CODE IS NOT NULL
778: AND UAI.PROCESS_STATUS = G_PS_IN_PROCESS
779: AND UAI.ORGANIZATION_CODE IS NOT NULL
780: AND UAI.ORGANIZATION_ID IS NULL;
781: /* AND EXISTS (SELECT MP2.ORGANIZATION_ID
782: FROM MTL_PARAMETERS MP2
783: WHERE MP2.ORGANIZATION_CODE = UAI.ORGANIZATION_CODE
784: AND ((UAI.REVISION_ID IS NOT NULL
785: OR
786: UAI.REVISION IS NOT NULL)
1255: AND UAI2.PROCESS_STATUS = G_PS_IN_PROCESS
1256: AND UAI2.ORGANIZATION_ID IS NOT NULL
1257: AND NOT EXISTS
1258: (SELECT 'X'
1259: FROM MTL_PARAMETERS MP
1260: WHERE MP.ORGANIZATION_ID = UAI2.ORGANIZATION_ID
1261: AND (UAI2.REVISION_ID IS NOT NULL
1262: OR
1263: UAI2.REVISION IS NOT NULL
1355: WHERE UAI.DATA_SET_ID = p_data_set_id
1356: AND UAI.PROCESS_STATUS = G_PS_IN_PROCESS
1357: AND UAI.DATA_LEVEL_ID IN (43101, 43103,43104,43107,43108)
1358: AND EXISTS (SELECT MP2.ORGANIZATION_ID
1359: FROM MTL_PARAMETERS MP2
1360: WHERE MP2.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1361: AND MP2.ORGANIZATION_ID <> MP2.MASTER_ORGANIZATION_ID);
1362:
1363: