View: PO_UDA_AG_TEMPLATES_VL

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.PO_UDA_AG_TEMPLATES_VL

View Text

SELECT B."TEMPLATE_ID"
, B."ENTITY_CODE"
, B.FUNCTIONAL_AREA
, B.DOCUMENT_LEVEL
, B.DOCUMENT_TYPE
, B.DOCUMENT_STYLE_ID
, B.REVISION
, B."EFFECTIVE_FROM"
, B."EFFECTIVE_TO"
, B.DATABASE_VIEW_NAME
, B."LAST_UPDATE_DATE"
, B."LAST_UPDATED_BY"
, B."LAST_UPDATE_LOGIN"
, B."CREATION_DATE"
, B."CREATED_BY"
, T.DISPLAY_NAME
, T.COMMENTS
, B.SRC_TEMPLATE_ID
, B.COMPILED_FLAG
FROM PO_UDA_AG_TEMPLATES B
, PO_UDA_AG_TEMPLATES_TL T
WHERE B.TEMPLATE_ID = T.TEMPLATE_ID
AND T.LANGUAGE = USERENV('LANG')

Columns