DBA Data[Home] [Help]

APPS.CSTPAVCP dependencies on MTL_UNITS_OF_MEASURE

Line 9180: l_primary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

9176: l_doc_line_qty PO_REQUISITION_LINES_ALL.QUANTITY%TYPE;
9177: l_doc_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;
9178: l_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;
9179: l_conversion_rate NUMBER;
9180: l_primary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
9181: l_doc_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
9182: l_uom_rate NUMBER;
9183: l_doc_primary_qty NUMBER;
9184: l_doc_rcv_qty NUMBER;

Line 9181: l_doc_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

9177: l_doc_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;
9178: l_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;
9179: l_conversion_rate NUMBER;
9180: l_primary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
9181: l_doc_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
9182: l_uom_rate NUMBER;
9183: l_doc_primary_qty NUMBER;
9184: l_doc_rcv_qty NUMBER;
9185:

Line 9234: mtl_units_of_measure um

9230: x_encumbrance_account,
9231: l_non_recoverable_tax /* Bug 6405593 */
9232: FROM po_req_distributions_all rd,
9233: po_requisition_lines_all rl,
9234: mtl_units_of_measure um
9235: WHERE rd.requisition_line_id = p_req_line_id
9236: and rd.requisition_line_id = rl.requisition_line_id
9237: and rl.UNIT_MEAS_LOOKUP_CODE = um.unit_of_measure;
9238: