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: IGS.IGP_WZ_TEMPLATES

Object Details

Object Name:	IGP_WZ_TEMPLATES
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGP_WZ_TEMPLATES
Subobject Name:
Status:	VALID

Table to store the details of Templates.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGP_WZ_TEMPLATES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TEMPLATE_ID
IGP_WZ_TEMPLATES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TEMPLATE_NAME
SYS_IL0000402872C00006$$	LOB	UNIQUE	APPS_TS_TX_DATA
IGP_WZ_TEMPLATES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATED_BY
IGP_WZ_TEMPLATES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATED_BY
IGP_WZ_TEMPLATES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DESCRIPTION

Columns

Name	Datatype	Length	Mandatory	Comments
TEMPLATE_ID	NUMBER		Yes	Sequence generated Primary Key
TEMPLATE_NAME	VARCHAR2	(256)	Yes	Name of the Template. This is unique irrespective of Case. E.g. Introduction.html and INTRODUCTION.html will be considered as same name.
TEMPLATE_STATUS_CODE	VARCHAR2	(30)	Yes	Status of the Template. This is validated with the lookup type IGP_WZ_TEMP_STATUS, Valid values are PUBLISH, DRAFT, PENDING
TEMPLATE_TITLE	VARCHAR2	(80)		Title of the Template
DESCRIPTION	VARCHAR2	(120)		Description of the Template
TEMPLATE_CONTENT	CLOB	(4000)	Yes	Contents of the Template, this will be XML contents.
TEMPLATE_TYPE_CODE	VARCHAR2	(30)	Yes	Type of the Template. This is validated with the lookup type IGP_WZ_TEMP_TYPE, Valid value is PRESENTATION
EXTERNAL_FLAG	VARCHAR2	(1)	Yes	Flag indicating that whether the template was created using the Wizard or it is uploaded.
EXPIRY_DATE	DATE			Expiry Date of the Template
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)		Standard Who column
OBJECT_VERSION_NUMBER	NUMBER		Yes	Standard Who column

Query Text

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


SELECT TEMPLATE_ID
,      TEMPLATE_NAME
,      TEMPLATE_STATUS_CODE
,      TEMPLATE_TITLE
,      DESCRIPTION
,      TEMPLATE_CONTENT
,      TEMPLATE_TYPE_CODE
,      EXTERNAL_FLAG
,      EXPIRY_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM IGS.IGP_WZ_TEMPLATES;

Dependencies

[top of page]

IGS.IGP_WZ_TEMPLATES does not reference any database object

IGS.IGP_WZ_TEMPLATES is referenced by following:

APPS: IGP_WZ_TEMPLATES