APPS.INV_MAINTAIN_RESERVATION_PUB dependencies on MTL_UNITS_OF_MEASURE

Line 3029: FROM mtl_units_of_measure

3025: WHERE po_line_id= p_po_line_id;
3026:
3027: SELECT unit_of_measure
3028: INTO l_primary_meas
3029: FROM mtl_units_of_measure
3030: WHERE uom_code = p_primary_uom;
3031:
3032: SELECT unit_of_measure
3033: INTO l_res_meas

Line 3034: FROM mtl_units_of_measure

3030: WHERE uom_code = p_primary_uom;
3031:
3032: SELECT unit_of_measure
3033: INTO l_res_meas
3034: FROM mtl_units_of_measure
3035: WHERE uom_code = p_res_uom;
3036:
3037: EXCEPTION
3038: WHEN OTHERS THEN

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

3213: , project_id
3214: , task_id
3215: , source_type_code
3216: , unit_of_measure -- Bug 8524455
3217: from po_requisition_lines_all prl, po_requisition_headers_all prh , po_req_distributions_all prd, mtl_units_of_measure muom
3218: where prh.requisition_header_id = p_header_id
3219: and prh.REQUISITION_HEADER_ID = prl.REQUISITION_HEADER_ID
3220: and prd.requisition_line_id = prl.requisition_line_id
3221: and nvl(prl.modified_by_agent_flag,'N') <> 'Y'

Line 3247: , mtl_units_of_measure muom

3243: , oel.ordered_quantity
3244: , oel.order_quantity_uom
3245: , muom.unit_of_measure
3246: FROM oe_order_lines_all oel
3247: , mtl_units_of_measure muom
3248: WHERE oel.line_id = v_demand_line_id
3249: AND cancelled_flag = 'N'
3250: AND oel.order_quantity_uom = muom.uom_code;
3251:

Line 3473: , mtl_units_of_measure d

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

Line 3521: , mtl_units_of_measure d

3517: , c.task_id
3518: FROM rcv_transactions a
3519: , rcv_shipment_lines b
3520: , po_distributions_all c
3521: , mtl_units_of_measure d
3522: WHERE a.transaction_id = v_transaction_id
3523: AND a.source_document_code = 'PO'
3524: AND b.shipment_line_id = a.shipment_line_id
3525: AND b.asn_line_flag = 'Y'

Line 3557: , mtl_units_of_measure e

3553: FROM rcv_transactions a
3554: , rcv_shipment_lines b
3555: , po_req_distributions_all c
3556: , po_requisition_lines_all d
3557: , mtl_units_of_measure e
3558: WHERE a.transaction_id = v_transaction_id
3559: AND a.source_document_code = 'REQ'
3560: AND b.shipment_line_id = a.shipment_line_id
3561: AND c.distribution_id = a.req_distribution_id