VIEW: APPS.CE_CP_WS_BA_DISC_V

Source

View Text - Preformatted

SELECT WSL.worksheet_header_id, null, CBA.bank_account_id, CBA.currency_code, CBA.account_owner_org_id LEGAL_ENTITY_ID, CBA.bank_account_name, WSL.balance_type, WSL.float_type, to_number(null), to_number(null) FROM CE_BANK_ACCOUNTS_V cba, CE_BANK_BRANCHES_V CBB, CE_CP_WORKSHEET_LINES WSL WHERE CBB.branch_party_id = CBA.bank_branch_id AND WSL.source_type = 'BAB' AND WSL.include_flag = 'Y' AND WSL.cashpool_id is null AND WSL.bank_account_id is null AND (WSL.legal_entity_id is null OR WSL.legal_entity_id = CBA.account_owner_org_id) and (WSL.bank_name is null OR WSL.bank_name = CBB.bank_name) and CBA.account_classification = 'INTERNAL' AND nvl(CBA.end_date, sysdate) >= sysdate UNION SELECT WSL.worksheet_header_id, null, CBA.bank_account_id, CBA.currency_code, CBA.account_owner_org_id LEGAL_ENTITY_ID, CBA.bank_account_name, WSL.balance_type, WSL.float_type, to_number(null), to_number(null) FROM CE_BANK_ACCOUNTS_V cba, CE_CP_WORKSHEET_LINES WSL WHERE WSL.source_type = 'BAB' AND WSL.include_flag = 'Y' AND WSL.bank_account_id = CBA.bank_account_id AND CBA.account_classification = 'INTERNAL' AND nvl(CBA.end_date, sysdate) >= sysdate MINUS SELECT WSL.worksheet_header_id, null, CPSA.account_id BANK_ACCOUNT_ID, cba.currency_code, CBA.account_owner_org_id LEGAL_ENTITY_ID, CBA.bank_account_name, WSL.balance_type, WSL.float_type, to_number(null), to_number(null) FROM CE_CP_WORKSHEET_LINES WSL, CE_CASHPOOL_SUB_ACCTS CPSA, CE_BANK_ACCOUNTS_V CBA WHERE WSL.source_type = 'BAB' AND WSL.include_flag = 'Y' AND WSL.legal_entity_id is null AND WSL.bank_name is null AND WSL.bank_account_id is null AND (WSL.cashpool_id = -1 OR WSL.cashpool_id = CPSA.cashpool_id) AND CPSA.type <> 'POOL' AND CPSA.account_id = CBA.bank_account_id UNION SELECT WSL.worksheet_header_id, null, CPSA.account_id BANK_ACCOUNT_ID, CBA.currency_code, CBA.account_owner_org_id, CBA.bank_account_name BANK_ACCOUNT_NAME, WSL.balance_type, WSL.float_type, CBA.cashflow_display_order, CPSA.cashpool_id FROM CE_CP_WORKSHEET_LINES WSL, CE_CASHPOOL_SUB_ACCTS CPSA, CE_BANK_ACCOUNTS_V cba WHERE WSL.source_type = 'BAB' AND WSL.include_flag = 'Y' AND WSL.legal_entity_id is null AND WSL.bank_name is null AND WSL.bank_account_id is null AND (WSL.cashpool_id = -1 OR WSL.cashpool_id = CPSA.cashpool_id) AND CPSA.cashpool_id in ( SELECT cashpool_id FROM CE_CASHPOOLS WHERE nvl(effective_date_from, trunc(sysdate)) <= trunc(sysdate) AND nvl(effective_date_to, trunc(sysdate)) >= trunc(sysdate)) AND CPSA.type <> 'POOL' AND CPSA.account_id = CBA.bank_account_id

View Text - HTML Formatted

