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