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_PLANNER_NOTIFICATIONS dependencies on MTL_ITEM_REVISIONS

Line 1734: FROM mtl_item_revisions mir

1730: OR ((p_pur_revision IS NULL) AND ( item_rev_ctl = 2)))
1731: THEN
1732: SELECT MAX(revision)
1733: INTO item_rev
1734: FROM mtl_item_revisions mir
1735: WHERE inventory_item_id = item_id
1736: AND organization_id = orgn_id
1737: AND effectivity_date < SYSDATE
1738: AND effectivity_date =

Line 1741: FROM mtl_item_revisions mir1

1737: AND effectivity_date < SYSDATE
1738: AND effectivity_date =
1739: (
1740: SELECT MAX(effectivity_date)
1741: FROM mtl_item_revisions mir1
1742: WHERE mir1.inventory_item_id = mir.inventory_item_id
1743: AND mir1.organization_id = mir.organization_id
1744: AND effectivity_date < SYSDATE
1745: );