[Home] [Help] [Dependency Information]
Object Name: | IGW_BUSINESS_RULE_LINES |
---|---|
Object Type: | TABLE |
Owner: | IGW |
FND Design Data: | IGW.IGW_BUSINESS_RULE_LINES |
Subobject Name: | |
Status: | VALID |
IGW_BUSINESS_RULE_LINES stores business rule expressions. A comprehensive business rule may consist of several expressions joined together by logical AND or OR operators.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGW_BUS_RULE_LINES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
RULE_ID
EXPRESSION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_ID | NUMBER | (15) | Yes | Rule identifier |
EXPRESSION_ID | NUMBER | (10) | Yes | Rule expression identifier |
EXPRESSION_SEQUENCE_NUMBER | NUMBER | (4) | Yes | Expression sequence number |
EXPRESSION_TYPE | VARCHAR2 | (1) | Yes | Type of rule expression. Possible values are Q for Question, C for Column, and F for Function |
LBRACKETS | VARCHAR2 | (10) | Field for entering left brackets of an expression. A valid left bracket is a left parenthesis. | |
LVALUE | VARCHAR2 | (50) | Yes | Left hand side of expression. Values are taken from lookup IGW_RULE_COLUMNS when EXPRESSION_TYPE is C for Columns and from lookup IGW_RULE_FUNCTIONS when EXPRESSION_TYPE is F for Functions. |
OPERATOR | VARCHAR2 | (2) | Yes | Operator. Possible values are Equals and Not Equal to if EXPRESSION_TYPE is F and Equals, Not Equal to, Less Than, Less Than or Equal to, Greater Than, Greater Than or Equal to if EXPRESSION_TYPE is C. |
RVALUE | VARCHAR2 | (200) | Yes | Right hand side of expression |
RVALUE_ID | VARCHAR2 | (30) | For expression of type Q for question or C for column. RVALUE_ID will be the same as Rvalue. For expression of type F for function, RVALUE_ID will have an identifier of Rvalue. | |
RBRACKETS | VARCHAR2 | (10) | Field for entering right brackets of expression. A valid right bracket is a right parenthesis. | |
LOGICAL_OPERATOR | VARCHAR2 | (3) | Logical operator joining two expressions. Possible values are AND and OR. | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT RULE_ID
, EXPRESSION_ID
, EXPRESSION_SEQUENCE_NUMBER
, EXPRESSION_TYPE
, LBRACKETS
, LVALUE
, OPERATOR
, RVALUE
, RVALUE_ID
, RBRACKETS
, LOGICAL_OPERATOR
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM IGW.IGW_BUSINESS_RULE_LINES;
IGW.IGW_BUSINESS_RULE_LINES does not reference any database object
IGW.IGW_BUSINESS_RULE_LINES is referenced by following:
|
|
|