[Home] [Help] [Dependency Information]
Object Name: | JTM_AK_REGION_ITEMS_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 |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Yes | Product team's application ID which the attribute belong to |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Yes | Attribute identifier |
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 |
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_PRESENCE_FLAG | VARCHAR2 | (1) | ||
LOV_REGION_APPLICATION_ID | NUMBER | (15) | Product team's application id which the LOV region belong to | |
LOV_REGION_CODE | VARCHAR2 | (30) | LOV region identifier | |
LOV_FOREIGN_KEY_NAME | VARCHAR2 | (30) | Lov foreign key relationship identifier | |
LOV_ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Product team's application id which the lov attribute belong to | |
LOV_ATTRIBUTE_CODE | VARCHAR2 | (30) | LOV attribute identifier | |
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_DATE | DATE | Default value of region item when the data type of the region item is DATE | ||
DEFAULT_VALUE_NUMBER | NUMBER | (15) | Default value of region item when the data type of the region item is NUMBER | |
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 |
ATTRIBUTE_LABEL_LONG | VARCHAR2 | (80) | Label/Prompt for this region item | |
ATTRIBUTE_LABEL_SHORT | VARCHAR2 | (30) | A short label/prompt for this region item (this column is obsolete, do not use) | |
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') |
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. | |
DESCRIPTION | VARCHAR2 | (2000) | Description | |
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_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 | |
ANCHOR | VARCHAR2 | (1) | For defining same page hyperlink | |
POPLIST_VIEW_USAGE_NAME | VARCHAR2 | (80) | Picklist View Usage Name | |
TARGET | VARCHAR2 | (1) | this is an old column of ANCHOR, keeping this here for backward compatibility | |
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) | |
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
, ATTRIBUTE_APPLICATION_ID
, ATTRIBUTE_CODE
, DISPLAY_SEQUENCE
, NODE_DISPLAY_FLAG
, NODE_QUERY_FLAG
, ATTRIBUTE_LABEL_LENGTH
, BOLD
, ITALIC
, VERTICAL_ALIGNMENT
, HORIZONTAL_ALIGNMENT
, ITEM_STYLE
, UPDATE_FLAG
, REQUIRED_FLAG
, DISPLAY_VALUE_LENGTH
, SECURITY_CODE
, LOV_PRESENCE_FLAG
, LOV_REGION_APPLICATION_ID
, LOV_REGION_CODE
, LOV_FOREIGN_KEY_NAME
, LOV_ATTRIBUTE_APPLICATION_ID
, LOV_ATTRIBUTE_CODE
, 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_DATE
, DEFAULT_VALUE_NUMBER
, 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
, ATTRIBUTE_LABEL_LONG
, ATTRIBUTE_LABEL_SHORT
, OBJECT_ATTRIBUTE_FLAG
, 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
, DESCRIPTION
, ITEM_NAME
, CSS_LABEL_CLASS_NAME
, MENU_NAME
, FLEXFIELD_NAME
, FLEXFIELD_APPLICATION_ID
, TABULAR_FUNCTION_CODE
, TIP_TYPE
, TIP_MESSAGE_NAME
, TIP_MESSAGE_APPLICATION_ID
, FLEX_SEGMENT_LIST
, ENTITY_ID
, ANCHOR
, POPLIST_VIEW_USAGE_NAME
, TARGET
, SORTBY_VIEW_ATTRIBUTE_NAME
, USER_CUSTOMIZABLE
, ADMIN_CUSTOMIZABLE
, INVOKE_FUNCTION_NAME
, EXPANSION
, ALS_MAX_LENGTH
, INITIAL_SORT_SEQUENCE
, CUSTOMIZATION_APPLICATION_ID
, CUSTOMIZATION_CODE
, LANGUAGE
, SOURCE_LANG
FROM APPS.JTM_AK_REGION_ITEMS_V;
APPS.JTM_AK_REGION_ITEMS_V is not referenced by any database object
|
|
|