ECC Service Contracts, Service Contract Service Request Details

select
x.*
from
(
select * from (SELECT   /*+ leading(v.oks_hdr) use_nl(v.oks_hdr v.inc.b v.hzp)
use_nl(v.inc.tl) */  ecc_spec_id,
  incident_id,
  language_code,
  sr_number,
  operating_unit,
  incident_status_id,
  sr_status,
  incident_type_id,
  sr_type,
  incident_urgency_id,
  urgency,
  incident_severity_id,
  sr_severity,
  customer_id,
  account_id,
  customer_site_id,
  contract_id,
  contract_number,
  contract_type,
  contract_service_id,
  coverage_type,
  incident_date,
  inc_date_year,
  inc_date_year_month,
  inc_date_ym_week,
  expected_resolution_date,
  actual_resolution_date,
  close_date,
  close_flag,
  problem_code,
  problem_summary,
  resolution_code,
  resolution_summary,
  incident_owner_id,
  owner,
  inv_organization_id,
  escalated,
  inventory_item_id,
  inventory_item_name,
  fa_corp_category,
  serial_num,
  item_instance,
  system_id,
  system_number,
  coverage_name,
  service_name,
  customer_party_name,
  customer_country,
  customer_city,
  customer_state,
  customer_party_id,
  customer_party_number,
  contract_operating_unit_id,
  sr_status_code,
  escalated_yn_code,
  item_category,
  sr_last_update_date,
  contract_status,
  contract_start_date,
  contract_end_date,
  contract_termination_date,
  contract_booked_amount,
  sr_operating_unit,
  sr_org_id,
  contract_currency,
  contract_status_group
 FROM oks_ecc_srs_v v WHERE (
 contract_end_date >=  NVL(fnd_date.canonical_to_date(fnd_profile.value('OKS_ECC_CONTARCT_FROM_DATE')),sysdate) and
              language_code in ('US')
)) pivot
(
max(sr_status)	as	sr_status	,
max(sr_type)	as	sr_type	,
max(urgency)	as	urgency,
max(sr_severity)	as	sr_severity,
max(sr_operating_unit)	as	sr_operating_unit,
max(problem_code)	as	problem_code,
max(resolution_code)	as	resolution_code
         for language_code in ('US' "US"))
) x
where
2=2