View: AR_DRAWEE_BANK_ACCOUNTS_H_V

Product:	AR - Receivables
Description:	drawee bank account header extract
Implementation/DBA Data:	APPS.AR_DRAWEE_BANK_ACCOUNTS_H_V

View Text

SELECT /*+ INDEX(HE AR_XLA_LINES_EXTRACT_N1) */ BAA5.ACCOUNT_TYPE DRAW_BANK_ACCOUNT_USE
, BAA5.ASSET_CODE_COMBINATION_ID DRAW_BA_ASSET_CCID
, BAA5.BANK_ACCOUNT_ID DRAW_BANK_ACCOUNT_ID
, BAA5.BANK_ACCOUNT_NAME DRAW_BANK_ACCOUNT_NAME
, BAA5.BANK_ACCOUNT_NAME_ALT DRAW_BANK_ACCOUNT_NAME_ALT
, BAA5.BANK_ACCOUNT_NUM DRAW_BANK_ACCOUNT_NUM
, BAA5.BANK_ACCOUNT_TYPE DRAW_BANK_ACCOUNT_TYPE
, BAA5.BANK_CHARGES_CCID DRAW_BA_BANK_CHARGES_CCID
, BAA5.BANK_ERRORS_CCID DRAW_BA_BANK_ERRORS_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
, BAA5.CURRENCY_CODE DRAW_BA_CURRENCY_CODE
, BAA5.DESCRIPTION DRAW_BA_DESCRIPTION
, BAA5.EARNED_CCID DRAW_BA_EARNED_CCID
, BAA5.FACTOR_CCID DRAW_BA_FACTOR_CCID
, BAA5.FUTURE_DATED_PAYMENT_CCID DRAW_BA_FUTURE_PAYMENT_CCID
, BAA5.GAIN_CODE_COMBINATION_ID DRAW_BA_GAIN_CCID
, BAA5.GLOBAL_ATTRIBUTE1 DRAW_BA_GLOBAL_ATTR1
, BAA5.GLOBAL_ATTRIBUTE10 DRAW_BA_GLOBAL_ATTR10
, BAA5.GLOBAL_ATTRIBUTE18 DRAW_BA_GLOBAL_ATTR18
, BAA5.GLOBAL_ATTRIBUTE19 DRAW_BA_GLOBAL_ATTR19
, BAA5.GLOBAL_ATTRIBUTE2 DRAW_BA_GLOBAL_ATTR2
, BAA5.GLOBAL_ATTRIBUTE20 DRAW_BA_GLOBAL_ATTR20
, BAA5.GLOBAL_ATTRIBUTE3 DRAW_BA_GLOBAL_ATTR3
, BAA5.GLOBAL_ATTRIBUTE4 DRAW_BA_GLOBAL_ATTR4
, BAA5.GLOBAL_ATTRIBUTE5 DRAW_BA_GLOBAL_ATTR5
, BAA5.GLOBAL_ATTRIBUTE6 DRAW_BA_GLOBAL_ATTR6
, BAA5.GLOBAL_ATTRIBUTE7 DRAW_BA_GLOBAL_ATTR7
, BAA5.GLOBAL_ATTRIBUTE8 DRAW_BA_GLOBAL_ATTR8
, BAA5.GLOBAL_ATTRIBUTE9 DRAW_BA_GLOBAL_ATTR9
, BAA5.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.SHORT_TERM_DEPOSIT_CCID DRAW_BA_SHORT_TERM_DEP_CCID
, BAA5.UNAPPLIED_CCID DRAW_BA_UNAPPLIED_CCID
, BAA5.UNEARNED_CCID DRAW_BA_UNEARNED_CCID
, BAA5.UNIDENTIFIED_CCID DRAW_BA_UNIDENTIFIED_CCID
, BAA5.AGENCY_LOCATION_CODE DRAW_BA_AGENCY_LOCATION_CODE
, BAA5.IBAN_NUMBER DRAW_BA_IBAN_NUMBER
, HE.EVENT_ID EVENT_ID
FROM AP_BANK_ACCOUNTS_ALL BAA5
, AR_XLA_LINES_EXTRACT HE
WHERE BAA5.BANK_ACCOUNT_ID = HE.DRAWEE_BANK_ACCOUNT_ID
AND HE.LEVEL_FLAG = 'H'

Columns