OKL Notify Title Filing Authority
Description
Categories: BI Publisher
Application: Lease and Finance Management
Source:
Short Name: OKLTITLEFILING
DB package:
Source:
Short Name: OKLTITLEFILING
DB package:
Run
OKL Notify Title Filing Authority and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT TO_CHAR(sysdate, 'MM-DD-YYYY') SYSTEM_DATE, OADT.CONTRACT_NUMBER CONTRACT_NUMBER , OKL_AM_UTIL_PVT.GET_JTF_OBJECT_NAME('OKX_VENDOR',OPRV.OBJECT1_ID1, OPRV.OBJECT1_ID2) TITLE_FILING_AUTHORITY, OKL_AM_UTIL_PVT.GET_JTF_OBJECT_NAME('OKX_PARTY',OPPV.OBJECT1_ID1, OPPV.OBJECT1_ID2) LESSEE, OADT.SERIAL_NUMBER SERIAL_NUMBER, OADT.MODEL_NUMBER MODEL_NUMBER, OADT.NAME ASSET_NUMBER, OADT.ITEM_DESCRIPTION ASSET_DESCRIPTION, OTQV.COMMENTS COMMENTS FROM OKL_AM_ASSET_DETAILS_UV OADT, OKL_TRX_QUOTES_V OTQV, OKC_K_PARTY_ROLES_V OPPV, OKC_K_PARTY_ROLES_V OPRV WHERE OADT.CHR_ID = OTQV.KHR_ID AND OPPV.chr_id = OTQV.khr_id AND OPPV.jtot_object1_code = 'OKX_PARTY' AND OPPV.RLE_CODE = 'LESSEE' AND OPRV.chr_id = OTQV.khr_id AND OPRV.jtot_object1_code = 'OKX_VENDOR' and OTQV.id = : P_QUOTE_ID |