View: CE_STATEMENT_RECON_GT_V

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

View Text

SELECT CSR.STATEMENT_LINE_ID
, CSR.REFERENCE_TYPE
, CSR.REFERENCE_ID
, CSR.CREATED_BY
, CSR.CREATION_DATE
, CSR.LAST_UPDATED_BY
, CSR.LAST_UPDATE_DATE
, CSR.JE_HEADER_ID
, CSR.ORG_ID
, REFERENCE_STATUS
, CSR.STATUS_FLAG
, CSR.ACTION_FLAG
, CSR.CURRENT_RECORD_FLAG
, CSR.AUTO_RECONCILED_FLAG
, CSR.REQUEST_ID
, CSR.PROGRAM_APPLICATION_ID
, CSR.PROGRAM_ID
, CSR.PROGRAM_UPDATE_DATE
, CSR.AMOUNT
, CSR.LEGAL_ENTITY_ID
, CSR.ROWID
FROM CE_STATEMENT_RECONCILS_ALL CSR
WHERE CSR.ORG_ID IN (SELECT OU.ORGANIZATION_ID
FROM CE_SECURITY_PROFILES_GT OU
WHERE OU.ORGANIZATION_TYPE IN ('BUSINESS_GROUP'
, 'OPERATING_UNIT')) OR CSR.LEGAL_ENTITY_ID IN (SELECT LE.ORGANIZATION_ID
FROM CE_SECURITY_PROFILES_GT LE
WHERE LE.ORGANIZATION_TYPE = 'LEGAL_ENTITY') OR (CSR.REFERENCE_TYPE IN ('JE_LINE'
, 'ROI_LINE'
, 'STATEMENT'))

Columns