FND Design Data [Home] [Help]

View: OKL_PRC_TMPLS_UV

Product: OKL - Lease and Finance Management
Description:
Implementation/DBA Data: ViewAPPS.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