ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2253869E053B46B63588994 SELECT org_id ,khr_id ,contract_number ,contract_start_date ,contract_end_date ,currency ,customer -- ,lty_code ,(select distinct oklsv.name from okc_line_styles_v oklsv, fnd_application fnd where oklsv.lty_code = ops.lty_code AND oklsv.application_id = fnd.application_id AND fnd.application_short_name = 'OKL') lty_code ,service_schedule ,kle_id ,line_start_date ,line_end_date ,line_name ,line_amount ,line_status_meaning ,line_status_code ,line_type ,line_type_meaning ,sel_id ,customer_trx_id ,ar_inv_num ,ar_inv_date ,ar_inv_line_num ,ar_inv_line_amt ,receipt_no ,receipt_amount ,passthru_term ,payout_basis ,vendor_id ,vendor ,vendor_site_id ,vendor_site_code ,ap_invoice_id ,ap_inv_num ,ap_inv_date ,ap_inv_line_num ,ap_inv_line_amt ,ap_inv_line_amt_paid ,ap_check_number ,ap_check_date FROM okl_passthrough_dtls_uv ops &WHERE_CLAUSE Y OKL OKLPASSTHRPT AR OKL تقرير نشاط حركة دفعات السداد المؤمنة Application: إدارة الإيجار Source: تقرير نشاط حركة دفعات السداد المؤمنة Short Name: OKLPASSTHRPT DB package: OKL_PASSTHROUGH_RECON_RPT_PVT D OKL Zahlungen durch Dritte - Transaktionsvorgänge Application: Lease and Finance Management Source: Zahlungen durch Dritte - Transaktionsvorgänge Short Name: OKLPASSTHRPT DB package: OKL_PASSTHROUGH_RECON_RPT_PVT F OKL Etat des activités de mouvement de transfert Application: Lease and Finance Management Source: Etat des activités de mouvement de transfert Short Name: OKLPASSTHRPT DB package: OKL_PASSTHROUGH_RECON_RPT_PVT US OKL Passthrough Transaction Activity Application: Lease and Finance Management Source: Passthrough Transaction Activity Report Short Name: OKLPASSTHRPT DB package: OKL_PASSTHROUGH_RECON_RPT_PVT ZHS OKL 转手事务处理活动报表 Application: Oracle Lease and Finance Management Source: 转手事务处理活动报表 Short Name: OKLPASSTHRPT DB package: OKL_PASSTHROUGH_RECON_RPT_PVT BI Publisher &where_clause :operating_unit :p_contract_end_date :p_contract_num :p_contract_start_date :p_lty_code :p_site_code :p_vendor :where_clause :where_clause1 1 10 :p_contract_num LOV Oracle OKL_CONTRACT_NUMBER Y select contract_number id, contract_number value, null description from okc_k_headers_b where scs_code in ('INVESTOR','LEASE') and nvl(template_yn,'N')='N' and nvl(orig_system_source_code,'OKC_HDR')<>'OKL_REBOOK' and decode(scs_code,'INVESTOR',sts_code,'ACTIVE') in ('ACTIVE','EXPIRED') and decode(scs_code,'LEASE',sts_code,'NEW')<>'ABANDONED' order by value,description AR رقم العقد D Vertragsnummer F Numéro de contrat US Contract Number ZHS 合同编号 2 20 :p_contract_start_date Date Y AR تاريخ بداية العقد D Startdatum Vertrag F Date de début du contrat US Contract start Date ZHS 合同起始日期 3 30 :p_contract_end_date Date select sysdate from dual Y AR تاريخ نهاية العقد D Enddatum Vertrag F Date de fin du contrat US Contract End Date ZHS 合同终止日期 4 40 :p_lty_code LOV Oracle OKL_LTY_CODE Y select lty_code id, lty_code value, null description from okc_line_styles_b where application_id=540 and lty_code in ('FEE','USAGE','SOLD_SERVICE') order by value,description AR نوع السطر D Positionsart F Type de ligne US Line Type ZHS 行类型 5 50 :p_vendor LOV Oracle OKL_PASSTHROUGH_VENDORS Y select vendor_name id, vendor_name value, null description from ap_suppliers order by value,description Y US P_VENDOR 6 60 :p_site_code LOV Oracle OKL_VENDOR_SITE_CODE Y select vendor_site_code id, vendor_site_code value, null description from ap_supplier_sites where vendor_id=(select vendor_id from ap_suppliers where vendor_name=:$flex$.p_vendor.value) order by value,description Y AR رمز موقع المورد D Schlüssel Lieferantenadresse F Code site fournisseur US Vendor Site Code ZHS 供应商地点代码 :$flex$.p_vendor.value P_VENDOR Vendor Site Code value