[Home] [Help] [Dependency Information]
Object Name: | JTM_AK_REGIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
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 |
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;
APPS.JTM_AK_REGIONS_V is not referenced by any database object
|
|
|