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_RULE_HDRS_ALL

Object Details

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

This table has the rule header information for template specific rules as well as rules assigned at all templates in the Operating Unit

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_XPRT_RULE_HDRS_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RULE_ID
OKC_XPRT_RULE_HDRS_ALL_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORG_ID RULE_NAME
OKC_XPRT_RULE_HDRS_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
RULE_ID	NUMBER		Yes	Sequence generated ID.
ORG_ID	NUMBER		Yes	The organization ID indicating the operating unit in which the rule is creating. FK to HR_ORGANIZATIONS_ALL.
INTENT	VARCHAR2	(1)	Yes	Rule intent. B: Buy or S: Sell
STATUS_CODE	VARCHAR2	(30)	Yes	Indicates the status of the Rule and is applicable only to Organization Rules. FK to FND lookup OKC_XPRT_RULE_STATUSES.
RULE_NAME	VARCHAR2	(240)	Yes	Rule name.
RULE_DESCRIPTION	VARCHAR2	(2000)		Rule description.
ORG_WIDE_FLAG	VARCHAR2	(1)		Flag to indicate if the template is applicable to all templates in the current operating unit
PUBLISHED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if the rule was published to Configurator once
CONDITION_EXPR_CODE	VARCHAR2	(30)	Yes	Indicates whether the conditions on the rule are 'Any True' or 'All True'. Possible values are 'ALL' or 'ANY'. FK to FND lookup OKC_XPRT_CONDITION_EXPRESSION.
REQUEST_ID	NUMBER	(15)		Keeps track of the concurrent request during which this row was created or updated.
RULE_TYPE	VARCHAR2	(30)	Yes	Identify the Rule Type Values: POLICY_DEVIATION and CLAUSE_SELECTION. FK to FND_LOOKUP 'OKC_XPRT_RULE_TYPE.
LINE_LEVEL_FLAG	VARCHAR2	(1)		Identify if the rule has any line level system variables. This column would be updated when the rules are activated.
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.
PROGRAM_ID	NUMBER	(15)		With PROGRAM_ID, keeps track of which concurrent program created or updated each row.
PROGRAM_APPLICATION_ID	NUMBER	(15)		With PROGRAM_APPLICATION_ID, keeps track of which concurrent program created or updated each row.
PROGRAM_UPDATE_DATE	DATE			Stores the date on which the concurrent program created or updated the row.
ACTIVATION_DATE	DATE			Indicates when the rule was activated

Query Text

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


SELECT RULE_ID
,      ORG_ID
,      INTENT
,      STATUS_CODE
,      RULE_NAME
,      RULE_DESCRIPTION
,      ORG_WIDE_FLAG
,      PUBLISHED_FLAG
,      CONDITION_EXPR_CODE
,      REQUEST_ID
,      RULE_TYPE
,      LINE_LEVEL_FLAG
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      ACTIVATION_DATE
FROM OKC.OKC_XPRT_RULE_HDRS_ALL;

Dependencies

[top of page]

OKC.OKC_XPRT_RULE_HDRS_ALL does not reference any database object

OKC.OKC_XPRT_RULE_HDRS_ALL is referenced by following:

OKC: OKC_XPRT_RULE_HDRS_ALL#