ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F23F3869E053B46B63588994Y select exp.salesrep_id, exp.customer_name, exp.contract_number, exp.contract_number_modifier, exp.contract_status_type, exp.contract_status_code, exp.line_amount, exp.customer_product_id, exp.serial_number, exp.product_start_date, exp.product_end_date, exp.org_id, exp.organization_id, OKS_OKSNREPD_XMLP_PKG.cf_salesrep_nameformula(exp.salesrep_id, exp.org_id) CF_salesrep_name, OKS_OKSNREPD_XMLP_PKG.cf_2formula(exp.customer_product_id, exp.organization_id) CF_part_number, OKS_OKSNREPD_XMLP_PKG.cf_1formula(exp.customer_product_id) CF_csi_number, OKS_OKSNREPD_XMLP_PKG.CP_description_p CP_description from oks_expired_contracts_v exp where not exists ( select '*' from oks_approved_contracts_v app where app.customer_product_id = exp.customer_product_id and exp.product_end_date < app.start_date ) &p_from_end_date_where &p_to_end_date_where &p_org_id_where &p_salesrep_where &p_customer_name_where &p_contract_group_where OKS OKSNREPD_XML AR OKS تقرير المنتجات التي لم يتم تجديدها Application: عقود الخدمة Source: OKS تقرير المنتجات التي لم يتم تجديدها (XML) Short Name: OKSNREPD_XML DB package: OKS_OKSNREPD_XMLP_PKG D OKS Oracle Service Contracts - Nicht erneuerte Produkte Application: Service Contracts Source: Oracle Service Contracts - Nicht erneuerte Produkte (XML) Short Name: OKSNREPD_XML DB package: OKS_OKSNREPD_XMLP_PKG F OKS - Produits non renouvelés Application: Service Contracts Source: OKS - Produits non renouvelés (XML) Short Name: OKSNREPD_XML DB package: OKS_OKSNREPD_XMLP_PKG US OKS Products Not Renewed Application: Service Contracts Source: OKS Products Not Renewed Report (XML) Short Name: OKSNREPD_XML DB package: OKS_OKSNREPD_XMLP_PKG ZHS OKS 未续订产品报表 Application: 服务合同管理系统 Source: OKS 未续订产品报表 (XML) Short Name: OKSNREPD_XML DB package: OKS_OKSNREPD_XMLP_PKG BI Publisher &p_contract_group_where &p_customer_name_where &p_from_end_date_where &p_org_id_where &p_salesrep_where &p_to_end_date_where :cp_description :p_conc_request_id :p_contract_group :p_contract_group_where :p_customer_name :p_customer_name_where :p_from_end_date :p_from_end_date_where :p_org_id :p_org_id_where :p_salesrep :p_salesrep_where :p_to_end_date :p_to_end_date_where 1 10 :p_contract_group LOV Oracle OKS_CONTRACT_GROUPS Y select id id, name value, null description from okc_k_groups_v where user_id is null or user_id=fnd_global.user_id order by value,description AR مجموعة العقود D Vertragsgruppe F Groupe de contrats US Contract Group ZHS 合同组 2 20 :p_operating_unit LOV Oracle OKS_OPERATING_UNITS Y select organization_id id, name value, null description from hr_operating_units where sysdate between nvl(date_from,sysdate) and nvl(date_to,sysdate) and (mo_global.check_access(organization_id)='Y') order by value,description AR وحدة التشغيل D Betriebseinheit F Unité opérationnelle US Operating Unit ZHS 业务实体 3 30 :p_salesrep LOV Oracle OKS_SALESREP_NAME1 Y select resource_id id, name value, null description from oks_rep_v where org_id=oks_util_pub.resp_org_id or oks_util_pub.resp_org_id is null order by value,description AR مندوب المبيعات D Vertriebsmitarbeiter F Vendeur US Sales Rep ZHS 销售代表 4 40 :p_customer_name LOV Oracle OKS_CUSTOMER_NAME Y Y select party_name id, party_name value, party_number description from oks_parties_v order by value,description AR العميل D Kunde F Client US Customer ZHS 客户 5 50 :p_from_end_date Date AR من تاريخ النهاية D Von Enddatum F Date de fin - Du US From End Date ZHS 自终止日期 6 60 :p_to_end_date Date AR إلى تاريخ النهاية D Bis Enddatum F Date de fin - Au US To End Date ZHS 至终止日期