View: OKL_ASSET_SUBSIDY_LOV_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view for subsidy LOV on asset subsidy page
Implementation/DBA Data:	APPS.OKL_ASSET_SUBSIDY_LOV_UV

View Text

SELECT SUBB.ID SUBSIDY_ID
, SUBB.NAME SUBSIDY_NAME
, SUBT.SHORT_DESCRIPTION SUBSIDY_DESCRIPTION
, CLEB.ID CLE_ID
FROM OKL_SUBSIDIES_B SUBB
, OKL_SUBSIDIES_TL SUBT
, OKC_K_LINES_B CLEB
, OKC_LINE_STYLES_B LSEB
WHERE SUBT.ID = SUBB.ID
AND SUBT.LANGUAGE = USERENV('LANG')
AND CLEB.LSE_ID = LSEB.ID
AND LSEB.LTY_CODE = 'FREE_FORM1'
AND OKL_ASSET_SUBSIDY_PVT.VALIDATE_SUBSIDY_APPLICABILITY(SUBB.ID
, CLEB.ID) = 'Y'
AND NOT EXISTS (SELECT '1'
FROM OKC_K_LINES_B CLEB_SUB
, OKC_LINE_STYLES_B LSEB_SUB
, OKL_K_LINES KLE_SUB
WHERE KLE_SUB.SUBSIDY_ID = SUBB.ID
AND KLE_SUB.ID = CLEB_SUB.ID
AND CLEB_SUB.LSE_ID = LSEB_SUB.ID
AND LSEB_SUB.LTY_CODE = 'SUBSIDY'
AND CLEB_SUB.CLE_ID = CLEB.ID
AND CLEB_SUB.STS_CODE <> 'ABANDONED')

Columns