POQ_ALL_RESP_REPOS_VALUES_V

Details

• Schema: FUSION

• Object owner: POQ

• Object type: VIEW

Columns

Name
RESP_REPOSITORY_VALUE_ID OBJECT_VERSION_NUMBER RESPONSE_REPOSITORY_ID RESPONSE_VALUE_TXT RESPONSE_VALUE_DATE RESPONSE_VALUE_DATETIME RESPONSE_VALUE_NUM ACC_RESPONSE_ID ACC_RESPONSE_TEXT CRITICAL_RESPONSE_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT RESP_REPOSITORY_VALUE_ID , OBJECT_VERSION_NUMBER , RESPONSE_REPOSITORY_ID , RESPONSE_VALUE_TXT , RESPONSE_VALUE_DATE , RESPONSE_VALUE_DATETIME , RESPONSE_VALUE_NUM , ACC_RESPONSE_ID , ACC_RESPONSE_TEXT , CRITICAL_RESPONSE_FLAG , CREATION_DATE , CREATED_BY , LAST_UPDATE_DATE , LAST_UPDATED_BY , LAST_UPDATE_LOGIN FROM POQ_RESP_REPOSITORY_VALUES UNION ALL SELECT PoqRespReposBusClass.RESP_REPOS_BUS_CLASS_ID AS RESP_REPOSITORY_VALUE_ID, PoqRespReposBusClass.OBJECT_VERSION_NUMBER AS OBJECT_VERSION_NUMBER , PoqRespReposBusClass.RESPONSE_REPOSITORY_ID AS RESPONSE_REPOSITORY_ID , NULL AS RESPONSE_VALUE_TXT , NULL AS RESPONSE_VALUE_DATE , NULL AS RESPONSE_VALUE_DATETIME , NULL AS RESPONSE_VALUE_NUM , NULL AS ACC_RESPONSE_ID , (CASE WHEN PoqRespReposBusClass.CERTIFYING_AGENCY_ID = -1 THEN PoqRespReposBusClass.OTHER_CERTIFYING_AGENCY WHEN PoqRespReposBusClass.CERTIFYING_AGENCY_ID is null THEN 'UNSPECIFIED_AGENCY' ELSE PozCertifyingAgencyPEO.NAME END) AS ACC_RESPONSE_TEXT, NULL AS CRITICAL_RESPONSE_FLAG , PoqRespReposBusClass.CREATION_DATE AS CREATION_DATE , PoqRespReposBusClass.CREATED_BY AS CREATED_BY , PoqRespReposBusClass.LAST_UPDATE_DATE AS LAST_UPDATE_DATE, PoqRespReposBusClass.LAST_UPDATED_BY AS LAST_UPDATED_BY , PoqRespReposBusClass.LAST_UPDATE_LOGIN AS LAST_UPDATE_LOGIN FROM POQ_RESP_REPOS_BUS_CLASS PoqRespReposBusClass, POZ_CERTIFYING_AGENCIES PozCertifyingAgencyPEO, (SELECT MIN(InnerB.ROWID) as ROW_ID, InnerB.RESPONSE_REPOSITORY_ID, NVL(InnerB.CERTIFYING_AGENCY_ID,-1) AS CERTIFYING_AGENCY_ID, NVL(InnerB.OTHER_CERTIFYING_AGENCY,-1) AS OTHER_CERTIFYING_AGENCY FROM POQ_RESP_REPOS_BUS_CLASS InnerB GROUP BY InnerB.RESPONSE_REPOSITORY_ID,InnerB.CERTIFYING_AGENCY_ID,InnerB.OTHER_CERTIFYING_AGENCY) UniqueRespReposBusClass WHERE PoqRespReposBusClass.CERTIFYING_AGENCY_ID =PozCertifyingAgencyPEO.AGENCY_ID(+) AND PoqRespReposBusClass.ROWID =UniqueRespReposBusClass.ROW_ID AND PoqRespReposBusClass.RESPONSE_REPOSITORY_ID = UniqueRespReposBusClass.RESPONSE_REPOSITORY_ID AND NVL(PoqRespReposBusClass.CERTIFYING_AGENCY_ID,-1) = NVL(UniqueRespReposBusClass.CERTIFYING_AGENCY_ID,-1) AND NVL(PoqRespReposBusClass.OTHER_CERTIFYING_AGENCY,-1) = NVL(UniqueRespReposBusClass.OTHER_CERTIFYING_AGENCY,-1)