eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_IMPORT_UTIL_PVT dependencies on MTL_ITEM_REVISIONS_B

Line 295: FROM MTL_ITEM_REVISIONS_B MIRB

291: Debug_Conc_Log('Resolve_PKs_For_Child: Updated Intersections '||SQL%ROWCOUNT);
292:
293: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
294: SET REVISION_ID = NVL((SELECT REVISION_ID
295: FROM MTL_ITEM_REVISIONS_B MIRB
296: WHERE MIRB.INVENTORY_ITEM_ID = EIUAI.INVENTORY_ITEM_ID
297: AND MIRB.ORGANIZATION_ID = EIUAI.ORGANIZATION_ID
298: AND MIRB.REVISION = EIUAI.REVISION
299: ),

Line 742: FROM MTL_ITEM_REVISIONS_B mirb1

738: NULL AS PK5_VALUE,
739: (CASE WHEN MIRI.REVISION_Id IS NULL
740: THEN (SELECT Max(revision_id) FROM
741: (SELECT revision_id, INVENTORY_ITEM_ID, ORGANIZATION_ID, dense_rank() over (PARTITION BY INVENTORY_ITEM_ID, ORGANIZATION_ID ORDER BY EFFECTIVITY_DATE DESC ) dr
742: FROM MTL_ITEM_REVISIONS_B mirb1
743: WHERE mirb1.EFFECTIVITY_DATE <= SYSDATE )
744: WHERE INVENTORY_ITEM_ID = MSII.INVENTORY_ITEM_ID
745: AND ORGANIZATION_ID = MSII.ORGANIZATION_ID
746: AND dr =1

Line 2435: FROM MTL_ITEM_REVISIONS_B mirb1

2431: AND mp.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
2432: AND ext_prod.DATA_LEVEL_ID = #' || l_item_rev_dl_id || q'#
2433: AND ext_prod.REVISION_ID = (SELECT Max(revision_id) FROM
2434: (SELECT revision_id, INVENTORY_ITEM_ID, ORGANIZATION_ID, dense_rank() over (PARTITION BY INVENTORY_ITEM_ID, ORGANIZATION_ID ORDER BY EFFECTIVITY_DATE DESC ) dr
2435: FROM MTL_ITEM_REVISIONS_B mirb1
2436: WHERE mirb1.EFFECTIVITY_DATE <= SYSDATE )
2437: WHERE INVENTORY_ITEM_ID = ext_prod.INVENTORY_ITEM_ID
2438: AND ORGANIZATION_ID = ext_prod.ORGANIZATION_ID
2439: AND dr =1

Line 2465: FROM MTL_ITEM_REVISIONS_B mirb1

2461: AND mp.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
2462: AND ext_prod.DATA_LEVEL_ID = #' || l_item_rev_dl_id || q'#
2463: AND ext_prod.REVISION_ID = (SELECT Max(revision_id) FROM
2464: (SELECT revision_id, INVENTORY_ITEM_ID, ORGANIZATION_ID, dense_rank() over (PARTITION BY INVENTORY_ITEM_ID, ORGANIZATION_ID ORDER BY EFFECTIVITY_DATE DESC ) dr
2465: FROM MTL_ITEM_REVISIONS_B mirb1
2466: WHERE mirb1.EFFECTIVITY_DATE <= SYSDATE )
2467: WHERE INVENTORY_ITEM_ID = ext_prod.INVENTORY_ITEM_ID
2468: AND ORGANIZATION_ID = ext_prod.ORGANIZATION_ID
2469: AND dr =1

Line 2551: FROM MTL_ITEM_REVISIONS_B mirb1

2547: AND miri.ORGANIZATION_ID = ext_prod.ORGANIZATION_ID
2548: AND ext_prod.DATA_LEVEL_ID = #' || l_item_rev_dl_id || q'#
2549: AND ext_prod.REVISION_ID = (SELECT Max(revision_id) FROM
2550: (SELECT revision_id, INVENTORY_ITEM_ID, ORGANIZATION_ID, dense_rank() over (PARTITION BY INVENTORY_ITEM_ID, ORGANIZATION_ID ORDER BY EFFECTIVITY_DATE DESC ) dr
2551: FROM MTL_ITEM_REVISIONS_B mirb1
2552: WHERE mirb1.EFFECTIVITY_DATE <= SYSDATE )
2553: WHERE INVENTORY_ITEM_ID = ext_prod.INVENTORY_ITEM_ID
2554: AND ORGANIZATION_ID = ext_prod.ORGANIZATION_ID
2555: AND dr =1

Line 2578: FROM MTL_ITEM_REVISIONS_B mirb1

2574: AND miri.ORGANIZATION_ID = ext_prod.ORGANIZATION_ID
2575: AND ext_prod.DATA_LEVEL_ID = #' || l_item_rev_dl_id || q'#
2576: AND ext_prod.REVISION_ID = (SELECT Max(revision_id) FROM
2577: (SELECT revision_id, INVENTORY_ITEM_ID, ORGANIZATION_ID, dense_rank() over (PARTITION BY INVENTORY_ITEM_ID, ORGANIZATION_ID ORDER BY EFFECTIVITY_DATE DESC ) dr
2578: FROM MTL_ITEM_REVISIONS_B mirb1
2579: WHERE mirb1.EFFECTIVITY_DATE <= SYSDATE )
2580: WHERE INVENTORY_ITEM_ID = ext_prod.INVENTORY_ITEM_ID
2581: AND ORGANIZATION_ID = ext_prod.ORGANIZATION_ID
2582: AND dr =1

Line 5749: FROM MTL_ITEM_REVISIONS_B mirb

5745: msii.INVENTORY_ITEM_ID AS DEST_ITEM_ID,
5746: msii.ORGANIZATION_ID,
5747: msii.STYLE_ITEM_ID AS SOURCE_ITEM_ID,
5748: (SELECT MAX(mirb.REVISION_ID)
5749: FROM MTL_ITEM_REVISIONS_B mirb
5750: WHERE mirb.INVENTORY_ITEM_ID = msii.STYLE_ITEM_ID
5751: AND mirb.ORGANIZATION_ID = msii.ORGANIZATION_ID
5752: AND mirb.EFFECTIVITY_DATE <= SYSDATE
5753: ) AS SOURCE_REVISION_ID,

Line 5755: FROM MTL_ITEM_REVISIONS_B mirb

5751: AND mirb.ORGANIZATION_ID = msii.ORGANIZATION_ID
5752: AND mirb.EFFECTIVITY_DATE <= SYSDATE
5753: ) AS SOURCE_REVISION_ID,
5754: (SELECT MAX(mirb.REVISION_ID)
5755: FROM MTL_ITEM_REVISIONS_B mirb
5756: WHERE mirb.INVENTORY_ITEM_ID = msii.INVENTORY_ITEM_ID
5757: AND mirb.ORGANIZATION_ID = msii.ORGANIZATION_ID
5758: AND mirb.EFFECTIVITY_DATE <= SYSDATE
5759: ) AS DEST_REVISION_ID