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_NEW_DELIVERIES

Object Details

Object Name:	WSH_NEW_DELIVERIES
Object Type:	TABLE
Owner:	WSH
FND Design Data:	WSH.WSH_NEW_DELIVERIES
Subobject Name:
Status:	VALID

WSH_NEW_DELIVERIES has the delivery records.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WSH_NEW_DELIVERIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DELIVERY_ID
WSH_NEW_DELIVERIES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	NAME
WSH_NEW_DELIVERIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS_CODE ULTIMATE_DROPOFF_LOCATION_ID
WSH_NEW_DELIVERIES_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASN_SHIPMENT_HEADER_ID
WSH_NEW_DELIVERIES_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RCV_SHIPMENT_HEADER_ID
WSH_NEW_DELIVERIES_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TMS_INTERFACE_FLAG
WSH_NEW_DELIVERIES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ROUTING_RESPONSE_ID
WSH_NEW_DELIVERIES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID
WSH_NEW_DELIVERIES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIP_METHOD_CODE
WSH_NEW_DELIVERIES_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID HASH_VALUE
WSH_NEW_DELIVERIES_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INITIAL_PICKUP_DATE
WSH_NEW_DELIVERIES_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID HASH_VALUE
WSH_NEW_DELIVERIES_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AP_BATCH_ID
WSH_NEW_DELIVERIES_N98	NORMAL	NONUNIQUE	APPS_TS_TX_DATA	LATEST_PICKUP_DATE
WSH_NEW_DELIVERIES_N99	NORMAL	NONUNIQUE	APPS_TS_TX_DATA	TP_PLAN_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
DELIVERY_ID	NUMBER		Yes	Primary Key to identify delivery
NAME	VARCHAR2	(30)	Yes	Unique Delivery Name
PLANNED_FLAG	VARCHAR2	(1)	Yes	Planned flag (N = unplanned; Y = planned)
STATUS_CODE	VARCHAR2	(2)	Yes	Delivery shipping status ,e.g., OP for Open delivery
INITIAL_PICKUP_DATE	DATE			Date on which the delivery is first picked up
INITIAL_PICKUP_LOCATION_ID	NUMBER		Yes	Initial Pick-up location of delivery
ULTIMATE_DROPOFF_LOCATION_ID	NUMBER		Yes	Final Drop-off location of delivery
ULTIMATE_DROPOFF_DATE	DATE			Date on which the delivery is finally dropped off
CUSTOMER_ID	NUMBER			Foreign Key to HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID
INTMED_SHIP_TO_LOCATION_ID	NUMBER			Intermediate ship-to location of delivery
POOLED_SHIP_TO_LOCATION_ID	NUMBER			(Auto) Pooled ship-to location of delivery
FREIGHT_TERMS_CODE	VARCHAR2	(30)		Freight Terms Code
FOB_CODE	VARCHAR2	(30)		Freight On Board code
FOB_LOCATION_ID	NUMBER			Freight On Board location
WAYBILL	VARCHAR2	(30)		May be the tracking number
ACCEPTANCE_FLAG	VARCHAR2	(1)		Y-goods are accepted
ACCEPTED_BY	VARCHAR2	(150)		Name of party accepting the goods
ACCEPTED_DATE	DATE			Date on which the goods were accepted
ACKNOWLEDGED_BY	VARCHAR2	(150)		Name of party acknowledging the goods
CONFIRMED_BY	VARCHAR2	(150)		The Shipper of the goods
ASN_DATE_SENT	DATE			Date the ASN was sent
ASN_STATUS_CODE	VARCHAR2	(15)		PENDING, SENT, CANCELLED
ASN_SEQ_NUMBER	NUMBER			ASN Sequence Number
REASON_OF_TRANSPORT	VARCHAR2	(30)		Reason of Transport
DESCRIPTION	VARCHAR2	(30)		External aspect of delivery
GROSS_WEIGHT	NUMBER			Gross Weight
NET_WEIGHT	NUMBER			Net Weight
WEIGHT_UOM_CODE	VARCHAR2	(3)		Unit of Measure for weight
VOLUME	NUMBER			Volume
VOLUME_UOM_CODE	VARCHAR2	(3)		Unit of Measure for volume
ADDITIONAL_SHIPMENT_INFO	VARCHAR2	(500)		Additional Shipment Information
PORT_OF_DISCHARGE	VARCHAR2	(150)		Port of Discharge
BOOKING_NUMBER	VARCHAR2	(30)		Carrier booking number
COD_AMOUNT	NUMBER			Cash on Delivery Amount
COD_CURRENCY_CODE	VARCHAR2	(15)		Currency Code for COD Amount
SERVICE_CONTRACT	VARCHAR2	(30)		Carrier service contract
COD_REMIT_TO	VARCHAR2	(150)		Person to remit to for COD Amount
COD_CHARGE_PAID_BY	VARCHAR2	(150)		Person paying the COD Charge
PROBLEM_CONTACT_REFERENCE	VARCHAR2	(500)		Problem Contact Reference person
BILL_FREIGHT_TO	VARCHAR2	(1000)		Bill Freight to
CARRIED_BY	VARCHAR2	(150)		Person carrying goods
PORT_OF_LOADING	VARCHAR2	(150)		Port of Loading
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive Flexfield category
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment
TP_ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Trading Partner Descriptive Flexfield category
TP_ATTRIBUTE1	VARCHAR2	(150)		Trading Partner Descriptive Flexfield segment
TP_ATTRIBUTE2	VARCHAR2	(150)		Trading Partner Descriptive Flexfield segment
TP_ATTRIBUTE3	VARCHAR2	(150)		Trading Partner Descriptive Flexfield segment
TP_ATTRIBUTE4	VARCHAR2	(150)		Trading Partner Descriptive Flexfield segment
TP_ATTRIBUTE5	VARCHAR2	(150)		Trading Partner Descriptive Flexfield segment
TP_ATTRIBUTE6	VARCHAR2	(150)		Trading Partner Descriptive Flexfield segment
TP_ATTRIBUTE7	VARCHAR2	(150)		Trading Partner Descriptive Flexfield segment
TP_ATTRIBUTE8	VARCHAR2	(150)		Trading Partner Descriptive Flexfield segment
TP_ATTRIBUTE9	VARCHAR2	(150)		Trading Partner Descriptive Flexfield segment
TP_ATTRIBUTE10	VARCHAR2	(150)		Trading Partner Descriptive Flexfield segment
TP_ATTRIBUTE11	VARCHAR2	(150)		Trading Partner Descriptive Flexfield segment
TP_ATTRIBUTE12	VARCHAR2	(150)		Trading Partner Descriptive Flexfield segment
TP_ATTRIBUTE13	VARCHAR2	(150)		Trading Partner Descriptive Flexfield segment
TP_ATTRIBUTE14	VARCHAR2	(150)		Trading Partner Descriptive Flexfield segment
TP_ATTRIBUTE15	VARCHAR2	(150)		Trading Partner Descriptive Flexfield segment
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column
PROGRAM_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
REQUEST_ID	NUMBER			Standard Who column
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved for country-specific functionality
CONFIRM_DATE	DATE			Date the delivery was confirmed
SHIP_METHOD_CODE	VARCHAR2	(30)		Shipping Method
DOCK_CODE	VARCHAR2	(30)		Customer dock code
DELIVERY_TYPE	VARCHAR2	(30)	Yes	Type of delivery - STANDARD, CONSOLIDATED
CARRIER_ID	NUMBER			Freight Carrier
CURRENCY_CODE	VARCHAR2	(15)		Currency code for freight costs
ORGANIZATION_ID	NUMBER			Organization identifier
LOADING_SEQUENCE	NUMBER			Sequence with which it is loaded in truck
LOADING_ORDER_FLAG	VARCHAR2	(2)		Sequence in which delivery details are to be loaded within delivery
NUMBER_OF_LPN	NUMBER			Number of LPNs in Delivery
BATCH_ID	NUMBER			Foreign key to WSH_PICKING_BATCHES
SOURCE_HEADER_ID	NUMBER			Header Id of the Order lines associated to this delivery
HASH_VALUE	NUMBER			Hash Value of the Delivery Grouping Attributes
FTZ_NUMBER	VARCHAR2	(35)		Foreign Trade Zone Identifier
ROUTED_EXPORT_TXN	VARCHAR2	(1)		Export Transaction is routed or not.
ENTRY_NUMBER	VARCHAR2	(35)		Entry Number for the Delivery
ROUTING_INSTRUCTIONS	VARCHAR2	(120)		Routing Instructions for Delivery
IN_BOND_CODE	VARCHAR2	(35)		In Bond Code for Delivery
SHIPPING_MARKS	VARCHAR2	(100)		Shipping Marks
SERVICE_LEVEL	VARCHAR2	(30)		Service Level for Ship Method
MODE_OF_TRANSPORT	VARCHAR2	(30)		Mode of Transport for Ship Method
ASSIGNED_TO_FTE_TRIPS	VARCHAR2	(1)		assigned to FTE Trips flag (Y - assigned to FTE trips, N - Not assigned to FTE trips)
AUTO_SC_EXCLUDE_FLAG	VARCHAR2	(1)		Y - exclude this record from Automated Ship Confirm
AUTO_AP_EXCLUDE_FLAG	VARCHAR2	(1)		Y - exclude this record from Automated Autopack
AP_BATCH_ID	NUMBER			Foreign key to WSH_PICKING_BATCHES for autopack batch
TP_DELIVERY_NUMBER	NUMBER			Delivery number in Transportation Planning
TP_PLAN_NAME	VARCHAR2	(10)		Plan name from which this delivery is released from Transportation Planning
VENDOR_ID	NUMBER			Ship from supplier or ship to supplier for return to supplier or shipment from supplier case
EARLIEST_PICKUP_DATE	DATE			Date on which this delivery is to be first picked up
LATEST_PICKUP_DATE	DATE			Latest date on which this delivery can be picked up
EARLIEST_DROPOFF_DATE	DATE			Earliest date on which the package needs to be delivered
LATEST_DROPOFF_DATE	DATE			Latest date at which this delivery is to be delivered to customer
IGNORE_FOR_PLANNING	VARCHAR2	(1)		Y= Transportation Planning will ignore, N= Transportation Planning will use
PARTY_ID	NUMBER			Party linked to vendor
ROUTING_RESPONSE_ID	NUMBER			Routing response sent to supplier
RCV_SHIPMENT_HEADER_ID	NUMBER			Reference to RCV shipment header
ASN_SHIPMENT_HEADER_ID	NUMBER			Reference to ASN header
SHIPMENT_DIRECTION	VARCHAR2	(30)		I=Inbound, O= Outbound, IO= Internal Sales Order, D= Drop shipment
SHIPPING_CONTROL	VARCHAR2	(30)		Shipment is managed by Buyer/Supplier
WV_FROZEN_FLAG	VARCHAR2	(1)		'Y' if the W/V is entered manually. 'N' if the W/V is automatically computed by system
HASH_STRING	VARCHAR2	(1000)		Hash String of the Delivery Grouping Attributes
ITINERARY_COMPLETE	VARCHAR2	(1)		Flag to indicate if itinerary by delivery legs is complete (Y) or not (N)
DELIVERED_DATE	DATE			Date Shipment Delivered to Customer
DELIVERY_WF_PROCESS	VARCHAR2	(30)		Stores Workflow process name selected for the delivery, if ever a workflow was instantiated for this delivery
DEL_WF_INTRANSIT_ATTR	VARCHAR2	(1)		Stores the Progress Status of Sub-Controlling Workflow Process, which marks Delivery as Intransit.
DEL_WF_INTERFACE_ATTR	VARCHAR2	(1)		Stores the Progress Status of Sub-Controlling Workflow Process, which marks Delivery as Interfaced
DEL_WF_CLOSE_ATTR	VARCHAR2	(1)		Stores the Progress Status of Sub-Controlling Workflow Process, which marks Delivery as Closed.
DELIVERY_SCPOD_WF_PROCESS	VARCHAR2	(30)		Stores the Controlling Workflow process name for the delivery, if it was instantiated for this delivery
TMS_VERSION_NUMBER	NUMBER			Version Control
TMS_INTERFACE_FLAG	VARCHAR2	(3)		Interface Action Code used for GC integration
PENDING_ADVICE_FLAG	VARCHAR2	(1)		'Y' if the Shipment Advice is not sent, 'NULL' if Shipment Advice is sent
CLIENT_ID	NUMBER			Client ID
CONSIGNEE_FLAG	VARCHAR2	(1)		'V' if consignee is vendor/supplier else customer

