ECC Depot Repair, Depot Resolved Service Orders, SQL1

Description
Columns: 'Srd Row Id', 'Srd Context Value', 'Srd Additional Info', 'Srd Concatenated Segments', 'Srxt Row Id', 'Srxt Context Value', 'Srxt Item', 'Srxt Serial Number', 'Srxt Customer Name', 'Srxt Customer Address' ...
Imported from ECC
select * from (SELECT srdfv.*,xdfv.*, csdro.* FROM CSD_ECC_REPAIRS_CLOSED_V csdro
                               , (select 'SRD_ROW_ID','SRD_CONTEXT_VALUE','SRD_ADDITIONAL_INFO','SRD_CONCATENATED_SEGMENTS' from dual where 1=2  union select ROWIDTOCHAR(ROW_ID),CONTEXT_VALUE,ADDITIONAL_INFO,CONCATENATED_SEGMENTS from CS_INCIDENTS_ALL_B_DFV) srdfv , (select 'SRXT_ROW_ID','SRXT_CONTEXT_VALUE','SRXT_ITEM','SRXT_SERIAL_NUMBER','SRXT_CUSTOMER_NAME','SRXT_CUSTOMER_ADDRESS','SRXT_CI_NAME','SRXT_CI_TAG','SRXT_CI_ENVIRONMENT','SRXT_CI_USER_COUNT','SRXT_CI_IMPACT','SRXT_IMPACT','SRXT_SPECIAL_INSTRUCTIONS','SRXT_CONCATENATED_SEGMENTS' from dual where 1=2  union select ROWIDTOCHAR(ROW_ID),CONTEXT_VALUE,ITEM,SERIAL_NUMBER,CUSTOMER_NAME,CUSTOMER_ADDRESS,CI_NAME,CI_TAG,CI_ENVIRONMENT,CI_USER_COUNT,CI_IMPACT,IMPACT,SPECIAL_INSTRUCTIONS,CONCATENATED_SEGMENTS from CS_INCIDENTS_ALL_B1_DFV) xdfv  WHERE csdro.sr_rowid = srdfv."'SRD_ROW_ID'"(+) AND csdro.sr_rowid = xdfv."'SRXT_ROW_ID'"(+) and csdro.language in ('US'))
                              PIVOT(max(repair_type_name) as repair_type_name,
                                  max(ro_status_meaning) as ro_status_meaning,
                                  max(approval_status) as approval_status,
                                  max(external_display_status) as external_display_status,
                                  max(flow_status) as flow_status,
                                  max(rework) as rework,
                                  max(ro_escalation) as ro_escalation,
                                  max(repair_item_desc) as repair_item_desc,
                                  max(repair_inventory_org) as repair_inventory_org,
                                  max(repair_owner) as repair_owner,
                                  max(repair_org_name) as repair_org_name,
                                  max(repair_priority) as repair_priority,
                                  max(warranty_status) as warranty_status,
                                  max(warranty_violation) as warranty_violation,
                                  max(instance_usage) as instance_usage,
                                  max(estimate_status) as estimate_status,
                                  max(sr_owner) as sr_owner,
                                  max(disposition) as disposition ,
                                  max(sr_item_description) as sr_item_description,
                                  max(diagnostic_code) as diagnostic_code,
                                  max(diagnostic_code_desc) as diagnostic_code_desc,
                                  max(service_code) as service_code,
                                  max(service_code_desc) as service_code_desc,
                                  max(incident_type) as incident_type,
                                  max(incident_severity) as incident_severity,
                                  max(incident_urgency) as incident_urgency,
                                  max(incident_status) as incident_status,
                                  max(sr_summary) as sr_summary,
                                  max(sr_creation_channel) as sr_creation_channel,
                                  max(return_type) as return_type,
                                  max(carrier_name) as carrier_name,
                                  max(processor_name) as processor_name,
                                  max(ship_to_country) as ship_to_country,
                                  max(returned_to_country) as returned_to_country,
                                  max(returned_from_country) as returned_from_country,
                                  max(operating_unit_name) as operating_unit_name,
                                  max(tis_flow_status_meaning) as tis_flow_status_meaning
                              for LANGUAGE in ('US' "US"))