ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F21D3869E053B46B63588994 SELECT TO_CHAR(sysdate, 'MM-DD-YYYY') SYSTEM_DATE, CHR.CONTRACT_NUMBER CONTRACT_NUMBER , CHR.STS_CODE CONTRACT_STATUS, CHR.START_DATE CONTRACT_EFFECTIVE_FROM, CHR.END_DATE CONTRACT_EFFECTIVE_TO, CHR.AUTHORING_ORG_ID ORG_ID, CHR.CUST_ACCT_ID CUST_ACCOUNT_ID, OALV.SERIAL_NUMBER SERIAL_NUMBER, OALV.MODEL_NUMBER MODEL_NUMBER, CLEV.NAME ASSET_NUMBER, CLEV.ITEM_DESCRIPTION ASSET_DESCRIPTION, OKL_AM_UTIL_PVT.GET_JTF_OBJECT_NAME('OKX_VENDOR',OPRV.OBJECT1_ID1,OPRV.OBJECT1_ID2 ) SERVICE_PROVIDER, OKL_AM_UTIL_PVT.GET_JTF_OBJECT_NAME('OKX_PARTY',OPPV.OBJECT1_ID1, OPPV.OBJECT1_ID2) LESSEE FROM OKL_K_LINES_FULL_V CLEV, OKX_ASSET_LINES_V OALV, OKC_K_HEADERS_ALL_B CHR, OKC_K_PARTY_ROLES_V OPRV, OKC_K_PARTY_ROLES_V OPPV WHERE CLEV.ID = OALV.PARENT_LINE_ID AND CLEV.CHR_ID = CHR.ID AND OPRV.chr_id = CHR.id AND OPRV.jtot_object1_code = 'OKX_VENDOR' AND OPPV.chr_id = CHR.id AND OPPV.jtot_object1_code = 'OKX_PARTY' and OPPV.RLE_CODE = 'LESSEE' and CLEV.id = :P_LINE_ID Y OKL OKLINFMSRVPRVDR AR OKL إخطار موفر الخدمة والصيانة Application: إدارة الإيجار Source: Short Name: OKLINFMSRVPRVDR DB package: D OKL Service- und Instandhaltungsanbieter benachrichtigen Application: Lease and Finance Management Source: Short Name: OKLINFMSRVPRVDR DB package: F OKL Informer le fournisseur de service et de maintenance Application: Lease and Finance Management Source: Short Name: OKLINFMSRVPRVDR DB package: US OKL Inform Service and Maintenance Provider Application: Lease and Finance Management Source: Short Name: OKLINFMSRVPRVDR DB package: ZHS OKL 通知服务与维护提供商 Application: Oracle Lease and Finance Management Source: Short Name: OKLINFMSRVPRVDR DB package: BI Publisher :p_line_id