VIEW: APPS.AK_REGION_ITEMS_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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