[Home] [Help]
View: OKL_STRM_PRC_PARAMS_UV
View Text
SELECT SIF.TRANSACTION_NUMBER TRANSACTION_NUMBER
, SIF.ID SIF_ID
, SIF.KHR_ID KHR_ID
, SPP.NAME PARAMETER_NAME
, SPP.PRC_ENG_IDENT PRICING_NAME
, SPP.PARAMETER_VALUE PARAMETER_VALUE
, SPP.DEFAULT_VALUE DEFAULT_VALUE
FROM OKL_SIF_PRICING_PARAMS SPP
, OKL_STREAM_INTERFACES SIF
WHERE SPP.SIF_ID = SIF.ID ORDER BY SIF.TRANSACTION_NUMBER
, SIF.CREATION_DATE DESC
Columns
| Name |
| TRANSACTION_NUMBER |
| SIF_ID |
| KHR_ID |
| PARAMETER_NAME |
| PRICING_NAME |
| PARAMETER_VALUE |
| DEFAULT_VALUE |