AR_REMIT_BANK_ACCT_S_V
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 LINE_NUMBER LANGUAGE 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 |
Query
SQL_Statement |
---|
SELECT 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.line_number line_number , l.language language , 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 , rm.earned_ccid 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 , rm.unearned_ccid rmt_bnk_unearned_ccid , rm.unidentified_ccid rmt_bnk_unidentified_ccid FROM ce_gl_accounts_ccid baa6 , ce_bank_accounts cba , ce_bank_acct_uses aba , ar_receipt_method_accounts_all rm , ar_xla_lines_extract l 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 l.event_class_code = 'CREDIT_MEMO' |