ECC Service Contracts, Service Contract Contact Details

select
x.*
from
(
select * from (SELECT     ecc_spec_id,
  language_code,
  contract_id,
  contract_number,
  contract_modifier,
  contact_role,
  contact_name,
  contact_status,
  contact_email_address,
  contact_start_date,
  contact_end_date ,
  contract_status_group,
  contract_end_date,
  contract_termination_date
 FROM oks_k_contact_ecc_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(contact_role)	as	contact_role
  for language_code in ('US' "US"))
) x
where
2=2