Product: | IEU - Universal Work Queue |
---|---|
Description: | View used for UWQ selector SpreadTable. |
Implementation/DBA Data: | Not implemented in this database |
SELECT O.OBJECT_FUNCTION IEU_OBJECT_FUNCTION
, O.OBJECT_PARAMETERS IEU_OBJECT_PARAMETERS
, '' IEU_MEDIA_TYPE_UUID
, 'DEFECT_NUMBER' IEU_PARAM_PK_COL
, TO_CHAR(A.DEFECT_NUMBER) IEU_PARAM_PK_VALUE
, A.PHASE_OWNER_ID RESOURCE_ID
, 'RS_INDIVIDUAL' RESOURCE_TYPE
, A.DEFECT_ID
, A.STATUS_NAME
, A.SEVERITY_NAME
, A.PRIORITY_NAME
, A.SUMMARY
, A.PRODUCT_DESCRIPTION
, A.FILER_NAME
, A.FILED_DATE
, A.COMPONENT_DESCRIPTION
, A.SUB_COMP_DESCRIPTION
, A.LIFE_CYCLE_MEANING
, A.UI_DEFECT_MEANING
, A.FUNC_DEFECT_MEANING
, A.PLATFORM_SPECIFIC_MEANING
, A.ESCALATION_LEVEL_CODE
, A.FIX_BY_REVISION_DESC
, A.DEV_OWNER_ID
, A.PHASE_NAME
FROM CSS_DEF_DEFECTS_ALL_V A
, JTF_OBJECTS_VL O
WHERE A.OPEN_FLAG = 'O'
AND NVL(A.DELETED_FLAG
, 'N') = 'N'
AND O.OBJECT_CODE = 'DF'