APPS.PO_CREATE_ISO dependencies on MTL_SYSTEM_ITEMS

Line 610: MTL_SYSTEM_ITEMS SI,

606: , decode(RL.URGENT_FLAG,'Y', fnd_profile.value('POR_URGENT_FLAG_SHIPMENT_PRIORITY_CODE'),null)
607: FROM PO_REQUISITION_LINES RL,
608: PO_REQUISITION_HEADERS RH,
609: PO_REQ_DISTRIBUTIONS RD, --only one distribution allowed!
610: MTL_SYSTEM_ITEMS SI,
611: PO_LOCATION_ASSOCIATIONS_ALL LA,
612: MTL_UNITS_OF_MEASURE MUM
613: --,MTL_UNITS_OF_MEASURE MUM1
614: WHERE RL.REQUISITION_LINE_ID = RD.REQUISITION_LINE_ID

Line 966: FROM mtl_system_items

962: x_progress := '020';
963:
964: SELECT primary_unit_of_measure
965: INTO x_primary_uom
966: FROM mtl_system_items
967: WHERE inventory_item_id = x_item_id
968: AND organization_id = x_organization_id;
969:
970: /*