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