View: FND_DOCUMENT_DATATYPES_VL

Product:	FND - Application Object Library
Description:	View of FND_DOCUMENT_DATATYPES for translation purposes
Implementation/DBA Data:	APPS.FND_DOCUMENT_DATATYPES_VL

View Text

SELECT DATATYPE_ID
, NAME
, USER_NAME
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM FND_DOCUMENT_DATATYPES
WHERE LANGUAGE = USERENV('LANG')
AND NVL(START_DATE_ACTIVE
, SYSDATE-1) <= SYSDATE
AND NVL(END_DATE_ACTIVE
, SYSDATE+1) > SYSDATE

Columns