View: FND_DOC_CATEGORY_USAGES_VL

Product:	FND - Application Object Library
Description:	Determines category language used to view assignments
Implementation/DBA Data:	APPS.FND_DOC_CATEGORY_USAGES_VL

View Text

SELECT FDCU.ROWID
, FDCU.DOC_CATEGORY_USAGE_ID
, FDCU.CATEGORY_ID
, FDCU.ATTACHMENT_FUNCTION_ID
, FAF.FUNCTION_NAME
, FAF.FUNCTION_TYPE
, FND_ATTACHMENT_UTIL_PKG.GET_USER_FUNCTION_NAME (FAF.FUNCTION_TYPE
, FAF.APPLICATION_ID
, FAF.FUNCTION_NAME)
, FDCU.ENABLED_FLAG
, FDCU.CREATION_DATE
, FDCU.CREATED_BY
, FDCU.LAST_UPDATE_DATE
, FDCU.LAST_UPDATED_BY
, FDCU.LAST_UPDATE_LOGIN
, FDC.NAME
, TL.USER_NAME
, FDC.START_DATE_ACTIVE
, FDC.END_DATE_ACTIVE
, FDCU.FORMAT
FROM FND_ATTACHMENT_FUNCTIONS FAF
, FND_DOCUMENT_CATEGORIES_TL TL
, FND_DOCUMENT_CATEGORIES FDC
, FND_DOC_CATEGORY_USAGES FDCU
WHERE FDCU.CATEGORY_ID = FDC.CATEGORY_ID
AND FDC.CATEGORY_ID = TL.CATEGORY_ID
AND TL.LANGUAGE = USERENV('LANG')
AND FAF.ATTACHMENT_FUNCTION_ID = FDCU.ATTACHMENT_FUNCTION_ID

Columns