1. Tables and Views for Financials
  2. AR_DRAWEE_BANK_ACCOUNTS_H_V

AR_DRAWEE_BANK_ACCOUNTS_H_V

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: VIEW

Columns

Name

DRAW_BANK_ACCOUNT_USE

DRAW_BA_ASSET_CCID

DRAW_BANK_ACCOUNT_ID

DRAW_BANK_ACCOUNT_NAME

DRAW_BANK_ACCOUNT_NAME_ALT

DRAW_BANK_ACCOUNT_NUM

DRAW_BANK_ACCOUNT_TYPE

DRAW_BA_BANK_CHARGES_CCID

DRAW_BA_BR_FACTOR_CCID

DRAW_BA_BR_REMITTANCE_CCID

DRAW_BA_CASH_CLEARING_CCID

DRAW_BA_CURRENCY_CODE

DRAW_BA_DESCRIPTION

DRAW_BA_FACTOR_CCID

DRAW_BA_GAIN_CCID

DRAW_BA_GLOBAL_ATTR1

DRAW_BA_GLOBAL_ATTR10

DRAW_BA_GLOBAL_ATTR18

DRAW_BA_GLOBAL_ATTR19

DRAW_BA_GLOBAL_ATTR2

DRAW_BA_GLOBAL_ATTR20

DRAW_BA_GLOBAL_ATTR3

DRAW_BA_GLOBAL_ATTR4

DRAW_BA_GLOBAL_ATTR5

DRAW_BA_GLOBAL_ATTR6

DRAW_BA_GLOBAL_ATTR7

DRAW_BA_GLOBAL_ATTR8

DRAW_BA_GLOBAL_ATTR9

DRAW_BA_GLOBAL_ATTR_CAT

DRAW_BA_LOSS_CCID

DRAW_BA_ON_ACCOUNT_CCID

DRAW_BA_RECEIPT_CLEARING_CCID

DRAW_BA_REMITTANCE_CCID

DRAW_BA_AR_SHORT_TERM_DEP_CCID

DRAW_BA_BR_SHORT_TERM_DEP_CCID

DRAW_BA_UNAPPLIED_CCID

DRAW_BA_UNIDENTIFIED_CCID

DRAW_BA_AGENCY_LOCATION_CODE

DRAW_BA_IBAN_NUMBER

EVENT_ID

Query

SQL_Statement

SELECT /*+ INDEX(HE AR_XLA_LINES_EXTRACT_N1) */

BANK_ACCT.BANK_ACCOUNT_TYPE DRAW_BANK_ACCOUNT_USE,

BAA5.ASSET_CODE_COMBINATION_ID DRAW_BA_ASSET_CCID,

BANK_ACCT.BANK_ACCOUNT_ID DRAW_BANK_ACCOUNT_ID,

BANK_ACCT.BANK_ACCOUNT_NAME DRAW_BANK_ACCOUNT_NAME,

BANK_ACCT.BANK_ACCOUNT_NAME_ALT DRAW_BANK_ACCOUNT_NAME_ALT,

BANK_ACCT.BANK_ACCOUNT_NUM DRAW_BANK_ACCOUNT_NUM,

BANK_ACCT.BANK_ACCOUNT_TYPE DRAW_BANK_ACCOUNT_TYPE,

BAA5.BANK_CHARGES_CCID DRAW_BA_BANK_CHARGES_CCID,

BAA5.BR_FACTOR_CCID DRAW_BA_BR_FACTOR_CCID,

BAA5.BR_REMITTANCE_CCID DRAW_BA_BR_REMITTANCE_CCID,

BAA5.CASH_CLEARING_CCID DRAW_BA_CASH_CLEARING_CCID,

BANK_ACCT.CURRENCY_CODE DRAW_BA_CURRENCY_CODE,

BANK_ACCT.DESCRIPTION DRAW_BA_DESCRIPTION,

BAA5.FACTOR_CCID DRAW_BA_FACTOR_CCID,

BAA5.GAIN_CODE_COMBINATION_ID DRAW_BA_GAIN_CCID,

BANK_ACCT.GLOBAL_ATTRIBUTE1 DRAW_BA_GLOBAL_ATTR1,

BANK_ACCT.GLOBAL_ATTRIBUTE10 DRAW_BA_GLOBAL_ATTR10,

BANK_ACCT.GLOBAL_ATTRIBUTE18 DRAW_BA_GLOBAL_ATTR18,

BANK_ACCT.GLOBAL_ATTRIBUTE19 DRAW_BA_GLOBAL_ATTR19,

BANK_ACCT.GLOBAL_ATTRIBUTE2 DRAW_BA_GLOBAL_ATTR2,

BANK_ACCT.GLOBAL_ATTRIBUTE20 DRAW_BA_GLOBAL_ATTR20,

BANK_ACCT.GLOBAL_ATTRIBUTE3 DRAW_BA_GLOBAL_ATTR3,

BANK_ACCT.GLOBAL_ATTRIBUTE4 DRAW_BA_GLOBAL_ATTR4,

BANK_ACCT.GLOBAL_ATTRIBUTE5 DRAW_BA_GLOBAL_ATTR5,

BANK_ACCT.GLOBAL_ATTRIBUTE6 DRAW_BA_GLOBAL_ATTR6,

BANK_ACCT.GLOBAL_ATTRIBUTE7 DRAW_BA_GLOBAL_ATTR7,

BANK_ACCT.GLOBAL_ATTRIBUTE8 DRAW_BA_GLOBAL_ATTR8,

BANK_ACCT.GLOBAL_ATTRIBUTE9 DRAW_BA_GLOBAL_ATTR9,

BANK_ACCT.GLOBAL_ATTRIBUTE_CATEGORY DRAW_BA_GLOBAL_ATTR_CAT,

BAA5.LOSS_CODE_COMBINATION_ID DRAW_BA_LOSS_CCID,

BAA5.ON_ACCOUNT_CCID DRAW_BA_ON_ACCOUNT_CCID,

BAA5.RECEIPT_CLEARING_CCID DRAW_BA_RECEIPT_CLEARING_CCID,

BAA5.REMITTANCE_CCID DRAW_BA_REMITTANCE_CCID,

BAA5.AR_SHORT_TERM_DEPOSIT_CCID DRAW_BA_AR_SHORT_TERM_DEP_CCID,

BAA5.BR_SHORT_TERM_DEPOSIT_CCID DRAW_BA_BR_SHORT_TERM_DEP_CCID,

BAA5.UNAPPLIED_CCID DRAW_BA_UNAPPLIED_CCID,

BAA5.UNIDENTIFIED_CCID DRAW_BA_UNIDENTIFIED_CCID,

BANK_ACCT.AGENCY_LOCATION_CODE DRAW_BA_AGENCY_LOCATION_CODE,

BANK_ACCT.IBAN_NUMBER DRAW_BA_IBAN_NUMBER,

HE.EVENT_ID EVENT_ID

FROM CE_BANK_ACCOUNTS BANK_ACCT,

CE_BANK_ACCT_USES_ALL BANK_USE,

CE_GL_ACCOUNTS_CCID BAA5,

AR_XLA_LINES_EXTRACT HE

WHERE BANK_ACCT.BANK_ACCOUNT_ID = HE.DRAWEE_BANK_ACCOUNT_ID

AND HE.LEVEL_FLAG = 'H'

AND BANK_ACCT.BANK_ACCOUNT_ID = BANK_USE.BANK_ACCOUNT_ID

AND BANK_USE.BANK_ACCT_USE_ID = BAA5.BANK_ACCT_USE_ID