APPS.INV_MAINTAIN_RESERVATION_PUB dependencies on MTL_UNITS_OF_MEASURE

Line 3043: FROM mtl_units_of_measure

3039: WHERE po_line_id= p_po_line_id;
3040:
3041: SELECT unit_of_measure
3042: INTO l_primary_meas
3043: FROM mtl_units_of_measure
3044: WHERE uom_code = p_primary_uom;
3045:
3046: SELECT unit_of_measure
3047: INTO l_res_meas

Line 3048: FROM mtl_units_of_measure

3044: WHERE uom_code = p_primary_uom;
3045:
3046: SELECT unit_of_measure
3047: INTO l_res_meas
3048: FROM mtl_units_of_measure
3049: WHERE uom_code = p_res_uom;
3050:
3051: EXCEPTION
3052: WHEN OTHERS THEN

Line 3227: from po_requisition_lines_all prl, po_requisition_headers_all prh , po_req_distributions_all prd, mtl_units_of_measure muom

3223: , quantity
3224: , project_id
3225: , task_id
3226: , source_type_code
3227: from po_requisition_lines_all prl, po_requisition_headers_all prh , po_req_distributions_all prd, mtl_units_of_measure muom
3228: where prh.requisition_header_id = p_header_id
3229: and prh.REQUISITION_HEADER_ID = prl.REQUISITION_HEADER_ID
3230: and prd.requisition_line_id = prl.requisition_line_id
3231: and nvl(prl.modified_by_agent_flag,'N') <> 'Y'

Line 3470: , mtl_units_of_measure d

3466: , c.task_id
3467: FROM rcv_transactions a
3468: , rcv_shipment_lines b
3469: , po_distributions_all c
3470: , mtl_units_of_measure d
3471: WHERE transaction_id = v_transaction_id
3472: AND a.shipment_line_id = b.shipment_line_id
3473: AND c.po_distribution_id = a.po_distribution_id
3474: AND c.po_header_id = a.po_header_id

Line 3514: , mtl_units_of_measure d

3510: , c.task_id
3511: FROM rcv_transactions a
3512: , rcv_shipment_lines b
3513: , po_distributions_all c
3514: , mtl_units_of_measure d
3515: WHERE a.transaction_id = v_transaction_id
3516: AND a.source_document_code = 'PO'
3517: AND b.shipment_line_id = a.shipment_line_id
3518: AND b.asn_line_flag = 'Y'

Line 3546: , mtl_units_of_measure e

3542: FROM rcv_transactions a
3543: , rcv_shipment_lines b
3544: , po_req_distributions_all c
3545: , po_requisition_lines_all d
3546: , mtl_units_of_measure e
3547: WHERE a.transaction_id = v_transaction_id
3548: AND a.source_document_code = 'REQ'
3549: AND b.shipment_line_id = a.shipment_line_id
3550: AND c.distribution_id = a.req_distribution_id