APPS.JAI_AP_MATCH_TAX_PROC_PKG dependencies on RCV_TRANSACTIONS

Line 1614: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,

1610: SELECT org_id, vendor_id, NVL(exchange_rate, 1) exchange_rate, invoice_currency_code,batch_id
1611: FROM ap_invoices_all
1612: WHERE invoice_id = pr_ap_inv_line_item.invoice_id;
1613:
1614: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
1615: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type,
1616: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type,
1617: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type,
1618: cp_attribute1 VARCHAR2)

Line 1615: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type,

1611: FROM ap_invoices_all
1612: WHERE invoice_id = pr_ap_inv_line_item.invoice_id;
1613:
1614: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
1615: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type,
1616: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type,
1617: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type,
1618: cp_attribute1 VARCHAR2)
1619: is

Line 1616: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type,

1612: WHERE invoice_id = pr_ap_inv_line_item.invoice_id;
1613:
1614: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
1615: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type,
1616: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type,
1617: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type,
1618: cp_attribute1 VARCHAR2)
1619: is
1620: select attribute2 excise_costing_flag

Line 1617: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type,

1613:
1614: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
1615: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type,
1616: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type,
1617: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type,
1618: cp_attribute1 VARCHAR2)
1619: is
1620: select attribute2 excise_costing_flag
1621: from jai_rcv_transactions jrcvt

Line 1621: from jai_rcv_transactions jrcvt

1617: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type,
1618: cp_attribute1 VARCHAR2)
1619: is
1620: select attribute2 excise_costing_flag
1621: from jai_rcv_transactions jrcvt
1622: where jrcvt.parent_transaction_id = cp_rcv_transaction_id
1623: and jrcvt.organization_id = cp_organization_id
1624: and jrcvt.shipment_header_id = cp_shipment_header_id
1625: and jrcvt.transaction_type = cp_txn_type ;

Line 3068: FROM rcv_transactions

3064: WHERE invoice_id = pn_invoice_id;
3065:
3066: CURSOR fetch_rcv_record(v_rcv_trans_id NUMBER) IS
3067: SELECT po_header_id,po_line_id
3068: FROM rcv_transactions
3069: WHERE transaction_id = v_rcv_trans_id;
3070:
3071: CURSOR fetch_tax_distribution(v_po_header_id NUMBER, v_po_line_id NUMBER, v_invoice_id NUMBER) IS
3072: SELECT COUNT(*)

Line 3087: FROM rcv_shipment_headers rsh, rcv_transactions rt

3083: WHERE invoice_id = pn_invoice_id;
3084:
3085: CURSOR count_receipts(p_pck_slip VARCHAR2, ven_id NUMBER, cpv_transaction_type VARCHAR2 ) IS
3086: SELECT DISTINCT rsh.receipt_num, rsh.shipment_header_id
3087: FROM rcv_shipment_headers rsh, rcv_transactions rt
3088: WHERE rsh.shipment_header_id = rt.shipment_header_id
3089: AND rsh.packing_slip = p_pck_slip
3090: AND rsh.vendor_id = ven_id
3091: AND rt.transaction_type = cpv_transaction_type;

Line 3493: FROM rcv_transactions

3489: ,pn_location_id OUT NOCOPY NUMBER
3490: ) IS
3491: CURSOR c_rcv_organization_id IS
3492: SELECT organization_id, location_id
3493: FROM rcv_transactions
3494: WHERE transaction_id = pn_rcv_trx_id;
3495: CURSOR c_po_organization_id IS
3496: SELECT ship_to_organization_id, ship_to_location_id
3497: FROM po_line_locations_all plla, po_distributions_all pod