VIEW: APPS.CE_BANK_ACCT_USES

Source

View Text - Preformatted

SELECT BAU.BANK_ACCT_USE_ID , BAU.BANK_ACCOUNT_ID , BAU.LAST_UPDATE_DATE , BAU.LAST_UPDATED_BY , BAU.CREATION_DATE , BAU.CREATED_BY , BAU.LAST_UPDATE_LOGIN , BAU.PRIMARY_FLAG , BAU.ATTRIBUTE_CATEGORY , BAU.ATTRIBUTE1 , BAU.ATTRIBUTE2 , BAU.ATTRIBUTE3 , BAU.ATTRIBUTE4 , BAU.ATTRIBUTE5 , BAU.ATTRIBUTE6 , BAU.ATTRIBUTE7 , BAU.ATTRIBUTE8 , BAU.ATTRIBUTE9 , BAU.ATTRIBUTE10 , BAU.ATTRIBUTE11 , BAU.ATTRIBUTE12 , BAU.ATTRIBUTE13 , BAU.ATTRIBUTE14 , BAU.ATTRIBUTE15 , BAU.REQUEST_ID , BAU.PROGRAM_APPLICATION_ID , BAU.PROGRAM_ID , BAU.PROGRAM_UPDATE_DATE , BAU.ORG_ID , BAU.ORG_PARTY_ID , BAU.AP_USE_ENABLE_FLAG , BAU.AR_USE_ENABLE_FLAG , BAU.XTR_USE_ENABLE_FLAG , BAU.PAY_USE_ENABLE_FLAG , BAU.EDISC_RECEIVABLES_TRX_ID , BAU.UNEDISC_RECEIVABLES_TRX_ID , BAU.POOLED_FLAG , BAU.END_DATE , BAU.BR_STD_RECEIVABLES_TRX_ID , BAU.INVESTMENT_LIMIT_CODE , BAU.FUNDING_LIMIT_CODE , BAU.LEGAL_ENTITY_ID , BAU.AP_DEFAULT_SETTLEMENT_FLAG , BAU.XTR_DEFAULT_SETTLEMENT_FLAG , BAU.PAYROLL_BANK_ACCOUNT_ID , BAU.PRICING_MODEL , BAU.AUTHORIZED_FLAG , BAU.EFT_SCRIPT_NAME ,BAU.PORTFOLIO_CODE ,BAU.DEFAULT_ACCOUNT_FLAG ,BAU.OBJECT_VERSION_NUMBER , BAU.AR_CLAIM_INV_ACT_ID , BAU.NEW_AR_RCPTS_RECEIVABLE_TRX_ID , BAU.PAYMENT_DOC_CATEGORY FROM CE_BANK_ACCT_USES_OU BAU UNION ALL SELECT distinct BAU.BANK_ACCT_USE_ID , BAU.BANK_ACCOUNT_ID , BAU.LAST_UPDATE_DATE , BAU.LAST_UPDATED_BY , BAU.CREATION_DATE , BAU.CREATED_BY , BAU.LAST_UPDATE_LOGIN , BAU.PRIMARY_FLAG , BAU.ATTRIBUTE_CATEGORY , BAU.ATTRIBUTE1 , BAU.ATTRIBUTE2 , BAU.ATTRIBUTE3 , BAU.ATTRIBUTE4 , BAU.ATTRIBUTE5 , BAU.ATTRIBUTE6 , BAU.ATTRIBUTE7 , BAU.ATTRIBUTE8 , BAU.ATTRIBUTE9 , BAU.ATTRIBUTE10 , BAU.ATTRIBUTE11 , BAU.ATTRIBUTE12 , BAU.ATTRIBUTE13 , BAU.ATTRIBUTE14 , BAU.ATTRIBUTE15 , BAU.REQUEST_ID , BAU.PROGRAM_APPLICATION_ID , BAU.PROGRAM_ID , BAU.PROGRAM_UPDATE_DATE , BAU.ORG_ID , BAU.ORG_PARTY_ID , BAU.AP_USE_ENABLE_FLAG , BAU.AR_USE_ENABLE_FLAG , BAU.XTR_USE_ENABLE_FLAG , BAU.PAY_USE_ENABLE_FLAG , BAU.EDISC_RECEIVABLES_TRX_ID , BAU.UNEDISC_RECEIVABLES_TRX_ID , BAU.POOLED_FLAG , BAU.END_DATE , BAU.BR_STD_RECEIVABLES_TRX_ID , BAU.INVESTMENT_LIMIT_CODE , BAU.FUNDING_LIMIT_CODE , BAU.LEGAL_ENTITY_ID , BAU.AP_DEFAULT_SETTLEMENT_FLAG , BAU.XTR_DEFAULT_SETTLEMENT_FLAG , BAU.PAYROLL_BANK_ACCOUNT_ID , BAU.PRICING_MODEL , BAU.AUTHORIZED_FLAG , BAU.EFT_SCRIPT_NAME ,BAU.PORTFOLIO_CODE ,BAU.DEFAULT_ACCOUNT_FLAG ,BAU.OBJECT_VERSION_NUMBER , BAU.AR_CLAIM_INV_ACT_ID , BAU.NEW_AR_RCPTS_RECEIVABLE_TRX_ID , BAU.PAYMENT_DOC_CATEGORY FROM CE_BANK_ACCT_USES_ALL BAU , CE_SECURITY_PROFILES_V OU WHERE (( BAU.ORG_ID = OU.ORGANIZATION_ID AND OU.ORGANIZATION_TYPE in ('BUSINESS_GROUP')) or (BAU.LEGAL_ENTITY_ID = OU.ORGANIZATION_ID AND OU.ORGANIZATION_TYPE = 'LEGAL_ENTITY')) and not exists (select null from CE_BANK_ACCT_USES_OU BAUOU where BAU.BANK_ACCT_USE_ID = BAUOU.BANK_ACCT_USE_ID)

