[Home] [Help]
View: OKL_ASSET_SUBSIDY_UV
Product: | OKL - Lease and Finance Management |
Description: | User interface view for asset subsidies page |
Implementation/DBA Data: |
APPS.OKL_ASSET_SUBSIDY_UV
|
View Text
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'
Columns
Name |
SUBSIDY_ID |
SUBSIDY_CLE_ID |
NAME |
DESCRIPTION |
AMOUNT |
SUBSIDY_OVERRIDE_AMOUNT |
DNZ_CHR_ID |
ASSET_CLE_ID |
CPL_ID |
VENDOR_ID |
VENDOR_NAME |