APPS.JAI_AP_IDA_TRIGGER_DTC_PKG dependencies on RCV_TRANSACTIONS

Line 103: from rcv_transactions

99: AND a. tax_type = 'TDS';
100:
101: cursor c_get_shipment_line_id (p_rcv_transaction_id number) is
102: select shipment_line_id
103: from rcv_transactions
104: where transaction_id = p_rcv_transaction_id;
105:
106: CURSOR from_po_distributions(po_dist_id NUMBER) IS
107: SELECT line_location_id, po_line_id

Line 327: FROM rcv_transactions

323:
324: --start additions by vkaranam for bug#13618731
325: cursor get_rcv_rate(cp_rcv_transaction_id in number) is
326: SELECT currency_conversion_rate
327: FROM rcv_transactions
328: WHERE transaction_id=cp_rcv_transaction_id;
329:
330:
331: cursor c_get_accrual_acct(cp_invoice_id number,cp_inv_distid number) is

Line 388: from jai_rcv_line_taxes jt ,jai_rcv_transactions jrt

384: */
385: cursor get_rcv_tax_amt (cp_rcv_transaction_id in number ,cp_tax_id in number)
386: is
387: select jt.tax_amount
388: from jai_rcv_line_taxes jt ,jai_rcv_transactions jrt
389: where
390: jrt.shipment_header_id=jt.shipment_headeR_id
391: and jrt.shipment_line_id=jt.shipment_line_id
392: and jrt.transaction_id=cp_rcv_transaction_id

Line 1240: also for receipt exchange rate is fetched from rcv_transactions instead

1236: is null and the accounting didnt happen for the ERV line
1237:
1238: fix :
1239: Modified the jai_ap_ida_trigger_pkg.process_ipv (cursor get_rcv_tax_amt).
1240: also for receipt exchange rate is fetched from rcv_transactions instead
1241: of PO document.
1242: 18. 04/05/2012 Chong for ZX integration
1243: Comment out code concerning global_attribute1, for DFF nolonger used in DTC.
1244: Comment pr_old.match_status_flag which used in validation, for validation will be invoke in ZX.