OKL Inform Service and Maintenance Provider
Description
Categories: BI Publisher
Application: Lease and Finance Management
Source:
Short Name: OKLINFMSRVPRVDR
DB package:
Source:
Short Name: OKLINFMSRVPRVDR
DB package:
Run
OKL Inform Service and Maintenance Provider and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |