VIEW: APPS.AR_REMIT_BANK_ACCT_H_V

Source

View Text - Preformatted

SELECT /*+INDEX(l ar_xla_lines_extract_n1)*/ cba.account_classification rmt_bnk_account_use ,baa6.asset_code_combination_id rmt_bnk_asset_ccid ,cba.BANK_ACCOUNT_ID rmt_bnk_account_id ,cba.BANK_ACCOUNT_NAME rmt_bnk_account_name ,SUBSTRB(cba.BANK_ACCOUNT_NAME_ALT,1,240) rmt_bnk_account_name_alt ,cba.BANK_ACCOUNT_NUM rmt_bnk_account_num ,cba.bank_account_type rmt_bnk_account_type ,baa6.bank_charges_ccid rmt_bnk_bank_charges_ccid ,baa6.bank_errors_ccid rmt_bnk_bank_errors_ccid ,baa6.receipt_clearing_ccid rmt_bnk_cash_clearing_ccid ,cba.currency_code rmt_bnk_currency_code ,cba.description rmt_bnk_description ,baa6.future_dated_payment_ccid rmt_bnk_future_pmt_ccid ,baa6.gain_code_combination_id rmt_bnk_gain_ccid ,baa6.loss_code_combination_id rmt_bnk_loss_ccid ,baa6.receipt_clearing_ccid rmt_bnk_rct_clearing_ccid ,baa6.ar_short_term_deposit_ccid rmt_bnk_short_trm_dep_ccid ,cba.agency_location_code RMT_BNK_AGENCY_LOC_CODE ,rm.global_attribute1 RMT_BNK_GLOBAL_ATTR1 ,rm.global_attribute10 RMT_BNK_GLOBAL_ATTR10 ,rm.global_attribute18 RMT_BNK_GLOBAL_ATTR18 ,rm.global_attribute19 RMT_BNK_GLOBAL_ATTR19 ,rm.global_attribute2 RMT_BNK_GLOBAL_ATTR2 ,rm.global_attribute20 RMT_BNK_GLOBAL_ATTR20 ,rm.global_attribute3 RMT_BNK_GLOBAL_ATTR3 ,rm.global_attribute4 RMT_BNK_GLOBAL_ATTR4 ,rm.global_attribute5 RMT_BNK_GLOBAL_ATTR5 ,rm.global_attribute6 RMT_BNK_GLOBAL_ATTR6 ,rm.global_attribute7 RMT_BNK_GLOBAL_ATTR7 ,rm.global_attribute8 RMT_BNK_GLOBAL_ATTR8 ,rm.global_attribute9 RMT_BNK_GLOBAL_ATTR9 ,rm.global_attribute_category RMT_BNK_GLOBAL_ATTR_CAT ,cba.iban_number RMT_BNK_IBAN_NUMBER ,l.event_id event_id ,l.ledger_id ledger_id ,rm.cash_ccid rmt_bnk_cash_ccid ,rm.bank_charges_ccid rmt_bnk_charges_ccid ,rm.br_factor_ccid rmt_bnk_br_factor_ccid ,rm.br_remittance_ccid rmt_bnk_br_remittance_ccid ,(SELECT CODE_COMBINATION_ID FROM AR_RECEIVABLES_TRX_ALL WHERE RECEIVABLES_TRX_ID = rm.EDISC_RECEIVABLES_TRX_ID) rmt_bnk_earned_ccid ,rm.factor_ccid rmt_bnk_factor_ccid ,rm.on_account_ccid rmt_bnk_on_account_ccid ,rm.receipt_clearing_ccid rmt_bnk_confirmation_ccid ,rm.remittance_ccid rmt_bnk_remittance_ccid ,rm.short_term_debt_ccid rmt_bnk_deposit_ccid ,rm.unapplied_ccid rmt_bnk_unapplied_ccid ,(SELECT CODE_COMBINATION_ID FROM AR_RECEIVABLES_TRX_ALL WHERE RECEIVABLES_TRX_ID = rm.UNEDISC_RECEIVABLES_TRX_ID) rmt_bnk_unearned_ccid ,rm.unidentified_ccid rmt_bnk_unidentified_ccid ,SUBSTRB(bk.party_name,1,240) ,bk.party_number ,SUBSTRB(bkb.party_name,1,240) ,bkb.party_number FROM ce_gl_accounts_ccid baa6 ,ce_bank_accounts cba ,ce_bank_acct_uses_all aba ,ar_receipt_method_accounts_all rm ,ar_xla_lines_extract l ,hz_parties bk ,hz_parties bkb WHERE l.remittance_bank_acct_id = rm.remit_bank_acct_use_id AND l.receipt_method_id = rm.receipt_method_id AND l.remittance_bank_acct_id = aba.bank_acct_use_id AND aba.bank_account_id = cba.bank_account_id AND aba.bank_acct_use_id = baa6.bank_acct_use_id AND l.remittance_bank_acct_id = rm.remit_bank_acct_use_id AND l.level_flag = 'H' AND cba.bank_id = bk.party_id(+) AND cba.bank_branch_id = bkb.party_id(+)

