APPS.JAI_AP_UTILS_PKG dependencies on RCV_TRANSACTIONS

Line 1492: from rcv_transactions

1488: cursor c_get_uoms_po_receipt(p_rcv_transaction_id number) is
1489: select unit_of_measure receipt_uom,
1490: source_doc_unit_of_measure po_uom,
1491: po_unit_price /*Bug 4990941 bduvarag*/
1492: from rcv_transactions
1493: where transaction_id = p_rcv_transaction_id;
1494:
1495: /* cursor c_get_po_qty_price(p_po_distribution_id number) is
1496: select price_override, quantity

Line 1523: from rcv_transactions

1519: where (shipment_header_id, shipment_line_id)
1520: in
1521: (
1522: select shipment_header_id, shipment_line_id
1523: from rcv_transactions
1524: where transaction_id = p_rcv_transaction_id
1525: );
1526:
1527: cursor c_get_uom_code(p_unit_of_measure in varchar2) is

Line 1536: from rcv_transactions

1532: cursor c_get_item (p_transaction_id number) is
1533: select item_id
1534: from rcv_shipment_lines
1535: where shipment_line_id = (select shipment_line_id
1536: from rcv_transactions
1537: where transaction_id = p_transaction_id);
1538:
1539: -- iSupplier porting
1540: CURSOR c_inv(inv_id NUMBER) IS

Line 1552: v_po_uom rcv_transactions.source_doc_unit_of_measure%type;

1548: v_invoice_price ap_invoice_distributions_all.unit_price%type;
1549: v_invoice_id ap_invoice_distributions_all.invoice_id%type; --iSuppleir porting
1550: v_source ap_invoices_all.source%type; --iSuppleir porting
1551:
1552: v_po_uom rcv_transactions.source_doc_unit_of_measure%type;
1553: v_receipt_price rcv_transactions.po_unit_price%type ; /*Bug 4990941 bduvarag*/
1554: v_receipt_uom rcv_transactions.unit_of_measure%type;
1555:
1556: v_receipt_quantity JAI_RCV_LINES.qty_received%type;

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

1549: v_invoice_id ap_invoice_distributions_all.invoice_id%type; --iSuppleir porting
1550: v_source ap_invoices_all.source%type; --iSuppleir porting
1551:
1552: v_po_uom rcv_transactions.source_doc_unit_of_measure%type;
1553: v_receipt_price rcv_transactions.po_unit_price%type ; /*Bug 4990941 bduvarag*/
1554: v_receipt_uom rcv_transactions.unit_of_measure%type;
1555:
1556: v_receipt_quantity JAI_RCV_LINES.qty_received%type;
1557:

Line 1554: v_receipt_uom rcv_transactions.unit_of_measure%type;

1550: v_source ap_invoices_all.source%type; --iSuppleir porting
1551:
1552: v_po_uom rcv_transactions.source_doc_unit_of_measure%type;
1553: v_receipt_price rcv_transactions.po_unit_price%type ; /*Bug 4990941 bduvarag*/
1554: v_receipt_uom rcv_transactions.unit_of_measure%type;
1555:
1556: v_receipt_quantity JAI_RCV_LINES.qty_received%type;
1557:
1558: v_po_price po_line_locations_all.price_override%type;