VIEW: APPS.CE_CP_WS_LE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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