VIEW: APPS.AK_OBJECTS_VL

Source

View Text - Preformatted

SELECT AO.ROWID ROW_ID , AO.DATABASE_OBJECT_NAME , T.NAME , T.DESCRIPTION , FAV.APPLICATION_NAME , FAV.APPLICATION_SHORT_NAME , AO.APPLICATION_ID , AO.PRIMARY_KEY_NAME , AO.DEFAULTING_API_PKG , AO.DEFAULTING_API_PROC , AO.VALIDATION_API_PKG , AO.VALIDATION_API_PROC , AO.ATTRIBUTE_CATEGORY , AO.ATTRIBUTE1 , AO.ATTRIBUTE2 , AO.ATTRIBUTE3 , AO.ATTRIBUTE4 , AO.ATTRIBUTE5 , AO.ATTRIBUTE6 , AO.ATTRIBUTE7 , AO.ATTRIBUTE8 , AO.ATTRIBUTE9 , AO.ATTRIBUTE10 , AO.ATTRIBUTE11 , AO.ATTRIBUTE12 , AO.ATTRIBUTE13 , AO.ATTRIBUTE14 , AO.ATTRIBUTE15 , AO.CREATED_BY , AO.CREATION_DATE , AO.LAST_UPDATED_BY , AO.LAST_UPDATE_DATE , AO.LAST_UPDATE_LOGIN FROM FND_APPLICATION_VL FAV, AK_OBJECTS AO, AK_OBJECTS_TL T WHERE FAV.APPLICATION_ID = AO.APPLICATION_ID AND AO.DATABASE_OBJECT_NAME = T.DATABASE_OBJECT_NAME AND T.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT AO.ROWID ROW_ID
, AO.DATABASE_OBJECT_NAME
, T.NAME
, T.DESCRIPTION
, FAV.APPLICATION_NAME
, FAV.APPLICATION_SHORT_NAME
, AO.APPLICATION_ID
, AO.PRIMARY_KEY_NAME
, AO.DEFAULTING_API_PKG
, AO.DEFAULTING_API_PROC
, AO.VALIDATION_API_PKG
, AO.VALIDATION_API_PROC
, AO.ATTRIBUTE_CATEGORY
, AO.ATTRIBUTE1
, AO.ATTRIBUTE2
, AO.ATTRIBUTE3
, AO.ATTRIBUTE4
, AO.ATTRIBUTE5
, AO.ATTRIBUTE6
, AO.ATTRIBUTE7
, AO.ATTRIBUTE8
, AO.ATTRIBUTE9
, AO.ATTRIBUTE10
, AO.ATTRIBUTE11
, AO.ATTRIBUTE12
, AO.ATTRIBUTE13
, AO.ATTRIBUTE14
, AO.ATTRIBUTE15
, AO.CREATED_BY
, AO.CREATION_DATE
, AO.LAST_UPDATED_BY
, AO.LAST_UPDATE_DATE
, AO.LAST_UPDATE_LOGIN
FROM FND_APPLICATION_VL FAV
, AK_OBJECTS AO
, AK_OBJECTS_TL T
WHERE FAV.APPLICATION_ID = AO.APPLICATION_ID
AND AO.DATABASE_OBJECT_NAME = T.DATABASE_OBJECT_NAME
AND T.LANGUAGE = USERENV('LANG')