[Home] [Help]
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
Name |
SUBSIDY_ID |
SUBSIDY_NAME |
SUBSIDY_DESCRIPTION |
CLE_ID |