eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_CMN_REVERSE_CHARGE_PKG dependencies on JAI_RGM_TRX_REFS

Line 142: FROM jai_rgm_trx_refs

138: lv_codepath varchar2(2000);
139:
140: CURSOR c_batch_references(cp_batch_id IN NUMBER, cp_source IN VARCHAR2) IS
141: SELECT distinct invoice_id
142: FROM jai_rgm_trx_refs
143: WHERE batch_id = cp_batch_id
144: AND source = cp_source;
145:
146: CURSOR c_previous_payments_of_inv(cp_invoice_id IN NUMBER,

Line 183: FROM jai_rgm_trx_refs jrtr

179: and source_table_name = jai_constants.ap_payments
180: and source_document_id = a.invoice_payment_id)
181: AND EXISTS
182: (SELECT 1
183: FROM jai_rgm_trx_refs jrtr
184: WHERE jrtr.source = jai_constants.source_ap
185: AND jrtr.invoice_id = aida.invoice_id
186: AND jrtr.line_id = aida.invoice_distribution_id
187:

Line 208: jai_rgm_trx_refs jrtr /* second table is used for join just to take IL records */

204: apinvp.accounting_date
205: FROM ap_invoice_payments_all apinvp,
206: ap_checks_all apc,
207: ap_invoice_distributions_all ainvd,
208: jai_rgm_trx_refs jrtr /* second table is used for join just to take IL records */
209: WHERE apinvp.org_id = p_org_id
210: AND apinvp.check_id = apc.check_id
211: AND nvl(apc.future_pay_due_date, SYSDATE) <= SYSDATE
212: AND apinvp.accounting_date BETWEEN cp_start_date AND cp_till_date

Line 252: jai_rgm_trx_refs jrtr

248: prepay.accounting_date,
249: ap_dist.po_distribution_id
250: FROM ap_invoice_distributions_all prepay,
251: ap_invoice_distributions_all ap_dist,
252: jai_rgm_trx_refs jrtr
253: WHERE prepay.invoice_id = cp_invoice_id
254: AND ap_dist.invoice_id = prepay.invoice_id
255: AND prepay.line_type_lookup_code = jai_constants.prepay_line
256: AND jai_cmn_reverse_charge_pkg.is_rvs_chrg_liablity_dist(ap_dist.invoice_distribution_id) = 'Y'

Line 288: jai_rgm_trx_refs jrtr

284: prepay.accounting_date,
285: ap_dist.po_distribution_id
286: FROM ap_invoice_distributions_all prepay,
287: ap_invoice_distributions_all ap_dist,
288: jai_rgm_trx_refs jrtr
289: WHERE ap_dist.org_id = p_org_id
290: AND prepay.org_id = p_org_id -- for bug 16071477 by anupgupt
291: AND ap_dist.invoice_id = prepay.invoice_id
292: AND prepay.line_type_lookup_code = jai_constants.prepay_line

Line 740: FROM jai_rgm_trx_refs

736: nvl(recovered_amount, 0) recovered_amount,
737: tax_type,
738: recoverable_amount,
739: nvl(discounted_amount, 0) discounted_amount
740: FROM jai_rgm_trx_refs
741: WHERE source = cp_source
742: AND invoice_id = cp_invoice_id
743: AND line_id = cp_invoice_distribution_id;
744:

Line 938: UPDATE jai_rgm_trx_refs

934: FETCH c_reference
935: INTO r_parent_ref;
936: CLOSE c_reference;
937:
938: UPDATE jai_rgm_trx_refs
939: SET reversal_flag = 'Y', last_update_date = sysdate
940: WHERE source = jai_constants.source_ap
941: AND invoice_id = pn_invoice_id
942: AND line_id in (pn_distribution_id, r_dist.parent_reversal_id);

Line 1502: jai_rgm_trx_refs jrf,

1498: jrr.location_id location_id,
1499: sum(nvl(jrr.debit_amount, 0)) debit_amount,
1500: sum(nvl(jrr.trx_debit_amount, 0)) trx_debit_amount
1501: FROM jai_rgm_trx_records jrr,
1502: jai_rgm_trx_refs jrf,
1503: JAI_CMN_TAXES_ALL jct
1504: Where jrr.reference_id = jrf.reference_id
1505: AND jrr.settlement_id = pn_settlement_id
1506: AND jrf.source = jai_constants.source_ap

Line 1866: jai_rgm_trx_refs jrf,

1862: jrr.settlement_id settlement_id,
1863: sum(nvl(jrr.debit_amount, 0)) debit_amount,
1864: sum(nvl(jrr.trx_debit_amount, 0)) trx_debit_amount
1865: FROM jai_rgm_trx_records jrr,
1866: jai_rgm_trx_refs jrf,
1867: JAI_CMN_TAXES_ALL jct
1868: Where jrr.reference_id = jrf.reference_id
1869: AND jrr.settlement_id = pn_settlement_id
1870: AND jrf.source = jai_constants.source_ap

Line 1903: jai_rgm_trx_refs jrf

1899:
1900: CURSOR c_get_repository_flag ( pn_settlement_id NUMBER, pn_reference_id NUMBER,pn_invoice_id NUMBER, pn_invoice_line_id NUMBER, pn_tax_id NUMBER) IS
1901: SELECT 'Y'
1902: FROM jai_rgm_trx_records jrr,
1903: jai_rgm_trx_refs jrf
1904: Where jrr.reference_id = jrf.reference_id
1905: AND jrf.invoice_id = pn_invoice_id
1906: AND jrr.source = jai_constants.source_ap
1907: AND jrr.source_trx_type = 'INVOICE_SETTLEMENT'

Line 1917: jai_rgm_trx_refs jrf

1913:
1914: CURSOR c_get_service_type_code ( pn_settlement_id NUMBER, pn_invoice_id NUMBER )IS
1915: SELECT jrr.service_type_code service_type_code
1916: FROM jai_rgm_trx_records jrr,
1917: jai_rgm_trx_refs jrf
1918: Where jrr.reference_id = jrf.reference_id
1919: AND jrr.settlement_id = pn_settlement_id
1920: AND jrf.source = jai_constants.source_ap
1921: AND jrr.source = jai_constants.source_ap

Line 1926: FROM jai_rgm_trx_refs jrf,

1922: AND jrr.source_trx_type in ( 'REVERSE_PAID_ACCOUNTING', 'REVERSE_AVOID_ACCOUNTING','REVERSE_APPLY_ACCOUNTING','REVERSE_UNAPPLY_ACCOUNTING' );
1923:
1924: CURSOR c_get_reference_id ( pn_invoice_id NUMBER, pn_invoice_line_id NUMBER, pn_tax_id NUMBER )IS
1925: SELECT jrf.reference_id
1926: FROM jai_rgm_trx_refs jrf,
1927: ap_invoice_lines_all aila,
1928: ap_invoice_distributions_all aida
1929: Where aida.invoice_id = aila.invoice_id
1930: AND aida.INVOICE_LINE_NUMBER = aila.line_number