View: OKL_LA_PT_EVG_STRM_TYPE_UV

Product:	OKL - Lease and Finance Management
Description:	This view is for evergreen stream type LOV in pass through fee line details page. It will display all the evergreen stream types with stream type purpose of "PASS_THROUGH_EVERGREEN_FEE" with primary stream type as "PASS_THROUGH_FEE".
Implementation/DBA Data:	APPS.OKL_LA_PT_EVG_STRM_TYPE_UV

View Text

SELECT DISTINCT STMPT.STY_ID STY_ID
, STMPT.STY_NAME STY_NAME
, STMPT.STY_PURPOSE STY_PURPOSE
, STMPT.START_DATE START_DATE
, STMPT.END_DATE END_DATE
, STMPT.DESCRIPTION DESCRIPTION
, STMPT.PDT_ID PDT_ID
, STMPT.BILLABLE_YN
, STMPT.PRIMARY_YN
, NULL PRIMARY_STY_ID
FROM OKL_STRM_TMPT_FULL_UV STMPT
WHERE BILLABLE_YN = 'Y'
AND PRIMARY_YN = 'N'
AND EXISTS ( SELECT 1
FROM OKL_STRM_TYPE_V STL
WHERE STL.ID = STMPT.PRIMARY_STY_ID )

Columns