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_LOOKUPS

Line 105: HZ_CUST_ACCOUNTS hca, GL_CODE_COMBINATIONS c, AR_LOOKUPS l

101: decode(rep.reference30||rep.reference29 , 'AR_ADJUSTMENTSADJ_ADJ' ,
102: nvl(rep.accounted_cr, 0)-nvl(rep.accounted_dr, 0) , 0 ) amount
103: FROM IGI_AR_JOURNAL_INTERIM rep, IGI_CBR_ARC_RECONCILE_V aat,
104: AR_ADJUSTMENTS aad, RA_CUSTOMER_TRX rct, HZ_PARTIES hz,
105: HZ_CUST_ACCOUNTS hca, GL_CODE_COMBINATIONS c, AR_LOOKUPS l
106: WHERE rep.CODE_COMBINATION_ID = c.code_combination_id(+)
107: AND l.lookup_type = 'ARRGTA_CATEGORIES'
108: AND rep.reference28 = l.lookup_code
109: AND rep.reference25 = aat.trans_num

Line 133: GL_CODE_COMBINATIONS c, AR_LOOKUPS l

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
137: AND rep.reference25 = aat.trans_num

Line 164: GL_CODE_COMBINATIONS c, AR_LOOKUPS l

160: nvl(rep.accounted_cr,0)-nvl(rep.accounted_dr,0) ,'RA_CUST_TRX_LINE_GL_DISTCM_REV' ,
161: nvl(rep.accounted_cr,0)-nvl(rep.accounted_dr,0) , 0 ) amount
162: FROM IGI_AR_JOURNAL_INTERIM rep, HZ_PARTIES hz, HZ_CUST_ACCOUNTS hca,
163: RA_CUSTOMER_TRX rct, IGI_CBR_ARC_RECONCILE_V aat,
164: GL_CODE_COMBINATIONS c, AR_LOOKUPS l
165: WHERE rep.CODE_COMBINATION_ID = c.code_combination_id(+)
166: AND l.lookup_type = 'ARRGTA_CATEGORIES'
167: AND rep.reference28 = l.lookup_code
168: AND rep.reference25 = aat.trans_num

Line 193: AR_LOOKUPS l

189: nvl(rep.accounted_dr,0)-nvl(rep.accounted_cr,0) ,'AR_CASH_BASIS_DISTRIBUTIONSCMAPP_REC' ,
190: nvl(rep.accounted_dr,0)-nvl(rep.accounted_cr,0)) amount
191: FROM IGI_AR_JOURNAL_INTERIM rep, IGI_CBR_ARC_RECONCILE_V aat,
192: RA_CUSTOMER_TRX rct, hz_parties hp, hz_cust_accounts hca, GL_CODE_COMBINATIONS c,
193: AR_LOOKUPS l
194: WHERE rep.CODE_COMBINATION_ID = c.code_combination_id(+)
195: AND l.lookup_type = 'ARRGTA_CATEGORIES'
196: AND rep.reference28 = l.lookup_code
197: AND rep.reference25 = aat.trans_num

Line 219: HZ_PARTIES hz, HZ_CUST_ACCOUNTS hca, GL_CODE_COMBINATIONS c, AR_LOOKUPS l

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
223: AND rep.reference25 = aat.trans_num