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.CTO_CHANGE_ORDER_PK dependencies on MTL_SYSTEM_ITEMS_VL

Line 1429: FROM mtl_system_items_vl item,

1425: -- bug 7447357.pdube Tue Oct 21 04:31:34 PDT 2008
1426: -- Introdcued this to get a unique user name
1427: CURSOR get_planner_user_name(inv_item_id NUMBER,ship_org_id NUMBER) IS
1428: SELECT u.user_name
1429: FROM mtl_system_items_vl item,
1430: mtl_planners p,
1431: fnd_user u
1432: WHERE item.inventory_item_id = inv_item_id
1433: and item.organization_id = ship_org_id

Line 1850: FROM mtl_system_items_vl item

1846: -- Bug 7447357.pdube Tue Oct 21 04:31:34 PDT 2008.
1847: -- getting the value for user_name in the variable.
1848: /*SELECT u.user_name
1849: INTO lplanner_code
1850: FROM mtl_system_items_vl item
1851: ,mtl_planners p
1852: ,fnd_user u
1853: WHERE item.inventory_item_id = linv_item_id
1854: and item.organization_id = lship_org_id