APPS.CSP_EXCESS_PARTS_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 206: mtl_system_items_b msib

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

Line 238: mtl_system_items_b msib

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

Line 787: mtl_system_items_b msib

783: cursor org_max_value is
784: select sum(msib.max_minmax_quantity * NVL(ITEM_COST,0))
785: from CST_ITEM_COSTS cic,
786: CST_COST_TYPES cct,
787: mtl_system_items_b msib
788: where msib.organization_id = p_organization_id
789: and cic.ORGANIZATION_ID = msib.organization_id
790: and cic.inventory_item_id = msib.inventory_item_id
791: and cic.COST_TYPE_ID = cct.COST_TYPE_ID

Line 813: mtl_system_items_b msib

809: select cel.excess_line_id,
810: cel.excess_quantity,
811: msib.max_minmax_quantity
812: from csp_excess_lists cel,
813: mtl_system_items_b msib
814: where cel.organization_id = p_organization_id
815: and cel.organization_id = msib.organization_id
816: and cel.inventory_item_id = msib.inventory_item_id
817: and cel.excess_status = 'P';