SELECT WSL.WORKSHEET_HEADER_ID
, NULL
, CBA.BANK_ACCOUNT_ID
, CBA.CURRENCY_CODE
, CBA.ACCOUNT_OWNER_ORG_ID LEGAL_ENTITY_ID
, CBA.BANK_ACCOUNT_NAME
, WSL.BALANCE_TYPE
, WSL.FLOAT_TYPE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM CE_BANK_ACCOUNTS_V CBA
, CE_BANK_BRANCHES_V CBB
, CE_CP_WORKSHEET_LINES WSL
WHERE CBB.BRANCH_PARTY_ID = CBA.BANK_BRANCH_ID
AND WSL.SOURCE_TYPE = 'BAB'
AND WSL.INCLUDE_FLAG = 'Y'
AND WSL.CASHPOOL_ID IS NULL
AND WSL.BANK_ACCOUNT_ID IS NULL
AND (WSL.LEGAL_ENTITY_ID IS NULL OR WSL.LEGAL_ENTITY_ID = CBA.ACCOUNT_OWNER_ORG_ID)
AND (WSL.BANK_NAME IS NULL OR WSL.BANK_NAME = CBB.BANK_NAME)
AND CBA.ACCOUNT_CLASSIFICATION = 'INTERNAL'
AND NVL(CBA.END_DATE
, SYSDATE) >= SYSDATE UNION SELECT WSL.WORKSHEET_HEADER_ID
, NULL
, CBA.BANK_ACCOUNT_ID
, CBA.CURRENCY_CODE
, CBA.ACCOUNT_OWNER_ORG_ID LEGAL_ENTITY_ID
, CBA.BANK_ACCOUNT_NAME
, WSL.BALANCE_TYPE
, WSL.FLOAT_TYPE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM CE_BANK_ACCOUNTS_V CBA
, CE_CP_WORKSHEET_LINES WSL
WHERE WSL.SOURCE_TYPE = 'BAB'
AND WSL.INCLUDE_FLAG = 'Y'
AND WSL.BANK_ACCOUNT_ID = CBA.BANK_ACCOUNT_ID
AND CBA.ACCOUNT_CLASSIFICATION = 'INTERNAL'
AND NVL(CBA.END_DATE
, SYSDATE) >= SYSDATE MINUS SELECT WSL.WORKSHEET_HEADER_ID
, NULL
, CPSA.ACCOUNT_ID BANK_ACCOUNT_ID
, CBA.CURRENCY_CODE
, CBA.ACCOUNT_OWNER_ORG_ID LEGAL_ENTITY_ID
, CBA.BANK_ACCOUNT_NAME
, WSL.BALANCE_TYPE
, WSL.FLOAT_TYPE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM CE_CP_WORKSHEET_LINES WSL
, CE_CASHPOOL_SUB_ACCTS CPSA
, CE_BANK_ACCOUNTS_V CBA
WHERE WSL.SOURCE_TYPE = 'BAB'
AND WSL.INCLUDE_FLAG = 'Y'
AND WSL.LEGAL_ENTITY_ID IS NULL
AND WSL.BANK_NAME IS NULL
AND WSL.BANK_ACCOUNT_ID IS NULL
AND (WSL.CASHPOOL_ID = -1 OR WSL.CASHPOOL_ID = CPSA.CASHPOOL_ID)
AND CPSA.TYPE <> 'POOL'
AND CPSA.ACCOUNT_ID = CBA.BANK_ACCOUNT_ID UNION SELECT WSL.WORKSHEET_HEADER_ID
, NULL
, CPSA.ACCOUNT_ID BANK_ACCOUNT_ID
, CBA.CURRENCY_CODE
, CBA.ACCOUNT_OWNER_ORG_ID
, CBA.BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, WSL.BALANCE_TYPE
, WSL.FLOAT_TYPE
, CBA.CASHFLOW_DISPLAY_ORDER
, CPSA.CASHPOOL_ID
FROM CE_CP_WORKSHEET_LINES WSL
, CE_CASHPOOL_SUB_ACCTS CPSA
, CE_BANK_ACCOUNTS_V CBA
WHERE WSL.SOURCE_TYPE = 'BAB'
AND WSL.INCLUDE_FLAG = 'Y'
AND WSL.LEGAL_ENTITY_ID IS NULL
AND WSL.BANK_NAME IS NULL
AND WSL.BANK_ACCOUNT_ID IS NULL
AND (WSL.CASHPOOL_ID = -1 OR WSL.CASHPOOL_ID = CPSA.CASHPOOL_ID)
AND CPSA.CASHPOOL_ID IN ( SELECT CASHPOOL_ID
FROM CE_CASHPOOLS
WHERE NVL(EFFECTIVE_DATE_FROM
, TRUNC(SYSDATE)) <= TRUNC(SYSDATE)
AND NVL(EFFECTIVE_DATE_TO
, TRUNC(SYSDATE)) >= TRUNC(SYSDATE))
AND CPSA.TYPE <> 'POOL'
AND CPSA.ACCOUNT_ID = CBA.BANK_ACCOUNT_ID