VIEW: APPS.AR_REMIT_BANK_ACCT_S_V

Source

View Text - Preformatted

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.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.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'

View Text - HTML Formatted

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.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.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'