View: AR_REMIT_BANK_ACCT_H_V

Product:	AR - Receivables
Description:	AR XLA Extract
Implementation/DBA Data:	APPS.AR_REMIT_BANK_ACCT_H_V

View Text

SELECT /*+INDEX(L AR_XLA_LINES_EXTRACT_N1)*/ 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.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
, BK.PARTY_NAME
, BK.PARTY_NUMBER
, BKB.PARTY_NAME
, BKB.PARTY_NUMBER
FROM CE_GL_ACCOUNTS_CCID BAA6
, CE_BANK_ACCOUNTS CBA
, CE_BANK_ACCT_USES_ALL ABA
, AR_RECEIPT_METHOD_ACCOUNTS_ALL RM
, AR_XLA_LINES_EXTRACT L
, HZ_PARTIES BK
, HZ_PARTIES BKB
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 CBA.BANK_ID = BK.PARTY_ID(+)
AND CBA.BANK_BRANCH_ID = BKB.PARTY_ID(+)

Columns