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.

VIEW: APPS.AR_AEL_SL_REC_MRC_V

Source

View Text - Preformatted


SELECT 222 APPLICATION_ID , CR.set_of_books_id SET_OF_BOOKS_ID , CR.org_id ORG_ID , CR.type TRX_CLASS , /* Bugfix 2182064. Similar changes in all selects */ arpt_sql_func_util.get_lookup_meaning('PAYMENT_CATEGORY_TYPE', cr.type) TRX_CLASS_NAME , CR.receipt_method_id TRX_TYPE_N , RM.name TRX_TYPE_NAME , CR.receipt_number TRX_NUMBER_DISPLAYED , CR.receipt_number TRX_NUMBER_C , CR.receipt_date TRX_DATE , CR.comments COMMENTS , CR.doc_sequence_id DOC_SEQUENCE_ID , SEQ.name DOC_SEQUENCE_NAME , CR.doc_sequence_value DOC_SEQUENCE_VALUE, 'CR' TRX_HDR_TABLE, CR.cash_receipt_id TRX_HDR_ID, ARD.source_type ACCT_LINE_TYPE, arpt_sql_func_util.get_lookup_meaning('DISTRIBUTION_SOURCE_TYPE', ARD.source_type) ACCT_LINE_TYPE_NAME, ARD.code_combination_id CODE_COMBINATION_ID, ARD.currency_code CURRENCY_CODE, ARD.amount_dr ENTERED_DR, ARD.amount_cr ENTERED_CR, ARD.acctd_amount_dr ACCOUNTED_DR, ARD.acctd_amount_cr ACCOUNTED_CR, ARD.currency_conversion_date CURRENCY_CONVERSION_DATE, ARD.currency_conversion_type CURRENCY_CONVERSION_TYPE, GLCT.user_conversion_type CURRENCY_USER_CONVERSION_TYPE, ARD.currency_conversion_rate CURRENCY_CONVERSION_RATE, 'C' THIRD_PARTY_TYPE, ARD.third_party_id THIRD_PARTY_ID, CUST_ACCT.account_number THIRD_PARTY_NUMBER, substrb(party.party_name,1,50) THIRD_PARTY_NAME, ARD.third_party_sub_id THIRD_PARTY_SUB_ID, SU.location THIRD_PARTY_SUB_NAME, CRH.gl_date ACCOUNTING_DATE, arpt_sql_func_util.get_lookup_meaning('YES/NO', decode(CRH.posting_control_id,-3,'N','Y')) GL_TRANSFER_STATUS_NAME, decode(CRH.posting_control_id,-3, 'N','Y') GL_TRANSFER_STATUS, ARD.source_table SOURCE_TABLE, ARD.source_id SOURCE_ID, ARD.line_id AEL_ID, 'ARD' AEL_TABLE, /* Line Ref: Trans Class + ' ' + Trans Number */ arpt_sql_func_util.get_lookup_meaning('PAYMENT_CATEGORY_TYPE',cr.type) ||' '||CR.receipt_number AE_LINE_REFERENCE, rpad(CR.receipt_number, 30, ' ') AE_LINE_REFERENCE_INTERNAL, ARD.last_update_date LAST_UPDATE_DATE, ARD.last_updated_by LAST_UPDATED_BY, ARD.creation_date CREATION_DATE, ARD.created_by CREATED_BY, ARD.last_update_login LAST_UPDATE_LOGIN, /* The following columns are specific to AR Receipts */ 'ACCRUAL' ACCOUNTING_BASIS, VAT.tax_code TAX_CODE, ARD.tax_code_id TAX_CODE_ID, ARD.tax_link_id TAX_LINK_ID, ARD.taxable_entered_dr TAXABLE_ENTERED_DR, ARD.taxable_entered_cr TAXABLE_ENTERED_CR, ARD.taxable_accounted_dr TAXABLE_ACCOUNTED_DR, ARD.taxable_accounted_cr TAXABLE_ACCOUNTED_CR, CR.currency_code TRX_HDR_CURRENCY, CBA.bank_account_name BANK_ACCOUNT_NAME, CR.reversal_comments REVERSAL_COMMENTS, CR.reversal_date REVERSAL_DATE, to_date(null) APPLICATION_DATE, CR.deposit_date PAYMENT_DEPOSIT_DATE, null APPLIED_TO_TRX_HDR_TABLE, to_number(null) APPLIED_TO_TRX_HDR_ID, null APPLIED_TO_TRX_HDR_NUMBER_C, null APPLIED_TO_TRX_HDR_NUMBER_DISP, null APPLIED_TO_TRX_HDR_CURRENCY, to_date(null) APPLIED_TO_TRX_HDR_DATE, null APPLIED_TO_TRX_LINE_TYPE_NAME, null APPLIED_TO_TRX_LINE_TYPE, to_number(null) APPLIED_TO_TRX_LINE_NUMBER, RCVTRX.name AR_ACTIVITY_NAME, null DISTRIBUTION_SET_NAME FROM ar_cash_receipts_all_mrc_v CR, ar_receivables_trx_all RCVTRX, ce_bank_accounts CBA, ce_bank_acct_uses APBA, hz_cust_accounts CUST_ACCT, hz_parties PARTY, hz_cust_site_uses_all SU, ar_vat_tax_all VAT, ar_receipt_methods RM, ar_distributions_all_mrc_v ARD, ar_cash_receipt_hist_all_mrc_v CRH, fnd_document_sequences SEQ, gl_daily_conversion_types GLCT WHERE CRH.cash_receipt_id = CR.cash_receipt_id AND nvl(CRH.org_id,-99) = nvl(CR.org_id,-99) AND ARD.source_table = 'CRH' AND ARD.source_id = CRH.cash_receipt_history_id AND nvl(ARD.org_id,-99) = nvl(CRH.org_id,-99) AND GLCT.conversion_type(+) = ARD.currency_conversion_type AND CR.doc_sequence_id = SEQ.doc_sequence_id (+) AND CR.receipt_method_id = RM.receipt_method_id AND ARD.tax_code_id = VAT.vat_tax_id(+) AND nvl(ARD.org_id,-99) = nvl(VAT.org_id(+),-99) AND ARD.third_party_id = CUST_ACCT.cust_account_id(+) AND CUST_ACCT.party_id = PARTY.party_id(+) AND ARD.third_party_sub_id = SU.site_use_id(+) AND nvl(ARD.org_id,-99) = nvl(SU.org_id(+),-99) AND CR.remit_bank_acct_use_id = APBA.bank_acct_use_id(+) AND nvl(CR.org_id,-99) = nvl(APBA.org_id(+),-99) AND CR.receivables_trx_id = RCVTRX.receivables_trx_id(+) AND nvl(CR.org_id,-99) = nvl(RCVTRX.org_id(+),-99) AND APBA.bank_account_id = CBA.bank_account_id (+) UNION ALL /*------------------------------------------------------------------------+ Trade Receipt Applications(Non-CASH AE Lines) +------------------------------------------------------------------------*/ select 222 APPLICATION_ID , CR.set_of_books_id SET_OF_BOOKS_ID , CR.org_id ORG_ID , CR.type TRX_CLASS , arpt_sql_func_util.get_lookup_meaning('PAYMENT_CATEGORY_TYPE', CR.type) TRX_CLASS_NAME , CR.receipt_method_id TRX_TYPE_N , RM.name TRX_TYPE_NAME , CR.receipt_number TRX_NUMBER_DISPLAYED , CR.receipt_number TRX_NUMBER_C , CR.receipt_date TRX_DATE , CR.comments COMMENTS , CR.doc_sequence_id DOC_SEQUENCE_ID , SEQ.name DOC_SEQUENCE_NAME , CR.doc_sequence_value DOC_SEQUENCE_VALUE, 'CR' TRX_HDR_TABLE, CR.cash_receipt_id TRX_HDR_ID, ARD.source_type ACCT_LINE_TYPE, arpt_sql_func_util.get_lookup_meaning('DISTRIBUTION_SOURCE_TYPE', ARD.source_type) ACCT_LINE_TYPE_NAME, ARD.code_combination_id CODE_COMBINATION_ID, ARD.currency_code CURRENCY_CODE, ARD.amount_dr ENTERED_DR, ARD.amount_cr ENTERED_CR, ARD.acctd_amount_dr ACCOUNTED_DR, ARD.acctd_amount_cr ACCOUNTED_CR, ARD.currency_conversion_date CURRENCY_CONVERSION_DATE, ARD.currency_conversion_type CURRENCY_CONVERSION_TYPE, GLCT.user_conversion_type CURRENCY_USER_CONVERSION_TYPE, ARD.currency_conversion_rate CURRENCY_CONVERSION_RATE, 'C' THIRD_PARTY_TYPE, ARD.third_party_id THIRD_PARTY_ID, CUST_ACCT.account_number THIRD_PARTY_NUMBER, substrb(party.party_name,1,50) THIRD_PARTY_NAME, ARD.third_party_sub_id THIRD_PARTY_SUB_ID, SU.location THIRD_PARTY_SUB_NAME, RA.gl_date ACCOUNTING_DATE, arpt_sql_func_util.get_lookup_meaning('YES/NO', decode(RA.posting_control_id,-3,'N','Y')) GL_TRANSFER_STATUS_NAME, decode(RA.posting_control_id, -3,'N','Y') GL_TRANSFER_STATUS, ARD.source_table SOURCE_TABLE, ARD.source_id SOURCE_ID, ARD.line_id AEL_ID, 'ARD' AEL_TABLE, /* Line Ref: If applied to trans 'Applied To ' + ' ' + Applied To Trans Class + ' ' + Applied To Trans Number else Trans Class + ' ' + Trans Number */ /* Bug 1783967 -for activity application,take the trx_number from payment schedules */ decode(SIGN(RA.applied_customer_trx_id), -1, arpt_sql_func_util.get_lookup_meaning('VIEW_ACCOUNTING', 'APPLIED_TO') ||' '||PS.trx_number, 1, arpt_sql_func_util.get_lookup_meaning('VIEW_ACCOUNTING', 'APPLIED_TO')||' '||L4.meaning||' '|| CT.trx_number, null, arpt_sql_func_util.get_lookup_meaning('PAYMENT_CATEGORY_TYPE',CR.type) ||' '||CR.receipt_number) AE_LINE_REFERENCE, decode(SIGN(RA.applied_customer_trx_id), -1,rpad(CR.receipt_number, 30, ' '), 1,rpad(CT.trx_number, 20, ' '), rpad(CR.receipt_number, 30, ' ')) AE_LINE_REFERENCE_INTERNAL, ARD.last_update_date LAST_UPDATE_DATE, ARD.last_updated_by LAST_UPDATED_BY, ARD.creation_date CREATION_DATE, ARD.created_by CREATED_BY, ARD.last_update_login LAST_UPDATE_LOGIN, /* The following columns are specific to AR Receipts */ 'ACCRUAL' ACCOUNTING_BASIS, VAT.tax_code TAX_CODE, ARD.tax_code_id TAX_CODE_ID, ARD.tax_link_id TAX_LINK_ID, ARD.taxable_entered_dr TAXABLE_ENTERED_DR, ARD.taxable_entered_cr TAXABLE_ENTERED_CR, ARD.taxable_accounted_dr TAXABLE_ACCOUNTED_DR, ARD.taxable_accounted_cr TAXABLE_ACCOUNTED_CR, CR.currency_code TRX_HDR_CURRENCY, CBA.bank_account_name BANK_ACCOUNT_NAME, CR.reversal_comments REVERSAL_COMMENTS, CR.reversal_date REVERSAL_DATE, RA.apply_date APPLICATION_DATE, CR.deposit_date PAYMENT_DEPOSIT_DATE, 'CT' APPLIED_TO_TRX_HDR_TABLE, RA.applied_customer_trx_id APPLIED_TO_TRX_HDR_ID, CT.trx_number APPLIED_TO_TRX_HDR_NUMBER_C, CT.trx_number APPLIED_TO_TRX_HDR_NUMBER_DISP, CT.invoice_currency_code APPLIED_TO_TRX_HDR_CURRENCY, CT.trx_date APPLIED_TO_TRX_HDR_DATE, L3.meaning APPLIED_TO_TRX_LINE_TYPE_NAME, CTL.line_type APPLIED_TO_TRX_LINE_TYPE, CTL.line_number APPLIED_TO_TRX_LINE_NUMBER, RCVTRX.name AR_ACTIVITY_NAME, null DISTRIBUTION_SET_NAME FROM ar_cash_receipts_all_mrc_v CR, ar_receivables_trx_all RCVTRX, ce_bank_accounts CBA, ce_bank_acct_uses APBA, hz_cust_accounts CUST_ACCT, hz_parties PARTY, hz_cust_site_uses_all SU, ra_cust_trx_types_all CTT, ar_vat_tax_all VAT, ar_receipt_methods RM, ra_customer_trx_all_mrc_v CT, ra_customer_trx_lines_all CTL, ar_distributions_all_mrc_v ARD, ar_receivable_apps_all_mrc_v RA, ar_payment_schedules_all_mrc_v PS, fnd_document_sequences SEQ, gl_daily_conversion_types GLCT, ar_lookups L3 , ar_lookups L4 WHERE L3.lookup_type(+) = 'STD_LINE_TYPE' AND L3.lookup_code(+) = CTL.line_type AND L4.lookup_type(+) = 'INV/CM' AND L4.lookup_code(+) = CTT.type AND RA.application_type = 'CASH' AND nvl(RA.postable, 'Y') = 'Y' AND RA.cash_receipt_id = CR.cash_receipt_id AND nvl(RA.org_id, -99) = nvl(CR.org_id, -99) AND ARD.source_table = 'RA' AND ARD.source_id = RA.receivable_application_id AND nvl(ARD.org_id, -99) = nvl(RA.org_id, -99) AND GLCT.conversion_type(+) = ARD.currency_conversion_type AND CR.doc_sequence_id = SEQ.doc_sequence_id (+) AND CR.receipt_method_id = RM.receipt_method_id AND ARD.tax_code_id = VAT.vat_tax_id(+) AND nvl(ARD.org_id, -99) = nvl(VAT.org_id(+), -99) AND ARD.third_party_id = CUST_ACCT.cust_account_id(+) AND CUST_ACCT.party_id = PARTY.party_id(+) AND ARD.third_party_sub_id = SU.site_use_id(+) AND nvl(ARD.org_id, -99) = nvl(SU.org_id(+), -99) AND CR.remit_bank_acct_use_id = APBA.bank_acct_use_id(+) AND nvl(CR.org_id,-99) = nvl(APBA.org_id(+),-99) AND CR.receivables_trx_id = RCVTRX.receivables_trx_id(+) AND nvl(CR.org_id,-99) = nvl(RCVTRX.org_id(+),-99) AND CT.cust_trx_type_id = CTT.cust_trx_type_id(+) AND nvl(CT.org_id, -99) = nvl(CTT.org_id(+), -99) AND RA.applied_customer_trx_id = CT.customer_trx_id(+) AND RA.applied_payment_schedule_id = PS.payment_schedule_id(+) AND nvl(RA.org_id, -99) = nvl(CT.org_id(+), -99) AND RA.applied_customer_trx_line_id = CTL.customer_trx_line_id(+) AND nvl(RA.org_id, -99) = nvl(CTL.org_id(+), -99) AND APBA.bank_account_id = CBA.bank_account_id (+) UNION ALL /*------------------------------------------------------------------------+ Misc Cash Distributions(Non-Cash + Tax AE Lines) +------------------------------------------------------------------------*/ select 222 APPLICATION_ID , CR.set_of_books_id SET_OF_BOOKS_ID , CR.org_id ORG_ID , CR.type TRX_CLASS , arpt_sql_func_util.get_lookup_meaning('PAYMENT_CATEGORY_TYPE', cr.type) TRX_CLASS_NAME , CR.receipt_method_id TRX_TYPE_N , RM.name TRX_TYPE_NAME , CR.receipt_number TRX_NUMBER_DISPLAYED , CR.receipt_number TRX_NUMBER_C , CR.receipt_date TRX_DATE , CR.comments COMMENTS , CR.doc_sequence_id DOC_SEQUENCE_ID , SEQ.name DOC_SEQUENCE_NAME , CR.doc_sequence_value DOC_SEQUENCE_VALUE, 'CR' TRX_HDR_TABLE, CR.cash_receipt_id TRX_HDR_ID, ARD.source_type ACCT_LINE_TYPE, arpt_sql_func_util.get_lookup_meaning('DISTRIBUTION_SOURCE_TYPE', ARD.source_type) ACCT_LINE_TYPE_NAME, ARD.code_combination_id CODE_COMBINATION_ID, ARD.currency_code CURRENCY_CODE, ARD.amount_dr ENTERED_DR, ARD.amount_cr ENTERED_CR, ARD.acctd_amount_dr ACCOUNTED_DR, ARD.acctd_amount_cr ACCOUNTED_CR, ARD.currency_conversion_date CURRENCY_CONVERSION_DATE, ARD.currency_conversion_type CURRENCY_CONVERSION_TYPE, GLCT.user_conversion_type CURRENCY_USER_CONVERSION_TYPE, ARD.currency_conversion_rate CURRENCY_CONVERSION_RATE, 'C' THIRD_PARTY_TYPE, ARD.third_party_id THIRD_PARTY_ID, null THIRD_PARTY_NUMBER, null THIRD_PARTY_NAME, ARD.third_party_sub_id THIRD_PARTY_SUB_ID, null THIRD_PARTY_SUB_NAME, MCD.gl_date ACCOUNTING_DATE, arpt_sql_func_util.get_lookup_meaning('YES/NO', decode(MCD.posting_control_id,-3,'N','Y')) GL_TRANSFER_STATUS_NAME, decode(MCD.posting_control_id,-3,'N','Y') GL_TRANSFER_STATUS, ARD.source_table SOURCE_TABLE, ARD.source_id SOURCE_ID, ARD.line_id AEL_ID, 'ARD' AEL_TABLE, /* Line Ref: Trans Class + ' ' + Trans Number */ arpt_sql_func_util.get_lookup_meaning('PAYMENT_CATEGORY_TYPE', cr.type) ||' '||CR.receipt_number AE_LINE_REFERENCE, rpad(CR.receipt_number, 30, ' ') AE_LINE_REFERENCE_INTERNAL, ARD.last_update_date LAST_UPDATE_DATE, ARD.last_updated_by LAST_UPDATED_BY, ARD.creation_date CREATION_DATE, ARD.created_by CREATED_BY, ARD.last_update_login LAST_UPDATE_LOGIN, /* The following columns are specific to AR Receipts */ 'ACCRUAL' ACCOUNTING_BASIS, VAT.tax_code TAX_CODE, ARD.tax_code_id TAX_CODE_ID, ARD.tax_link_id TAX_LINK_ID, ARD.taxable_entered_dr TAXABLE_ENTERED_DR, ARD.taxable_entered_cr TAXABLE_ENTERED_CR, ARD.taxable_accounted_dr TAXABLE_ACCOUNTED_DR, ARD.taxable_accounted_cr TAXABLE_ACCOUNTED_CR, CR.currency_code TRX_HDR_CURRENCY, CBA.bank_account_name BANK_ACCOUNT_NAME, CR.reversal_comments REVERSAL_COMMENTS, CR.reversal_date REVERSAL_DATE, to_date(null) APPLICATION_DATE, CR.deposit_date PAYMENT_DEPOSIT_DATE, null APPLIED_TO_TRX_HDR_TABLE, to_number(null) APPLIED_TO_TRX_HDR_ID, null APPLIED_TO_TRX_HDR_NUMBER_C, null APPLIED_TO_TRX_HDR_NUMBER_DISP, null APPLIED_TO_TRX_HDR_CURRENCY, to_date(null) APPLIED_TO_TRX_HDR_DATE, null APPLIED_TO_TRX_LINE_TYPE_NAME, null APPLIED_TO_TRX_LINE_TYPE, to_number(null) APPLIED_TO_TRX_LINE_NUMBER, RCVTRX.name AR_ACTIVITY_NAME, DSET.distribution_set_name DISTRIBUTION_SET_NAME FROM ar_cash_receipts_all_mrc_v CR, ar_receivables_trx_all RCVTRX, ce_bank_accounts CBA, ce_bank_acct_uses APBA, ar_distribution_sets_all DSET, ar_vat_tax_all VAT, ar_receipt_methods RM, ar_distributions_all_mrc_v ARD, ar_misc_cash_dists_all_mrc_v MCD, fnd_document_sequences SEQ, gl_daily_conversion_types GLCT WHERE MCD.cash_receipt_id = CR.cash_receipt_id AND nvl(MCD.org_id,-99) = nvl(CR.org_id,-99) AND ARD.source_table = 'MCD' AND ARD.source_id = MCD.misc_cash_distribution_id AND nvl(ARD.org_id,-99) = nvl(MCD.org_id,-99) AND ARD.tax_code_id = VAT.vat_tax_id(+) AND nvl(ARD.org_id,-99) = nvl(VAT.org_id(+),-99) AND GLCT.conversion_type(+) = ARD.currency_conversion_type AND CR.doc_sequence_id = SEQ.doc_sequence_id (+) AND CR.receipt_method_id = RM.receipt_method_id AND CR.remit_bank_acct_use_id = APBA.bank_acct_use_id(+) AND nvl(CR.org_id,-99) = nvl(APBA.org_id(+),-99) AND CR.receivables_trx_id = RCVTRX.receivables_trx_id(+) AND nvl(CR.org_id,-99) = nvl(RCVTRX.org_id(+),-99) AND CR.distribution_set_id = DSET.distribution_set_id(+) AND nvl(CR.org_id,-99) = nvl(DSET.org_id(+),-99) AND APBA.bank_account_id = CBA.bank_account_id (+)

