APPS.JAI_AP_UTILS_PKG dependencies on RCV_TRANSACTIONS

Line 1281: from rcv_transactions

1277: cursor c_get_uoms_po_receipt(p_rcv_transaction_id number) is
1278: select unit_of_measure receipt_uom,
1279: source_doc_unit_of_measure po_uom,
1280: po_unit_price /*Bug 4990941 bduvarag*/
1281: from rcv_transactions
1282: where transaction_id = p_rcv_transaction_id;
1283:
1284: cursor c_get_po_qty_price(p_po_distribution_id number) is
1285: select price_override, quantity

Line 1301: from rcv_transactions

1297: where (shipment_header_id, shipment_line_id)
1298: in
1299: (
1300: select shipment_header_id, shipment_line_id
1301: from rcv_transactions
1302: where transaction_id = p_rcv_transaction_id
1303: );
1304:
1305: cursor c_get_uom_code(p_unit_of_measure in varchar2) is

Line 1314: from rcv_transactions

1310: cursor c_get_item (p_transaction_id number) is
1311: select item_id
1312: from rcv_shipment_lines
1313: where shipment_line_id = (select shipment_line_id
1314: from rcv_transactions
1315: where transaction_id = p_transaction_id);
1316:
1317: -- iSupplier porting
1318: CURSOR c_inv(inv_id NUMBER) IS

Line 1330: v_po_uom rcv_transactions.source_doc_unit_of_measure%type;

1326: v_invoice_price ap_invoice_distributions_all.unit_price%type;
1327: v_invoice_id ap_invoice_distributions_all.invoice_id%type; --iSuppleir porting
1328: v_source ap_invoices_all.source%type; --iSuppleir porting
1329:
1330: v_po_uom rcv_transactions.source_doc_unit_of_measure%type;
1331: v_receipt_price rcv_transactions.po_unit_price%type ; /*Bug 4990941 bduvarag*/
1332: v_receipt_uom rcv_transactions.unit_of_measure%type;
1333:
1334: v_receipt_quantity JAI_RCV_LINES.qty_received%type;

Line 1331: v_receipt_price rcv_transactions.po_unit_price%type ; /*Bug 4990941 bduvarag*/

1327: v_invoice_id ap_invoice_distributions_all.invoice_id%type; --iSuppleir porting
1328: v_source ap_invoices_all.source%type; --iSuppleir porting
1329:
1330: v_po_uom rcv_transactions.source_doc_unit_of_measure%type;
1331: v_receipt_price rcv_transactions.po_unit_price%type ; /*Bug 4990941 bduvarag*/
1332: v_receipt_uom rcv_transactions.unit_of_measure%type;
1333:
1334: v_receipt_quantity JAI_RCV_LINES.qty_received%type;
1335:

Line 1332: v_receipt_uom rcv_transactions.unit_of_measure%type;

1328: v_source ap_invoices_all.source%type; --iSuppleir porting
1329:
1330: v_po_uom rcv_transactions.source_doc_unit_of_measure%type;
1331: v_receipt_price rcv_transactions.po_unit_price%type ; /*Bug 4990941 bduvarag*/
1332: v_receipt_uom rcv_transactions.unit_of_measure%type;
1333:
1334: v_receipt_quantity JAI_RCV_LINES.qty_received%type;
1335:
1336: v_po_price po_line_locations_all.price_override%type;