DBA Data[Home] [Help]

APPS.CSTPAPBR dependencies on MTL_UNITS_OF_MEASURE

Line 10488: l_primary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

10484: l_doc_line_qty PO_REQUISITION_LINES_ALL.QUANTITY%TYPE;
10485: l_doc_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;
10486: l_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;
10487: l_conversion_rate NUMBER;
10488: l_primary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
10489: l_doc_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
10490: l_uom_rate NUMBER;
10491: l_doc_primary_qty NUMBER;
10492: l_doc_rcv_qty NUMBER;

Line 10489: l_doc_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

10485: l_doc_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;
10486: l_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;
10487: l_conversion_rate NUMBER;
10488: l_primary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
10489: l_doc_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
10490: l_uom_rate NUMBER;
10491: l_doc_primary_qty NUMBER;
10492: l_doc_rcv_qty NUMBER;
10493: l_non_recoverable_tax NUMBER;

Line 10538: mtl_units_of_measure um

10534: x_encumbrance_account,
10535: l_non_recoverable_tax /* Bug 6033153 */
10536: FROM po_req_distributions_all rd,
10537: po_requisition_lines_all rl,
10538: mtl_units_of_measure um
10539: WHERE rd.requisition_line_id = p_req_line_id
10540: and rd.requisition_line_id = rl.requisition_line_id
10541: and rl.UNIT_MEAS_LOOKUP_CODE = um.unit_of_measure;
10542: