eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPAVCP dependencies on PO_REQUISITION_LINES_ALL

Line 9165: p_req_line_id IN PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE,

9161:
9162: PROCEDURE CompEncumbrance_IntOrdersExp (
9163: p_api_version IN NUMBER,
9164: p_transaction_id IN MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE,
9165: p_req_line_id IN PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE,
9166: p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
9167: p_organization_id IN MTL_PARAMETERS.ORGANIZATION_ID%TYPE,
9168: p_primary_qty IN MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE,
9169: p_total_primary_qty IN NUMBER,

Line 9176: l_doc_line_qty PO_REQUISITION_LINES_ALL.QUANTITY%TYPE;

9172: x_return_status OUT NOCOPY VARCHAR,
9173: x_return_message OUT NOCOPY VARCHAR2
9174: ) IS
9175:
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;

Line 9177: l_doc_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;

9173: x_return_message OUT NOCOPY VARCHAR2
9174: ) IS
9175:
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;

Line 9178: l_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;

9174: ) IS
9175:
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;

Line 9233: po_requisition_lines_all rl,

9229: l_unit_price,
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;

Line 9375: l_req_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;

9371: l_total_primary_qty NUMBER;
9372: l_primary_qty MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE;
9373: l_organization_id MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID%TYPE;
9374: l_trx_source_line_id MTL_MATERIAL_TRANSACTIONS.TRX_SOURCE_LINE_ID%TYPE;
9375: l_req_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
9376: l_item_id MTL_MATERIAL_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE;
9377: l_txn_action_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ACTION_ID%TYPE;
9378: l_txn_src_type_id
9379: MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID%TYPE;