APPS.JAI_AP_IDA_TRIGGER_PKG dependencies on RCV_TRANSACTIONS

Line 134: FROM jai_rcv_transactions rcv, ap_invoice_lines_all ap

130: AND ap.line_number = pn_line_number;
131:
132: CURSOR get_rcpt_matched_org_cur(pn_line_number NUMBER) IS
133: SELECT rcv.organization_id, rcv.location_id
134: FROM jai_rcv_transactions rcv, ap_invoice_lines_all ap
135: WHERE ap.rcv_transaction_id = rcv.transaction_id
136: AND ap.invoice_id = pr_new.invoice_id
137: AND ap.line_number = pn_line_number;
138:

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

355: is null and the accounting didnt happen for the ERV line
356:
357: fix :
358: Modified the jai_ap_ida_trigger_pkg.process_ipv (cursor get_rcv_tax_amt).
359: also for receipt exchange rate is fetched from rcv_transactions instead
360: of PO document.
361:
362: 18. 6-FEB-2012 Xin Modified for Bug 13540555
363: Issue : INCORRECT ACCOUNT WHEN CANCEL INVOICE

Line 980: from rcv_transactions

976: AND a. tax_type = 'TDS';
977:
978: cursor c_get_shipment_line_id (p_rcv_transaction_id number) is
979: select shipment_line_id
980: from rcv_transactions
981: where transaction_id = p_rcv_transaction_id;
982:
983: CURSOR from_po_distributions(po_dist_id NUMBER) IS
984: SELECT line_location_id, po_line_id

Line 1194: FROM rcv_transactions

1190:
1191: --start additions by vkaranam for bug#13618731
1192: cursor get_rcv_rate(cp_rcv_transaction_id in number) is
1193: SELECT currency_conversion_rate
1194: FROM rcv_transactions
1195: WHERE transaction_id=cp_rcv_transaction_id;
1196:
1197: cursor c_get_accrual_acct(cp_invoice_id number,cp_inv_distid number) is
1198: select dist_code_combination_id

Line 1253: from jai_rcv_line_taxes jt ,jai_rcv_transactions jrt

1249: */
1250: cursor get_rcv_tax_amt (cp_rcv_transaction_id in number ,cp_tax_id in number)
1251: is
1252: select jt.tax_amount
1253: from jai_rcv_line_taxes jt ,jai_rcv_transactions jrt
1254: where
1255: jrt.shipment_header_id=jt.shipment_headeR_id
1256: and jrt.shipment_line_id=jt.shipment_line_id
1257: and jrt.transaction_id=cp_rcv_transaction_id