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_ACCTS_GT_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_ACCTS_GT_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_ACCTS_GT_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_ACCTS_GT_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 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 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 AND CBA.ACCOUNT_CLASSIFICATION = 'SUBSIDIARY'