AR_REMIT_BANK_ACCT_H

Details

Schema: FUSION
Object owner: AR
Object type: VIEW

Columns

Name
RMT_BNK_ACCOUNT_USE RMT_BNK_ASSET_CCID RMT_BNK_ACCOUNT_ID RMT_BNK_ACCOUNT_NAME RMT_BNK_ACCOUNT_NAME_ALT RMT_BNK_ACCOUNT_NUM RMT_BNK_ACCOUNT_TYPE RMT_BNK_BANK_CHARGES_CCID RMT_BNK_CASH_CLEARING_CCID RMT_BNK_CURRENCY_CODE RMT_BNK_DESCRIPTION RMT_BNK_GAIN_CCID RMT_BNK_LOSS_CCID RMT_BNK_RCT_CLEARING_CCID RMT_BNK_SHORT_TRM_DEP_CCID RMT_BNK_AGENCY_LOC_CODE RMT_BNK_GLOBAL_ATTR1 RMT_BNK_GLOBAL_ATTR10 RMT_BNK_GLOBAL_ATTR18 RMT_BNK_GLOBAL_ATTR19 RMT_BNK_GLOBAL_ATTR2 RMT_BNK_GLOBAL_ATTR20 RMT_BNK_GLOBAL_ATTR3 RMT_BNK_GLOBAL_ATTR4 RMT_BNK_GLOBAL_ATTR5 RMT_BNK_GLOBAL_ATTR6 RMT_BNK_GLOBAL_ATTR7 RMT_BNK_GLOBAL_ATTR8 RMT_BNK_GLOBAL_ATTR9 RMT_BNK_GLOBAL_ATTR_CAT RMT_BNK_IBAN_NUMBER EVENT_ID LEDGER_ID RMT_BNK_CASH_CCID RMT_BNK_CHARGES_CCID RMT_BNK_BR_FACTOR_CCID RMT_BNK_BR_REMITTANCE_CCID RMT_BNK_EARNED_CCID RMT_BNK_FACTOR_CCID RMT_BNK_ON_ACCOUNT_CCID RMT_BNK_CONFIRMATION_CCID RMT_BNK_REMITTANCE_CCID RMT_BNK_DEPOSIT_CCID RMT_BNK_UNAPPLIED_CCID RMT_BNK_UNEARNED_CCID RMT_BNK_UNIDENTIFIED_CCID RMT_BANK_NAME RMT_BANK_NUM RMT_BANK_BRANCH_NAME RMT_BANK_BRANCH_NUM

Name

RMT_BNK_ACCOUNT_USE

RMT_BNK_ASSET_CCID

RMT_BNK_ACCOUNT_ID

RMT_BNK_ACCOUNT_NAME

RMT_BNK_ACCOUNT_NAME_ALT

RMT_BNK_ACCOUNT_NUM

RMT_BNK_ACCOUNT_TYPE

RMT_BNK_BANK_CHARGES_CCID

RMT_BNK_CASH_CLEARING_CCID

RMT_BNK_CURRENCY_CODE

RMT_BNK_DESCRIPTION

RMT_BNK_GAIN_CCID

RMT_BNK_LOSS_CCID

RMT_BNK_RCT_CLEARING_CCID

RMT_BNK_SHORT_TRM_DEP_CCID

RMT_BNK_AGENCY_LOC_CODE

RMT_BNK_GLOBAL_ATTR1

RMT_BNK_GLOBAL_ATTR10

RMT_BNK_GLOBAL_ATTR18

RMT_BNK_GLOBAL_ATTR19

RMT_BNK_GLOBAL_ATTR2

RMT_BNK_GLOBAL_ATTR20

RMT_BNK_GLOBAL_ATTR3

RMT_BNK_GLOBAL_ATTR4

RMT_BNK_GLOBAL_ATTR5

RMT_BNK_GLOBAL_ATTR6

RMT_BNK_GLOBAL_ATTR7

RMT_BNK_GLOBAL_ATTR8

RMT_BNK_GLOBAL_ATTR9

RMT_BNK_GLOBAL_ATTR_CAT

RMT_BNK_IBAN_NUMBER

EVENT_ID

LEDGER_ID

RMT_BNK_CASH_CCID

RMT_BNK_CHARGES_CCID

RMT_BNK_BR_FACTOR_CCID

RMT_BNK_BR_REMITTANCE_CCID

RMT_BNK_EARNED_CCID

RMT_BNK_FACTOR_CCID

RMT_BNK_ON_ACCOUNT_CCID

RMT_BNK_CONFIRMATION_CCID

RMT_BNK_REMITTANCE_CCID

RMT_BNK_DEPOSIT_CCID

RMT_BNK_UNAPPLIED_CCID

RMT_BNK_UNEARNED_CCID

RMT_BNK_UNIDENTIFIED_CCID

RMT_BANK_NAME

RMT_BANK_NUM

RMT_BANK_BRANCH_NAME

RMT_BANK_BRANCH_NUM

Query

SQL_Statement
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 , cba.BANK_ACCOUNT_NAME_ALT 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.receipt_clearing_ccid rmt_bnk_cash_clearing_ccid , cba.currency_code rmt_bnk_currency_code , cba.description rmt_bnk_description , 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 , rtr1.code_combination_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 , rtr2.code_combination_id rmt_bnk_unearned_ccid , rm.unidentified_ccid rmt_bnk_unidentified_ccid , bk.party_name RMT_BANK_NAME, bk.party_number RMT_BANK_NUM, bkb.party_name RMT_BANK_BRANCH_NAME, bkb.party_number RMT_BANK_BRANCH_NUM 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 , ar_receivables_trx_all rtr1 , ar_receivables_trx_all rtr2 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 rtr1.RECEIVABLES_TRX_ID = rm.EDISC_RECEIVABLES_TRX_ID AND rtr2.RECEIVABLES_TRX_ID = rm.UNEDISC_RECEIVABLES_TRX_ID AND rtr1.org_id = rm.org_id AND rtr2.org_id = rm.org_id AND l.level_flag = 'H' AND cba.bank_id = bk.party_id(+) AND cba.bank_branch_id = bkb.party_id(+)

SQL_Statement

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 ,

cba.BANK_ACCOUNT_NAME_ALT 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.receipt_clearing_ccid rmt_bnk_cash_clearing_ccid ,

cba.currency_code rmt_bnk_currency_code ,

cba.description rmt_bnk_description ,

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 ,

rtr1.code_combination_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 ,

rtr2.code_combination_id rmt_bnk_unearned_ccid ,

rm.unidentified_ccid rmt_bnk_unidentified_ccid ,

bk.party_name RMT_BANK_NAME,

bk.party_number RMT_BANK_NUM,

bkb.party_name RMT_BANK_BRANCH_NAME,

bkb.party_number RMT_BANK_BRANCH_NUM

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 ,

ar_receivables_trx_all rtr1 ,

ar_receivables_trx_all rtr2

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 rtr1.RECEIVABLES_TRX_ID = rm.EDISC_RECEIVABLES_TRX_ID

AND rtr2.RECEIVABLES_TRX_ID = rm.UNEDISC_RECEIVABLES_TRX_ID

AND rtr1.org_id = rm.org_id

AND rtr2.org_id = rm.org_id

AND l.level_flag = 'H'

AND cba.bank_id = bk.party_id(+)

AND cba.bank_branch_id = bkb.party_id(+)