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

Line 118: ra_customer_trx ct,

114: ) CmPsIdFlag,
115: ra.receivable_application_id
116: FROM ar_receivable_applications ra,
117: ra_cust_trx_types ctt,
118: ra_customer_trx ct,
119: ar_cash_receipts cr,
120: ar_cash_receipt_history crh,
121: ra_customer_trx ctcm,
122: ar_lookups l

Line 121: ra_customer_trx ctcm,

117: ra_cust_trx_types ctt,
118: ra_customer_trx ct,
119: ar_cash_receipts cr,
120: ar_cash_receipt_history crh,
121: ra_customer_trx ctcm,
122: ar_lookups l
123: WHERE ra.gl_date BETWEEN p_Prepare.GlDateFrom
124: AND p_Prepare.GlDateTo
125: AND nvl(ra.postable,'Y') = 'Y'

Line 130: AND ra.customer_trx_id = ctcm.customer_trx_id(+)

126: AND nvl(ra.confirmed_flag,'Y') = 'Y'
127: AND ra.status||'' = 'APP' -- Bug 3519052
128: AND ra.cash_receipt_id = cr.cash_receipt_id(+)
129: AND ra.cash_receipt_history_id = crh.cash_receipt_history_id(+)
130: AND ra.customer_trx_id = ctcm.customer_trx_id(+)
131: AND ctcm.previous_customer_trx_id IS NULL
132: AND ra.applied_customer_trx_id = ct.customer_trx_id
133: AND ct.cust_trx_type_id = ctt.cust_trx_type_id
134: AND ra.set_of_books_id = p_Prepare.SetOfBooksId