ECC Service Contracts, Service Contract Contact Details

Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: oks-contract-contact
Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info
Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
Run ECC Service Contracts, Service Contract Contact Details and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Blitz Report™