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_EXCESS_PARTS_PVT dependencies on MTL_ONHAND_SUB_V

Line 236: from mtl_onhand_sub_v mosv,

232: cursor c_sub_items(c_subinventory_code varchar2) is
233: select mosv.inventory_item_id,
234: nvl(misi.max_minmax_quantity,0) max,
235: msib.revision_qty_control_code
236: from mtl_onhand_sub_v mosv,
237: mtl_item_sub_inventories misi,
238: mtl_system_items_b msib
239: where mosv.organization_id = p_organization_id
240: and mosv.subinventory_code = c_subinventory_code

Line 1036: from mtl_onhand_sub_v mosv,

1032: select mosv.organization_id,
1033: mosv.subinventory_code,
1034: mosv.inventory_item_id,
1035: total_qoh excess_quantity
1036: from mtl_onhand_sub_v mosv,
1037: csp_sec_inventories csin
1038: where mosv.organization_id = p_organization_id
1039: and csin.organization_id = mosv.organization_id
1040: and csin.secondary_inventory_name = mosv.subinventory_code