APPS.PO_CREATE_ISO dependencies on MTL_UNITS_OF_MEASURE

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

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

Line 612: MTL_UNITS_OF_MEASURE MUM

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

Line 613: --,MTL_UNITS_OF_MEASURE MUM1

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
615: AND RL.REQUISITION_HEADER_ID = RH.REQUISITION_HEADER_ID
616: AND RL.ITEM_ID = SI.INVENTORY_ITEM_ID
617: AND RL.SOURCE_ORGANIZATION_ID = SI.ORGANIZATION_ID

Line 892: FROM mtl_units_of_measure

888: -- pmarada bug 4687787
889:
890: SELECT uom_code
891: INTO l_uom_code
892: FROM mtl_units_of_measure
893: WHERE unit_of_measure = x_unit_of_measure
894: ;
895:
896: GMF_get_transfer_price_PUB.get_transfer_price (