View: PQH_TEMPLATES_VL

Product:	PQH - Public Sector HR
Description:	Templates View
Implementation/DBA Data:	APPS.PQH_TEMPLATES_VL

View Text

SELECT TEM.ROWID ROW_ID
, TEM.SHORT_NAME
, TEM.TEMPLATE_ID
, TEM.ATTRIBUTE_ONLY_FLAG
, TEM.ENABLE_FLAG
, TEM.CREATE_FLAG
, TEM.TRANSACTION_CATEGORY_ID
, TEM.UNDER_REVIEW_FLAG
, TEM.OBJECT_VERSION_NUMBER
, TEM.LAST_UPDATE_DATE
, TEM.LAST_UPDATED_BY
, TEM.LAST_UPDATE_LOGIN
, TEM.CREATED_BY
, TEM.CREATION_DATE
, TEM.FREEZE_STATUS_CD
, TEM.TEMPLATE_TYPE_CD
, TEM.LEGISLATION_CODE
, TTL.TEMPLATE_NAME
FROM PQH_TEMPLATES_TL TTL
, PQH_TEMPLATES TEM
WHERE TEM.TEMPLATE_ID = TTL.TEMPLATE_ID
AND TTL.LANGUAGE = USERENV('LANG')

Columns