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 238: from mtl_onhand_sub_v mosv,

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

Line 1126: from mtl_onhand_sub_v mosv,

1122: select mosv.organization_id,
1123: mosv.subinventory_code,
1124: mosv.inventory_item_id,
1125: total_qoh excess_quantity
1126: from mtl_onhand_sub_v mosv,
1127: csp_sec_inventories csin
1128: where mosv.organization_id = p_organization_id
1129: and csin.organization_id = mosv.organization_id
1130: and csin.secondary_inventory_name = mosv.subinventory_code