ECC Service Contracts, Service Contract Sales Credit Details

select
x.*
from
(
select * from (SELECT    ecc_spec_id,
  language_code,
  linesalescreditid,
  linesalesperson,
  linesalesgroup,
  linesalescredittype,
  linequotapercent,
  linenonquota,
  contract_id,
  contract_line_id,
  contract_number,
  contract_modifier,
  line_number  ,
  CONTRACT_STATUS_GROUP,
  CONTRACT_END_DATE,
  CONTRACT_TERMINATION_DATE
 FROM oks_k_sales_credit_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(lineSALESGROUP)	as	lineSALESGROUP
  for language_code in ('US' "US"))
) x
where
2=2