View: OKL_STRM_TMPT_PRC_PARAMS_UV

Product:	OKL - Lease and Finance Management
Description:	View that holds the stream template procing parameters for a contract
Implementation/DBA Data:	APPS.OKL_STRM_TMPT_PRC_PARAMS_UV

View Text

SELECT GTPV.ID ID
, GTPV.NAME NAME
, GTPV.DESCRIPTION PARAMETER_DESC
, GTPV.DISPLAY_YN DISPLAY_YN
, GTPV.UPDATE_YN UPDATE_YN
, GTPV.PRC_ENG_IDENT PRC_ENG_IDENT
, '' VALUE
, GTPV.DEFAULT_VALUE DEFAULT_VALUE
, GTTV.ID GTT_ID
, GTTV.VERSION VERSION
, GTTV.START_DATE START_DATE
, GTTV.END_DATE END_DATE
, GTTV.TMPT_STATUS TMPT_STATUS
, GTSV.ID GTS_ID
, GTSV.NAME ST_GEN_TMPT_SET_NAME
, GTSV.DESCRIPTION DESCRIPTION
, GTSV.PRODUCT_TYPE PRODUCT_TYPE
, GTSV.TAX_OWNER TAX_OWNER
, GTSV.DEAL_TYPE DEAL_TYPE
, GTSV.PRICING_ENGINE PRICING_ENGINE
, AES.ID AES_ID
, AES.NAME AE_TMPT_SET_NAME
, PDT.ID PDT_ID
, PDT.NAME PRODUCT_NAME
, KHR.ID KHR_ID
FROM OKL_ST_GEN_PRC_PRMS_ALL GTPV
, OKL_ST_GEN_TEMPLATES_ALL GTTV
, OKL_ST_GEN_TMPT_SETS_ALL GTSV
, OKL_AE_TMPT_SETS_ALL AES
, OKL_PRODUCTS_V PDT
, OKL_K_HEADERS KHR
, OKC_K_HEADERS_ALL_B CHR
WHERE GTPV.GTT_ID = GTTV.ID
AND GTTV.GTS_ID = GTSV.ID
AND GTTV.TMPT_STATUS = 'ACTIVE'
AND GTSV.ID = AES.GTS_ID
AND AES.ID = PDT.AES_ID
AND PDT.ID = KHR.PDT_ID
AND KHR.ID = CHR.ID
AND CHR.START_DATE BETWEEN GTTV.START_DATE
AND NVL(GTTV.END_DATE
, CHR.START_DATE+1)

Columns