VIEW: APPS.CS_SR_SOURCE_NUMBER_VIEW

Source

View Text - Preformatted

SELECT 'SR' col1, incident_number col2 , incident_id col3 from CS_incidents_vl_sec union select 'FS' col1, debrief_number col2 ,debrief_header_id col3 from csf_debrief_headers union select 'DR' col1, repair_number col2 ,repair_line_id col3 from CSD_REPAIRS

View Text - HTML Formatted

SELECT 'SR' COL1
, INCIDENT_NUMBER COL2
, INCIDENT_ID COL3
FROM CS_INCIDENTS_VL_SEC UNION SELECT 'FS' COL1
, DEBRIEF_NUMBER COL2
, DEBRIEF_HEADER_ID COL3
FROM CSF_DEBRIEF_HEADERS UNION SELECT 'DR' COL1
, REPAIR_NUMBER COL2
, REPAIR_LINE_ID COL3
FROM CSD_REPAIRS