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: OKC.OKC_XPRT_TEMPLATE_RULES

Object Details

Object Name:	OKC_XPRT_TEMPLATE_RULES
Object Type:	TABLE
Owner:	OKC
FND Design Data:	OKC.OKC_XPRT_TEMPLATE_RULES
Subobject Name:
Status:	VALID

This entity stores all the rules on a template. Rules that are applicable to all templates will not have rows in this entity. OKC_XPRT_RULE_HDRS_ALL.ORG_WIDE_FLAG will be set to 'Y' if the rule is applicable to all templates in an operating unit.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_XPRT_TEMPLATE_RULES_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TEMPLATE_RULE_ID
OKC_XPRT_TEMPLATE_RULES_U2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TEMPLATE_ID RULE_ID DELETED_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
TEMPLATE_RULE_ID	NUMBER		Yes	Primary key for the table
TEMPLATE_ID	NUMBER		Yes	Id of the template to which the rule is associated
RULE_ID	NUMBER		Yes	Id of the rule associated with the template. FK to OKC_XPRT_RULE_HDRS_ALL
DELETED_FLAG	VARCHAR2	(1)		Soft deleted record indicator
PUBLISHED_FLAG	VARCHAR2	(1)		Flag to indicate whether the template has been published to Oracle Configurator or not
OBJECT_VERSION_NUMBER	NUMBER		Yes	Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
CREATED_BY	NUMBER	(15)	Yes	Keeps track of which user created each row.
CREATION_DATE	DATE		Yes	Stores the date on which each row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Keeps track of who last updated each row.
LAST_UPDATE_DATE	DATE		Yes	Stores the date on which each row was last updated.
LAST_UPDATE_LOGIN	NUMBER	(15)		Provides access to information about the operating system login of the user who last updated each row.

Query Text

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


SELECT TEMPLATE_RULE_ID
,      TEMPLATE_ID
,      RULE_ID
,      DELETED_FLAG
,      PUBLISHED_FLAG
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM OKC.OKC_XPRT_TEMPLATE_RULES;

Dependencies

[top of page]

OKC.OKC_XPRT_TEMPLATE_RULES does not reference any database object

OKC.OKC_XPRT_TEMPLATE_RULES is referenced by following:

APPS: OKC_XPRT_TEMPLATE_RULES