VIEW: APPS.CE_INTERNAL_BANK_ACCTS_V

Source

View Text - Preformatted

SELECT DISTINCT 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 FROM CE_BANK_ACCOUNTS BA, CE_BANK_ACCT_USES_ALL BAU WHERE BA.BANK_ACCOUNT_ID = BAU.BANK_ACCOUNT_ID and BA.ACCOUNT_CLASSIFICATION = 'INTERNAL' and exists (select /*+ no_unnest */ 1 from CE_SECURITY_PROFILES_V ou where ((BAU.ORG_ID = OU.ORGANIZATION_ID and OU.ORGANIZATION_TYPE in ('OPERATING_UNIT', 'BUSINESS_GROUP')) OR (BAU.LEGAL_ENTITY_ID = OU.ORGANIZATION_ID and OU.ORGANIZATION_TYPE = 'LEGAL_ENTITY')))

View Text - HTML Formatted

SELECT DISTINCT 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
FROM CE_BANK_ACCOUNTS BA
, CE_BANK_ACCT_USES_ALL BAU
WHERE BA.BANK_ACCOUNT_ID = BAU.BANK_ACCOUNT_ID
AND BA.ACCOUNT_CLASSIFICATION = 'INTERNAL'
AND EXISTS (SELECT /*+ NO_UNNEST */ 1
FROM CE_SECURITY_PROFILES_V OU
WHERE ((BAU.ORG_ID = OU.ORGANIZATION_ID
AND OU.ORGANIZATION_TYPE IN ('OPERATING_UNIT'
, 'BUSINESS_GROUP')) OR (BAU.LEGAL_ENTITY_ID = OU.ORGANIZATION_ID
AND OU.ORGANIZATION_TYPE = 'LEGAL_ENTITY')))