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.CSTPAPBR dependencies on PO_REQUISITION_LINES_ALL

Line 10958: p_req_line_id IN PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE,

10954:
10955: PROCEDURE CompEncumbrance_IntOrdersExp (
10956: p_api_version IN NUMBER,
10957: p_transaction_id IN MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE,
10958: p_req_line_id IN PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE,
10959: p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
10960: p_organization_id IN MTL_PARAMETERS.ORGANIZATION_ID%TYPE,
10961: p_primary_qty IN MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE,
10962: p_total_primary_qty IN NUMBER,

Line 10968: l_doc_line_qty PO_REQUISITION_LINES_ALL.QUANTITY%TYPE;

10964: x_encumbrance_account OUT NOCOPY NUMBER,
10965: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
10966: ) IS
10967:
10968: l_doc_line_qty PO_REQUISITION_LINES_ALL.QUANTITY%TYPE;
10969: l_doc_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;
10970: l_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;
10971: l_conversion_rate NUMBER;
10972: l_primary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

Line 10969: l_doc_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;

10965: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
10966: ) IS
10967:
10968: l_doc_line_qty PO_REQUISITION_LINES_ALL.QUANTITY%TYPE;
10969: l_doc_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;
10970: l_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;
10971: l_conversion_rate NUMBER;
10972: l_primary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
10973: l_doc_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

Line 10970: l_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;

10966: ) IS
10967:
10968: l_doc_line_qty PO_REQUISITION_LINES_ALL.QUANTITY%TYPE;
10969: l_doc_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;
10970: l_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;
10971: l_conversion_rate NUMBER;
10972: l_primary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
10973: l_doc_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
10974: l_uom_rate NUMBER;

Line 11021: po_requisition_lines_all rl,

11017: l_unit_price,
11018: x_encumbrance_account,
11019: l_non_recoverable_tax /* Bug 6033153 */
11020: FROM po_req_distributions_all rd,
11021: po_requisition_lines_all rl,
11022: mtl_units_of_measure um
11023: WHERE rd.requisition_line_id = p_req_line_id
11024: and rd.requisition_line_id = rl.requisition_line_id
11025: and rl.UNIT_MEAS_LOOKUP_CODE = um.unit_of_measure;

Line 11106: l_req_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;

11102: l_total_primary_qty NUMBER;
11103: l_primary_qty MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE;
11104: l_organization_id MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID%TYPE;
11105: l_trx_source_line_id MTL_MATERIAL_TRANSACTIONS.TRX_SOURCE_LINE_ID%TYPE;
11106: l_req_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
11107: l_item_id MTL_MATERIAL_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE;
11108: l_txn_action_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ACTION_ID%TYPE;
11109: l_txn_src_type_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID%TYPE;
11110: l_rcv_txn_id MTL_MATERIAL_TRANSACTIONS.RCV_TRANSACTION_ID%TYPE;