ECC Service Contracts, Service Contract Sales Credit Details

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Linesalescreditid, Linesalesperson, Linesalescredittype, Linequotapercent, Linenonquota, Contract Id, Contract Line Id, Contract Number, Contract Modifier ...
Imported from Enterprise Command Center
Dataset Key: oks-contract-salescredit
Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info
Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
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