VIEW: APPS.AR_DRAWEE_BANK_ACCOUNTS_H_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'