APPS.PO_CREATE_ISO dependencies on MTL_UNITS_OF_MEASURE

Line 87: l_source_secondary_uom MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE := NULL;

83: l_dest_secondary_quantity PO_REQUISITION_LINES.SECONDARY_QUANTITY%TYPE := NULL;
84: l_dest_secondary_unit PO_REQUISITION_LINES.SECONDARY_UNIT_OF_MEASURE%TYPE := NULL;
85: l_item_id PO_REQUISITION_LINES.ITEM_ID%TYPE := NULL;
86: l_source_secondary_quantity PO_REQUISITION_LINES.SECONDARY_QUANTITY%TYPE := NULL;
87: l_source_secondary_uom MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE := NULL;
88: l_source_secondary_unit PO_REQUISITION_LINES.SECONDARY_UNIT_OF_MEASURE%TYPE := NULL;
89: --
90:
91: l_pjm_ou_id FINANCIALS_SYSTEM_PARAMS_ALL.org_id%TYPE; --< Bug 3265539 >

Line 744: MTL_UNITS_OF_MEASURE MUM

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
747: AND RL.REQUISITION_HEADER_ID = RH.REQUISITION_HEADER_ID
748: AND RL.ITEM_ID = SI.INVENTORY_ITEM_ID

Line 745: --,MTL_UNITS_OF_MEASURE MUM1

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
747: AND RL.REQUISITION_HEADER_ID = RH.REQUISITION_HEADER_ID
748: AND RL.ITEM_ID = SI.INVENTORY_ITEM_ID
749: AND RL.SOURCE_ORGANIZATION_ID = SI.ORGANIZATION_ID

Line 1045: FROM mtl_units_of_measure

1041: -- pmarada bug 4687787
1042:
1043: SELECT uom_code
1044: INTO l_uom_code
1045: FROM mtl_units_of_measure
1046: WHERE unit_of_measure = x_unit_of_measure
1047: ;
1048:
1049: GMF_get_transfer_price_PUB.get_transfer_price (