View Text - HTML Formatted

SELECT 222 APPLICATION_ID
, CR.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, CR.ORG_ID ORG_ID
, CR.TYPE TRX_CLASS
, /* BUGFIX 2182064. SIMILAR CHANGES IN ALL SELECTS */ ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('PAYMENT_CATEGORY_TYPE'
, CR.TYPE) TRX_CLASS_NAME
, CR.RECEIPT_METHOD_ID TRX_TYPE_N
, RM.NAME TRX_TYPE_NAME
, CR.RECEIPT_NUMBER TRX_NUMBER_DISPLAYED
, CR.RECEIPT_NUMBER TRX_NUMBER_C
, CR.RECEIPT_DATE TRX_DATE
, CR.COMMENTS COMMENTS
, CR.DOC_SEQUENCE_ID DOC_SEQUENCE_ID
, SEQ.NAME DOC_SEQUENCE_NAME
, CR.DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE
, 'CR' TRX_HDR_TABLE
, CR.CASH_RECEIPT_ID TRX_HDR_ID
, ARD.SOURCE_TYPE ACCT_LINE_TYPE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('DISTRIBUTION_SOURCE_TYPE'
, ARD.SOURCE_TYPE) ACCT_LINE_TYPE_NAME
, ARD.CODE_COMBINATION_ID CODE_COMBINATION_ID
, ARD.CURRENCY_CODE CURRENCY_CODE
, ARD.AMOUNT_DR ENTERED_DR
, ARD.AMOUNT_CR ENTERED_CR
, ARD.ACCTD_AMOUNT_DR ACCOUNTED_DR
, ARD.ACCTD_AMOUNT_CR ACCOUNTED_CR
, ARD.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, ARD.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, GLCT.USER_CONVERSION_TYPE CURRENCY_USER_CONVERSION_TYPE
, ARD.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, 'C' THIRD_PARTY_TYPE
, ARD.THIRD_PARTY_ID THIRD_PARTY_ID
, CUST_ACCT.ACCOUNT_NUMBER THIRD_PARTY_NUMBER
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50) THIRD_PARTY_NAME
, ARD.THIRD_PARTY_SUB_ID THIRD_PARTY_SUB_ID
, SU.LOCATION THIRD_PARTY_SUB_NAME
, CRH.GL_DATE ACCOUNTING_DATE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO'
, DECODE(CRH.POSTING_CONTROL_ID
, -3
, 'N'
, 'Y')) GL_TRANSFER_STATUS_NAME
, DECODE(CRH.POSTING_CONTROL_ID
, -3
, 'N'
, 'Y') GL_TRANSFER_STATUS
, ARD.SOURCE_TABLE SOURCE_TABLE
, ARD.SOURCE_ID SOURCE_ID
, ARD.LINE_ID AEL_ID
, 'ARD' AEL_TABLE
, /* LINE REF: TRANS CLASS + ' ' + TRANS NUMBER */ ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('PAYMENT_CATEGORY_TYPE'
, CR.TYPE) ||' '||CR.RECEIPT_NUMBER AE_LINE_REFERENCE
, RPAD(CR.RECEIPT_NUMBER
, 30
, ' ') AE_LINE_REFERENCE_INTERNAL
, ARD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ARD.LAST_UPDATED_BY LAST_UPDATED_BY
, ARD.CREATION_DATE CREATION_DATE
, ARD.CREATED_BY CREATED_BY
, ARD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, /* THE FOLLOWING COLUMNS ARE SPECIFIC TO AR RECEIPTS */ 'ACCRUAL' ACCOUNTING_BASIS
, VAT.TAX_CODE TAX_CODE
, ARD.TAX_CODE_ID TAX_CODE_ID
, ARD.TAX_LINK_ID TAX_LINK_ID
, ARD.TAXABLE_ENTERED_DR TAXABLE_ENTERED_DR
, ARD.TAXABLE_ENTERED_CR TAXABLE_ENTERED_CR
, ARD.TAXABLE_ACCOUNTED_DR TAXABLE_ACCOUNTED_DR
, ARD.TAXABLE_ACCOUNTED_CR TAXABLE_ACCOUNTED_CR
, CR.CURRENCY_CODE TRX_HDR_CURRENCY
, CBA.BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, CR.REVERSAL_COMMENTS REVERSAL_COMMENTS
, CR.REVERSAL_DATE REVERSAL_DATE
, TO_DATE(NULL) APPLICATION_DATE
, CR.DEPOSIT_DATE PAYMENT_DEPOSIT_DATE
, NULL APPLIED_TO_TRX_HDR_TABLE
, TO_NUMBER(NULL) APPLIED_TO_TRX_HDR_ID
, NULL APPLIED_TO_TRX_HDR_NUMBER_C
, NULL APPLIED_TO_TRX_HDR_NUMBER_DISP
, NULL APPLIED_TO_TRX_HDR_CURRENCY
, TO_DATE(NULL) APPLIED_TO_TRX_HDR_DATE
, NULL APPLIED_TO_TRX_LINE_TYPE_NAME
, NULL APPLIED_TO_TRX_LINE_TYPE
, TO_NUMBER(NULL) APPLIED_TO_TRX_LINE_NUMBER
, RCVTRX.NAME AR_ACTIVITY_NAME
, NULL DISTRIBUTION_SET_NAME
FROM AR_CASH_RECEIPTS_ALL_MRC_V CR
, AR_RECEIVABLES_TRX_ALL RCVTRX
, CE_BANK_ACCOUNTS CBA
, CE_BANK_ACCT_USES APBA
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
, HZ_CUST_SITE_USES_ALL SU
, AR_VAT_TAX_ALL VAT
, AR_RECEIPT_METHODS RM
, AR_DISTRIBUTIONS_ALL_MRC_V ARD
, AR_CASH_RECEIPT_HIST_ALL_MRC_V CRH
, FND_DOCUMENT_SEQUENCES SEQ
, GL_DAILY_CONVERSION_TYPES GLCT
WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
AND NVL(CRH.ORG_ID
, -99) = NVL(CR.ORG_ID
, -99)
AND ARD.SOURCE_TABLE = 'CRH'
AND ARD.SOURCE_ID = CRH.CASH_RECEIPT_HISTORY_ID
AND NVL(ARD.ORG_ID
, -99) = NVL(CRH.ORG_ID
, -99)
AND GLCT.CONVERSION_TYPE(+) = ARD.CURRENCY_CONVERSION_TYPE
AND CR.DOC_SEQUENCE_ID = SEQ.DOC_SEQUENCE_ID (+)
AND CR.RECEIPT_METHOD_ID = RM.RECEIPT_METHOD_ID
AND ARD.TAX_CODE_ID = VAT.VAT_TAX_ID(+)
AND NVL(ARD.ORG_ID
, -99) = NVL(VAT.ORG_ID(+)
, -99)
AND ARD.THIRD_PARTY_ID = CUST_ACCT.CUST_ACCOUNT_ID(+)
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID(+)
AND ARD.THIRD_PARTY_SUB_ID = SU.SITE_USE_ID(+)
AND NVL(ARD.ORG_ID
, -99) = NVL(SU.ORG_ID(+)
, -99)
AND CR.REMIT_BANK_ACCT_USE_ID = APBA.BANK_ACCT_USE_ID(+)
AND NVL(CR.ORG_ID
, -99) = NVL(APBA.ORG_ID(+)
, -99)
AND CR.RECEIVABLES_TRX_ID = RCVTRX.RECEIVABLES_TRX_ID(+)
AND NVL(CR.ORG_ID
, -99) = NVL(RCVTRX.ORG_ID(+)
, -99)
AND APBA.BANK_ACCOUNT_ID = CBA.BANK_ACCOUNT_ID (+) UNION ALL /*------------------------------------------------------------------------+ TRADE RECEIPT APPLICATIONS(NON-CASH AE LINES) +------------------------------------------------------------------------*/ SELECT 222 APPLICATION_ID
, CR.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, CR.ORG_ID ORG_ID
, CR.TYPE TRX_CLASS
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('PAYMENT_CATEGORY_TYPE'
, CR.TYPE) TRX_CLASS_NAME
, CR.RECEIPT_METHOD_ID TRX_TYPE_N
, RM.NAME TRX_TYPE_NAME
, CR.RECEIPT_NUMBER TRX_NUMBER_DISPLAYED
, CR.RECEIPT_NUMBER TRX_NUMBER_C
, CR.RECEIPT_DATE TRX_DATE
, CR.COMMENTS COMMENTS
, CR.DOC_SEQUENCE_ID DOC_SEQUENCE_ID
, SEQ.NAME DOC_SEQUENCE_NAME
, CR.DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE
, 'CR' TRX_HDR_TABLE
, CR.CASH_RECEIPT_ID TRX_HDR_ID
, ARD.SOURCE_TYPE ACCT_LINE_TYPE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('DISTRIBUTION_SOURCE_TYPE'
, ARD.SOURCE_TYPE) ACCT_LINE_TYPE_NAME
, ARD.CODE_COMBINATION_ID CODE_COMBINATION_ID
, ARD.CURRENCY_CODE CURRENCY_CODE
, ARD.AMOUNT_DR ENTERED_DR
, ARD.AMOUNT_CR ENTERED_CR
, ARD.ACCTD_AMOUNT_DR ACCOUNTED_DR
, ARD.ACCTD_AMOUNT_CR ACCOUNTED_CR
, ARD.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, ARD.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, GLCT.USER_CONVERSION_TYPE CURRENCY_USER_CONVERSION_TYPE
, ARD.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, 'C' THIRD_PARTY_TYPE
, ARD.THIRD_PARTY_ID THIRD_PARTY_ID
, CUST_ACCT.ACCOUNT_NUMBER THIRD_PARTY_NUMBER
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50) THIRD_PARTY_NAME
, ARD.THIRD_PARTY_SUB_ID THIRD_PARTY_SUB_ID
, SU.LOCATION THIRD_PARTY_SUB_NAME
, RA.GL_DATE ACCOUNTING_DATE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO'
, DECODE(RA.POSTING_CONTROL_ID
, -3
, 'N'
, 'Y')) GL_TRANSFER_STATUS_NAME
, DECODE(RA.POSTING_CONTROL_ID
, -3
, 'N'
, 'Y') GL_TRANSFER_STATUS
, ARD.SOURCE_TABLE SOURCE_TABLE
, ARD.SOURCE_ID SOURCE_ID
, ARD.LINE_ID AEL_ID
, 'ARD' AEL_TABLE
, /* LINE REF: IF APPLIED TO TRANS 'APPLIED TO ' + ' ' + APPLIED TO TRANS CLASS + ' ' + APPLIED TO TRANS NUMBER ELSE TRANS CLASS + ' ' + TRANS NUMBER */ /* BUG 1783967 -FOR ACTIVITY APPLICATION
, TAKE THE TRX_NUMBER
FROM PAYMENT SCHEDULES */ DECODE(SIGN(RA.APPLIED_CUSTOMER_TRX_ID)
, -1
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('VIEW_ACCOUNTING'
, 'APPLIED_TO') ||' '||PS.TRX_NUMBER
, 1
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('VIEW_ACCOUNTING'
, 'APPLIED_TO')||' '||L4.MEANING||' '|| CT.TRX_NUMBER
, NULL
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('PAYMENT_CATEGORY_TYPE'
, CR.TYPE) ||' '||CR.RECEIPT_NUMBER) AE_LINE_REFERENCE
, DECODE(SIGN(RA.APPLIED_CUSTOMER_TRX_ID)
, -1
, RPAD(CR.RECEIPT_NUMBER
, 30
, ' ')
, 1
, RPAD(CT.TRX_NUMBER
, 20
, ' ')
, RPAD(CR.RECEIPT_NUMBER
, 30
, ' ')) AE_LINE_REFERENCE_INTERNAL
, ARD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ARD.LAST_UPDATED_BY LAST_UPDATED_BY
, ARD.CREATION_DATE CREATION_DATE
, ARD.CREATED_BY CREATED_BY
, ARD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, /* THE FOLLOWING COLUMNS ARE SPECIFIC TO AR RECEIPTS */ 'ACCRUAL' ACCOUNTING_BASIS
, VAT.TAX_CODE TAX_CODE
, ARD.TAX_CODE_ID TAX_CODE_ID
, ARD.TAX_LINK_ID TAX_LINK_ID
, ARD.TAXABLE_ENTERED_DR TAXABLE_ENTERED_DR
, ARD.TAXABLE_ENTERED_CR TAXABLE_ENTERED_CR
, ARD.TAXABLE_ACCOUNTED_DR TAXABLE_ACCOUNTED_DR
, ARD.TAXABLE_ACCOUNTED_CR TAXABLE_ACCOUNTED_CR
, CR.CURRENCY_CODE TRX_HDR_CURRENCY
, CBA.BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, CR.REVERSAL_COMMENTS REVERSAL_COMMENTS
, CR.REVERSAL_DATE REVERSAL_DATE
, RA.APPLY_DATE APPLICATION_DATE
, CR.DEPOSIT_DATE PAYMENT_DEPOSIT_DATE
, 'CT' APPLIED_TO_TRX_HDR_TABLE
, RA.APPLIED_CUSTOMER_TRX_ID APPLIED_TO_TRX_HDR_ID
, CT.TRX_NUMBER APPLIED_TO_TRX_HDR_NUMBER_C
, CT.TRX_NUMBER APPLIED_TO_TRX_HDR_NUMBER_DISP
, CT.INVOICE_CURRENCY_CODE APPLIED_TO_TRX_HDR_CURRENCY
, CT.TRX_DATE APPLIED_TO_TRX_HDR_DATE
, L3.MEANING APPLIED_TO_TRX_LINE_TYPE_NAME
, CTL.LINE_TYPE APPLIED_TO_TRX_LINE_TYPE
, CTL.LINE_NUMBER APPLIED_TO_TRX_LINE_NUMBER
, RCVTRX.NAME AR_ACTIVITY_NAME
, NULL DISTRIBUTION_SET_NAME
FROM AR_CASH_RECEIPTS_ALL_MRC_V CR
, AR_RECEIVABLES_TRX_ALL RCVTRX
, CE_BANK_ACCOUNTS CBA
, CE_BANK_ACCT_USES APBA
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
, HZ_CUST_SITE_USES_ALL SU
, RA_CUST_TRX_TYPES_ALL CTT
, AR_VAT_TAX_ALL VAT
, AR_RECEIPT_METHODS RM
, RA_CUSTOMER_TRX_ALL_MRC_V CT
, RA_CUSTOMER_TRX_LINES_ALL CTL
, AR_DISTRIBUTIONS_ALL_MRC_V ARD
, AR_RECEIVABLE_APPS_ALL_MRC_V RA
, AR_PAYMENT_SCHEDULES_ALL_MRC_V PS
, FND_DOCUMENT_SEQUENCES SEQ
, GL_DAILY_CONVERSION_TYPES GLCT
, AR_LOOKUPS L3
, AR_LOOKUPS L4
WHERE L3.LOOKUP_TYPE(+) = 'STD_LINE_TYPE'
AND L3.LOOKUP_CODE(+) = CTL.LINE_TYPE
AND L4.LOOKUP_TYPE(+) = 'INV/CM'
AND L4.LOOKUP_CODE(+) = CTT.TYPE
AND RA.APPLICATION_TYPE = 'CASH'
AND NVL(RA.POSTABLE
, 'Y') = 'Y'
AND RA.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
AND NVL(RA.ORG_ID
, -99) = NVL(CR.ORG_ID
, -99)
AND ARD.SOURCE_TABLE = 'RA'
AND ARD.SOURCE_ID = RA.RECEIVABLE_APPLICATION_ID
AND NVL(ARD.ORG_ID
, -99) = NVL(RA.ORG_ID
, -99)
AND GLCT.CONVERSION_TYPE(+) = ARD.CURRENCY_CONVERSION_TYPE
AND CR.DOC_SEQUENCE_ID = SEQ.DOC_SEQUENCE_ID (+)
AND CR.RECEIPT_METHOD_ID = RM.RECEIPT_METHOD_ID
AND ARD.TAX_CODE_ID = VAT.VAT_TAX_ID(+)
AND NVL(ARD.ORG_ID
, -99) = NVL(VAT.ORG_ID(+)
, -99)
AND ARD.THIRD_PARTY_ID = CUST_ACCT.CUST_ACCOUNT_ID(+)
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID(+)
AND ARD.THIRD_PARTY_SUB_ID = SU.SITE_USE_ID(+)
AND NVL(ARD.ORG_ID
, -99) = NVL(SU.ORG_ID(+)
, -99)
AND CR.REMIT_BANK_ACCT_USE_ID = APBA.BANK_ACCT_USE_ID(+)
AND NVL(CR.ORG_ID
, -99) = NVL(APBA.ORG_ID(+)
, -99)
AND CR.RECEIVABLES_TRX_ID = RCVTRX.RECEIVABLES_TRX_ID(+)
AND NVL(CR.ORG_ID
, -99) = NVL(RCVTRX.ORG_ID(+)
, -99)
AND CT.CUST_TRX_TYPE_ID = CTT.CUST_TRX_TYPE_ID(+)
AND NVL(CT.ORG_ID
, -99) = NVL(CTT.ORG_ID(+)
, -99)
AND RA.APPLIED_CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID(+)
AND RA.APPLIED_PAYMENT_SCHEDULE_ID = PS.PAYMENT_SCHEDULE_ID(+)
AND NVL(RA.ORG_ID
, -99) = NVL(CT.ORG_ID(+)
, -99)
AND RA.APPLIED_CUSTOMER_TRX_LINE_ID = CTL.CUSTOMER_TRX_LINE_ID(+)
AND NVL(RA.ORG_ID
, -99) = NVL(CTL.ORG_ID(+)
, -99)
AND APBA.BANK_ACCOUNT_ID = CBA.BANK_ACCOUNT_ID (+) UNION ALL /*------------------------------------------------------------------------+ MISC CASH DISTRIBUTIONS(NON-CASH + TAX AE LINES) +------------------------------------------------------------------------*/ SELECT 222 APPLICATION_ID
, CR.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, CR.ORG_ID ORG_ID
, CR.TYPE TRX_CLASS
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('PAYMENT_CATEGORY_TYPE'
, CR.TYPE) TRX_CLASS_NAME
, CR.RECEIPT_METHOD_ID TRX_TYPE_N
, RM.NAME TRX_TYPE_NAME
, CR.RECEIPT_NUMBER TRX_NUMBER_DISPLAYED
, CR.RECEIPT_NUMBER TRX_NUMBER_C
, CR.RECEIPT_DATE TRX_DATE
, CR.COMMENTS COMMENTS
, CR.DOC_SEQUENCE_ID DOC_SEQUENCE_ID
, SEQ.NAME DOC_SEQUENCE_NAME
, CR.DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE
, 'CR' TRX_HDR_TABLE
, CR.CASH_RECEIPT_ID TRX_HDR_ID
, ARD.SOURCE_TYPE ACCT_LINE_TYPE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('DISTRIBUTION_SOURCE_TYPE'
, ARD.SOURCE_TYPE) ACCT_LINE_TYPE_NAME
, ARD.CODE_COMBINATION_ID CODE_COMBINATION_ID
, ARD.CURRENCY_CODE CURRENCY_CODE
, ARD.AMOUNT_DR ENTERED_DR
, ARD.AMOUNT_CR ENTERED_CR
, ARD.ACCTD_AMOUNT_DR ACCOUNTED_DR
, ARD.ACCTD_AMOUNT_CR ACCOUNTED_CR
, ARD.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, ARD.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, GLCT.USER_CONVERSION_TYPE CURRENCY_USER_CONVERSION_TYPE
, ARD.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, 'C' THIRD_PARTY_TYPE
, ARD.THIRD_PARTY_ID THIRD_PARTY_ID
, NULL THIRD_PARTY_NUMBER
, NULL THIRD_PARTY_NAME
, ARD.THIRD_PARTY_SUB_ID THIRD_PARTY_SUB_ID
, NULL THIRD_PARTY_SUB_NAME
, MCD.GL_DATE ACCOUNTING_DATE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO'
, DECODE(MCD.POSTING_CONTROL_ID
, -3
, 'N'
, 'Y')) GL_TRANSFER_STATUS_NAME
, DECODE(MCD.POSTING_CONTROL_ID
, -3
, 'N'
, 'Y') GL_TRANSFER_STATUS
, ARD.SOURCE_TABLE SOURCE_TABLE
, ARD.SOURCE_ID SOURCE_ID
, ARD.LINE_ID AEL_ID
, 'ARD' AEL_TABLE
, /* LINE REF: TRANS CLASS + ' ' + TRANS NUMBER */ ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('PAYMENT_CATEGORY_TYPE'
, CR.TYPE) ||' '||CR.RECEIPT_NUMBER AE_LINE_REFERENCE
, RPAD(CR.RECEIPT_NUMBER
, 30
, ' ') AE_LINE_REFERENCE_INTERNAL
, ARD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ARD.LAST_UPDATED_BY LAST_UPDATED_BY
, ARD.CREATION_DATE CREATION_DATE
, ARD.CREATED_BY CREATED_BY
, ARD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, /* THE FOLLOWING COLUMNS ARE SPECIFIC TO AR RECEIPTS */ 'ACCRUAL' ACCOUNTING_BASIS
, VAT.TAX_CODE TAX_CODE
, ARD.TAX_CODE_ID TAX_CODE_ID
, ARD.TAX_LINK_ID TAX_LINK_ID
, ARD.TAXABLE_ENTERED_DR TAXABLE_ENTERED_DR
, ARD.TAXABLE_ENTERED_CR TAXABLE_ENTERED_CR
, ARD.TAXABLE_ACCOUNTED_DR TAXABLE_ACCOUNTED_DR
, ARD.TAXABLE_ACCOUNTED_CR TAXABLE_ACCOUNTED_CR
, CR.CURRENCY_CODE TRX_HDR_CURRENCY
, CBA.BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, CR.REVERSAL_COMMENTS REVERSAL_COMMENTS
, CR.REVERSAL_DATE REVERSAL_DATE
, TO_DATE(NULL) APPLICATION_DATE
, CR.DEPOSIT_DATE PAYMENT_DEPOSIT_DATE
, NULL APPLIED_TO_TRX_HDR_TABLE
, TO_NUMBER(NULL) APPLIED_TO_TRX_HDR_ID
, NULL APPLIED_TO_TRX_HDR_NUMBER_C
, NULL APPLIED_TO_TRX_HDR_NUMBER_DISP
, NULL APPLIED_TO_TRX_HDR_CURRENCY
, TO_DATE(NULL) APPLIED_TO_TRX_HDR_DATE
, NULL APPLIED_TO_TRX_LINE_TYPE_NAME
, NULL APPLIED_TO_TRX_LINE_TYPE
, TO_NUMBER(NULL) APPLIED_TO_TRX_LINE_NUMBER
, RCVTRX.NAME AR_ACTIVITY_NAME
, DSET.DISTRIBUTION_SET_NAME DISTRIBUTION_SET_NAME
FROM AR_CASH_RECEIPTS_ALL_MRC_V CR
, AR_RECEIVABLES_TRX_ALL RCVTRX
, CE_BANK_ACCOUNTS CBA
, CE_BANK_ACCT_USES APBA
, AR_DISTRIBUTION_SETS_ALL DSET
, AR_VAT_TAX_ALL VAT
, AR_RECEIPT_METHODS RM
, AR_DISTRIBUTIONS_ALL_MRC_V ARD
, AR_MISC_CASH_DISTS_ALL_MRC_V MCD
, FND_DOCUMENT_SEQUENCES SEQ
, GL_DAILY_CONVERSION_TYPES GLCT
WHERE MCD.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
AND NVL(MCD.ORG_ID
, -99) = NVL(CR.ORG_ID
, -99)
AND ARD.SOURCE_TABLE = 'MCD'
AND ARD.SOURCE_ID = MCD.MISC_CASH_DISTRIBUTION_ID
AND NVL(ARD.ORG_ID
, -99) = NVL(MCD.ORG_ID
, -99)
AND ARD.TAX_CODE_ID = VAT.VAT_TAX_ID(+)
AND NVL(ARD.ORG_ID
, -99) = NVL(VAT.ORG_ID(+)
, -99)
AND GLCT.CONVERSION_TYPE(+) = ARD.CURRENCY_CONVERSION_TYPE
AND CR.DOC_SEQUENCE_ID = SEQ.DOC_SEQUENCE_ID (+)
AND CR.RECEIPT_METHOD_ID = RM.RECEIPT_METHOD_ID
AND CR.REMIT_BANK_ACCT_USE_ID = APBA.BANK_ACCT_USE_ID(+)
AND NVL(CR.ORG_ID
, -99) = NVL(APBA.ORG_ID(+)
, -99)
AND CR.RECEIVABLES_TRX_ID = RCVTRX.RECEIVABLES_TRX_ID(+)
AND NVL(CR.ORG_ID
, -99) = NVL(RCVTRX.ORG_ID(+)
, -99)
AND CR.DISTRIBUTION_SET_ID = DSET.DISTRIBUTION_SET_ID(+)
AND NVL(CR.ORG_ID
, -99) = NVL(DSET.ORG_ID(+)
, -99)
AND APBA.BANK_ACCOUNT_ID = CBA.BANK_ACCOUNT_ID (+)