ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2213869E053B46B63588994Y SELECT LFE.*, RMA.DESCRIPTION INSTRUMENT_NUMBER, RMA.BANK BANK_NAME FROM OKL_CNTRCT_LINE_FIN_EXTRACT_T LFE, OKX_RCPT_METHOD_ACCOUNTS_V RMA WHERE REQUEST_ID = :L_REQUEST_ID AND CONTRACT_LINE_TYPE_NAME = 'Financial Asset Line' AND RMA.ID1(+) = LFE.ASSET_BILLING_BANK_ACCT_ID ORDER BY CONTRACT_CURRENCY, line_supplier, CONTRACT_BOOK_CLASSIFICATION, fa_corp_category, CONTRACT_NUMBER OKL OKLLNFINEXT AR OKL التقرير المالي لسطور العقد Application: إدارة الإيجار Source: التقرير المالي لسطور العقد Short Name: OKLLNFINEXT DB package: OKL_K_LINE_FIN_EXT_PVT D OKL Vertragspositions-Finanzbericht Application: Lease and Finance Management Source: Vertragspositions-Finanzbericht Short Name: OKLLNFINEXT DB package: OKL_K_LINE_FIN_EXT_PVT F OKL Etat financier des lignes de contrat Application: Lease and Finance Management Source: Etat financier des lignes de contrat Short Name: OKLLNFINEXT DB package: OKL_K_LINE_FIN_EXT_PVT US OKL Contract Lines Financial Application: Lease and Finance Management Source: Contract Lines Financial Report Short Name: OKLLNFINEXT DB package: OKL_K_LINE_FIN_EXT_PVT ZHS OKL 合同行财务报表 Application: Oracle Lease and Finance Management Source: 合同行财务报表 Short Name: OKLLNFINEXT DB package: OKL_K_LINE_FIN_EXT_PVT BI Publisher :l_request_id :operating_unit :p_book_class :p_contract_line_status :p_contract_line_type :p_contract_number :p_contract_status :p_customer_name :p_customer_number :p_delete_data_yn :p_fa_info_yn :p_lease_product :p_operating_unit :p_request_id :p_start_date_from :p_start_date_to :p_tax_book :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_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 登记分类 6 60 :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 财务产品 7 70 :p_contract_number LOV Oracle OKL_REPORT_CONTRACT_NUM Y select chr.contract_number id, chr.contract_number value, chr.contract_number description from okc_k_headers_b chr,okl_k_headers khr where khr.id=chr.id and chr.scs_code='LEASE' and chr.authoring_org_id=:$flex$.okl_operating_units_mo order by contract_number AR رقم العقد D Vertragsnummer F Numéro de contrat US Contract Number 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_contract_line_status LOV Oracle OKC_STATUSES Y select code id, meaning value, null description from okc_statuses_v order by meaning AR موقف سطر العقد D Status Vertragsposition F Statut de ligne de contrat US Contract Line Status ZHS 合同行状态 10 100 :p_contract_line_type LOV Oracle OKL_LINE_STYLES Y select lty_code id, name value, description description from okc_line_styles_v where application_id=540 and id in (33,52,48,56,47) order by name AR نوع سطر العقد D Vertragspositionsart F Type de ligne de contrat US Contract Line Type ZHS 合同行类型 11 110 :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 客户交易方名称 12 120 :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 客户交易方编号 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 Lieferantenname F Nom du fournisseur US Supplier Name ZHS 供应商名称 14 140 :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 Lieferantennummer F Numéro de fournisseur US Supplier Number ZHS 供应商编号 15 150 :p_fa_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 Anlagendetails F Inclure les détails de l'immobilisation US Include Fixed Asset Details ZHS 包括固定资产明细 16 160 :p_tax_book LOV Oracle OKL_TAX_BOOKS Y select book_type_code id, book_type_name value, null description from fa_book_controls bc,okl_system_params_all sp where sp.org_id=:$flex$.okl_operating_units_mo and 'YES'=:$flex$.okl_yes_no and bc.book_class='TAX' and sp.asst_add_book_type_code= bc.distribution_source_book and nvl(sp.rpt_prod_book_type_code,'XXX')<> bc.book_type_code order by bc.book_type_name AR دفتر حسابات ضريبة الأصل D Anlagen-Steuerbuch F Livre de gestion des biens US Asset Tax Book ZHS 资产税簿 17 170 :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 删除报表数据