VIEW: APPS.CE_STATEMENT_RECONCILIATIONS

Source

View Text - Preformatted

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_V OU WHERE OU.ORGANIZATION_TYPE in ('BUSINESS_GROUP', 'OPERATING_UNIT')) or CSR.LEGAL_ENTITY_ID in (select LE.ORGANIZATION_ID from CE_SECURITY_PROFILES_V LE WHERE LE.ORGANIZATION_TYPE = 'LEGAL_ENTITY') or (CSR.REFERENCE_TYPE in ('JE_LINE', 'ROI_LINE','STATEMENT'))

View Text - HTML Formatted

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_V OU
WHERE OU.ORGANIZATION_TYPE IN ('BUSINESS_GROUP'
, 'OPERATING_UNIT')) OR CSR.LEGAL_ENTITY_ID IN (SELECT LE.ORGANIZATION_ID
FROM CE_SECURITY_PROFILES_V LE
WHERE LE.ORGANIZATION_TYPE = 'LEGAL_ENTITY') OR (CSR.REFERENCE_TYPE IN ('JE_LINE'
, 'ROI_LINE'
, 'STATEMENT'))