ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2193869E053B46B63588994 select meaning BOOK_CLASS from fnd_lookups where lookup_type like 'OKL_BOOK_CLASS' AND lookup_code like NVL (:P_BOOK_CLASS, 'XXX') and nvl(start_date_active,sysdate) <=sysdate and nvl(end_date_active,sysdate+1) > sysdate and enabled_flag = 'Y' Y OKL OKLFINEXTR AR OKL التقرير المالي للعقد Application: إدارة الإيجار Source: التقرير المالي للعقد Short Name: OKLFINEXTR DB package: OKL_CNTRCT_FIN_EXTRACT_PVT D OKL Vertragsfinanzbericht Application: Lease and Finance Management Source: Vertragsfinanzbericht Short Name: OKLFINEXTR DB package: OKL_CNTRCT_FIN_EXTRACT_PVT F OKL Etat financier des contrats Application: Lease and Finance Management Source: Etat financier des contrats Short Name: OKLFINEXTR DB package: OKL_CNTRCT_FIN_EXTRACT_PVT US OKL Contract Financial Application: Lease and Finance Management Source: Contract Financial Report Short Name: OKLFINEXTR DB package: OKL_CNTRCT_FIN_EXTRACT_PVT ZHS OKL 合同财务报表 Application: Oracle Lease and Finance Management Source: 合同财务报表 Short Name: OKLFINEXTR DB package: OKL_CNTRCT_FIN_EXTRACT_PVT BI Publisher :l_request_id :operating_unit :p_ar_info_yn :p_book_class :p_contract_status :p_customer_name :p_customer_number :p_delete_data_yn :p_end_date_from :p_end_date_to :p_gen_accrual :p_lease_product :p_operating_unit :p_request_id :p_sales_channel_code :p_sales_type_indicator :p_sic_code :p_start_date_from :p_start_date_to :p_terminate_date_from :p_terminate_date_to :p_vendor_name :p_vendor_number 1 10 :p_operating_unit LOV Oracle OKL_OPERATING_UNITS_MO Y select organization_id id, name value, null description from hr_operating_units where mo_global.check_access(organization_id)='Y' order by value,description Y AR وحدة التشغيل D Betriebseinheit F Unité opérationnelle US Operating Unit ZHS 业务实体 2 20 :p_report_date Date select sysdate from dual Y AR تاريخ التقرير D Auswertungsdatum F Edité le US Report Date ZHS 报表日期 3 30 :p_start_date_from Date Y AR تاريخ بداية العقد من D Vertragsbeginn von F Date de début de contrat - Du US Contract Start Date From ZHS 合同起始日期自 4 40 :p_start_date_to Date Y AR تاريخ بداية العقد إلى D Vertragsbeginn bis F Date de début de contrat - Au US Contract Start Date To ZHS 合同起始日期至 5 50 :p_ar_info_yn LOV Oracle OKL_YES_NO Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=1019019 order by ffvv.flex_value NO Y AR تضمين تفاصيل تحرير فواتير حساب المقبوضات D Mit DE-Fakturierungsdetails F Inclure les détails de facturation AR US Include AR Billing Details ZHS 包括 AR 开单详细信息 6 60 :p_book_class LOV Oracle OKL_BOOK_CLASS Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='OKL_BOOK_CLASS' and nvl(start_date_active,sysdate)<=sysdate and nvl(end_date_active,sysdate+1)>sysdate and enabled_flag='Y' order by meaning AR تصنيف دفتر الحسابات D Buchungsklassifizierung F Classification de livre US Book Classification ZHS 登记分类 7 70 :p_lease_product LOV Oracle OKL_LEASE_PRODUCTS Y select id id, name value, deal_type description from okl_product_parameters_v where product_subclass like 'LEASE' order by value,description AR المنتج المالي D Finanzprodukt F Produit financier US Financial Product ZHS 财务产品 8 80 :p_contract_status LOV Oracle OKL_EXTRACT_CONTRACT_STATUSES Y select code id, meaning value, null description from okc_statuses_v where code in ('BANKRUPTCY_HOLD','ENTERED','BOOKED','COMPLETE','EVERGREEN','EXPIRED','INCOMPLETE','LITIGATION_HOLD','NEW','PASSED','REVERSED','TERMINATED') order by meaning AR موقف العقد D Vertragsstatus F Statut du contrat US Contract Status ZHS 合同状态 9 90 :p_customer_number LOV Oracle OKS_CUSTOMER_NUMBER Y select party_number id, party_number value, party_name description from hz_parties order by party_number AR رقم طرف العميل D Kundenparteinummer F Numéro de partie client US Customer Party Number ZHS 客户交易方编号 10 100 :p_customer_name LOV Oracle OKL_CUSTOMERS Y select id1 id, name value, description description from okx_parties_v order by value,description AR اسم طرف العميل D Kundenparteiname F Nom de la partie client US Customer Party Name ZHS 客户交易方名称 11 110 :p_sic_code LOV Oracle OKL_HZ_SIC_CODES Y select lvalue.lookup_code id, lvalue.meaning value, lvalue.description description from hz_class_categories cc,fnd_lookup_types_tl ltype,fnd_lookup_values lvalue where cc.class_category=ltype.lookup_type and ltype.language=userenv('LANG') and ltype.view_application_id=nvl(cc.class_owner_id,222) and cc.class_category=lvalue.lookup_type and lvalue.language=userenv('LANG') and lvalue.view_application_id=nvl(cc.class_owner_id,222) and lvalue.enabled_flag='Y' and trunc(sysdate) between trunc(nvl(start_date_active,sysdate)) and trunc(nvl(end_date_active,sysdate)) order by value,description AR رمز تصنيف الصناعات القياسية للعميل D Kunden-Branchen-Code F Code NAF du client US Customer SIC Code ZHS 客户 SIC 代码 12 120 :p_vendor_number LOV Oracle OKL_VENDORS Y select id1 id, name value, description description from okx_vendors_v order by value,description AR رقم طرف البائع D Lieferantenparteinummer F Numéro de partie fournisseur US Vendor Party Number ZHS 供应商交易方编号 13 130 :p_vendor_name LOV Oracle OKL_VENDORS Y select id1 id, name value, description description from okx_vendors_v order by value,description AR اسم طرف البائع D Lieferantenparteiname F Nom de la partie fournisseur US Vendor Party Name ZHS 供应商交易方名称 14 140 :p_sales_channel LOV Oracle QP_SALES_CHANNEL_CODE Y select lookup_code id, lookup_code value, meaning description from oe_lookups where lookup_type='SALES_CHANNEL' order by value,description AR قناة المبيعات D Vertriebsweg F Canal de ventes US Sales Channel ZHS 销售渠道 15 150 :p_gen_accrual LOV Oracle OKL_YES_NO Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=1019019 order by ffvv.flex_value AR عقد على أساس الاستحقاق D Vertrag mit Abgrenzung F Provisions pour contrat US Contract On Accrual ZHS 应计合同 16 160 :p_end_date_from Date AR تاريخ نهاية العقد من D Vertragsende von F Date de fin de contrat - Du US Contract End Date From ZHS 合同终止日期自 17 170 :p_end_date_to Date AR تاريخ نهاية العقد إلى D Vertragsende bis F Date de fin de contrat - Au US Contract End Date To ZHS 合同终止日期至 18 180 :p_terminate_date_from Date AR تاريخ إنهاء العقد من D Vertragsbeendigungsdatum von F Date de résiliation de contrat - Du US Contract Termination Date From ZHS 合同终止日期自 19 190 :p_terminate_date_to Date AR تاريخ إنهاء العقد إلى D Vertragsbeendigungsdatum bis F Date de résiliation de contrat - Au US Contract Termination Date To ZHS 合同终止日期至 20 200 :p_delete_data_yn LOV Oracle OKL_YES_NO Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=1019019 order by ffvv.flex_value YES Y AR حذف بيانات التقرير D Auswertungsdaten löschen F Supprimer les données de l'état US Delete Report Data ZHS 删除报表数据