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.POR_TEMPLATE_ATTRIBUTES_V

Object Details

Object Name:	POR_TEMPLATE_ATTRIBUTES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ICX.POR_TEMPLATE_ATTRIBUTES_V
Subobject Name:
Status:	VALID

View Type

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.

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

APPS.POR_TEMPLATE_ATTRIBUTES_V references the following:

APPS: POR_TEMPLATE_ATTRIBUTES_B; POR_TEMPLATE_ATTRIBUTES_TL

APPS.POR_TEMPLATE_ATTRIBUTES_V is referenced by following:

APPS: POR_IFT_ADMIN_PKG - show dependent code