ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2393869E053B46B63588994Y SELECT VPA.contract_number PROGRAM_AGREEMENT, CLE.name ASSET_NUMBER, CLE.item_description ASSET_DESCRIPTION, CHR.contract_number CONTRACT_NUMBER, CLE.date_terminated ASSET_TERMINATION_DATE, PPD.vendor_name VENDOR, TAL.fa_trx_date DISPOSITION_DATE, TAL.residual_shr_amount||' '||CHR.currency_code VENDOR_SHARE FROM OKC_K_LINES_V CLE, OKC_K_HEADERS_B CHR, OKC_K_HEADERS_B VPA, OKL_K_HEADERS KHR, OKL_TRX_ASSETS TAS, OKL_TXL_ASSETS_B TAL, OKL_PARTY_PAYMENT_DTLS_UV PPD &WHERE_CLAUSE OKL OKL_AM_VEND_RES_SHR_RPT AR OKL تقرير OKL - تقرير الحصة المتبقية للبائع Application: إدارة الإيجار Source: تقرير OKL - تقرير الحصة المتبقية للبائع Short Name: OKL_AM_VEND_RES_SHR_RPT DB package: OKL_AM_VENDOR_RES_SHARE_PVT D OKL Restwertanteil Lieferant - Ergebnisse Application: Lease and Finance Management Source: OKL Restwertanteil Lieferant - Ergebnisse Short Name: OKL_AM_VEND_RES_SHR_RPT DB package: OKL_AM_VENDOR_RES_SHARE_PVT F OKL Etat OKL - Etat Partage de la valeur résiduelle fournisseur Application: Lease and Finance Management Source: Etat OKL - Etat Partage de la valeur résiduelle fournisseur Short Name: OKL_AM_VEND_RES_SHR_RPT DB package: OKL_AM_VENDOR_RES_SHARE_PVT US OKL Report - Vendor Residual Share Application: Lease and Finance Management Source: OKL Report - Vendor Residual Share Report Short Name: OKL_AM_VEND_RES_SHR_RPT DB package: OKL_AM_VENDOR_RES_SHARE_PVT ZHS OKL 报表 - 供应商残余份额报表 Application: Oracle Lease and Finance Management Source: OKL 报表 - 供应商残余份额报表 Short Name: OKL_AM_VEND_RES_SHR_RPT DB package: OKL_AM_VENDOR_RES_SHARE_PVT BI Publisher &where_clause :operating_unit :p_asset_number :p_asst_end_dt_from :p_asst_end_dt_to :p_currency :p_disp_date_from :p_disp_date_to :p_vpa_number :where_clause 1 10 :p_asset_number LOV Oracle OKL_AM_ASSET_NUM Y select name id, name value, null description from okc_k_lines_v order by value,description AR رقم الأصل D Anlagennummer F Numéro de bien US Asset Number ZHS 资产编号 2 20 :p_disp_date_from Date AR تاريخ التصرف من D Von Weiterverkaufsdatum F Date de début de rachat US Disposition Date From ZHS 处理日期自 3 30 :p_disp_date_to Date AR تاريخ التصرف إلى D Bis Weiterverkaufsdatum F Date de fin de rachat US Disposition Date To ZHS 处理日期至 4 40 :p_vpa_number LOV Oracle OKL_AM_CONTRACT_NUM Y select contract_number id, contract_number value, null description from okc_k_headers_b order by value,description AR اتفاقية البرنامج D Vertrag für Finanzierungsprogramm F Accord de programme US Program Agreement ZHS 方案协议 5 50 :p_asst_end_dt_from Date AR تاريخ إنهاء الأصل من D Von Anlagenbeendigungsdatum F Date de fin de contrat pour le bien - Du US Asset Termination Date From ZHS 资产终止日期自 6 60 :p_asst_end_dt_to Date AR تاريخ إنهاء الأصل إلى D Bis Anlagenbeendigungsdatum F Date de fin de contrat pour le bien - Au US Asset Termination Date To ZHS 资产终止日期至 7 70 :p_currency LOV Oracle OKL_AM_CURRENCY_CODE Y select currency_code id, currency_code value, name description from fnd_currencies_vl order by value,description AR رمز العملة D Währungsschlüssel F Code devise US Currency Code ZHS 币种代码