View: CE_BANK_ACCTS_GT_V

Product:	CE - Cash Management
Description:
Implementation/DBA Data:	APPS.CE_BANK_ACCTS_GT_V

View Text

SELECT BA.BANK_ACCOUNT_ID
, BA.BANK_ACCOUNT_NAME
, BA.LAST_UPDATE_DATE
, BA.LAST_UPDATED_BY
, BA.LAST_UPDATE_LOGIN
, BA.CREATION_DATE
, BA.CREATED_BY
, BA.BANK_ACCOUNT_NUM
, BA.BANK_BRANCH_ID
, BA.BANK_ID
, BA.CURRENCY_CODE
, BA.DESCRIPTION
, BA.ATTRIBUTE_CATEGORY
, BA.ATTRIBUTE1
, BA.ATTRIBUTE2
, BA.ATTRIBUTE3
, BA.ATTRIBUTE4
, BA.ATTRIBUTE5
, BA.ATTRIBUTE6
, BA.ATTRIBUTE7
, BA.ATTRIBUTE8
, BA.ATTRIBUTE9
, BA.ATTRIBUTE10
, BA.ATTRIBUTE11
, BA.ATTRIBUTE12
, BA.ATTRIBUTE13
, BA.ATTRIBUTE14
, BA.ATTRIBUTE15
, BA.REQUEST_ID
, BA.PROGRAM_APPLICATION_ID
, BA.PROGRAM_ID
, BA.PROGRAM_UPDATE_DATE
, BA.CHECK_DIGITS
, BA.BANK_ACCOUNT_NAME_ALT
, BA.ACCOUNT_HOLDER_ID
, BA.EFT_REQUESTER_IDENTIFIER
, BA.SECONDARY_ACCOUNT_REFERENCE
, BA.ACCOUNT_SUFFIX
, BA.DESCRIPTION_CODE1
, BA.DESCRIPTION_CODE2
, BA.IBAN_NUMBER
, BA.SHORT_ACCOUNT_NAME
, BA.ACCOUNT_OWNER_PARTY_ID
, BA.ACCOUNT_OWNER_ORG_ID
, BA.ACCOUNT_CLASSIFICATION
, BA.AP_USE_ALLOWED_FLAG
, BA.AR_USE_ALLOWED_FLAG
, BA.XTR_USE_ALLOWED_FLAG
, BA.PAY_USE_ALLOWED_FLAG
, BA.MULTI_CURRENCY_ALLOWED_FLAG
, BA.PAYMENT_MULTI_CURRENCY_FLAG
, BA.RECEIPT_MULTI_CURRENCY_FLAG
, BA.ZERO_AMOUNT_ALLOWED
, BA.MAX_OUTLAY
, BA.MAX_CHECK_AMOUNT
, BA.MIN_CHECK_AMOUNT
, BA.AP_AMOUNT_TOLERANCE
, BA.AR_AMOUNT_TOLERANCE
, BA.XTR_AMOUNT_TOLERANCE
, BA.PAY_AMOUNT_TOLERANCE
, BA.AP_PERCENT_TOLERANCE
, BA.AR_PERCENT_TOLERANCE
, BA.XTR_PERCENT_TOLERANCE
, BA.PAY_PERCENT_TOLERANCE
, BA.BANK_ACCOUNT_TYPE
, BA.AGENCY_LOCATION_CODE
, BA.START_DATE
, BA.END_DATE
, BA.ACCOUNT_HOLDER_NAME_ALT
, BA.CASHFLOW_DISPLAY_ORDER
, BA.ACCOUNT_HOLDER_NAME
, BA.MASKED_ACCOUNT_NUM
, BA.MASKED_IBAN
, BA.POOLED_FLAG
, BA.MIN_TARGET_BALANCE
, BA.MAX_TARGET_BALANCE
, BA.EFT_USER_NUM
, BA.INTEREST_SCHEDULE_ID
, BA.ASSET_CODE_COMBINATION_ID
, BA.NETTING_ACCT_FLAG
, BA.CASH_CLEARING_CCID
, BA.BANK_ACCOUNT_NUM_ELECTRONIC
, BA.STMT_LINE_FLOAT_HANDLING_FLAG
, BA.AUTORECON_AP_MATCHING_ORDER
, BA.AUTORECON_AR_MATCHING_ORDER
, BA.RECON_FOREIGN_BANK_XRATE_TYPE
, BA.RECON_FOR_BANK_XRATE_DATE_TYPE
, BA.RECON_ENABLE_OI_FLAG
, BA.RECON_OI_FLOAT_STATUS
, BA.RECON_OI_CLEARED_STATUS
, BA.RECON_OI_MATCHING_CODE
, BA.RECON_OI_AMOUNT_TOLERANCE
, BA.RECON_OI_PERCENT_TOLERANCE
, BA.MANUAL_RECON_AMOUNT_TOLERANCE
, BA.MANUAL_RECON_PERCENT_TOLERANCE
, BA.RECON_AP_FOREIGN_DIFF_HANDLING
, BA.RECON_AR_FOREIGN_DIFF_HANDLING
, BA.RECON_CE_FOREIGN_DIFF_HANDLING
, BA.RECON_AP_TOLERANCE_DIFF_ACCT
, BA.RECON_CE_TOLERANCE_DIFF_ACCT
, BA.XTR_BANK_ACCOUNT_REFERENCE
FROM CE_BANK_ACCOUNTS BA
WHERE EXISTS (SELECT 'X'
FROM CE_BANK_ACCT_USES_ALL BAU
, CE_SECURITY_PROFILES_GT OU
WHERE BA.BANK_ACCOUNT_ID = BAU.BANK_ACCOUNT_ID
AND ((BAU.ORG_ID = OU.ORGANIZATION_ID AND OU.ORGANIZATION_TYPE IN ('OPERATING_UNIT'
, 'BUSINESS_GROUP')
AND TRUNC(NVL(BAU.END_DATE
, SYSDATE)) >= TRUNC(SYSDATE)) OR (BAU.LEGAL_ENTITY_ID = OU.ORGANIZATION_ID AND OU.ORGANIZATION_TYPE = 'LEGAL_ENTITY') )
AND TRUNC(NVL(BAU.END_DATE
, SYSDATE)) >= TRUNC(SYSDATE))
AND BA.ACCOUNT_CLASSIFICATION = 'INTERNAL'
AND NVL(BA.NETTING_ACCT_FLAG
, 'N') = 'N'

Columns