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_CONDITION_LINES_B

Object Details

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

Each Condition Line expresses a Boolean condition. Multiple Condition Lines can be evaluated by using AND or OR with paranthesis..
A Condition Line represents an expression that is one of three types: general, counter, or functi on-based.
A general expression has a left operand that is an Action Attribute (OKC_ACTION_ATTRIBUTES_B), a relational operator (<=, = , =>, >, <>), and a right operand that is either free form (user entered) or chosen from a list of values taken from the table/column pair in OKC_ACTION_ATT_LOOKUPS.
A counter expression must have a counter as its left operand. It has a relational operator, and as a right operand it may have a user-entered value or another cou nter in the same counter group as the left operand.
A function-based expression calls a function that returns a boolean. The function may take as parameters either Action Attributes or user-entered values.
All the Cond ition Lines under a Condition Header (OKC_CONDITION_HEADERS_B) form the complete condition that is to be evaluated upon the occurence of an Action (OKC_ACTIONS_B). If that condition evaluates to true, then any Outcomes (OKC_OUTCOMES_B) associated w ith that Condition Header will be initiated.
If a Condition Header has no Condition Lines, then it will always evaluate to true.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_CONDITION_LINES_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
OKC_CONDITION_LINES_B_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	CNH_ID SORTSEQ
OKC_CONDITION_LINES_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DNZ_CHR_ID
OKC_CONDITION_LINES_B_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AAE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	System generated Unique Identifier. Generated from sequence OKC_CONDITION_LINES_S1. Also primary key of the table.
CNH_ID	NUMBER		Yes	Unique identifier of Condition Header. Refers to ID in OKC_CONDITION_HEADERS_B.
PDF_ID	NUMBER			Unique identifier of Process Definition. Refers to ID in OKC_PROCESS_DEFS_B.
AAE_ID	NUMBER			Unique identifier of Action Attribute. Refers to ID in OKC_ACTION_ATTRIBUTES_B.
LEFT_CTR_MASTER_ID	NUMBER	(15)		This is the Counter Id for the Counter Group Id defined in the Condition Headers. Refers to COUNTER_ID in CS_COUNTERS.
RIGHT_CTR_MASTER_ID	NUMBER	(15)		This is the Counter Id for the Counter Group Id defined in the Condition Headers. Refers to COUNTER_ID in CS_COUNTERS.
LEFT_COUNTER_ID	NUMBER	(15)		This is the Counter Id for the Counter Group Id defined in the Condition Headers. Refers to COUNTER_ID in CS_COUNTERS.
RIGHT_COUNTER_ID	NUMBER	(15)		This is the Counter Id for the Counter Group Id defined in the Condition Headers. Refers to COUNTER_ID in CS_COUNTERS.
DNZ_CHR_ID	NUMBER			Contract ID. Denormalized for performance.
SORTSEQ	NUMBER	(10)	Yes	Serial Number to indicate the sort sequence of condition lines.
LOGICAL_OPERATOR	VARCHAR2	(9)		Logical operator. i.e. AND / OR
CNL_TYPE	VARCHAR2	(10)	Yes	Condition Line Type. CEX for Counter Expression referencing CS_COUNTERS. GEX for General Expression could be Free Formatted or a Constrained Value referencing Action Attribute Lookups. FEX for Function Expression referencing function expression parameters
OBJECT_VERSION_NUMBER	NUMBER	(9)	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	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.
LEFT_PARENTHESIS	VARCHAR2	(90)		Left parenthesis.
RELATIONAL_OPERATOR	VARCHAR2	(36)		Relational operator. ''='',''<>'',''<='',''>='',''>'',''<'',''EVERY'',''IS NULL'',''IS NOT NULL'',''LIKE''
RIGHT_PARENTHESIS	VARCHAR2	(90)		Right parenthesis.
TOLERANCE	NUMBER	(10)		Numeric value for Tolerance for Counters. Valid for Counter Expressions.
START_AT	NUMBER	(10)		Start position for Counters . Valid for Counter Expressions.
RIGHT_OPERAND	VARCHAR2	(150)		Value for the Right operand.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
ATTRIBUTE_CATEGORY	VARCHAR2	(90)		Descriptive flexfield category column.
ATTRIBUTE1	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE2	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE3	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE4	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE5	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE6	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE7	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE8	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE9	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE10	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE11	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE12	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE13	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE14	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE15	VARCHAR2	(450)		Descriptive flexfield column.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
APPLICATION_ID	NUMBER			Owning Application Identifier
SEEDED_FLAG	VARCHAR2	(3)		Indicates whether a record is seeded data. Valid values are Y or N.

Query Text

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


SELECT ID
,      CNH_ID
,      PDF_ID
,      AAE_ID
,      LEFT_CTR_MASTER_ID
,      RIGHT_CTR_MASTER_ID
,      LEFT_COUNTER_ID
,      RIGHT_COUNTER_ID
,      DNZ_CHR_ID
,      SORTSEQ
,      LOGICAL_OPERATOR
,      CNL_TYPE
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LEFT_PARENTHESIS
,      RELATIONAL_OPERATOR
,      RIGHT_PARENTHESIS
,      TOLERANCE
,      START_AT
,      RIGHT_OPERAND
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      APPLICATION_ID
,      SEEDED_FLAG
FROM OKC.OKC_CONDITION_LINES_B;

Dependencies

[top of page]

OKC.OKC_CONDITION_LINES_B does not reference any database object

OKC.OKC_CONDITION_LINES_B is referenced by following:

APPS: OKC_CONDITION_LINES_B