View: AK_REGION_ITEMS_VL

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

View Text

SELECT ARA.ROWID ROW_ID
, ARA.REGION_APPLICATION_ID
, ARA.REGION_CODE
, ARA.ATTRIBUTE_APPLICATION_ID
, FAT.APPLICATION_NAME ATTRIBUTE_APPLICATION_NAME
, ARA.ATTRIBUTE_CODE
, AAT.NAME ATTRIBUTE_NAME
, AAT.DESCRIPTION ATTRIBUTE_DESCRIPTION
, ARA.DISPLAY_SEQUENCE
, ARA.NODE_DISPLAY_FLAG
, ARA.NODE_QUERY_FLAG
, ARA.ATTRIBUTE_LABEL_LENGTH
, ARA.BOLD
, ARA.ITALIC
, ARA.VERTICAL_ALIGNMENT
, ARA.HORIZONTAL_ALIGNMENT
, ARA.ITEM_STYLE
, ARA.UPDATE_FLAG
, ARA.REQUIRED_FLAG
, ARA.DISPLAY_VALUE_LENGTH
, ARA.SECURITY_CODE
, DECODE(ARA.LOV_FOREIGN_KEY_NAME
, NULL
, 'N'
, 'Y') LOV_PRESENCE_FLAG
, ARA.LOV_REGION_APPLICATION_ID
, ARA.LOV_REGION_CODE
, ARA.LOV_FOREIGN_KEY_NAME
, ARA.LOV_ATTRIBUTE_APPLICATION_ID
, ARA.LOV_ATTRIBUTE_CODE
, ARA.LOV_DEFAULT_FLAG
, ARA.REGION_DEFAULTING_API_PKG
, ARA.REGION_DEFAULTING_API_PROC
, ARA.REGION_VALIDATION_API_PKG
, ARA.REGION_VALIDATION_API_PROC
, ARA.ORDER_SEQUENCE
, ARA.ORDER_DIRECTION
, ART.NAME LOV_REGION_NAME
, AAT1.NAME LOV_ATTRIBUTE_NAME
, ARA.DEFAULT_VALUE_VARCHAR2
, ARA.DEFAULT_VALUE_DATE
, ARA.DEFAULT_VALUE_NUMBER
, ARA.ICX_CUSTOM_CALL
, ARA.ATTRIBUTE_CATEGORY
, ARA.ATTRIBUTE1
, ARA.ATTRIBUTE2
, ARA.ATTRIBUTE3
, ARA.ATTRIBUTE4
, ARA.ATTRIBUTE5
, ARA.ATTRIBUTE6
, ARA.ATTRIBUTE7
, ARA.ATTRIBUTE8
, ARA.ATTRIBUTE9
, ARA.ATTRIBUTE10
, ARA.ATTRIBUTE11
, ARA.ATTRIBUTE12
, ARA.ATTRIBUTE13
, ARA.ATTRIBUTE14
, ARA.ATTRIBUTE15
, ARA.CREATED_BY
, ARA.CREATION_DATE
, ARA.LAST_UPDATED_BY
, ARA.LAST_UPDATE_DATE
, ARA.LAST_UPDATE_LOGIN
, ARAT.ATTRIBUTE_LABEL_LONG
, ARAT.ATTRIBUTE_LABEL_SHORT
, ARA.OBJECT_ATTRIBUTE_FLAG
, AA.DATA_TYPE
, ARA.DISPLAY_HEIGHT
, ARA.SUBMIT
, ARA.ENCRYPT
, ARA.NESTED_REGION_CODE
, ARA.NESTED_REGION_APPLICATION_ID
, ARA.VIEW_USAGE_NAME
, ARA.VIEW_ATTRIBUTE_NAME
, ARA.CSS_CLASS_NAME
, ARA.POPLIST_VIEWOBJECT
, ARA.IMAGE_FILE_NAME
, ARA.URL
, ARA.POPLIST_DISPLAY_ATTRIBUTE
, ARA.POPLIST_VALUE_ATTRIBUTE
, ART2.NAME NESTED_REGION_NAME
, AA.ATTRIBUTE_VALUE_LENGTH
, ARAT.DESCRIPTION
, ARA.ITEM_NAME
, ARA.CSS_LABEL_CLASS_NAME
, ARA.MENU_NAME
, FM.MENU_ID
, ARA.FLEXFIELD_NAME
, ARA.FLEXFIELD_APPLICATION_ID
, FAT2.APPLICATION_SHORT_NAME
, ARA.TABULAR_FUNCTION_CODE
, ARA.TIP_TYPE
, ARA.TIP_MESSAGE_NAME
, ARA.TIP_MESSAGE_APPLICATION_ID
, FAT3.APPLICATION_SHORT_NAME
, ARA.FLEX_SEGMENT_LIST
, ARA.ENTITY_ID
, ARA.ANCHOR
, ARA.POPLIST_VIEW_USAGE_NAME
, ARA.TARGET
, ARA.SORTBY_VIEW_ATTRIBUTE_NAME
, ARA.USER_CUSTOMIZABLE
, ARA.ADMIN_CUSTOMIZABLE
, ARA.INVOKE_FUNCTION_NAME
, ARA.EXPANSION
, ARA.ALS_MAX_LENGTH
, ARA.INITIAL_SORT_SEQUENCE
, ARA.CUSTOMIZATION_APPLICATION_ID
, ARA.CUSTOMIZATION_CODE
FROM AK_ATTRIBUTES_TL AAT
, AK_ATTRIBUTES_TL AAT1
, AK_REGIONS_TL ART
, AK_REGION_ITEMS_TL ARAT
, AK_REGIONS_TL ART2
, AK_REGION_ITEMS ARA
, AK_ATTRIBUTES AA
, FND_APPLICATION_TL FAT
, FND_MENUS FM
, FND_APPLICATION FAT2
, FND_APPLICATION FAT3
WHERE AAT.ATTRIBUTE_APPLICATION_ID = ARA.ATTRIBUTE_APPLICATION_ID
AND AAT.ATTRIBUTE_CODE = ARA.ATTRIBUTE_CODE
AND AAT.LANGUAGE = ARAT.LANGUAGE
AND FAT.APPLICATION_ID = ARA.ATTRIBUTE_APPLICATION_ID
AND AA.ATTRIBUTE_CODE = ARA.ATTRIBUTE_CODE
AND AA.ATTRIBUTE_APPLICATION_ID = ARA.ATTRIBUTE_APPLICATION_ID
AND ARAT.REGION_APPLICATION_ID = ARA.REGION_APPLICATION_ID
AND ARAT.REGION_CODE = ARA.REGION_CODE
AND ARAT.ATTRIBUTE_APPLICATION_ID = ARA.ATTRIBUTE_APPLICATION_ID
AND ARAT.ATTRIBUTE_CODE = ARA.ATTRIBUTE_CODE
AND ARAT.LANGUAGE = USERENV('LANG')
AND ART.REGION_CODE(+) = ARA.LOV_REGION_CODE
AND ART.REGION_APPLICATION_ID(+) = ARA.LOV_REGION_APPLICATION_ID
AND ART.LANGUAGE(+) = USERENV('LANG')
AND AAT1.ATTRIBUTE_CODE(+) = ARA.LOV_ATTRIBUTE_CODE
AND AAT1.ATTRIBUTE_APPLICATION_ID(+) = ARA.LOV_ATTRIBUTE_APPLICATION_ID
AND ART2.REGION_CODE(+)= ARA.NESTED_REGION_CODE
AND ART2.REGION_APPLICATION_ID (+)= ARA.NESTED_REGION_APPLICATION_ID
AND AAT1.LANGUAGE(+) = USERENV('LANG')
AND ART2.LANGUAGE(+) = USERENV('LANG')
AND FAT.LANGUAGE = USERENV('LANG')
AND FM.MENU_NAME(+) = ARA.MENU_NAME
AND FAT2.APPLICATION_ID (+)= ARA.FLEXFIELD_APPLICATION_ID
AND FAT3.APPLICATION_ID(+) = ARA.TIP_MESSAGE_APPLICATION_ID

Columns