VIEW: APPS.FND_DOC_CATEGORY_USAGES_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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