View: CSF_DEBRIEF_SRC_NUMBERS_V

Product:	CSF - Field Service
Description:	This view is used for LOV purposes in Debrief UI.
Implementation/DBA Data:	APPS.CSF_DEBRIEF_SRC_NUMBERS_V

View Text

SELECT CSA.INCIDENT_NUMBER SOURCE_NUMBER
, JOT.NAME SOURCE_TYPE
, 'SR' SOURCE_TYPE_CODE
, JTV.SOURCE_OBJECT_ID INCIDENT_ID
, TO_NUMBER(NULL) REPAIR_LINE_ID
, TO_CHAR(CSA.SUMMARY) DESCRIPTION
FROM JTF_TASKS_VL JTV
, CS_INCIDENTS_ALL CSA
, JTF_OBJECTS_VL JOT
WHERE JTV.SOURCE_OBJECT_ID=CSA.INCIDENT_ID
AND SOURCE_OBJECT_TYPE_CODE = 'SR'
AND JOT.OBJECT_CODE='SR' UNION SELECT CR.REPAIR_NUMBER SOURCE_NUMBER
, JOT.NAME SOURCE_TYPE
, 'DR' SOURCE_TYPE_CODE
, TO_NUMBER(NULL) INCIDENT_ID
, CR.REPAIR_LINE_ID REPAIR_LINE_ID
, TO_CHAR(NULL) DESCRIPTION
FROM CSD_REPAIRS CR
, JTF_OBJECTS_VL JOT
WHERE JOT.OBJECT_CODE = 'DR' ORDER BY 1

Columns