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.WIP_WOL_PROCESSOR dependencies on MTL_ITEM_REVISIONS

Line 11: FROM mtl_item_revisions mir

7: UPDATE wip_lpn_completions wlc
8: SET last_update_date = SYSDATE,
9: bom_revision =
10: (SELECT NVL(wlc.bom_revision, MAX(mir.revision))
11: FROM mtl_item_revisions mir
12: WHERE mir.organization_id = wlc.organization_id
13: AND mir.inventory_item_id = wlc.inventory_item_id
14: AND mir.effectivity_date <= SYSDATE
15: AND mir.effectivity_date =

Line 17: FROM mtl_item_revisions mir2

13: AND mir.inventory_item_id = wlc.inventory_item_id
14: AND mir.effectivity_date <= SYSDATE
15: AND mir.effectivity_date =
16: (SELECT MAX(mir2.effectivity_date)
17: FROM mtl_item_revisions mir2
18: WHERE mir2.organization_id = wlc.organization_id
19: AND mir2.inventory_item_id = wlc.inventory_item_id
20: AND mir2.effectivity_date <= SYSDATE))
21: WHERE p_header_id = source_id