OKL Inform Service and Maintenance Provider

Description
Categories: BI Publisher
Columns: System Date, Contract Number, Contract Status, Contract Effective From, Contract Effective To, Org Id, Cust Account Id, Serial Number, Model Number, Asset Number ...
Application: Lease and Finance Management
Source:
Short Name: OKLINFMSRVPRVDR
DB package:
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