DBA Data[Home] [Help]

APPS.IGI_CBR_ARC_INTERFACE_PKG dependencies on AR_CASH_RECEIPTS_ALL

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)