[Home] [Help] [Dependency Information]
Object Name: | IGW_BUSINESS_RULES_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGW |
FND Design Data: | IGW.IGW_BUSINESS_RULES_ALL |
Subobject Name: | |
Status: | VALID |
IGW_BUSINESS_RULES_ALL stores business rules for organizations.
The three kinds of business rules are validation, notification, and routing. This table contains
information about which routing maps to use for the routing and notificaton business rules.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGW_BUSINESS_RULES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | RULE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_ID | NUMBER | (10) | Yes | Rule identifier |
RULE_SEQUENCE_NUMBER | NUMBER | (4) | Rule sequence number | |
ORGANIZATION_ID | NUMBER | (15) | Yes | Organization identifier |
ORG_ID | NUMBER | (15) | Operating unit identifier for multiple organizations | |
RULE_NAME | VARCHAR2 | (50) | Yes | Rule name |
RULE_TYPE | VARCHAR2 | (1) | Yes | Type of rule. N means Notification, R means Routing, and V means Validation. |
MAP_ID | NUMBER | (10) | Map identifier | |
VALID_FLAG | VARCHAR2 | (1) | Flag that determines if proposal is valid or invalid if validation business rule evaluates to True. Possible values are V for Valid and I for Invalid. | |
START_DATE_ACTIVE | DATE | Yes | First effective date of a rule | |
END_DATE_ACTIVE | DATE | Last effective date of a rule | ||
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
, RULE_SEQUENCE_NUMBER
, ORGANIZATION_ID
, ORG_ID
, RULE_NAME
, RULE_TYPE
, MAP_ID
, VALID_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM IGW.IGW_BUSINESS_RULES_ALL;
IGW.IGW_BUSINESS_RULES_ALL does not reference any database object
IGW.IGW_BUSINESS_RULES_ALL is referenced by following:
|
|
|