Product: | AK - Common Modules-AK |
---|---|
Description: | 10SC ONLY |
Implementation/DBA Data: | APPS.AK_REGIONS_VL |
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')