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.CSTPPINV dependencies on MTL_SYSTEM_ITEMS

Line 2309: FROM mtl_system_items

2305: l_stmt_num := 10;
2306:
2307: SELECT primary_uom_code
2308: INTO o_from_uom
2309: FROM mtl_system_items
2310: WHERE organization_id = i_from_org
2311: AND inventory_item_id = i_item_id;
2312:
2313: l_stmt_num := 20;

Line 2317: FROM mtl_system_items

2313: l_stmt_num := 20;
2314:
2315: SELECT primary_uom_code
2316: INTO o_to_uom
2317: FROM mtl_system_items
2318: WHERE organization_id = i_to_org
2319: AND inventory_item_id = i_item_id;
2320:
2321: EXCEPTION

Line 2785: FROM mtl_system_items

2781:
2782:
2783: SELECT inventory_asset_flag
2784: INTO l_asset_item
2785: FROM mtl_system_items
2786: WHERE inventory_item_id = i_item_id AND organization_id = i_txn_org_id;
2787:
2788:
2789: IF (l_asset_item = 'Y') THEN