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.IGI_CBR_ARC_INTERFACE_PKG dependencies on AR_CASH_RECEIPTS

Line 132: AR_CASH_RECEIPTS acr, RA_CUSTOMER_TRX rct, HZ_PARTIES hz, HZ_CUST_ACCOUNTS hca,

128: hz.party_name customer_name, rep.accounting_date,
129: decode(rep.reference30||rep.reference29 ,'AR_RECEIVABLE_APPLICATIONSTRADE_GL' ,
130: nvl(rep.accounted_cr,0)-nvl(rep.accounted_dr,0) , 0 ) amount
131: FROM IGI_AR_JOURNAL_INTERIM rep, IGI_CBR_ARC_RECONCILE_V aat,
132: AR_CASH_RECEIPTS acr, RA_CUSTOMER_TRX rct, HZ_PARTIES hz, HZ_CUST_ACCOUNTS hca,
133: GL_CODE_COMBINATIONS c, AR_LOOKUPS l
134: WHERE rep.CODE_COMBINATION_ID = c.code_combination_id(+)
135: AND l.lookup_type = 'ARRGTA_CATEGORIES'
136: AND rep.reference28 = l.lookup_code

Line 218: FROM IGI_AR_JOURNAL_INTERIM rep, IGI_CBR_ARC_RECONCILE_V aat, AR_CASH_RECEIPTS acr,

214: rep.reference25 trans_number, rep.reference26 customer_number,
215: hz.party_name customer_name, rep.accounting_date,
216: decode(rep.reference30||rep.reference29 ,'AR_CASH_BASIS_DISTRIBUTIONSTRADE_APP' ,
217: nvl(-rep.accounted_cr,0)-nvl(-rep.accounted_dr,0)) amount
218: FROM IGI_AR_JOURNAL_INTERIM rep, IGI_CBR_ARC_RECONCILE_V aat, AR_CASH_RECEIPTS acr,
219: HZ_PARTIES hz, HZ_CUST_ACCOUNTS hca, GL_CODE_COMBINATIONS c, AR_LOOKUPS l
220: WHERE rep.CODE_COMBINATION_ID = c.code_combination_id(+)
221: AND l.lookup_type = 'ARRGTA_CATEGORIES'
222: AND rep.reference28 = l.lookup_code

Line 245: FROM IGI_AR_JOURNAL_INTERIM rep, GL_CODE_COMBINATIONS c, AR_CASH_RECEIPTS_ALL acr

241: rep.request_id, rep.currency_code, acr.doc_sequence_value doc_seq_num,
242: nvl(rep.reference25,rep.reference24) trans_number, rep.reference26 customer_number,
243: null customer_name, rep.accounting_date,
244: nvl(rep.accounted_dr,0) - nvl(rep.accounted_cr,0) amount
245: FROM IGI_AR_JOURNAL_INTERIM rep, GL_CODE_COMBINATIONS c, AR_CASH_RECEIPTS_ALL acr
246: WHERE rep.code_combination_id = c.code_combination_id
247: AND nvl(rep.accounted_dr,0) - nvl(rep.accounted_cr,0) <> 0
248: AND rep.reference28 in ('TRADE','MISC')
249: AND rep.reference22 = to_char(acr.cash_receipt_id)