DBA Data[Home] [Help]

VIEW: APPS.FND_DOCUMENT_DATATYPES_VL

Source

View Text - Preformatted

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
View Text - HTML Formatted

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