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]

VIEW: APPS.JTM_AK_REGIONS_V

Object Details

Object Name:	JTM_AK_REGIONS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ACCESS_ID	NUMBER		Yes
REGION_APPLICATION_ID	NUMBER	(15)	Yes	Product team's application id which the region belong to
REGION_CODE	VARCHAR2	(30)	Yes	Region identifier
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
ICX_CUSTOM_CALL	VARCHAR2	(80)		A URL to launch an html file
NAME	VARCHAR2	(80)	Yes	Friendly user name of region
DESCRIPTION	VARCHAR2	(2000)		Description of region
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
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.
LANGUAGE	VARCHAR2	(4)	Yes	The language code of the language which the translatable fields are translated to
SOURCE_LANG	VARCHAR2	(4)	Yes	Language code of the language which the values of the translatable columns were originally entered

Query Text

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


SELECT ACCESS_ID
,      REGION_APPLICATION_ID
,      REGION_CODE
,      DATABASE_OBJECT_NAME
,      REGION_STYLE
,      NUM_COLUMNS
,      ICX_CUSTOM_CALL
,      NAME
,      DESCRIPTION
,      REGION_DEFAULTING_API_PKG
,      REGION_DEFAULTING_API_PROC
,      REGION_VALIDATION_API_PKG
,      REGION_VALIDATION_API_PROC
,      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
,      LANGUAGE
,      SOURCE_LANG
FROM APPS.JTM_AK_REGIONS_V;

Dependencies

[top of page]

APPS.JTM_AK_REGIONS_V references the following:

APPS: AK_REGIONS; AK_REGIONS_TL; ASG_BASE - show dependent code; JTM_AK_REGIONS_ACC

APPS.JTM_AK_REGIONS_V is not referenced by any database object