eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_STRM_PRC_PARAMS_UV

Source

View Text - Preformatted


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

View Text - HTML Formatted

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