VIEW: APPS.OKL_ASSET_SUBSIDY_UV

Source

View Text - Preformatted

SELECT kle.subsidy_id subsidy_id, cleb.id subsidy_cle_id, subb.name name, subt.short_description description, kle.amount amount, to_char(kle.subsidy_override_amount) subsidy_overide_amount, cleb.dnz_chr_id dnz_chr_id, cleb.cle_id asset_cle_id, cplb.id cpl_id, okxv.id1 vendor_id, okxv.name vendor_name FROM OKX_VENDORS_V OKXV,OKC_K_PARTY_ROLES_B CPLB,OKL_SUBSIDIES_ALL_B SUBB,OKL_SUBSIDIES_TL SUBT,OKL_K_LINES KLE,OKC_LINE_STYLES_B LSEB,OKC_K_LINES_B CLEB WHERE okxv.id1(+) = cplb.object1_id1 And okxv.id2(+) = cplb.object1_id2 And cplb.jtot_object1_code(+) = 'OKX_VENDOR' And cplb.dnz_chr_id(+) = cleb.dnz_chr_id And cplb.cle_id(+) = cleb.id And cplb.rle_code(+) = 'OKL_VENDOR' And subt.id = subb.id And subt.language = userenv('LANG') And subb.id = kle.subsidy_id And kle.id = cleb.id And lseb.id = cleb.lse_id And lseb.lty_code = 'SUBSIDY' And cleb.sts_code <> 'ABANDONED'

View Text - HTML Formatted

SELECT KLE.SUBSIDY_ID SUBSIDY_ID
, CLEB.ID SUBSIDY_CLE_ID
, SUBB.NAME NAME
, SUBT.SHORT_DESCRIPTION DESCRIPTION
, KLE.AMOUNT AMOUNT
, TO_CHAR(KLE.SUBSIDY_OVERRIDE_AMOUNT) SUBSIDY_OVERIDE_AMOUNT
, CLEB.DNZ_CHR_ID DNZ_CHR_ID
, CLEB.CLE_ID ASSET_CLE_ID
, CPLB.ID CPL_ID
, OKXV.ID1 VENDOR_ID
, OKXV.NAME VENDOR_NAME
FROM OKX_VENDORS_V OKXV
, OKC_K_PARTY_ROLES_B CPLB
, OKL_SUBSIDIES_ALL_B SUBB
, OKL_SUBSIDIES_TL SUBT
, OKL_K_LINES KLE
, OKC_LINE_STYLES_B LSEB
, OKC_K_LINES_B CLEB
WHERE OKXV.ID1(+) = CPLB.OBJECT1_ID1
AND OKXV.ID2(+) = CPLB.OBJECT1_ID2
AND CPLB.JTOT_OBJECT1_CODE(+) = 'OKX_VENDOR'
AND CPLB.DNZ_CHR_ID(+) = CLEB.DNZ_CHR_ID
AND CPLB.CLE_ID(+) = CLEB.ID
AND CPLB.RLE_CODE(+) = 'OKL_VENDOR'
AND SUBT.ID = SUBB.ID
AND SUBT.LANGUAGE = USERENV('LANG')
AND SUBB.ID = KLE.SUBSIDY_ID
AND KLE.ID = CLEB.ID
AND LSEB.ID = CLEB.LSE_ID
AND LSEB.LTY_CODE = 'SUBSIDY'
AND CLEB.STS_CODE <> 'ABANDONED'