View Text - HTML Formatted

SELECT BAU.BANK_ACCT_USE_ID
, BAU.BANK_ACCOUNT_ID
, BAU.LAST_UPDATE_DATE
, BAU.LAST_UPDATED_BY
, BAU.CREATION_DATE
, BAU.CREATED_BY
, BAU.LAST_UPDATE_LOGIN
, BAU.PRIMARY_FLAG
, BAU.ATTRIBUTE_CATEGORY
, BAU.ATTRIBUTE1
, BAU.ATTRIBUTE2
, BAU.ATTRIBUTE3
, BAU.ATTRIBUTE4
, BAU.ATTRIBUTE5
, BAU.ATTRIBUTE6
, BAU.ATTRIBUTE7
, BAU.ATTRIBUTE8
, BAU.ATTRIBUTE9
, BAU.ATTRIBUTE10
, BAU.ATTRIBUTE11
, BAU.ATTRIBUTE12
, BAU.ATTRIBUTE13
, BAU.ATTRIBUTE14
, BAU.ATTRIBUTE15
, BAU.REQUEST_ID
, BAU.PROGRAM_APPLICATION_ID
, BAU.PROGRAM_ID
, BAU.PROGRAM_UPDATE_DATE
, BAU.ORG_ID
, BAU.ORG_PARTY_ID
, BAU.AP_USE_ENABLE_FLAG
, BAU.AR_USE_ENABLE_FLAG
, BAU.XTR_USE_ENABLE_FLAG
, BAU.PAY_USE_ENABLE_FLAG
, BAU.EDISC_RECEIVABLES_TRX_ID
, BAU.UNEDISC_RECEIVABLES_TRX_ID
, BAU.POOLED_FLAG
, BAU.END_DATE
, BAU.BR_STD_RECEIVABLES_TRX_ID
, BAU.INVESTMENT_LIMIT_CODE
, BAU.FUNDING_LIMIT_CODE
, BAU.LEGAL_ENTITY_ID
, BAU.AP_DEFAULT_SETTLEMENT_FLAG
, BAU.XTR_DEFAULT_SETTLEMENT_FLAG
, BAU.PAYROLL_BANK_ACCOUNT_ID
, BAU.PRICING_MODEL
, BAU.AUTHORIZED_FLAG
, BAU.EFT_SCRIPT_NAME
, BAU.PORTFOLIO_CODE
, BAU.DEFAULT_ACCOUNT_FLAG
, BAU.OBJECT_VERSION_NUMBER
, BAU.AR_CLAIM_INV_ACT_ID
, BAU.NEW_AR_RCPTS_RECEIVABLE_TRX_ID
, BAU.PAYMENT_DOC_CATEGORY
FROM CE_BANK_ACCT_USES_OU BAU UNION ALL SELECT DISTINCT BAU.BANK_ACCT_USE_ID
, BAU.BANK_ACCOUNT_ID
, BAU.LAST_UPDATE_DATE
, BAU.LAST_UPDATED_BY
, BAU.CREATION_DATE
, BAU.CREATED_BY
, BAU.LAST_UPDATE_LOGIN
, BAU.PRIMARY_FLAG
, BAU.ATTRIBUTE_CATEGORY
, BAU.ATTRIBUTE1
, BAU.ATTRIBUTE2
, BAU.ATTRIBUTE3
, BAU.ATTRIBUTE4
, BAU.ATTRIBUTE5
, BAU.ATTRIBUTE6
, BAU.ATTRIBUTE7
, BAU.ATTRIBUTE8
, BAU.ATTRIBUTE9
, BAU.ATTRIBUTE10
, BAU.ATTRIBUTE11
, BAU.ATTRIBUTE12
, BAU.ATTRIBUTE13
, BAU.ATTRIBUTE14
, BAU.ATTRIBUTE15
, BAU.REQUEST_ID
, BAU.PROGRAM_APPLICATION_ID
, BAU.PROGRAM_ID
, BAU.PROGRAM_UPDATE_DATE
, BAU.ORG_ID
, BAU.ORG_PARTY_ID
, BAU.AP_USE_ENABLE_FLAG
, BAU.AR_USE_ENABLE_FLAG
, BAU.XTR_USE_ENABLE_FLAG
, BAU.PAY_USE_ENABLE_FLAG
, BAU.EDISC_RECEIVABLES_TRX_ID
, BAU.UNEDISC_RECEIVABLES_TRX_ID
, BAU.POOLED_FLAG
, BAU.END_DATE
, BAU.BR_STD_RECEIVABLES_TRX_ID
, BAU.INVESTMENT_LIMIT_CODE
, BAU.FUNDING_LIMIT_CODE
, BAU.LEGAL_ENTITY_ID
, BAU.AP_DEFAULT_SETTLEMENT_FLAG
, BAU.XTR_DEFAULT_SETTLEMENT_FLAG
, BAU.PAYROLL_BANK_ACCOUNT_ID
, BAU.PRICING_MODEL
, BAU.AUTHORIZED_FLAG
, BAU.EFT_SCRIPT_NAME
, BAU.PORTFOLIO_CODE
, BAU.DEFAULT_ACCOUNT_FLAG
, BAU.OBJECT_VERSION_NUMBER
, BAU.AR_CLAIM_INV_ACT_ID
, BAU.NEW_AR_RCPTS_RECEIVABLE_TRX_ID
, BAU.PAYMENT_DOC_CATEGORY
FROM CE_BANK_ACCT_USES_ALL BAU
, CE_SECURITY_PROFILES_V OU
WHERE (( BAU.ORG_ID = OU.ORGANIZATION_ID
AND OU.ORGANIZATION_TYPE IN ('BUSINESS_GROUP')) OR (BAU.LEGAL_ENTITY_ID = OU.ORGANIZATION_ID
AND OU.ORGANIZATION_TYPE = 'LEGAL_ENTITY'))
AND NOT EXISTS (SELECT NULL
FROM CE_BANK_ACCT_USES_OU BAUOU
WHERE BAU.BANK_ACCT_USE_ID = BAUOU.BANK_ACCT_USE_ID)