Product: | CE - Cash Management |
---|---|
Description: | (SINGLE-ORG view) |
Implementation/DBA Data: | APPS.CE_ARCH_RECONCILIATIONS |
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'))