APPS.IGI_CBR_ARC_INTERFACE_PKG dependencies on AR_ADJUSTMENTS

Line 101: decode(rep.reference30||rep.reference29 , 'AR_ADJUSTMENTSADJ_ADJ' ,

97: c.SEGMENT26, c.SEGMENT27, c.SEGMENT28, c.SEGMENT29, c.SEGMENT30,
98: rep.request_id, rep.currency_code, rct.doc_sequence_value doc_seq_num,
99: rep.reference25 trans_number, rep.reference26 customer_number,
100: hz.party_name customer_name, rep.accounting_date,
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

Line 104: AR_ADJUSTMENTS aad, RA_CUSTOMER_TRX rct, HZ_PARTIES hz,

100: hz.party_name customer_name, rep.accounting_date,
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

Line 115: AND rep.reference30 = 'AR_ADJUSTMENTS'

111: AND rep.reference22 = to_char(aad.adjustment_id)
112: AND (rep.accounted_cr <> 0 OR rep.accounted_dr <> 0)
113: AND rep.reference25 is not null
114: AND rep.reference29 = 'ADJ_ADJ'
115: AND rep.reference30 = 'AR_ADJUSTMENTS'
116: AND rep.reference26 = hca.account_number
117: AND hz.party_id = hca.party_id
118: AND nvl(rep.accounted_dr,0)-nvl(rep.accounted_cr,0) <> 0
119: UNION