[Home] [Help]
View: OKL_PRC_TMPLS_UV
View Text
SELECT TEMPLATE.ID ID
, TEMPLATE.TEMPLATE_NAME TEMPLATE_NAME
, TEMPLATE.VERSION VERSION
, TEMPLATE.START_DATE START_DATE
, TEMPLATE.END_DATE END_DATE
, PRODUCT.NAME PRODUCT_NAME
FROM OKL_PRODUCTS PRODUCT
, OKL_PRD_PRICE_TMPLS TEMPLATE
WHERE TEMPLATE.PDT_ID = PRODUCT.ID
Columns
Name |
ID |
TEMPLATE_NAME |
VERSION |
START_DATE |
END_DATE |
PRODUCT_NAME |