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_TMPT_PRC_PARAMS_UV

Source

View Text - Preformatted


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)

View Text - HTML Formatted

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)