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
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 |