View: AK_ATTRIBUTES_VL

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

View Text

SELECT AA.ROWID ROW_ID
, AA.ATTRIBUTE_APPLICATION_ID
, FAV.APPLICATION_SHORT_NAME
, FAV.APPLICATION_NAME
, AA.ATTRIBUTE_CODE
, AAT.NAME
, AAT.DESCRIPTION
, AAT.ATTRIBUTE_LABEL_LONG
, AAT.ATTRIBUTE_LABEL_SHORT
, AA.ATTRIBUTE_LABEL_LENGTH
, AA.ATTRIBUTE_VALUE_LENGTH
, AA.BOLD
, AA.ITALIC
, AA.HORIZONTAL_ALIGNMENT
, AA.VERTICAL_ALIGNMENT
, AA.DATA_TYPE
, AA.UPPER_CASE_FLAG
, AA.DEFAULT_VALUE_VARCHAR2
, AA.DEFAULT_VALUE_NUMBER
, AA.DEFAULT_VALUE_DATE
, AA.LOV_REGION_CODE
, AA.LOV_REGION_APPLICATION_ID
, ART.NAME LOV_REGION_NAME
, AA.ATTRIBUTE_CATEGORY
, AA.ATTRIBUTE1
, AA.ATTRIBUTE2
, AA.ATTRIBUTE3
, AA.ATTRIBUTE4
, AA.ATTRIBUTE5
, AA.ATTRIBUTE6
, AA.ATTRIBUTE7
, AA.ATTRIBUTE8
, AA.ATTRIBUTE9
, AA.ATTRIBUTE10
, AA.ATTRIBUTE11
, AA.ATTRIBUTE12
, AA.ATTRIBUTE13
, AA.ATTRIBUTE14
, AA.ATTRIBUTE15
, AA.CREATED_BY
, AA.CREATION_DATE
, AA.LAST_UPDATED_BY
, AA.LAST_UPDATE_DATE
, AA.LAST_UPDATE_LOGIN
, AA.ITEM_STYLE
, AA.DISPLAY_HEIGHT
, AA.CSS_CLASS_NAME
, AA.POPLIST_VIEWOBJECT
, AA.POPLIST_DISPLAY_ATTRIBUTE
, AA.POPLIST_VALUE_ATTRIBUTE
, AA.CSS_LABEL_CLASS_NAME
, AA.EXPANSION
, AA.ALS_MAX_LENGTH
, AA.PRECISION
FROM FND_APPLICATION_VL FAV
, AK_REGIONS_TL ART
, AK_ATTRIBUTES_TL AAT
, AK_ATTRIBUTES AA
WHERE AA.ATTRIBUTE_APPLICATION_ID = AAT.ATTRIBUTE_APPLICATION_ID
AND AA.ATTRIBUTE_CODE = AAT.ATTRIBUTE_CODE
AND AAT.LANGUAGE = USERENV('LANG')
AND AA.ATTRIBUTE_APPLICATION_ID = FAV.APPLICATION_ID
AND ART.REGION_CODE(+) = AA.LOV_REGION_CODE
AND ART.REGION_APPLICATION_ID(+) = AA.LOV_REGION_APPLICATION_ID
AND ART.LANGUAGE(+) = USERENV('LANG')

Columns