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: WSH.WSH_CONSOL_GROUPING_RULES

Object Details

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.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WSH_CONSOL_GROUPING_RULES_U1	NORMAL	NONUNIQUE	APPS_TS_SEED	CONSOL_GROUPING_RULE_ID

Columns

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

Query Text

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;

Dependencies

[top of page]

WSH.WSH_CONSOL_GROUPING_RULES does not reference any database object

WSH.WSH_CONSOL_GROUPING_RULES is referenced by following:

WSH: WSH_CONSOL_GROUPING_RULES#