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 237: mtl_item_sub_inventories misi,

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

Line 799: mtl_item_sub_inventories misi

795: cursor sub_max_value is
796: select sum(misi.max_minmax_quantity * nvl(cic.item_cost,0))
797: from cst_item_costs cic,
798: cst_cost_types cct,
799: mtl_item_sub_inventories misi
800: where misi.organization_id = p_organization_id
801: and misi.secondary_inventory = p_subinventory_code
802: and cic.organization_id = misi.organization_id
803: and cic.inventory_item_id = misi.inventory_item_id

Line 824: mtl_item_sub_inventories misi

820: select cel.excess_line_id,
821: cel.excess_quantity,
822: misi.max_minmax_quantity
823: from csp_excess_lists cel,
824: mtl_item_sub_inventories misi
825: where cel.organization_id = p_organization_id
826: and cel.organization_id = misi.organization_id
827: and cel.subinventory_code = misi.secondary_inventory
828: and cel.inventory_item_id = misi.inventory_item_id