VIEW: APPS.CSP_SR_DR_LOV_V

Source

View Text - Preformatted

SELECT distinct csa.incident_number, jtot.name source_type, csa.incident_id, csa.summary Description from cs_incidents_all csa, jtf_Tasks_b jtb, jtf_objects_tl jtot where jtb.source_object_id = csa.incident_id and jtb.source_object_Type_code = 'SR' and jtot.object_code = 'SR' and jtot.language = userenv('lang') and csa.incident_status_id not in (select incident_status_id from cs_incident_statuses where close_flag = 'Y') union all select distinct cr.repair_number incident_number, jtot.name, cr.incident_id, csa.summary Description from csd_Repairs cr, cs_incidents_all csa, jtf_objects_tl jtot, jtf_Tasks_b jtb where cr.status = 'O' and cr.incident_id = csa.incident_id and jtot.object_code = 'DR' and jtot.language = userenv('lang') and jtb.source_object_id = cr.repair_line_id and jtb.source_object_type_code = 'DR'

View Text - HTML Formatted

SELECT DISTINCT CSA.INCIDENT_NUMBER
, JTOT.NAME SOURCE_TYPE
, CSA.INCIDENT_ID
, CSA.SUMMARY DESCRIPTION
FROM CS_INCIDENTS_ALL CSA
, JTF_TASKS_B JTB
, JTF_OBJECTS_TL JTOT
WHERE JTB.SOURCE_OBJECT_ID = CSA.INCIDENT_ID
AND JTB.SOURCE_OBJECT_TYPE_CODE = 'SR'
AND JTOT.OBJECT_CODE = 'SR'
AND JTOT.LANGUAGE = USERENV('LANG')
AND CSA.INCIDENT_STATUS_ID NOT IN (SELECT INCIDENT_STATUS_ID
FROM CS_INCIDENT_STATUSES
WHERE CLOSE_FLAG = 'Y') UNION ALL SELECT DISTINCT CR.REPAIR_NUMBER INCIDENT_NUMBER
, JTOT.NAME
, CR.INCIDENT_ID
, CSA.SUMMARY DESCRIPTION
FROM CSD_REPAIRS CR
, CS_INCIDENTS_ALL CSA
, JTF_OBJECTS_TL JTOT
, JTF_TASKS_B JTB
WHERE CR.STATUS = 'O'
AND CR.INCIDENT_ID = CSA.INCIDENT_ID
AND JTOT.OBJECT_CODE = 'DR'
AND JTOT.LANGUAGE = USERENV('LANG')
AND JTB.SOURCE_OBJECT_ID = CR.REPAIR_LINE_ID
AND JTB.SOURCE_OBJECT_TYPE_CODE = 'DR'