OKC_XPRT_RULE_CONDITIONS

This table stores all the conditions of the rules. This is a child entity of rule header entity.

Details

• Schema: FUSION

• Object owner: OKC

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
OKC_XPRT_RULE_CONDITIONS_PK	RULE_CONDITION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
RULE_CONDITION_ID	NUMBER		18	Yes	Sequence generated ID.
RULE_ID	NUMBER		18	Yes	Rule Id. FK to OKC_XPRT_RULE_HDRS_ALL.
OBJECT_TYPE	VARCHAR2	30		Yes	Indicates if condition type is a clause, system or user defined variable or question. FK to FND lookup OKC_XPRT_COND_OBJECT_TYPE
OBJECT_CODE	VARCHAR2	40			This is used where the condition types are either system or user defined variables or questoins.. The code identifies the actual system or user defined variable or the question used in the condition. For clauses, this will be NULL.
OBJECT_CODE_DATATYPE	VARCHAR2	1			Indicates the datatype for the object_code. For Clause this is NULL. Used values are 'N': Numeric variable or Numeric Question, 'V': Character variable, 'L': Character Question, 'B': Boolean (Yes/No) quesion.
OPERATOR	VARCHAR2	30		Yes	Condition operator for Numeric variables and Questions: <=, >=, <>, = , >, <. For Character type variables and questions: IS, IS NOT, IN, NOT IN.
OBJECT_VALUE_SET_NAME	VARCHAR2	60			FND value set name of Variables / Questions for the RHS of condition.
OBJECT_VALUE_TYPE	VARCHAR2	30		Yes	Indicates if the RHS of condition is CLAUSE, VARIABLE, QUESTION, CONSTANT, VALUE. FK to FND lookup OKC_XPRT_COND_VALUE_TYPE.
OBJECT_VALUE_CODE	VARCHAR2	1000			Variable's value Id or Variable code or Clause Id or Constant Id or Question Id. This will be populated only if the condition has one value.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
OKC_XPRT_RULE_CONDITIONS	okc_xprt_rule_hdrs_all	RULE_ID
okc_xprt_rule_cond_vals	okc_xprt_rule_conditions	RULE_CONDITION_ID

Indexes

Index	Uniqueness	Tablespace	Columns
OKC_XPRT_RULE_CONDITIONS_N1	Non Unique	Default	RULE_ID
OKC_XPRT_RULE_CONDITIONS_N2	Non Unique	Default	OBJECT_TYPE, OBJECT_CODE
OKC_XPRT_RULE_CONDITIONS_N3	Non Unique	Default	OBJECT_VALUE_TYPE, OBJECT_VALUE_CODE
OKC_XPRT_RULE_CONDITIONS_U1	Unique	Default	RULE_CONDITION_ID