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.IGIRCABJP dependencies on RA_CUSTOMER_TRX

Line 86: ra_customer_trx_all ct,

82: 'ADJ' ref28,
83: 'ADJ' || ard.source_type ref29,
84: 'AR_ADJUSTMENTS' ref30
85: FROM
86: ra_customer_trx_all ct,
87: ra_cust_trx_types_all ctt,
88: ar_distributions_all ard,
89: hz_parties, -- Bug 3902175
90: hz_cust_accounts, -- Bug 3902175

Line 261: ra_customer_trx_all ct,

257: ar_lookups l_cat,
258: ra_cust_trx_types ctt,
259: hz_parties, -- Bug 3902175
260: hz_cust_accounts, -- Bug 3902175
261: ra_customer_trx_all ct,
262: ra_cust_trx_line_gl_dist ctlgd,
263: xla_ae_headers xah
264: WHERE
265: ctlgd.cust_trx_line_gl_dist_id+0 < p_Report.NxtCustTrxLineGlDistId

Line 590: ra_customer_trx ctinv,

586: FROM
587: ar_receivable_applications ra,
588: ar_cash_receipts cr,
589: ar_distributions ard,
590: ra_customer_trx ctinv,
591: ar_lookups l_cat,
592: ar_posting_control pc,
593: ar_system_parameters sp,
594: gl_sets_of_books gl,

Line 692: ra_customer_trx ctcm,

688: 'CMAPP_' || ard.source_type ref29,
689: 'AR_RECEIVABLE_APPLICATIONS' ref30
690: FROM
691: ar_receivable_applications ra,
692: ra_customer_trx ctcm,
693: ar_distributions ard,
694: ra_cust_trx_line_gl_dist ctlgdcm,
695: ra_customer_trx ctinv,
696: ar_lookups l_cat,

Line 695: ra_customer_trx ctinv,

691: ar_receivable_applications ra,
692: ra_customer_trx ctcm,
693: ar_distributions ard,
694: ra_cust_trx_line_gl_dist ctlgdcm,
695: ra_customer_trx ctinv,
696: ar_lookups l_cat,
697: ar_posting_control pc,
698: ar_system_parameters sp,
699: gl_sets_of_books gl,

Line 710: and ra.customer_trx_id = ctcm.customer_trx_id

706: and ard.source_id = ra.receivable_application_id
707: and nvl(ra.postable,'Y') = 'Y'
708: and nvl(ra.confirmed_flag,'Y') = 'Y'
709: and ra.status||'' = 'APP'
710: and ra.customer_trx_id = ctcm.customer_trx_id
711: and ra.customer_trx_id = ctlgdcm.customer_trx_id
712: and ctlgdcm.account_class = 'REC'
713: and ctlgdcm.latest_rec_flag = 'Y'
714: and ra.applied_customer_trx_id = ctinv.customer_trx_id

Line 711: and ra.customer_trx_id = ctlgdcm.customer_trx_id

707: and nvl(ra.postable,'Y') = 'Y'
708: and nvl(ra.confirmed_flag,'Y') = 'Y'
709: and ra.status||'' = 'APP'
710: and ra.customer_trx_id = ctcm.customer_trx_id
711: and ra.customer_trx_id = ctlgdcm.customer_trx_id
712: and ctlgdcm.account_class = 'REC'
713: and ctlgdcm.latest_rec_flag = 'Y'
714: and ra.applied_customer_trx_id = ctinv.customer_trx_id
715: and hz_parties.party_id = hz_cust_accounts.party_id -- Bug 3902175