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

Line 2818: FROM mtl_item_revisions mir

2814: IF l_item_rev_ctl = 2
2815: THEN
2816: SELECT MAX(revision)
2817: INTO l_item_revision
2818: FROM mtl_item_revisions mir
2819: WHERE inventory_item_id = p_item_id
2820: AND organization_id = l_orgn_id
2821: AND effectivity_date < SYSDATE
2822: AND effectivity_date =

Line 2825: FROM mtl_item_revisions mir1

2821: AND effectivity_date < SYSDATE
2822: AND effectivity_date =
2823: (
2824: SELECT MAX(effectivity_date)
2825: FROM mtl_item_revisions mir1
2826: WHERE mir1.inventory_item_id = mir.inventory_item_id
2827: AND mir1.organization_id = mir.organization_id
2828: AND effectivity_date < SYSDATE
2829: );