[Home] [Help] [Dependency Information]
Object Name: | WSH_CONSOL_GROUPING_RULES |
---|---|
Object Type: | TABLE |
Owner: | WSH |
Subobject Name: | |
Status: | VALID |
The table WSH_CONSOL_GROUPING_RULES has rules for grouping deliveries into their own consolidations.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WSH_CONSOL_GROUPING_RULES_U1 | NORMAL | NONUNIQUE | APPS_TS_SEED | CONSOL_GROUPING_RULE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONSOL_GROUPING_RULE_ID | NUMBER | Yes | Entity identifier | |
RULE_NAME | VARCHAR2 | (30) | Yes | Consolidation Grouping Rule Name |
START_DATE_ACTIVE | DATE | Yes | Date from which the Grouping Rule becomes active | |
END_DATE_ACTIVE | DATE | Date on which the grouping rule becomes inactive | ||
SHIP_FROM_FLAG | VARCHAR2 | (1) | Yes | Ship From Location is the mandatory attribute in a grouping rule |
CUSTOMER_FLAG | VARCHAR2 | (1) | Flag to include customer as a grouping criterion | |
INTMED_SHIP_TO_FLAG | VARCHAR2 | (1) | Yes | Intermediate ship to location is a mandatory grouping |
CARRIER_FLAG | VARCHAR2 | (1) | Flag to include carrier as a grouping criterion | |
MODE_OF_TRANSPORT_FLAG | VARCHAR2 | (1) | Flag to include mode of transport as a grouping criterion | |
SERVICE_LEVEL_FLAG | VARCHAR2 | (1) | Flag to include service level as a grouping criterion | |
FOB_FLAG | VARCHAR2 | (1) | Flag to include FOB as a grouping criterion | |
FREIGHT_TERMS_FLAG | VARCHAR2 | (1) | Flag to include Freight Terms as a grouping criterion | |
LOADING_SEQUENCE_FLAG | VARCHAR2 | (1) | Flag to include loading sequence as a grouping criterion | |
SHIP_TO_CODE | VARCHAR2 | (1) | Flag to include Ship-To location as a grouping criterion. The following are the valid values:L: Ship to location is selected.R: Ship to region is selected.X: Ship to zone is selected. | |
SHIP_TO_COUNTRY_FLAG | VARCHAR2 | (1) | Flag to include Ship-To Region's Country as a grouping criterion | |
SHIP_TO_STATE_FLAG | VARCHAR2 | (1) | Flag to include Ship-To Region's State as a grouping criterion | |
SHIP_TO_CITY_FLAG | VARCHAR2 | (1) | Flag to include Ship-To Region's City as a grouping criterion | |
SHIP_TO_POSTAL_CODE_FLAG | VARCHAR2 | (1) | Flag to include Ship-To Region's postal code as a grouping criterion | |
SHIP_TO_ZONE | NUMBER | Flag to include Ship-To Zone as a grouping criterion | ||
CREATION_DATE | DATE | Standard Who column | ||
CREATED_BY | NUMBER | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield attribute |
Cut, paste (and edit) the following text to query this object:
SELECT CONSOL_GROUPING_RULE_ID
, RULE_NAME
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, SHIP_FROM_FLAG
, CUSTOMER_FLAG
, INTMED_SHIP_TO_FLAG
, CARRIER_FLAG
, MODE_OF_TRANSPORT_FLAG
, SERVICE_LEVEL_FLAG
, FOB_FLAG
, FREIGHT_TERMS_FLAG
, LOADING_SEQUENCE_FLAG
, SHIP_TO_CODE
, SHIP_TO_COUNTRY_FLAG
, SHIP_TO_STATE_FLAG
, SHIP_TO_CITY_FLAG
, SHIP_TO_POSTAL_CODE_FLAG
, SHIP_TO_ZONE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM WSH.WSH_CONSOL_GROUPING_RULES;
WSH.WSH_CONSOL_GROUPING_RULES does not reference any database object
WSH.WSH_CONSOL_GROUPING_RULES is referenced by following:
|
|
|