APPS.EGO_IMPORT_UTIL_PVT dependencies on MTL_ITEM_REVISIONS_B

Line 245: FROM MTL_ITEM_REVISIONS_B MIRB

241: Debug_Conc_Log('Resolve_PKs_For_Child: Updated Intersections '||SQL%ROWCOUNT);
242:
243: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
244: SET REVISION_ID = NVL((SELECT REVISION_ID
245: FROM MTL_ITEM_REVISIONS_B MIRB
246: WHERE MIRB.INVENTORY_ITEM_ID = EIUAI.INVENTORY_ITEM_ID
247: AND MIRB.ORGANIZATION_ID = EIUAI.ORGANIZATION_ID
248: AND MIRB.REVISION = EIUAI.REVISION
249: ),

Line 661: FROM MTL_ITEM_REVISIONS_B MIRB

657: NULL AS PK4_VALUE,
658: NULL AS PK5_VALUE,
659: (CASE WHEN MIRI.REVISION_Id IS NULL
660: THEN (SELECT Max(REVISION_ID)
661: FROM MTL_ITEM_REVISIONS_B MIRB
662: WHERE MIRB.EFFECTIVITY_DATE <= SYSDATE
663: AND MIRB.INVENTORY_ITEM_ID = MSII.INVENTORY_ITEM_ID
664: AND MIRB.ORGANIZATION_ID = MSII.ORGANIZATION_ID
665: )

Line 2259: FROM MTL_ITEM_REVISIONS_B mirb

2255: AND msii.ORGANIZATION_ID = mp.ORGANIZATION_ID
2256: AND mp.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
2257: AND ext_prod.DATA_LEVEL_ID = #' || l_item_rev_dl_id || q'#
2258: AND ext_prod.REVISION_ID = (SELECT MAX(REVISION_ID)
2259: FROM MTL_ITEM_REVISIONS_B mirb
2260: WHERE mirb.EFFECTIVITY_DATE <= SYSDATE
2261: AND mirb.INVENTORY_ITEM_ID = ext_prod.INVENTORY_ITEM_ID
2262: AND mirb.ORGANIZATION_ID = ext_prod.ORGANIZATION_ID
2263: )

Line 2287: FROM MTL_ITEM_REVISIONS_B mirb

2283: AND msii.ORGANIZATION_ID = mp.ORGANIZATION_ID
2284: AND mp.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
2285: AND ext_prod.DATA_LEVEL_ID = #' || l_item_rev_dl_id || q'#
2286: AND ext_prod.REVISION_ID = (SELECT MAX(REVISION_ID)
2287: FROM MTL_ITEM_REVISIONS_B mirb
2288: WHERE mirb.EFFECTIVITY_DATE <= SYSDATE
2289: AND mirb.INVENTORY_ITEM_ID = ext_prod.INVENTORY_ITEM_ID
2290: AND mirb.ORGANIZATION_ID = ext_prod.ORGANIZATION_ID
2291: )

Line 2365: FROM MTL_ITEM_REVISIONS_B mirb

2361: AND miri.INVENTORY_ITEM_ID = ext_prod.INVENTORY_ITEM_ID
2362: AND miri.ORGANIZATION_ID = ext_prod.ORGANIZATION_ID
2363: AND ext_prod.DATA_LEVEL_ID = #' || l_item_rev_dl_id || q'#
2364: AND ext_prod.REVISION_ID = (SELECT MAX(REVISION_ID)
2365: FROM MTL_ITEM_REVISIONS_B mirb
2366: WHERE mirb.EFFECTIVITY_DATE <= SYSDATE
2367: AND mirb.INVENTORY_ITEM_ID = ext_prod.INVENTORY_ITEM_ID
2368: AND mirb.ORGANIZATION_ID = ext_prod.ORGANIZATION_ID
2369: )

Line 2390: FROM MTL_ITEM_REVISIONS_B mirb

2386: AND miri.INVENTORY_ITEM_ID = ext_prod.INVENTORY_ITEM_ID
2387: AND miri.ORGANIZATION_ID = ext_prod.ORGANIZATION_ID
2388: AND ext_prod.DATA_LEVEL_ID = #' || l_item_rev_dl_id || q'#
2389: AND ext_prod.REVISION_ID = (SELECT MAX(REVISION_ID)
2390: FROM MTL_ITEM_REVISIONS_B mirb
2391: WHERE mirb.EFFECTIVITY_DATE <= SYSDATE
2392: AND mirb.INVENTORY_ITEM_ID = ext_prod.INVENTORY_ITEM_ID
2393: AND mirb.ORGANIZATION_ID = ext_prod.ORGANIZATION_ID
2394: )

Line 4999: FROM MTL_ITEM_REVISIONS_B mirb

4995: msii.INVENTORY_ITEM_ID AS DEST_ITEM_ID,
4996: msii.ORGANIZATION_ID,
4997: msii.STYLE_ITEM_ID AS SOURCE_ITEM_ID,
4998: (SELECT MAX(mirb.REVISION_ID)
4999: FROM MTL_ITEM_REVISIONS_B mirb
5000: WHERE mirb.INVENTORY_ITEM_ID = msii.STYLE_ITEM_ID
5001: AND mirb.ORGANIZATION_ID = msii.ORGANIZATION_ID
5002: AND mirb.EFFECTIVITY_DATE <= SYSDATE
5003: ) AS SOURCE_REVISION_ID,

Line 5005: FROM MTL_ITEM_REVISIONS_B mirb

5001: AND mirb.ORGANIZATION_ID = msii.ORGANIZATION_ID
5002: AND mirb.EFFECTIVITY_DATE <= SYSDATE
5003: ) AS SOURCE_REVISION_ID,
5004: (SELECT MAX(mirb.REVISION_ID)
5005: FROM MTL_ITEM_REVISIONS_B mirb
5006: WHERE mirb.INVENTORY_ITEM_ID = msii.INVENTORY_ITEM_ID
5007: AND mirb.ORGANIZATION_ID = msii.ORGANIZATION_ID
5008: AND mirb.EFFECTIVITY_DATE <= SYSDATE
5009: ) AS DEST_REVISION_ID