VIEW: APPS.JTM_AK_REGIONS_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID, AR.REGION_APPLICATION_ID, AR.REGION_CODE, AR.DATABASE_OBJECT_NAME, 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, ART.LANGUAGE, ART.SOURCE_LANG FROM AK_REGIONS_TL ART ,AK_REGIONS AR, JTM_AK_REGIONS_ACC ACC WHERE AR.REGION_APPLICATION_ID = ART.REGION_APPLICATION_ID AND AR.REGION_CODE = ART.REGION_CODE AND ART.LANGUAGE = ASG_BASE.GET_LANGUAGE AND AR.REGION_APPLICATION_ID = ACC.REGION_APPLICATION_ID AND AR.REGION_CODE = ACC.REGION_CODE

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, AR.REGION_APPLICATION_ID
, AR.REGION_CODE
, AR.DATABASE_OBJECT_NAME
, 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
, ART.LANGUAGE
, ART.SOURCE_LANG
FROM AK_REGIONS_TL ART
, AK_REGIONS AR
, JTM_AK_REGIONS_ACC ACC
WHERE AR.REGION_APPLICATION_ID = ART.REGION_APPLICATION_ID
AND AR.REGION_CODE = ART.REGION_CODE
AND ART.LANGUAGE = ASG_BASE.GET_LANGUAGE
AND AR.REGION_APPLICATION_ID = ACC.REGION_APPLICATION_ID
AND AR.REGION_CODE = ACC.REGION_CODE