APPS.PO_CREATE_ISO dependencies on MTL_SYSTEM_ITEMS

Line 742: MTL_SYSTEM_ITEMS SI,

738: , decode(RL.URGENT_FLAG,'Y', fnd_profile.value('POR_URGENT_FLAG_SHIPMENT_PRIORITY_CODE'),null)
739: FROM PO_REQUISITION_LINES RL,
740: PO_REQUISITION_HEADERS RH,
741: PO_REQ_DISTRIBUTIONS RD, --only one distribution allowed!
742: MTL_SYSTEM_ITEMS SI,
743: PO_LOCATION_ASSOCIATIONS_ALL LA,
744: MTL_UNITS_OF_MEASURE MUM
745: --,MTL_UNITS_OF_MEASURE MUM1
746: WHERE RL.REQUISITION_LINE_ID = RD.REQUISITION_LINE_ID

Line 1119: FROM mtl_system_items

1115: x_progress := '020';
1116:
1117: SELECT primary_unit_of_measure
1118: INTO x_primary_uom
1119: FROM mtl_system_items
1120: WHERE inventory_item_id = x_item_id
1121: AND organization_id = x_organization_id;
1122:
1123: /*