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]

TABLE: PO.PO_UDA_AG_TEMPLATES

Object Details

Object Name:	PO_UDA_AG_TEMPLATES
Object Type:	TABLE
Owner:	PO
FND Design Data:	PO.PO_UDA_AG_TEMPLATES
Subobject Name:
Status:	VALID

This table stores the attribute template header information. The unique key is template_id. The combination of functional_area, document_type, document_style_id and document_level and revision is also unique. Each template revision will have one record in this table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PO_UDA_AG_TEMPLATES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TEMPLATE_ID ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
TEMPLATE_ID	NUMBER		Yes	Attribute template unique identifier
ENTITY_CODE	VARCHAR2	(300)		Attribute Group type internal name
FUNCTIONAL_AREA	VARCHAR2	(25)		Functional Area to which Attribute Group is required
DOCUMENT_LEVEL	VARCHAR2	(25)		Document Level on which Attribute Group is relevant
DOCUMENT_TYPE	VARCHAR2	(25)		Document Type on which Attribute Group is relevant
DOCUMENT_STYLE_ID	NUMBER			Document Style on which Attribute Group is relevant
REVISION	NUMBER			Attribute template revision unique identifier
DATABASE_VIEW_NAME	VARCHAR2	(50)		Attribute template Database View
COMPILED_FLAG	VARCHAR2	(1)		Complied Flag of the Attribute Template
SRC_TEMPLATE_ID	NUMBER			Unique identifier of previous revision of Attribute Template
EFFECTIVE_FROM	DATE			Attribute template Effective from date
EFFECTIVE_TO	DATE			Attribute template Effective to date
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER			Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TEMPLATE_ID
,      ENTITY_CODE
,      FUNCTIONAL_AREA
,      DOCUMENT_LEVEL
,      DOCUMENT_TYPE
,      DOCUMENT_STYLE_ID
,      REVISION
,      DATABASE_VIEW_NAME
,      COMPILED_FLAG
,      SRC_TEMPLATE_ID
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ZD_EDITION_NAME
FROM PO.PO_UDA_AG_TEMPLATES;

Dependencies

[top of page]

PO.PO_UDA_AG_TEMPLATES does not reference any database object

PO.PO_UDA_AG_TEMPLATES is referenced by following:

PO: PO_UDA_AG_TEMPLATES#