View: CSS_DEF_ESCALATED_DEFECTS_V

View Text

SELECT TRF.OBJECT_ID DEFECT_ID
, DEF.DEFECT_NUMBER
, TSK.OWNER_ID ESCALATION_OWNER_ID
, TSK.OWNER_TYPE_CODE ESCALATION_OWNER_TYPE_CODE
, SUBSTR( CSS_DEF_RESOURCE_UTIL_PVT.GET_RESOURCE_NAME( TSK.OWNER_ID
, TSK.OWNER_TYPE_CODE )
, 1
, 573 ) ESCALATION_OWNER_NAME
, TSK.ESCALATION_LEVEL ESCALATION_LEVEL_CODE
, FLK.MEANING ESCALATION_LEVEL_MEANING
FROM JTF_TASKS_VL TSK
, JTF_TASK_REFERENCES_VL TRF
, JTF_EC_STATUSES_VL TST
, FND_LOOKUPS FLK
, CSS_DEF_DEFECTS_B DEF
WHERE TSK.TASK_ID = TRF.TASK_ID
AND TSK.TASK_STATUS_ID = TST.TASK_STATUS_ID
AND TSK.TASK_TYPE_ID = 22
AND NVL(TSK.DELETED_FLAG
, 'N') = 'N'
AND NVL(TST.CLOSED_FLAG
, 'N') = 'N'
AND NVL(TST.CANCELLED_FLAG
, 'N') = 'N'
AND NVL(TST.COMPLETED_FLAG
, 'N') = 'N'
AND NVL(TST.REJECTED_FLAG
, 'N') = 'N'
AND TRF.OBJECT_TYPE_CODE = 'DF'
AND TRF.REFERENCE_CODE = 'ESC'
AND FLK.LOOKUP_TYPE = 'JTF_TASK_ESC_LEVEL'
AND FLK.LOOKUP_CODE = TSK.ESCALATION_LEVEL
AND DEF.DEFECT_ID = TRF.OBJECT_ID

Columns