View Text - HTML Formatted

SELECT /*+INDEX(L AR_XLA_LINES_EXTRACT_N1)*/ CBA.ACCOUNT_CLASSIFICATION RMT_BNK_ACCOUNT_USE
, BAA6.ASSET_CODE_COMBINATION_ID RMT_BNK_ASSET_CCID
, CBA.BANK_ACCOUNT_ID RMT_BNK_ACCOUNT_ID
, CBA.BANK_ACCOUNT_NAME RMT_BNK_ACCOUNT_NAME
, SUBSTRB(CBA.BANK_ACCOUNT_NAME_ALT
, 1
, 240) RMT_BNK_ACCOUNT_NAME_ALT
, CBA.BANK_ACCOUNT_NUM RMT_BNK_ACCOUNT_NUM
, CBA.BANK_ACCOUNT_TYPE RMT_BNK_ACCOUNT_TYPE
, BAA6.BANK_CHARGES_CCID RMT_BNK_BANK_CHARGES_CCID
, BAA6.BANK_ERRORS_CCID RMT_BNK_BANK_ERRORS_CCID
, BAA6.RECEIPT_CLEARING_CCID RMT_BNK_CASH_CLEARING_CCID
, CBA.CURRENCY_CODE RMT_BNK_CURRENCY_CODE
, CBA.DESCRIPTION RMT_BNK_DESCRIPTION
, BAA6.FUTURE_DATED_PAYMENT_CCID RMT_BNK_FUTURE_PMT_CCID
, BAA6.GAIN_CODE_COMBINATION_ID RMT_BNK_GAIN_CCID
, BAA6.LOSS_CODE_COMBINATION_ID RMT_BNK_LOSS_CCID
, BAA6.RECEIPT_CLEARING_CCID RMT_BNK_RCT_CLEARING_CCID
, BAA6.AR_SHORT_TERM_DEPOSIT_CCID RMT_BNK_SHORT_TRM_DEP_CCID
, CBA.AGENCY_LOCATION_CODE RMT_BNK_AGENCY_LOC_CODE
, RM.GLOBAL_ATTRIBUTE1 RMT_BNK_GLOBAL_ATTR1
, RM.GLOBAL_ATTRIBUTE10 RMT_BNK_GLOBAL_ATTR10
, RM.GLOBAL_ATTRIBUTE18 RMT_BNK_GLOBAL_ATTR18
, RM.GLOBAL_ATTRIBUTE19 RMT_BNK_GLOBAL_ATTR19
, RM.GLOBAL_ATTRIBUTE2 RMT_BNK_GLOBAL_ATTR2
, RM.GLOBAL_ATTRIBUTE20 RMT_BNK_GLOBAL_ATTR20
, RM.GLOBAL_ATTRIBUTE3 RMT_BNK_GLOBAL_ATTR3
, RM.GLOBAL_ATTRIBUTE4 RMT_BNK_GLOBAL_ATTR4
, RM.GLOBAL_ATTRIBUTE5 RMT_BNK_GLOBAL_ATTR5
, RM.GLOBAL_ATTRIBUTE6 RMT_BNK_GLOBAL_ATTR6
, RM.GLOBAL_ATTRIBUTE7 RMT_BNK_GLOBAL_ATTR7
, RM.GLOBAL_ATTRIBUTE8 RMT_BNK_GLOBAL_ATTR8
, RM.GLOBAL_ATTRIBUTE9 RMT_BNK_GLOBAL_ATTR9
, RM.GLOBAL_ATTRIBUTE_CATEGORY RMT_BNK_GLOBAL_ATTR_CAT
, CBA.IBAN_NUMBER RMT_BNK_IBAN_NUMBER
, L.EVENT_ID EVENT_ID
, L.LEDGER_ID LEDGER_ID
, RM.CASH_CCID RMT_BNK_CASH_CCID
, RM.BANK_CHARGES_CCID RMT_BNK_CHARGES_CCID
, RM.BR_FACTOR_CCID RMT_BNK_BR_FACTOR_CCID
, RM.BR_REMITTANCE_CCID RMT_BNK_BR_REMITTANCE_CCID
, (SELECT CODE_COMBINATION_ID
FROM AR_RECEIVABLES_TRX_ALL
WHERE RECEIVABLES_TRX_ID = RM.EDISC_RECEIVABLES_TRX_ID) RMT_BNK_EARNED_CCID
, RM.FACTOR_CCID RMT_BNK_FACTOR_CCID
, RM.ON_ACCOUNT_CCID RMT_BNK_ON_ACCOUNT_CCID
, RM.RECEIPT_CLEARING_CCID RMT_BNK_CONFIRMATION_CCID
, RM.REMITTANCE_CCID RMT_BNK_REMITTANCE_CCID
, RM.SHORT_TERM_DEBT_CCID RMT_BNK_DEPOSIT_CCID
, RM.UNAPPLIED_CCID RMT_BNK_UNAPPLIED_CCID
, (SELECT CODE_COMBINATION_ID
FROM AR_RECEIVABLES_TRX_ALL
WHERE RECEIVABLES_TRX_ID = RM.UNEDISC_RECEIVABLES_TRX_ID) RMT_BNK_UNEARNED_CCID
, RM.UNIDENTIFIED_CCID RMT_BNK_UNIDENTIFIED_CCID
, SUBSTRB(BK.PARTY_NAME
, 1
, 240)
, BK.PARTY_NUMBER
, SUBSTRB(BKB.PARTY_NAME
, 1
, 240)
, BKB.PARTY_NUMBER
FROM CE_GL_ACCOUNTS_CCID BAA6
, CE_BANK_ACCOUNTS CBA
, CE_BANK_ACCT_USES_ALL ABA
, AR_RECEIPT_METHOD_ACCOUNTS_ALL RM
, AR_XLA_LINES_EXTRACT L
, HZ_PARTIES BK
, HZ_PARTIES BKB
WHERE L.REMITTANCE_BANK_ACCT_ID = RM.REMIT_BANK_ACCT_USE_ID
AND L.RECEIPT_METHOD_ID = RM.RECEIPT_METHOD_ID
AND L.REMITTANCE_BANK_ACCT_ID = ABA.BANK_ACCT_USE_ID
AND ABA.BANK_ACCOUNT_ID = CBA.BANK_ACCOUNT_ID
AND ABA.BANK_ACCT_USE_ID = BAA6.BANK_ACCT_USE_ID
AND L.REMITTANCE_BANK_ACCT_ID = RM.REMIT_BANK_ACCT_USE_ID
AND L.LEVEL_FLAG = 'H'
AND CBA.BANK_ID = BK.PARTY_ID(+)
AND CBA.BANK_BRANCH_ID = BKB.PARTY_ID(+)