VIEW: APPS.JTM_AK_REGION_ITEMS_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID, ARA.REGION_APPLICATION_ID, ARA.REGION_CODE, ARA.ATTRIBUTE_APPLICATION_ID, ARA.ATTRIBUTE_CODE, 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, 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, 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, ARAT.DESCRIPTION, ARA.ITEM_NAME, ARA.CSS_LABEL_CLASS_NAME, ARA.MENU_NAME, ARA.FLEXFIELD_NAME, ARA.FLEXFIELD_APPLICATION_ID, ARA.TABULAR_FUNCTION_CODE, ARA.TIP_TYPE, ARA.TIP_MESSAGE_NAME, ARA.TIP_MESSAGE_APPLICATION_ID, 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, ARAT.language, ARAT.source_lang FROM AK_REGION_ITEMS_TL ARAT, AK_REGION_ITEMS ARA, JTM_AK_REGION_ITEMS_ACC ACC WHERE 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 = asg_base.get_language AND ARA.region_application_id = ACC.REGION_APPLICATION_ID AND ARA.REGION_CODE = ACC.REGION_CODE AND ARA.ATTRIBUTE_APPLICATION_ID = ACC.ATTRIBUTE_APPLICATION_ID AND ARA.ATTRIBUTE_CODE = ACC.ATTRIBUTE_CODE

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, ARA.REGION_APPLICATION_ID
, ARA.REGION_CODE
, ARA.ATTRIBUTE_APPLICATION_ID
, ARA.ATTRIBUTE_CODE
, 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
, 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
, 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
, ARAT.DESCRIPTION
, ARA.ITEM_NAME
, ARA.CSS_LABEL_CLASS_NAME
, ARA.MENU_NAME
, ARA.FLEXFIELD_NAME
, ARA.FLEXFIELD_APPLICATION_ID
, ARA.TABULAR_FUNCTION_CODE
, ARA.TIP_TYPE
, ARA.TIP_MESSAGE_NAME
, ARA.TIP_MESSAGE_APPLICATION_ID
, 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
, ARAT.LANGUAGE
, ARAT.SOURCE_LANG
FROM AK_REGION_ITEMS_TL ARAT
, AK_REGION_ITEMS ARA
, JTM_AK_REGION_ITEMS_ACC ACC
WHERE 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 = ASG_BASE.GET_LANGUAGE
AND ARA.REGION_APPLICATION_ID = ACC.REGION_APPLICATION_ID
AND ARA.REGION_CODE = ACC.REGION_CODE
AND ARA.ATTRIBUTE_APPLICATION_ID = ACC.ATTRIBUTE_APPLICATION_ID
AND ARA.ATTRIBUTE_CODE = ACC.ATTRIBUTE_CODE