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_ITEM_SUB_INVENTORIES

Line 239: mtl_item_sub_inventories misi,

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
243: and misi.organization_id(+) = mosv.organization_id

Line 889: mtl_item_sub_inventories misi

885: cursor sub_max_value is
886: select sum(misi.max_minmax_quantity * nvl(cic.item_cost,0))
887: from cst_item_costs cic,
888: cst_cost_types cct,
889: mtl_item_sub_inventories misi
890: where misi.organization_id = p_organization_id
891: and misi.secondary_inventory = p_subinventory_code
892: and cic.organization_id = misi.organization_id
893: and cic.inventory_item_id = misi.inventory_item_id

Line 914: mtl_item_sub_inventories misi

910: select cel.excess_line_id,
911: cel.excess_quantity,
912: misi.max_minmax_quantity
913: from csp_excess_lists cel,
914: mtl_item_sub_inventories misi
915: where cel.organization_id = p_organization_id
916: and cel.organization_id = misi.organization_id
917: and cel.subinventory_code = misi.secondary_inventory
918: and cel.inventory_item_id = misi.inventory_item_id