View: OKL_CS_SCHACCR_AMOUNT_UV

Product:	OKL - Lease and Finance Management
Description:	View to display the amounts for Subsidies and Discounts
Implementation/DBA Data:	APPS.OKL_CS_SCHACCR_AMOUNT_UV

View Text

SELECT STRM.KLE_ID KLE_ID
, STR_ELM.AMOUNT AMOUNT
, STR_ELM.STREAM_ELEMENT_DATE STREAM_ELEMENT_DATE
FROM OKL_STRM_TYPE_B STR_TYPE
, OKL_STREAMS STRM
, OKL_STRM_TYPE_B ACCR_STY
, OKL_SGN_TRANSLATIONS STN
, OKL_STRM_TYPE_B SUB_STY
, OKL_STRM_ELEMENTS STR_ELM
WHERE STR_TYPE.ID = TO_NUMBER(STN.VALUE)
AND STN.JTOT_OBJECT1_CODE = 'OKL_STRMTYP'
AND STN.OBJECT1_ID1 = SUB_STY.ID
AND SUB_STY.STREAM_TYPE_PURPOSE ='SUBSIDY'
AND STR_TYPE.CODE = ACCR_STY.CODE
AND STR_TYPE.ID = STRM.STY_ID
AND STR_ELM.STM_ID = STRM.ID
AND STRM.SAY_CODE = 'CURR'
AND STRM.ACTIVE_YN ='Y'
AND STRM. PURPOSE_CODE IS NULL

Columns