ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN EEE75CEB4AA76AD8E05362FB09051F8BY select x.* from ( select * from (SELECT /*+ leading(v.oks_hdr) use_nl(v.oks_hdr v.inc.b v.hzp) use_nl(v.inc.tl) */ ecc_spec_id, incident_id, language_code, sr_number, operating_unit, incident_status_id, sr_status, incident_type_id, sr_type, incident_urgency_id, urgency, incident_severity_id, sr_severity, customer_id, account_id, customer_site_id, contract_id, contract_number, contract_type, contract_service_id, coverage_type, incident_date, inc_date_year, inc_date_year_month, inc_date_ym_week, expected_resolution_date, actual_resolution_date, close_date, close_flag, problem_code, problem_summary, resolution_code, resolution_summary, incident_owner_id, owner, inv_organization_id, escalated, inventory_item_id, inventory_item_name, fa_corp_category, serial_num, item_instance, system_id, system_number, coverage_name, service_name, customer_party_name, customer_country, customer_city, customer_state, customer_party_id, customer_party_number, contract_operating_unit_id, sr_status_code, escalated_yn_code, item_category, sr_last_update_date, contract_status, contract_start_date, contract_end_date, contract_termination_date, contract_booked_amount, sr_operating_unit, sr_org_id, contract_currency, contract_status_group FROM oks_ecc_srs_v 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(sr_status) as sr_status , max(sr_type) as sr_type , max(urgency) as urgency, max(sr_severity) as sr_severity, max(sr_operating_unit) as sr_operating_unit, max(problem_code) as problem_code, max(resolution_code) as resolution_code for language_code in ('US' "US")) ) x where 2=2 AR ECC عقود الخدمة, تفاصيل طلب الخدمة بعقد الخدمة Imported from Enterprise Command Center Dataset Key: oks-contract-sr Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues D ECC Service Contracts, Servicevertrag - Serviceanfragedetails Imported from Enterprise Command Center Dataset Key: oks-contract-sr Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues E ECC Service Contracts, Detalles de Solicitud Servicio de Contrato de Servicio Imported from Enterprise Command Center Dataset Key: oks-contract-sr Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues F ECC Service Contracts, Contrat de service - Détails demandes de service Imported from Enterprise Command Center Dataset Key: oks-contract-sr Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues I ECC Contratti di assistenza, Dettagli richiesta di assistenza contratto assistenza Imported from Enterprise Command Center Dataset Key: oks-contract-sr Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues JA ECC Service Contracts, サービス契約サービス要求詳細 Imported from Enterprise Command Center Dataset Key: oks-contract-sr Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues KO ECC Service Contracts, 서비스 계약 서비스 요청 상세내역 Imported from Enterprise Command Center Dataset Key: oks-contract-sr Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues RU ECC Контракты на обслуживание, Сведения о запросе на обслуж. для контракта на обслуж. Imported from Enterprise Command Center Dataset Key: oks-contract-sr Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues S ECC Servicekontrakt, Servicekontrakt, detaljer om serviceärende Imported from Enterprise Command Center Dataset Key: oks-contract-sr Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues TR ECC Servis Sözleşmeleri, Servis Sözleşmesi Servis İsteği Detayları Imported from Enterprise Command Center Dataset Key: oks-contract-sr Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues US ECC Service Contracts, Service Contract Service Request Details Imported from Enterprise Command Center Dataset Key: oks-contract-sr Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues ZHS ECC Service Contracts, 服务合同服务请求详细信息 Imported from Enterprise Command Center Dataset Key: oks-contract-sr Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues Enterprise Command Center