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 1409: FROM mtl_system_items_vl item,

1405: -- bug 7447357.pdube Tue Oct 21 04:31:34 PDT 2008
1406: -- Introdcued this to get a unique user name
1407: CURSOR get_planner_user_name(inv_item_id NUMBER,ship_org_id NUMBER) IS
1408: SELECT u.user_name
1409: FROM mtl_system_items_vl item,
1410: mtl_planners p,
1411: fnd_user u
1412: WHERE item.inventory_item_id = inv_item_id
1413: and item.organization_id = ship_org_id

Line 1649: FROM mtl_system_items_vl item

1645: -- Bug 7447357.pdube Tue Oct 21 04:31:34 PDT 2008.
1646: -- getting the value for user_name in the variable.
1647: /*SELECT u.user_name
1648: INTO lplanner_code
1649: FROM mtl_system_items_vl item
1650: ,mtl_planners p
1651: ,fnd_user u
1652: WHERE item.inventory_item_id = linv_item_id
1653: and item.organization_id = lship_org_id