Search Results wsh_new_deliveries
I'll provide a comprehensive description of the WSH_NEW_DELIVERIES table in Oracle EBS (E-Business Suite), typically used in the Shipping and Logistics modules:
Table Name: WSH_NEW_DELIVERIES
Purpose:
- Tracks new delivery information in the Shipping and Warehouse Management module
- Stores details about delivery transactions and shipments
Key Columns:
1. DELIVERY_ID (Primary Key)
- Unique identifier for each delivery
- Sequentially generated
2. ORGANIZATION_ID
- Links to inventory organization
- Identifies the shipping location/warehouse
3. CUSTOMER_ID
- References customer information
- Connects to AR_CUSTOMERS table
4. DELIVERY_TYPE
- Classifies type of delivery (e.g., Sales, Transfer, Return)
5. STATUS_CODE
- Current status of delivery (e.g., Open, Closed, In-Transit)
6. SHIPPING_METHOD_CODE
- Indicates shipping method/carrier
7. FREIGHT_TERMS_CODE
- Defines freight payment terms
8. REQUEST_DATE
- Date delivery was initially requested
9. ACTUAL_SHIPMENT_DATE
- Date shipment was actually processed
10. CREATION_DATE
- Timestamp of delivery record creation
Common Usage:
- Tracks shipment progress
- Manages delivery logistics
- Supports order fulfillment processes
Related Tables:
- WSH_DELIVERY_DETAILS
- SO_HEADERS_ALL
- MTL_MATERIAL_TRANSACTIONS
Typical Constraints:
- Foreign key relationships
- Not null constraints
- Check constraints on status codes
Note: Specific column details might vary slightly based on your Oracle EBS version and customizations.
-
Table: WSH_NEW_DELIVERIES
12.1.1
owner:WSH, object_type:TABLE, fnd_design_data:WSH.WSH_NEW_DELIVERIES, object_name:WSH_NEW_DELIVERIES, status:VALID, product: WSH - Shipping Execution , description: Deliveries , implementation_dba_data: WSH.WSH_NEW_DELIVERIES ,
-
Table: WSH_NEW_DELIVERIES
12.2.2
owner:WSH, object_type:TABLE, fnd_design_data:WSH.WSH_NEW_DELIVERIES, object_name:WSH_NEW_DELIVERIES, status:VALID, product: WSH - Shipping Execution , description: Deliveries , implementation_dba_data: WSH.WSH_NEW_DELIVERIES ,
-
APPS.JL_ZZ_RECEIV_INTERFACE dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.OKE_FORM_DD250 dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_CONTAINER_UTILITIES dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_OTM_INBOUND_GRP dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_DELIVERY_VALIDATIONS dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_DELIVERY_DETAILS_UTILITIES dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WMS_RFID_DEVICE_PUB dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_WF dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_WSHRDVLS_XMLP_PKG dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.FTE_TL_RATING dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.GMI_UPDATE_ORDER dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_INV_INTEGRATION_GRP dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_CONTAINER_ACTIONS dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.GMD_COA_DATA_OM dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_DELIVERY_DETAILS_PKG dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_INTEGRATION dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WMS_REPLENISHMENT_PVT dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_ROUTING_RESPONSE_PKG dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.FTE_FREIGHT_RATING_DLVY_GRP dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.INV_UI_ITEM_LOVS dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_DELIVERIES_PUB dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_WMS_LPN_GRP dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.CLN_SHOWSHIP_PKG dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_INTERFACE_VALIDATIONS_PKG dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.GMD_COA_DATA_OM dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_TRIPS_GRP dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_FREIGHT_COSTS_PVT dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_PICK_LIST dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_FTE_COMP_CONSTRAINT_PKG dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_FTE_COMP_CONSTRAINT_GRP dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.CSD_UPDATE_PROGRAMS_PVT dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_NEW_DELIVERIES_PVT dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.WSH_SHIP_CONFIRM_ACTIONS2 dependencies on WSH_NEW_DELIVERIES
12.1.1
-
APPS.CSD_PROCESS_PVT dependencies on WSH_NEW_DELIVERIES
12.2.2
-
APPS.WSH_DELIVERIES_PUB dependencies on WSH_NEW_DELIVERIES
12.2.2
-
APPS.WSH_RLM_INTERFACE dependencies on WSH_NEW_DELIVERIES
12.2.2
-
APPS.WSH_INBOUND_UTIL_PKG dependencies on WSH_NEW_DELIVERIES
12.2.2
-
APPS.WSH_WF_INTERFACE dependencies on WSH_NEW_DELIVERIES
12.2.2
-
APPS.WSH_DOCUMENT_SETS dependencies on WSH_NEW_DELIVERIES
12.2.2
-
APPS.QA_ERES_SHIPPING dependencies on WSH_NEW_DELIVERIES
12.2.2
-
APPS.JA_JAINARE1_XMLP_PKG dependencies on WSH_NEW_DELIVERIES
12.2.2
-
APPS.FTE_TRIP_RATING_GRP dependencies on WSH_NEW_DELIVERIES
12.2.2
-
APPS.WSH_DETAILS_VALIDATIONS dependencies on WSH_NEW_DELIVERIES
12.2.2
-
APPS.WSH_PACKING_SLIPS_PVT dependencies on WSH_NEW_DELIVERIES
12.2.2
-
APPS.WSH_ECE_VIEWS_DEF dependencies on WSH_NEW_DELIVERIES
12.2.2
-
APPS.WSH_NEW_DELIVERIES_PVT dependencies on WSH_NEW_DELIVERIES
12.2.2
-
APPS.GMD_COA_DATA_OM_NEW dependencies on WSH_NEW_DELIVERIES
12.2.2