VIEW: APPS.OKL_ASSET_SUBSIDY_LOV_UV

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')