View: CE_CP_WS_LE_V

Product:	CE - Cash Management
Description:	Legal Entity list based on Cash Position worksheets
Implementation/DBA Data:	APPS.CE_CP_WS_LE_V

View Text

SELECT WSL.WORKSHEET_HEADER_ID
, BA.ACCOUNT_OWNER_ORG_ID
FROM CE_CP_WORKSHEET_LINES WSL
, CE_BANK_BRANCHES_V BB
, CE_BANK_ACCTS_GT_V BA
WHERE WSL.SOURCE_TYPE = 'BAB'
AND WSL.INCLUDE_FLAG = 'Y'
AND WSL.LEGAL_ENTITY_ID IS NULL
AND WSL.BANK_ACCOUNT_ID IS NULL
AND BB.BANK_NAME = WSL.BANK_NAME
AND BB.BRANCH_PARTY_ID = BA.BANK_BRANCH_ID
AND BA.ACCOUNT_CLASSIFICATION = 'INTERNAL' UNION SELECT WSL.WORKSHEET_HEADER_ID
, WSL.LEGAL_ENTITY_ID
FROM CE_CP_WORKSHEET_LINES WSL
WHERE WSL.SOURCE_TYPE = 'BAB'
AND WSL.INCLUDE_FLAG = 'Y'AND WSL.LEGAL_ENTITY_ID IS NOT NULL UNION SELECT WSL.WORKSHEET_HEADER_ID
, WSL.LEGAL_ENTITY_ID
FROM CE_CP_WORKSHEET_LINES WSL
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

Columns