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 1737: FROM mtl_item_revisions mir

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

Line 1744: FROM mtl_item_revisions mir1

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