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_BATCHES

Object Details

Object Name:	WSH_CONSOL_BATCHES
Object Type:	TABLE
Owner:	WSH
Subobject Name:
Status:	VALID

The table WSH_CONSOL_BATCHES has the consolidation batch records.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WSH_CONSOL_BATCHES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BATCH_ID
WSH_CONSOL_BATCHES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID
WSH_CONSOL_BATCHES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONSOL_GROUPING_RULE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER		Yes	Entity Identifier
ORGANIZATION_ID	NUMBER		Yes	Organization ID of the batch
CONSOL_GROUPING_RULE_ID	NUMBER		Yes	Consolidation Grouping Rule of the batch
CONSOL_SHIP_TO_LOCATION_ID	NUMBER			User Entered consolidation ship-to location for the batch
SHIP_TO_OVERIDE_FLAG	VARCHAR2	(1)		Flag to override the delivery level consol location with the user-entered value
DELIVERY_NAME_FROM	VARCHAR2	(30)		Starting name for the range of deliveries to be included for consolidation
DELIVERY_NAME_TO	VARCHAR2	(30)		Ending name for the range of deliveries to be included for consolidation
PICKUP_START_DAYS	NUMBER			The deliveries having pickup date after pickup_start_days + sysdate will be consolidated
PICKUP_END_DAYS	NUMBER			The deliveries having pickup date before pickup_end_days + sysdate will be consolidated
DROPOFF_START_DAYS	NUMBER			The deliveries having dropoff date after dropoff_start_days + sysdate will be consolidated
DROPOFF_END_DAYS	NUMBER			The deliveries having dropoff date before dropoff_end_days + sysdate will be consolidated
PR_BATCH_ID	NUMBER			Deliveries belonging to this picking batch will be consolidated
CUSTOMER_ID	NUMBER			Customer for which deliveries need to be consolidated
FOB_CODE	VARCHAR2	(30)		Deliveries having this FOB will be consolidated
FREIGHT_TERMS_CODE	VARCHAR2	(30)		Deliveries having this Freight Term will be consolidated
CARRIER_ID	NUMBER			Deliveries catered by the carrier will be consolidated
MODE_OF_TRANSPORT	VARCHAR2	(30)		Deliveries having this mode of transport will be consolidated
SERVICE_LEVEL	VARCHAR2	(30)		Deliveries having this service level will be consolidated
LOADING_SEQUENCE	NUMBER			Deliveries having the specified loading sequence will be consolidated
INTMED_SHIP_TO_LOCATION_ID	NUMBER			Deliveries to this intermediate location will be consolidated
ULTI_SHIP_TO_LOCATION_ID	NUMBER			Deliveries to this ultimate ship to location id will be consolidated
ULTI_SHIP_TO_REGION	NUMBER			Deliveries to this region will be consolidated
ULTI_SHIP_TO_ZIP_FROM	NUMBER			Start of the range of zip codes of ultimate ship to locations for which deliveries need to be consolidated
ULTI_SHIP_TO_ZIP_TO	NUMBER			End of the range of zip codes of ultimate ship to locations for which deliveries need to be consolidated
ULTI_SHIP_TO_ZONE	NUMBER			Deliveries having ultimate ship to belonging to this zone will be consolidated
INCL_STAGED_DEL_FLAG	VARCHAR2	(1)		Flag to include staged deliveries for consolidation
INCL_DEL_ASG_TRIPS_FLAG	VARCHAR2	(1)		Flag to include deliveries assigned to trip for consolidation
CR_TRIP_TO_ULTM_SHIP_TO	VARCHAR2	(1)		Flag to create deconsolidation trips for the deliveries getting consolidated
ROUTE_TRIPS_FLAG	VARCHAR2	(1)		Flag to route the consolidation and deconsolidation trips created
RATE_TRIPS_FLAG	VARCHAR2	(1)		Flag to rate the consolidation and deconsolidation trips created
TRIP_NAME_PREFIX	VARCHAR2	(30)		Prefix for the consolidation trips being created
MAX_TRIP_WEIGHT	NUMBER			Maximum weight allowed on consolidation trips
MAX_TRIP_WEIGHT_UOM	VARCHAR2	(3)		Unit of measure for the consolidation trip maximum weight
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

Query Text

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


SELECT BATCH_ID
,      ORGANIZATION_ID
,      CONSOL_GROUPING_RULE_ID
,      CONSOL_SHIP_TO_LOCATION_ID
,      SHIP_TO_OVERIDE_FLAG
,      DELIVERY_NAME_FROM
,      DELIVERY_NAME_TO
,      PICKUP_START_DAYS
,      PICKUP_END_DAYS
,      DROPOFF_START_DAYS
,      DROPOFF_END_DAYS
,      PR_BATCH_ID
,      CUSTOMER_ID
,      FOB_CODE
,      FREIGHT_TERMS_CODE
,      CARRIER_ID
,      MODE_OF_TRANSPORT
,      SERVICE_LEVEL
,      LOADING_SEQUENCE
,      INTMED_SHIP_TO_LOCATION_ID
,      ULTI_SHIP_TO_LOCATION_ID
,      ULTI_SHIP_TO_REGION
,      ULTI_SHIP_TO_ZIP_FROM
,      ULTI_SHIP_TO_ZIP_TO
,      ULTI_SHIP_TO_ZONE
,      INCL_STAGED_DEL_FLAG
,      INCL_DEL_ASG_TRIPS_FLAG
,      CR_TRIP_TO_ULTM_SHIP_TO
,      ROUTE_TRIPS_FLAG
,      RATE_TRIPS_FLAG
,      TRIP_NAME_PREFIX
,      MAX_TRIP_WEIGHT
,      MAX_TRIP_WEIGHT_UOM
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM WSH.WSH_CONSOL_BATCHES;

Dependencies

[top of page]

WSH.WSH_CONSOL_BATCHES does not reference any database object

WSH.WSH_CONSOL_BATCHES is referenced by following:

APPS: WSH_CONSOL_BATCHES