View: AK_OBJECT_ATTRIBUTES_VL

Product:	AK - Common Modules-AK
Description:	10SC ONLY
Implementation/DBA Data:	APPS.AK_OBJECT_ATTRIBUTES_VL

View Text

SELECT AOA.ROWID ROW_ID
, AOA.DATABASE_OBJECT_NAME
, AOT.NAME OBJECT_NAME
, AOT.DESCRIPTION OBJECT_DESCRIPTION
, AOA.ATTRIBUTE_APPLICATION_ID
, FAV.APPLICATION_SHORT_NAME
, FAV.APPLICATION_NAME
, AOA.ATTRIBUTE_CODE
, AAT.NAME
, AA.DATA_TYPE
, ART1.NAME LOV_REGION_NAME
, AAT1.NAME LOV_ATTRIBUTE_NAME
, AOA.COLUMN_NAME
, AOAT.ATTRIBUTE_LABEL_LONG
, AOAT.ATTRIBUTE_LABEL_SHORT
, AOA.ATTRIBUTE_LABEL_LENGTH
, AOA.BOLD
, AOA.ITALIC
, AOA.HORIZONTAL_ALIGNMENT
, AOA.VERTICAL_ALIGNMENT
, AOA.DATA_SOURCE_TYPE
, AOA.DATA_STORAGE_TYPE
, AOA.TABLE_NAME
, AOA.BASE_TABLE_COLUMN_NAME
, AOA.REQUIRED_FLAG
, AOA.DISPLAY_VALUE_LENGTH
, AOA.LOV_REGION_APPLICATION_ID
, AOA.LOV_REGION_CODE
, AOA.LOV_FOREIGN_KEY_NAME
, AOA.LOV_ATTRIBUTE_APPLICATION_ID
, AOA.LOV_ATTRIBUTE_CODE
, AOA.DEFAULTING_API_PKG
, AOA.DEFAULTING_API_PROC
, AOA.VALIDATION_API_PKG
, AOA.VALIDATION_API_PROC
, AOA.DEFAULT_VALUE_VARCHAR2
, AOA.DEFAULT_VALUE_NUMBER
, AOA.DEFAULT_VALUE_DATE
, AOA.TRANSLATION_FLAG
, AOA.ATTRIBUTE_CATEGORY
, AOA.ATTRIBUTE1
, AOA.ATTRIBUTE2
, AOA.ATTRIBUTE3
, AOA.ATTRIBUTE4
, AOA.ATTRIBUTE5
, AOA.ATTRIBUTE6
, AOA.ATTRIBUTE7
, AOA.ATTRIBUTE8
, AOA.ATTRIBUTE9
, AOA.ATTRIBUTE10
, AOA.ATTRIBUTE11
, AOA.ATTRIBUTE12
, AOA.ATTRIBUTE13
, AOA.ATTRIBUTE14
, AOA.ATTRIBUTE15
, AOA.CREATED_BY
, AOA.CREATION_DATE
, AOA.LAST_UPDATED_BY
, AOA.LAST_UPDATE_DATE
, AOA.LAST_UPDATE_LOGIN
FROM FND_APPLICATION_VL FAV
, AK_OBJECTS_TL AOT
, AK_REGIONS_TL ART1
, AK_OBJECT_ATTRIBUTES_TL AOAT
, AK_OBJECT_ATTRIBUTES AOA
, AK_ATTRIBUTES_TL AAT
, AK_ATTRIBUTES AA
, AK_ATTRIBUTES_TL AAT1
WHERE AOA.DATABASE_OBJECT_NAME = AOT.DATABASE_OBJECT_NAME
AND AOT.LANGUAGE = USERENV('LANG')
AND AAT.ATTRIBUTE_CODE = AOA.ATTRIBUTE_CODE
AND AAT.ATTRIBUTE_APPLICATION_ID = AOA.ATTRIBUTE_APPLICATION_ID
AND AAT.LANGUAGE = USERENV('LANG')
AND AA.ATTRIBUTE_CODE = AOA.ATTRIBUTE_CODE
AND AA.ATTRIBUTE_APPLICATION_ID = AOA.ATTRIBUTE_APPLICATION_ID
AND ART1.REGION_CODE(+) = AOA.LOV_REGION_CODE
AND ART1.REGION_APPLICATION_ID(+) = AOA.LOV_REGION_APPLICATION_ID
AND ART1.LANGUAGE(+) = USERENV('LANG')
AND AAT1.ATTRIBUTE_CODE(+) = AOA.LOV_ATTRIBUTE_CODE
AND AAT1.ATTRIBUTE_APPLICATION_ID(+) = AOA.LOV_ATTRIBUTE_APPLICATION_ID
AND AAT1.LANGUAGE(+) = USERENV('LANG')
AND AOA.ATTRIBUTE_APPLICATION_ID = FAV.APPLICATION_ID
AND AOAT.DATABASE_OBJECT_NAME = AOA.DATABASE_OBJECT_NAME
AND AOAT.ATTRIBUTE_APPLICATION_ID = AOA.ATTRIBUTE_APPLICATION_ID
AND AOAT.ATTRIBUTE_CODE = AOA.ATTRIBUTE_CODE
AND AOAT.LANGUAGE = USERENV('LANG')

Columns