POQ_ALL_QNAIRE_RESP_VALUES_V

Details

• Schema: FUSION

• Object owner: POQ

• Object type: VIEW

Columns

Name
QUESTNAIRE_RESP_VALUE_ID OBJECT_VERSION_NUMBER QUESTNAIRE_RESPONSE_ID RESPONSE_VALUE_TXT RESPONSE_VALUE_DATE RESPONSE_VALUE_DATETIME RESPONSE_VALUE_NUM ACC_RESPONSE_ID QUESTNAIRE_ACC_RESPONSE_ID IS_SELECTED_FLAG RESPONSE_VALIDATE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN BC_RESPONSE_TEXT

Query

SQL_Statement

SELECT QUESTNAIRE_RESP_VALUE_ID , OBJECT_VERSION_NUMBER , QUESTNAIRE_RESPONSE_ID , RESPONSE_VALUE_TXT , RESPONSE_VALUE_DATE , RESPONSE_VALUE_DATETIME , RESPONSE_VALUE_NUM , ACC_RESPONSE_ID , QUESTNAIRE_ACC_RESPONSE_ID, IS_SELECTED_FLAG , RESPONSE_VALIDATE , CREATION_DATE , CREATED_BY , LAST_UPDATE_DATE , LAST_UPDATED_BY , LAST_UPDATE_LOGIN , null as BC_RESPONSE_TEXT FROM POQ_QUESTNAIRE_RESP_VALUES UNION ALL SELECT PozBusClassReqs.BUS_CLASS_REQUEST_ID AS QUESTNAIRE_RESP_VALUE_ID, PozBusClassReqs.OBJECT_VERSION_NUMBER AS OBJECT_VERSION_NUMBER , PozSupplierMappings.POQ_QUESTNAIRE_RESPONSE_ID AS QUESTNAIRE_RESPONSE_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 , null as QUESTNAIRE_ACC_RESPONSE_ID, 'Y' as IS_SELECTED_FLAG , null as RESPONSE_VALIDATE , PozBusClassReqs.CREATION_DATE as CREATION_DATE , PozBusClassReqs.CREATED_BY as CREATED_BY , PozBusClassReqs.LAST_UPDATE_DATE as LAST_UPDATE_DATE , PozBusClassReqs.LAST_UPDATED_BY as LAST_UPDATED_BY , PozBusClassReqs.LAST_UPDATE_LOGIN as LAST_UPDATE_LOGIN, (CASE WHEN PozBusClassReqs.CERTIFYING_AGENCY_ID = -1 THEN PozBusClassReqs.OTHER_CERTIFYING_AGENCY WHEN PozBusClassReqs.CERTIFYING_AGENCY_ID is null THEN 'UNSPECIFIED_AGENCY' ELSE PozCertifyingAgencyPEO.NAME END)as BC_RESPONSE_TEXT FROM POZ_BUS_CLASS_REQS PozBusClassReqs, POZ_CERTIFYING_AGENCIES PozCertifyingAgencyPEO, POZ_SUPPLIER_MAPPINGS PozSupplierMappings, (select min(InnerB.rowid) as row_id, InnerS.POQ_QUESTNAIRE_RESPONSE_ID, nvl(InnerB.CERTIFYING_AGENCY_ID,-1) AS CERTIFYING_AGENCY_ID, NVL(InnerB.OTHER_CERTIFYING_AGENCY,-1) AS OTHER_CERTIFYING_AGENCY FROM POZ_BUS_CLASS_REQS InnerB, POZ_SUPPLIER_MAPPINGS InnerS WHERE InnerB.MAPPING_ID = InnerS.MAPPING_ID AND InnerS.POQ_QUESTNAIRE_RESPONSE_HDR_ID is not null GROUP BY InnerS.POQ_QUESTNAIRE_RESPONSE_ID,InnerB.CERTIFYING_AGENCY_ID,InnerB.OTHER_CERTIFYING_AGENCY) UniqueRespReposBusClass WHERE (PozBusClassReqs.CERTIFYING_AGENCY_ID = PozCertifyingAgencyPEO.AGENCY_ID(+)) AND PozBusClassReqs.MAPPING_ID = PozSupplierMappings.MAPPING_ID AND PozBusClassReqs.rowid =UniqueRespReposBusClass.row_id AND PozSupplierMappings.POQ_QUESTNAIRE_RESPONSE_ID = UniqueRespReposBusClass.POQ_QUESTNAIRE_RESPONSE_ID AND NVL(PozBusClassReqs.CERTIFYING_AGENCY_ID,-1) = NVL(UniqueRespReposBusClass.CERTIFYING_AGENCY_ID,-1) AND NVL(PozBusClassReqs.OTHER_CERTIFYING_AGENCY,-1) = NVL(UniqueRespReposBusClass.OTHER_CERTIFYING_AGENCY,-1)