OKL Notify Title Filing Authority

Description
Categories: BI Publisher
Application: Lease and Finance Management
Source:
Short Name: OKLTITLEFILING
DB package:
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