[Home] [Help] [Dependency Information]
Object Name: | WSH_CONSOL_BATCHES# |
---|---|
Object Type: | VIEW |
Owner: | WSH |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | Yes | ||
ORGANIZATION_ID | NUMBER | Yes | ||
CONSOL_GROUPING_RULE_ID | NUMBER | Yes | ||
CONSOL_SHIP_TO_LOCATION_ID | NUMBER | |||
SHIP_TO_OVERIDE_FLAG | VARCHAR2 | (1) | ||
DELIVERY_NAME_FROM | VARCHAR2 | (30) | ||
DELIVERY_NAME_TO | VARCHAR2 | (30) | ||
PICKUP_START_DAYS | NUMBER | |||
PICKUP_END_DAYS | NUMBER | |||
DROPOFF_START_DAYS | NUMBER | |||
DROPOFF_END_DAYS | NUMBER | |||
PR_BATCH_ID | NUMBER | |||
CUSTOMER_ID | NUMBER | |||
FOB_CODE | VARCHAR2 | (30) | ||
FREIGHT_TERMS_CODE | VARCHAR2 | (30) | ||
CARRIER_ID | NUMBER | |||
MODE_OF_TRANSPORT | VARCHAR2 | (30) | ||
SERVICE_LEVEL | VARCHAR2 | (30) | ||
LOADING_SEQUENCE | NUMBER | |||
INTMED_SHIP_TO_LOCATION_ID | NUMBER | |||
ULTI_SHIP_TO_LOCATION_ID | NUMBER | |||
ULTI_SHIP_TO_REGION | NUMBER | |||
ULTI_SHIP_TO_ZIP_FROM | NUMBER | |||
ULTI_SHIP_TO_ZIP_TO | NUMBER | |||
ULTI_SHIP_TO_ZONE | NUMBER | |||
INCL_STAGED_DEL_FLAG | VARCHAR2 | (1) | ||
INCL_DEL_ASG_TRIPS_FLAG | VARCHAR2 | (1) | ||
CR_TRIP_TO_ULTM_SHIP_TO | VARCHAR2 | (1) | ||
ROUTE_TRIPS_FLAG | VARCHAR2 | (1) | ||
RATE_TRIPS_FLAG | VARCHAR2 | (1) | ||
TRIP_NAME_PREFIX | VARCHAR2 | (30) | ||
MAX_TRIP_WEIGHT | NUMBER | |||
MAX_TRIP_WEIGHT_UOM | VARCHAR2 | (3) | ||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER |
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#;
|
|
|