VIEW: APPS.CSF_DEBRIEF_SRC_NUMBERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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