[Home] [Help] [Dependency Information]
Object Name: | POR_TEMPLATE_ATTRIBUTES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ICX.POR_TEMPLATE_ATTRIBUTES_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
The POR_TEMPLATE_ATTRIBUTES_V view returns the information used about the attributes that are used in Information Template. This display sequence of the attribute is used to indicate the sequence that various attributes are displayed. The required flag indicates whether the attribute requires to fill in for a particular information template.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Identifier | |
TEMPLATE_CODE | VARCHAR2 | (30) | Yes | Unique identifier of information template to which this attribute belongs |
DISPLAY_SEQUENCE | NUMBER | Yes | Sequence number that controls the order in which the attribute is displayed | |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Yes | Unique identifier of attribute |
ATTRIBUTE_NAME | VARCHAR2 | (240) | Yes | Information attribute name in session language |
DESCRIPTION | VARCHAR2 | (240) | Attribute description in session language | |
DEFAULT_VALUE | VARCHAR2 | (240) | Default value of attribute defined on setup form | |
FLEX_VALUE_SET_ID | NUMBER | Identifier of flex field value set if attribute type is list of value | ||
REQUIRED_FLAG | VARCHAR2 | (1) | Yes | Determine if the attribute is required |
NODE_DISPLAY_FLAG | VARCHAR2 | (1) | Yes | Determine if the node should be displayed |
CREATED_BY | NUMBER | Yes | Identifier of user who created the row | |
CREATION_DATE | DATE | Yes | Date on which the row was created | |
LAST_UPDATED_BY | NUMBER | Yes | Identifier of user who last updated the row | |
LAST_UPDATE_DATE | DATE | Yes | Date on which the row was last updated | |
LAST_UPDATE_LOGIN | NUMBER | Operating system login of user who last updated the row |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, TEMPLATE_CODE
, DISPLAY_SEQUENCE
, ATTRIBUTE_CODE
, ATTRIBUTE_NAME
, DESCRIPTION
, DEFAULT_VALUE
, FLEX_VALUE_SET_ID
, REQUIRED_FLAG
, NODE_DISPLAY_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.POR_TEMPLATE_ATTRIBUTES_V;
|
|
|