[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AK_REGION_ITEMS |
|---|---|
| Object Type: | TABLE |
| Owner: | AK |
| FND Design Data: |  AK.AK_REGION_ITEMS
|
| Subobject Name: | |
| Status: | VALID |
AK_REGION_ITEMS defines the item (attribute or object attribute) on a
region. An item is a single attribute or object attribute that exists
on a region. You will need one row for each item you want to assign to
a region.
You must define formatting properties (i.e., ATTRIBUTE_LABEL_LENGTH,
BOLD, ITALIC, VERTICAL_ALIGNMENT, etc.) for each item. You must
also specify if the item is an attribute or object attribute with the
OBJECT_ATTRIBUTE_FLAG. This table also allows you to specify other
properties for the item.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AK_REGION_ITEMS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 REGION_CODE
REGION_APPLICATION_ID
ATTRIBUTE_CODE
ATTRIBUTE_APPLICATION_ID
|
| AK_REGION_ITEMS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
REGION_CODE
REGION_APPLICATION_ID
DISPLAY_SEQUENCE
|
| AK_REGION_ITEMS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REGION_APPLICATION_ID
REGION_CODE
|
| AK_REGION_ITEMS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
VIEW_USAGE_NAME
VIEW_ATTRIBUTE_NAME
|
| AK_REGION_ITEMS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ATTRIBUTE_CODE
ATTRIBUTE_APPLICATION_ID
|
| AK_REGION_ITEMS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LOV_FOREIGN_KEY_NAME
|
| AK_REGION_ITEMS_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LOV_REGION_CODE
LOV_REGION_APPLICATION_ID
|
| AK_REGION_ITEMS_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
NESTED_REGION_CODE
NESTED_REGION_APPLICATION_ID
|
| 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 |
| ATTRIBUTE_CODE | VARCHAR2 | (30) | Yes | Attribute identifier |
| ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Yes | Product team's application ID which the attribute belong to |
| DISPLAY_SEQUENCE | NUMBER | (15) | Yes | Sequence number for displaying region items. Each sequence number should be unique within the same region |
| NODE_DISPLAY_FLAG | VARCHAR2 | (1) | Yes | Node display flag ('Y' - Display this region item in a node, 'N' - Do not display this region item in a node) |
| NODE_QUERY_FLAG | VARCHAR2 | (1) | Yes | This flag indicates whether the value of this region item can be queried (NODE_QUERY_FLAG = 'Y') or not (NODE_QUERY_FLAG='N') |
| ATTRIBUTE_LABEL_LENGTH | NUMBER | (15) | Yes | Prompt/label length for this item |
| BOLD | VARCHAR2 | (1) | Yes | Bold flag ('Y' - Bold the region item, 'N' - Do not bold the region item) |
| ITALIC | VARCHAR2 | (1) | Yes | Italic flag ('Y' - Italicize the region item, 'N' - Do not italicize the region item) |
| VERTICAL_ALIGNMENT | VARCHAR2 | (30) | Yes | Vertical Alignment for the region item |
| HORIZONTAL_ALIGNMENT | VARCHAR2 | (30) | Yes | Horizontal alignment for the region item |
| ITEM_STYLE | VARCHAR2 | (30) | Yes | Style of region item |
| OBJECT_ATTRIBUTE_FLAG | VARCHAR2 | (1) | Yes | Flag indicates if this item is an attribute (OBJECT_ATTRIBUTE_FLAG = 'N') or an object attribute (OBJECT_ATTRIBUTE_FLAG = 'Y') |
| UPDATE_FLAG | VARCHAR2 | (1) | Yes | Flag indicates whether this attribute is updatable (UPDATE_FLAG = 'Y') or not (UPDATE_FLAG = 'N') |
| REQUIRED_FLAG | VARCHAR2 | (1) | Yes | Flag indicates whether this attribute is input required for the region (REQUIRED_FLAG = 'Y') or not (REQUIRED_FLAG = 'N') |
| DISPLAY_VALUE_LENGTH | NUMBER | (15) | Yes | Length of region item to be displayed |
| SECURITY_CODE | VARCHAR2 | (30) | Security Code | |
| LOV_REGION_CODE | VARCHAR2 | (30) | LOV region identifier | |
| LOV_REGION_APPLICATION_ID | NUMBER | (15) | Product team's application id which the LOV region belong to | |
| LOV_FOREIGN_KEY_NAME | VARCHAR2 | (30) | Lov foreign key relationship identifier | |
| LOV_ATTRIBUTE_CODE | VARCHAR2 | (30) | LOV attribute identifier | |
| LOV_ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Product team's application id which the lov attribute belong to | |
| LOV_DEFAULT_FLAG | VARCHAR2 | (1) | LOV default flag | |
| REGION_DEFAULTING_API_PKG | VARCHAR2 | (30) | PL/SQL package name which contains the stored procedure to populate default values into this region item | |
| REGION_DEFAULTING_API_PROC | VARCHAR2 | (30) | Procedure name in PL/SQL package which populates default values into this region item | |
| REGION_VALIDATION_API_PKG | VARCHAR2 | (30) | PL/SQL package name which contains the procedure to validate the region item's value | |
| REGION_VALIDATION_API_PROC | VARCHAR2 | (30) | Procedure name in PL/SQL package which contains the procedure to validate the region item's value | |
| ORDER_SEQUENCE | NUMBER | (15) | Order Sequence | |
| ORDER_DIRECTION | VARCHAR2 | (30) | Direction of sorting values of region items | |
| DEFAULT_VALUE_VARCHAR2 | VARCHAR2 | (240) | Default value of region item when the data type of the region item is VARCHAR | |
| DEFAULT_VALUE_NUMBER | NUMBER | (15) | Default value of region item when the data type of the region item is NUMBER | |
| DEFAULT_VALUE_DATE | DATE | Default value of region item when the data type of the region item is DATE | ||
| 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 |
| DISPLAY_HEIGHT | NUMBER | If this item is a text area then this property defines the vertical number of lines for that text. | ||
| SUBMIT | VARCHAR2 | (1) | Yes | Obsolete |
| ENCRYPT | VARCHAR2 | (1) | Yes | Flag that indicates if an item is encrypted or not. |
| NESTED_REGION_CODE | VARCHAR2 | (30) | Code of the region to be referenced from this item. | |
| NESTED_REGION_APPLICATION_ID | NUMBER | Application of the region to be referenced from this item. | ||
| VIEW_USAGE_NAME | VARCHAR2 | (80) | View object data source name for the data item to be displayed/updated/created. | |
| VIEW_ATTRIBUTE_NAME | VARCHAR2 | (80) | View object attribute name data source for the data item to be displayed/updated/created. | |
| CSS_CLASS_NAME | VARCHAR2 | (80) | The cascading style sheet class name to be applied to the value of a data item that will be displayed on the page. | |
| POPLIST_VIEWOBJECT | VARCHAR2 | (240) | If this attribute is of item style poplist then this property defines the view object source for the list of possible values for the poplist. | |
| IMAGE_FILE_NAME | VARCHAR2 | (80) | The name of the image that will be displayed on the page. | |
| URL | VARCHAR2 | (2000) | The URL properly applies to many item styles within a region. It can be defined for button, button submit, label, text and image. | |
| POPLIST_DISPLAY_ATTRIBUTE | VARCHAR2 | (80) | If this attribute is of item style poplist then this property defines the view object attribute source for the list of possible display values for the poplist that the user can choose from. | |
| POPLIST_VALUE_ATTRIBUTE | VARCHAR2 | (80) | If this attribute is of item style poplist then this property defines the view object attribute source for the list of possible returned values for the poplist that the user can choose from. | |
| ITEM_NAME | VARCHAR2 | (30) | Single reference name for the usage of an attribute with the region. | |
| CSS_LABEL_CLASS_NAME | VARCHAR2 | (80) | The cascading style sheet class name that will be applied to the label of a data item or the static text that will be displayied on the page. | |
| MENU_ID | NUMBER | Id of the menu to use for Global Menu and Application menu item style to represent the menu hierarchy that will be used to create the tab bar, submenu and bin. | ||
| MENU_NAME | VARCHAR2 | (30) | menu_name references menu_name in FND_MENUS table | |
| FLEXFIELD_NAME | VARCHAR2 | (40) | FND Flexfield name | |
| FLEXFIELD_APPLICATION_ID | NUMBER | Application ID of Flexfield | ||
| TABULAR_FUNCTION_CODE | VARCHAR2 | (30) | Function code to put in this region item if this region item is used as a function | |
| TIP_TYPE | VARCHAR2 | (30) | Type of tip message of region item if the region item has a tip | |
| TIP_MESSAGE_NAME | VARCHAR2 | (30) | message_name of tip message in FND_NEW_MESSAGES table | |
| TIP_MESSAGE_APPLICATION_ID | NUMBER | application ID of tip message name | ||
| FLEX_SEGMENT_LIST | VARCHAR2 | (4000) | column for attaching flex fields to a region item | |
| ENTITY_ID | VARCHAR2 | (30) | ENTITY_ID references DATA_OBJECT_CODE column in FND_DOCUMENT_ENTITIES | |
| TARGET | VARCHAR2 | (1) | this is an old column of ANCHOR, keeping this here for backward compatibility | |
| ANCHOR | VARCHAR2 | (1) | For defining same page hyperlink | |
| POPLIST_VIEW_USAGE_NAME | VARCHAR2 | (80) | Picklist View Usage Name | |
| SORTBY_VIEW_ATTRIBUTE_NAME | VARCHAR2 | (80) | Indicates which view attribute that the table region is sorted by | |
| USER_CUSTOMIZABLE | VARCHAR2 | (1) | Flag to indicate if this can be customized by user | |
| ADMIN_CUSTOMIZABLE | VARCHAR2 | (1) | Yes | especially useful in the defualt rendered regions where we don't want every cell format and row layout to be customizable by an administrator |
| INVOKE_FUNCTION_NAME | VARCHAR2 | (30) | This is for constructing generic URL to launch functions from OA Framework. | |
| EXPANSION | NUMBER | (15) | % of expansion that's allowed for translation. | |
| ALS_MAX_LENGTH | NUMBER | (15) | Maximum length of ATTRIBUTE_LABEL_SHORT column that's allowed for translation. | |
| INITIAL_SORT_SEQUENCE | VARCHAR2 | (30) | stores the startup sort sequence of a table. | |
| CUSTOMIZATION_APPLICATION_ID | NUMBER | (15) | Customization application id of the extended item (added by customization) | |
| CUSTOMIZATION_CODE | VARCHAR2 | (30) | Customization code of the extended item (added by customization) |
Cut, paste (and edit) the following text to query this object:
SELECT REGION_CODE
, REGION_APPLICATION_ID
, ATTRIBUTE_CODE
, ATTRIBUTE_APPLICATION_ID
, DISPLAY_SEQUENCE
, NODE_DISPLAY_FLAG
, NODE_QUERY_FLAG
, ATTRIBUTE_LABEL_LENGTH
, BOLD
, ITALIC
, VERTICAL_ALIGNMENT
, HORIZONTAL_ALIGNMENT
, ITEM_STYLE
, OBJECT_ATTRIBUTE_FLAG
, UPDATE_FLAG
, REQUIRED_FLAG
, DISPLAY_VALUE_LENGTH
, SECURITY_CODE
, LOV_REGION_CODE
, LOV_REGION_APPLICATION_ID
, LOV_FOREIGN_KEY_NAME
, LOV_ATTRIBUTE_CODE
, LOV_ATTRIBUTE_APPLICATION_ID
, LOV_DEFAULT_FLAG
, REGION_DEFAULTING_API_PKG
, REGION_DEFAULTING_API_PROC
, REGION_VALIDATION_API_PKG
, REGION_VALIDATION_API_PROC
, ORDER_SEQUENCE
, ORDER_DIRECTION
, DEFAULT_VALUE_VARCHAR2
, DEFAULT_VALUE_NUMBER
, DEFAULT_VALUE_DATE
, 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
, DISPLAY_HEIGHT
, SUBMIT
, ENCRYPT
, NESTED_REGION_CODE
, NESTED_REGION_APPLICATION_ID
, VIEW_USAGE_NAME
, VIEW_ATTRIBUTE_NAME
, CSS_CLASS_NAME
, POPLIST_VIEWOBJECT
, IMAGE_FILE_NAME
, URL
, POPLIST_DISPLAY_ATTRIBUTE
, POPLIST_VALUE_ATTRIBUTE
, ITEM_NAME
, CSS_LABEL_CLASS_NAME
, MENU_ID
, MENU_NAME
, FLEXFIELD_NAME
, FLEXFIELD_APPLICATION_ID
, TABULAR_FUNCTION_CODE
, TIP_TYPE
, TIP_MESSAGE_NAME
, TIP_MESSAGE_APPLICATION_ID
, FLEX_SEGMENT_LIST
, ENTITY_ID
, TARGET
, ANCHOR
, POPLIST_VIEW_USAGE_NAME
, SORTBY_VIEW_ATTRIBUTE_NAME
, USER_CUSTOMIZABLE
, ADMIN_CUSTOMIZABLE
, INVOKE_FUNCTION_NAME
, EXPANSION
, ALS_MAX_LENGTH
, INITIAL_SORT_SEQUENCE
, CUSTOMIZATION_APPLICATION_ID
, CUSTOMIZATION_CODE
FROM AK.AK_REGION_ITEMS;
AK.AK_REGION_ITEMS does not reference any database object
AK.AK_REGION_ITEMS is referenced by following:
APPS
AK_REGION_ITEMS
|
|
|
|