VIEW: APPS.AK_REGIONS_VL

Source

View Text - Preformatted

SELECT AR.ROWID ROW_ID , AR.REGION_APPLICATION_ID , FAV.APPLICATION_SHORT_NAME , FAV.APPLICATION_NAME , AR.REGION_CODE , AR.DATABASE_OBJECT_NAME , AOT.NAME OBJECT_NAME , AOT.DESCRIPTION OBJECT_DESCRIPTION , AR.REGION_STYLE , AR.NUM_COLUMNS , AR.ICX_CUSTOM_CALL , ART.NAME , ART.DESCRIPTION , AR.REGION_DEFAULTING_API_PKG , AR.REGION_DEFAULTING_API_PROC , AR.REGION_VALIDATION_API_PKG , AR.REGION_VALIDATION_API_PROC , AR.ATTRIBUTE_CATEGORY , AR.ATTRIBUTE1 , AR.ATTRIBUTE2 , AR.ATTRIBUTE3 , AR.ATTRIBUTE4 , AR.ATTRIBUTE5 , AR.ATTRIBUTE6 , AR.ATTRIBUTE7 , AR.ATTRIBUTE8 , AR.ATTRIBUTE9 , AR.ATTRIBUTE10 , AR.ATTRIBUTE11 , AR.ATTRIBUTE12 , AR.ATTRIBUTE13 , AR.ATTRIBUTE14 , AR.ATTRIBUTE15 , AR.CREATED_BY , AR.CREATION_DATE , AR.LAST_UPDATED_BY , AR.LAST_UPDATE_DATE , AR.LAST_UPDATE_LOGIN , AR.APPLICATIONMODULE_OBJECT_TYPE , AR.NUM_ROWS_DISPLAY , AR.REGION_OBJECT_TYPE , AR.IMAGE_FILE_NAME , AR.ISFORM_FLAG , AR.HELP_TARGET , AR.STYLE_SHEET_FILENAME , AR.VERSION , AR.APPLICATIONMODULE_USAGE_NAME , AR.ADD_INDEXED_CHILDREN , AR.STATEFUL_FLAG , AR.FUNCTION_NAME , AR.CHILDREN_VIEW_USAGE_NAME , AR.SEARCH_PANEL , AR.ADVANCED_SEARCH_PANEL , AR.CUSTOMIZE_PANEL , AR.DEFAULT_SEARCH_PANEL , AR.RESULTS_BASED_SEARCH , AR.DISPLAY_GRAPH_TABLE , AR.PREF_REGION_APPLICATION_ID , AR.PREF_REGION_CODE , AR.DISABLE_HEADER , AR.STANDALONE , AR.AUTO_CUSTOMIZATION_CRITERIA FROM FND_APPLICATION_VL FAV, AK_OBJECTS_TL AOT, AK_REGIONS_TL ART, AK_REGIONS AR WHERE FAV.APPLICATION_ID = AR.REGION_APPLICATION_ID AND AOT.DATABASE_OBJECT_NAME = AR.DATABASE_OBJECT_NAME AND AOT.LANGUAGE = USERENV('LANG') AND AR.REGION_APPLICATION_ID = ART.REGION_APPLICATION_ID AND AR.REGION_CODE = ART.REGION_CODE AND ART.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT AR.ROWID ROW_ID
, AR.REGION_APPLICATION_ID
, FAV.APPLICATION_SHORT_NAME
, FAV.APPLICATION_NAME
, AR.REGION_CODE
, AR.DATABASE_OBJECT_NAME
, AOT.NAME OBJECT_NAME
, AOT.DESCRIPTION OBJECT_DESCRIPTION
, AR.REGION_STYLE
, AR.NUM_COLUMNS
, AR.ICX_CUSTOM_CALL
, ART.NAME
, ART.DESCRIPTION
, AR.REGION_DEFAULTING_API_PKG
, AR.REGION_DEFAULTING_API_PROC
, AR.REGION_VALIDATION_API_PKG
, AR.REGION_VALIDATION_API_PROC
, AR.ATTRIBUTE_CATEGORY
, AR.ATTRIBUTE1
, AR.ATTRIBUTE2
, AR.ATTRIBUTE3
, AR.ATTRIBUTE4
, AR.ATTRIBUTE5
, AR.ATTRIBUTE6
, AR.ATTRIBUTE7
, AR.ATTRIBUTE8
, AR.ATTRIBUTE9
, AR.ATTRIBUTE10
, AR.ATTRIBUTE11
, AR.ATTRIBUTE12
, AR.ATTRIBUTE13
, AR.ATTRIBUTE14
, AR.ATTRIBUTE15
, AR.CREATED_BY
, AR.CREATION_DATE
, AR.LAST_UPDATED_BY
, AR.LAST_UPDATE_DATE
, AR.LAST_UPDATE_LOGIN
, AR.APPLICATIONMODULE_OBJECT_TYPE
, AR.NUM_ROWS_DISPLAY
, AR.REGION_OBJECT_TYPE
, AR.IMAGE_FILE_NAME
, AR.ISFORM_FLAG
, AR.HELP_TARGET
, AR.STYLE_SHEET_FILENAME
, AR.VERSION
, AR.APPLICATIONMODULE_USAGE_NAME
, AR.ADD_INDEXED_CHILDREN
, AR.STATEFUL_FLAG
, AR.FUNCTION_NAME
, AR.CHILDREN_VIEW_USAGE_NAME
, AR.SEARCH_PANEL
, AR.ADVANCED_SEARCH_PANEL
, AR.CUSTOMIZE_PANEL
, AR.DEFAULT_SEARCH_PANEL
, AR.RESULTS_BASED_SEARCH
, AR.DISPLAY_GRAPH_TABLE
, AR.PREF_REGION_APPLICATION_ID
, AR.PREF_REGION_CODE
, AR.DISABLE_HEADER
, AR.STANDALONE
, AR.AUTO_CUSTOMIZATION_CRITERIA
FROM FND_APPLICATION_VL FAV
, AK_OBJECTS_TL AOT
, AK_REGIONS_TL ART
, AK_REGIONS AR
WHERE FAV.APPLICATION_ID = AR.REGION_APPLICATION_ID
AND AOT.DATABASE_OBJECT_NAME = AR.DATABASE_OBJECT_NAME
AND AOT.LANGUAGE = USERENV('LANG')
AND AR.REGION_APPLICATION_ID = ART.REGION_APPLICATION_ID
AND AR.REGION_CODE = ART.REGION_CODE
AND ART.LANGUAGE = USERENV('LANG')