View: CE_CP_WS_BA_DISC_V

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

View Text

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

Columns