VIEW: APPS.CE_ARCH_RECONCILIATIONS

Source

View Text - Preformatted

SELECT CAR.STATEMENT_LINE_ID , CAR.REFERENCE_TYPE , CAR.REFERENCE_ID , CAR.JE_HEADER_ID , CAR.CREATED_BY , CAR.CREATION_DATE , CAR.LAST_UPDATED_BY , CAR.LAST_UPDATE_DATE , CAR.ORG_ID , CAR.REFERENCE_STATUS , CAR.STATUS_FLAG , CAR.ACTION_FLAG , CAR.CURRENT_RECORD_FLAG , CAR.AUTO_RECONCILED_FLAG , CAR.REQUEST_ID , CAR.PROGRAM_APPLICATION_ID , CAR.PROGRAM_ID , CAR.PROGRAM_UPDATE_DATE , CAR.AMOUNT , CAR.LEGAL_ENTITY_ID FROM CE_ARCH_RECONCILIATIONS_ALL CAR WHERE CAR.ORG_ID in (select OU.ORGANIZATION_ID from CE_SECURITY_PROFILES_V OU WHERE OU.ORGANIZATION_TYPE in ('BUSINESS_GROUP', 'OPERATING_UNIT')) or CAR.LEGAL_ENTITY_ID in (select LE.ORGANIZATION_ID from CE_SECURITY_PROFILES_V LE WHERE LE.ORGANIZATION_TYPE = 'LEGAL_ENTITY') or (CAR.REFERENCE_TYPE in ('JE_LINE', 'ROI_LINE','STATEMENT'))

View Text - HTML Formatted

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