[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 |