ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN EEE75CEB4AA96AD8E05362FB09051F8BY select x.* from ( select * from ( SELECT HDR.ID ecc_spec_id, HDR.ID contract_id, KHDR.FOLLOW_UP_DATE FOLLOW_UP_DATE FROM OKS_K_HEADERS_B khdr,OKC_K_HEADERS_ALL_B hdr WHERE hdr.end_date >= NVL(fnd_date.canonical_to_date(fnd_profile.value('OKS_ECC_CONTARCT_FROM_DATE')),sysdate) and hdr.template_yn = 'N' AND hdr.scs_code IN ('SERVICE', 'WARRANTY', 'SUBSCRIPTION') AND hdr.id = khdr.chr_id AND KHDR.FOLLOW_UP_DATE IS NOT NULL union select ID ecc_spec_id, CHR_ID contract_id, FOLLOW_UP_DUE_DATE FOLLOW_UP_DATE FROM OKS_FOLLOW_UP_ACTIONS WHERE FOLLOW_UP_COMPLETION_DATE IS NULL AND FOLLOW_UP_DUE_DATE >= NVL(fnd_date.canonical_to_date(fnd_profile.value('OKS_ECC_CONTARCT_FROM_DATE')),sysdate)) ) x where 2=2 AR ECC عقود الخدمة, تفاصيل متابعة عقود الخدمة Imported from Enterprise Command Center Dataset Key: oks-followup Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues D ECC Service Contracts, Serviceverträge - Nachfassdetails Imported from Enterprise Command Center Dataset Key: oks-followup 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 Seguimiento de Contratos de Servicio Imported from Enterprise Command Center Dataset Key: oks-followup Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues F ECC Service Contracts, Détails du suivi des contrats de service Imported from Enterprise Command Center Dataset Key: oks-followup 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 sul follow-up dei contratti assistenza Imported from Enterprise Command Center Dataset Key: oks-followup 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-followup 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-followup 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-followup Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues S ECC Servicekontrakt, Uppföljningsdetaljer för servicekontrakt Imported from Enterprise Command Center Dataset Key: oks-followup 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, Hizmet Sözleşmeleri Takip Detayları Imported from Enterprise Command Center Dataset Key: oks-followup Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues US ECC Service Contracts, Service Contracts Follow-Up Details Imported from Enterprise Command Center Dataset Key: oks-followup 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-followup Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues Enterprise Command Center