View: CAC_SR_TEMPLATES_VL

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.CAC_SR_TEMPLATES_VL

View Text

SELECT JSTB.ROWID ROW_ID
, JSTB.TEMPLATE_ID
, JSTB.OBJECT_VERSION_NUMBER
, JSTB.TEMPLATE_TYPE
, JSTB.TEMPLATE_LENGTH_DAYS
, JSTB.START_DATE_ACTIVE
, JSTB.END_DATE_ACTIVE
, JSTB.DELETED_DATE
, JSTTL.TEMPLATE_NAME
, JSTTL.TEMPLATE_DESC
, JSTB.CREATED_BY
, JSTB.CREATION_DATE
, JSTB.LAST_UPDATED_BY
, JSTB.LAST_UPDATE_DATE
, JSTB.LAST_UPDATE_LOGIN
FROM CAC_SR_TEMPLATES_B JSTB
, CAC_SR_TEMPLATES_TL JSTTL
WHERE JSTTL.TEMPLATE_ID = JSTB.TEMPLATE_ID
AND JSTTL.LANGUAGE = USERENV('LANG')