eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: AK.AK_REGIONS

Object Details

Object Name:	AK_REGIONS
Object Type:	TABLE
Owner:	AK
FND Design Data:	AK.AK_REGIONS
Subobject Name:
Status:	VALID

AK_REGIONS contains regions and the application owner of the
region. A region contains a set of items that may be returned by
AK_QUERY_PKG. You need to one row for each region.
Each row must include a database object name and a region style. You
can also specify the number of columns that are to be displayed on the
region as well as an URL for the region.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AK_REGIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REGION_CODE REGION_APPLICATION_ID ZD_EDITION_NAME
AK_REGIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REGION_APPLICATION_ID
AK_REGIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DATABASE_OBJECT_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
REGION_CODE	VARCHAR2	(30)	Yes	Region identifier
REGION_APPLICATION_ID	NUMBER	(15)	Yes	Product team's application id which the region belong to
DATABASE_OBJECT_NAME	VARCHAR2	(30)	Yes	Database object identifier
REGION_STYLE	VARCHAR2	(30)	Yes	Region style of the region to be displayed
NUM_COLUMNS	NUMBER	(15)		Number of columns of region to be displayed
REGION_DEFAULTING_API_PKG	VARCHAR2	(30)		PL/SQL package name which contains the stored procedure to populate default values of regions
REGION_DEFAULTING_API_PROC	VARCHAR2	(30)		Procedure name in PL/SQL package which populates default values of regions
REGION_VALIDATION_API_PKG	VARCHAR2	(30)		PL/SQL package name which contains the procedure to validate default values of regions
REGION_VALIDATION_API_PROC	VARCHAR2	(30)		Procedure name in PL/SQL package which contains the procedure to validate default values of regions
ICX_CUSTOM_CALL	VARCHAR2	(80)		A URL to launch an html file
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column
APPLICATIONMODULE_OBJECT_TYPE	VARCHAR2	(240)		The application module that has been created for the view objects that are utilized in this region.
NUM_ROWS_DISPLAY	NUMBER			If this region is a table region style then the display rows attribute determines how many rows to show in that region.
REGION_OBJECT_TYPE	VARCHAR2	(240)		Type of HTML User Interface component that will be used to organize this data into a logical unit.
IMAGE_FILE_NAME	VARCHAR2	(80)		column for putting icon file name when displaying region title
ISFORM_FLAG	VARCHAR2	(1)	Yes	column to indicate whether this region is a form
HELP_TARGET	VARCHAR2	(240)		stores location of product team's specific help file
STYLE_SHEET_FILENAME	VARCHAR2	(240)		file name of style sheet that applies to the region
VERSION	VARCHAR2	(30)		OAFramework version number
APPLICATIONMODULE_USAGE_NAME	VARCHAR2	(80)		Application Module Usage name
ADD_INDEXED_CHILDREN	VARCHAR2	(1)		Flag to indicate whether the region items of the region would be added as indexed children by OAFramework
STATEFUL_FLAG	VARCHAR2	(1)		Flag which indicates whether a page is stateful or stateless
FUNCTION_NAME	VARCHAR2	(30)		Assign region to a function
CHILDREN_VIEW_USAGE_NAME	VARCHAR2	(80)		binds the children of any container to a view object
SEARCH_PANEL	VARCHAR2	(1)		Applicable for region style Query only: Indicates if the query region has a simple search panel or not.
ADVANCED_SEARCH_PANEL	VARCHAR2	(1)		Applicable for region style Query only: Indicates if the query region has an advanced search panel or not.
CUSTOMIZE_PANEL	VARCHAR2	(1)		Applicable for region style Query only: Indicates if the query region has a customize panel or not.
DEFAULT_SEARCH_PANEL	VARCHAR2	(30)		Applicable for region style Query only: Indicates which panel should be used as default when rendering the query region. Possible choices are: Search Panel, Advanced Search Panel, Customize Panel.
RESULTS_BASED_SEARCH	VARCHAR2	(1)		Applicable for region style Query only; Indicates that the query bean needs to build the search panels based on the results region's queryable attributes.
DISPLAY_GRAPH_TABLE	VARCHAR2	(1)		graph table is displayed when this column = Y, only possible when region_style = 'GRAPH_DATA'
PREF_REGION_APPLICATION_ID	NUMBER	(15)		Region Application Id for pointing to Preference region. This is valid only when region style = 'PAGE LAYOUT'
PREF_REGION_CODE	VARCHAR2	(30)		Region Code for pointing to Preference region. This is valid only when region style = 'PAGE LAYOUT'.
DISABLE_HEADER	VARCHAR2	(1)		This allows developers to remove the header title for Default Single/Double Column Layout
STANDALONE	VARCHAR2	(1)	Yes	This column indicates whether a region can be rendered standalone or not.
AUTO_CUSTOMIZATION_CRITERIA	VARCHAR2	(1)		Associated for regions of style QUERY.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REGION_CODE
,      REGION_APPLICATION_ID
,      DATABASE_OBJECT_NAME
,      REGION_STYLE
,      NUM_COLUMNS
,      REGION_DEFAULTING_API_PKG
,      REGION_DEFAULTING_API_PROC
,      REGION_VALIDATION_API_PKG
,      REGION_VALIDATION_API_PROC
,      ICX_CUSTOM_CALL
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      APPLICATIONMODULE_OBJECT_TYPE
,      NUM_ROWS_DISPLAY
,      REGION_OBJECT_TYPE
,      IMAGE_FILE_NAME
,      ISFORM_FLAG
,      HELP_TARGET
,      STYLE_SHEET_FILENAME
,      VERSION
,      APPLICATIONMODULE_USAGE_NAME
,      ADD_INDEXED_CHILDREN
,      STATEFUL_FLAG
,      FUNCTION_NAME
,      CHILDREN_VIEW_USAGE_NAME
,      SEARCH_PANEL
,      ADVANCED_SEARCH_PANEL
,      CUSTOMIZE_PANEL
,      DEFAULT_SEARCH_PANEL
,      RESULTS_BASED_SEARCH
,      DISPLAY_GRAPH_TABLE
,      PREF_REGION_APPLICATION_ID
,      PREF_REGION_CODE
,      DISABLE_HEADER
,      STANDALONE
,      AUTO_CUSTOMIZATION_CRITERIA
,      ZD_EDITION_NAME
FROM AK.AK_REGIONS;

Dependencies

[top of page]

AK.AK_REGIONS does not reference any database object

AK.AK_REGIONS is referenced by following:

AK: AK_REGIONS#