APPS.CSP_EXCESS_PARTS_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 208: mtl_system_items_b msib

204: select distinct moq.inventory_item_id,
205: nvl(msib.max_minmax_quantity,0) max,
206: revision_qty_control_code
207: from mtl_onhand_quantities_detail moq,
208: mtl_system_items_b msib
209: where moq.organization_id = p_organization_id
210: and msib.organization_id = moq.organization_id
211: and msib.inventory_item_id = moq.inventory_item_id
212: and nvl(msib.INVENTORY_PLANNING_CODE,6) = 6;

Line 240: mtl_system_items_b msib

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

Line 877: mtl_system_items_b msib

873: cursor org_max_value is
874: select sum(msib.max_minmax_quantity * NVL(ITEM_COST,0))
875: from CST_ITEM_COSTS cic,
876: CST_COST_TYPES cct,
877: mtl_system_items_b msib
878: where msib.organization_id = p_organization_id
879: and cic.ORGANIZATION_ID = msib.organization_id
880: and cic.inventory_item_id = msib.inventory_item_id
881: and cic.COST_TYPE_ID = cct.COST_TYPE_ID

Line 903: mtl_system_items_b msib

899: select cel.excess_line_id,
900: cel.excess_quantity,
901: msib.max_minmax_quantity
902: from csp_excess_lists cel,
903: mtl_system_items_b msib
904: where cel.organization_id = p_organization_id
905: and cel.organization_id = msib.organization_id
906: and cel.inventory_item_id = msib.inventory_item_id
907: and cel.excess_status = 'P';