Query Text

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


SELECT DELIVERY_ID
,      NAME
,      PLANNED_FLAG
,      STATUS_CODE
,      INITIAL_PICKUP_DATE
,      INITIAL_PICKUP_LOCATION_ID
,      ULTIMATE_DROPOFF_LOCATION_ID
,      ULTIMATE_DROPOFF_DATE
,      CUSTOMER_ID
,      INTMED_SHIP_TO_LOCATION_ID
,      POOLED_SHIP_TO_LOCATION_ID
,      FREIGHT_TERMS_CODE
,      FOB_CODE
,      FOB_LOCATION_ID
,      WAYBILL
,      ACCEPTANCE_FLAG
,      ACCEPTED_BY
,      ACCEPTED_DATE
,      ACKNOWLEDGED_BY
,      CONFIRMED_BY
,      ASN_DATE_SENT
,      ASN_STATUS_CODE
,      ASN_SEQ_NUMBER
,      REASON_OF_TRANSPORT
,      DESCRIPTION
,      GROSS_WEIGHT
,      NET_WEIGHT
,      WEIGHT_UOM_CODE
,      VOLUME
,      VOLUME_UOM_CODE
,      ADDITIONAL_SHIPMENT_INFO
,      PORT_OF_DISCHARGE
,      BOOKING_NUMBER
,      COD_AMOUNT
,      COD_CURRENCY_CODE
,      SERVICE_CONTRACT
,      COD_REMIT_TO
,      COD_CHARGE_PAID_BY
,      PROBLEM_CONTACT_REFERENCE
,      BILL_FREIGHT_TO
,      CARRIED_BY
,      PORT_OF_LOADING
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      TP_ATTRIBUTE_CATEGORY
,      TP_ATTRIBUTE1
,      TP_ATTRIBUTE2
,      TP_ATTRIBUTE3
,      TP_ATTRIBUTE4
,      TP_ATTRIBUTE5
,      TP_ATTRIBUTE6
,      TP_ATTRIBUTE7
,      TP_ATTRIBUTE8
,      TP_ATTRIBUTE9
,      TP_ATTRIBUTE10
,      TP_ATTRIBUTE11
,      TP_ATTRIBUTE12
,      TP_ATTRIBUTE13
,      TP_ATTRIBUTE14
,      TP_ATTRIBUTE15
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      CONFIRM_DATE
,      SHIP_METHOD_CODE
,      DOCK_CODE
,      DELIVERY_TYPE
,      CARRIER_ID
,      CURRENCY_CODE
,      ORGANIZATION_ID
,      LOADING_SEQUENCE
,      LOADING_ORDER_FLAG
,      NUMBER_OF_LPN
,      BATCH_ID
,      SOURCE_HEADER_ID
,      HASH_VALUE
,      FTZ_NUMBER
,      ROUTED_EXPORT_TXN
,      ENTRY_NUMBER
,      ROUTING_INSTRUCTIONS
,      IN_BOND_CODE
,      SHIPPING_MARKS
,      SERVICE_LEVEL
,      MODE_OF_TRANSPORT
,      ASSIGNED_TO_FTE_TRIPS
,      AUTO_SC_EXCLUDE_FLAG
,      AUTO_AP_EXCLUDE_FLAG
,      AP_BATCH_ID
,      TP_DELIVERY_NUMBER
,      TP_PLAN_NAME
,      VENDOR_ID
,      EARLIEST_PICKUP_DATE
,      LATEST_PICKUP_DATE
,      EARLIEST_DROPOFF_DATE
,      LATEST_DROPOFF_DATE
,      IGNORE_FOR_PLANNING
,      PARTY_ID
,      ROUTING_RESPONSE_ID
,      RCV_SHIPMENT_HEADER_ID
,      ASN_SHIPMENT_HEADER_ID
,      SHIPMENT_DIRECTION
,      SHIPPING_CONTROL
,      WV_FROZEN_FLAG
,      HASH_STRING
,      ITINERARY_COMPLETE
,      DELIVERED_DATE
,      DELIVERY_WF_PROCESS
,      DEL_WF_INTRANSIT_ATTR
,      DEL_WF_INTERFACE_ATTR
,      DEL_WF_CLOSE_ATTR
,      DELIVERY_SCPOD_WF_PROCESS
,      TMS_VERSION_NUMBER
,      TMS_INTERFACE_FLAG
,      PENDING_ADVICE_FLAG
,      CLIENT_ID
,      CONSIGNEE_FLAG
FROM WSH.WSH_NEW_DELIVERIES;

Dependencies

[top of page]

WSH.WSH_NEW_DELIVERIES does not reference any database object

WSH.WSH_NEW_DELIVERIES is referenced by following:

WSH: WSH_NEW_DELIVERIES#