ECC Service Contracts, Service Contract Contact Details, SQL1

Description
Columns: Ecc Spec Id, Contract Id, Contract Number, Contract Modifier, Contact Name, Contact Status, Contact Email Address, Contact Start Date, Contact End Date, Contract Status Group ...
Imported from ECC
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"))