[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | WSH_DELIVERY_DETAILS |
|---|---|
| Object Type: | TABLE |
| Owner: | WSH |
| FND Design Data: |  WSH.WSH_DELIVERY_DETAILS
|
| Subobject Name: | |
| Status: | VALID |
WSH_DELIVERY_DETAILS has delivery lines and LPNs.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| WSH_DELIVERY_DETAILS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 DELIVERY_DETAIL_ID
|
| WSH_DELIVERY_DETAILS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DATE_SCHEDULED
|
| WSH_DELIVERY_DETAILS_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CONTAINER_FLAG
|
| WSH_DELIVERY_DETAILS_N12 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SOURCE_HEADER_NUMBER
|
| WSH_DELIVERY_DETAILS_N13 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TOP_MODEL_LINE_ID
|
| WSH_DELIVERY_DETAILS_N14 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INV_INTERFACED_FLAG
|
| WSH_DELIVERY_DETAILS_N15 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DELIVER_TO_LOCATION_ID
DELIVER_TO_SITE_USE_ID
|
| WSH_DELIVERY_DETAILS_N16 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LPN_ID
|
| WSH_DELIVERY_DETAILS_N17 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ROUTING_REQ_ID
|
| WSH_DELIVERY_DETAILS_N18 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BATCH_ID
|
| WSH_DELIVERY_DETAILS_N19 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CONTAINER_NAME
|
| WSH_DELIVERY_DETAILS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SOURCE_HEADER_ID
|
| WSH_DELIVERY_DETAILS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SOURCE_LINE_ID
|
| WSH_DELIVERY_DETAILS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CUSTOMER_ID
|
| WSH_DELIVERY_DETAILS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SHIP_FROM_LOCATION_ID
|
| WSH_DELIVERY_DETAILS_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SHIP_TO_LOCATION_ID
SHIP_TO_SITE_USE_ID
|
| WSH_DELIVERY_DETAILS_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
MOVE_ORDER_LINE_ID
|
| WSH_DELIVERY_DETAILS_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RELEASED_STATUS
ORGANIZATION_ID
|
| WSH_DELIVERY_DETAILS_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INVENTORY_ITEM_ID
ORGANIZATION_ID
SHIP_FROM_LOCATION_ID
RELEASED_STATUS
|
| WSH_DELIVERY_DETAILS_N99 | NORMAL | NONUNIQUE |
APPS_TS_TX_DATA
|
LATEST_PICKUP_DATE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| DELIVERY_DETAIL_ID | NUMBER | Yes | Primary Key to identify delivery line | |
| SOURCE_CODE | VARCHAR2 | (30) | Yes | OE/WIP/PO |
| SOURCE_HEADER_ID | NUMBER | For example, it can be sale order header ID | ||
| SOURCE_LINE_ID | NUMBER | Yes | OE, WIP, or PO line identifier. For example, it can be sales order line ID | |
| SOURCE_HEADER_TYPE_ID | NUMBER | OE: Order_Type_Id | ||
| SOURCE_HEADER_TYPE_NAME | VARCHAR2 | (240) | OE: Order_Type_Name | |
| CUST_PO_NUMBER | VARCHAR2 | (50) | OE: PO Number the line belongs to | |
| CUSTOMER_ID | NUMBER | Foreign Key to HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID | ||
| SOLD_TO_CONTACT_ID | NUMBER | Identifier for sold to contact | ||
| INVENTORY_ITEM_ID | NUMBER | Foreign key to MTL_SYSTEM_ITEMS | ||
| ITEM_DESCRIPTION | VARCHAR2 | (250) | Item description | |
| SHIP_SET_ID | NUMBER | Ship set identifier for lines which needs to be shipped together | ||
| ARRIVAL_SET_ID | NUMBER | Arrival set identifier for lines which needs to be shipped together | ||
| TOP_MODEL_LINE_ID | NUMBER | Line identifier for PTO items | ||
| ATO_LINE_ID | NUMBER | Line identifier for ATO items | ||
| HOLD_CODE | VARCHAR2 | (1) | Hold code | |
| SHIP_MODEL_COMPLETE_FLAG | VARCHAR2 | (1) | Flag to indicate if ship model is completed | |
| HAZARD_CLASS_ID | NUMBER | Hazardous material Code? | ||
| COUNTRY_OF_ORIGIN | VARCHAR2 | (50) | Contry of origin | |
| CLASSIFICATION | VARCHAR2 | (30) | Classification of type of goods | |
| SHIP_FROM_LOCATION_ID | NUMBER | Yes | Location identifier of shipping from warehouse | |
| ORGANIZATION_ID | NUMBER | Organization identifier | ||
| SHIP_TO_LOCATION_ID | NUMBER | Location identifier for ship to destination | ||
| SHIP_TO_CONTACT_ID | NUMBER | Contact identifier for ship to destination | ||
| DELIVER_TO_LOCATION_ID | NUMBER | Location identifier for deliver to destination | ||
| DELIVER_TO_CONTACT_ID | NUMBER | Contact identifier for deliver to destination | ||
| INTMED_SHIP_TO_LOCATION_ID | NUMBER | Location identifier for intermediate ship to destination | ||
| INTMED_SHIP_TO_CONTACT_ID | NUMBER | Contact identifier for ship to destination | ||
| SHIP_TOLERANCE_ABOVE | NUMBER | Overshipment tolerance percentage | ||
| SHIP_TOLERANCE_BELOW | NUMBER | Undershipment tolerance percentage | ||
| SRC_REQUESTED_QUANTITY | NUMBER | As ordered by customer | ||
| SRC_REQUESTED_QUANTITY_UOM | VARCHAR2 | (3) | As ordered by customer uom | |
| CANCELLED_QUANTITY | NUMBER | Quantity being cancelled | ||
| REQUESTED_QUANTITY | NUMBER | Yes | As shipping quantity for customer | |
| REQUESTED_QUANTITY_UOM | VARCHAR2 | (3) | Yes | Unit of measure for requested quantity |
| SHIPPED_QUANTITY | NUMBER | In shipping_quantity_UOM | ||
| DELIVERED_QUANTITY | NUMBER | In shipping_quantity_uom | ||
| QUALITY_CONTROL_QUANTITY | NUMBER | In requested_quantity_uom | ||
| CYCLE_COUNT_QUANTITY | NUMBER | In requested_quantity_uom | ||
| MOVE_ORDER_LINE_ID | NUMBER | Move order line identifier | ||
| SUBINVENTORY | VARCHAR2 | (10) | Subinventory of item | |
| REVISION | VARCHAR2 | (3) | Revision of item | |
| LOT_NUMBER | VARCHAR2 | (80) | Lot number of item | |
| RELEASED_STATUS | VARCHAR2 | (1) | Pick Release Status | |
| CUSTOMER_REQUESTED_LOT_FLAG | VARCHAR2 | (1) | Indicates the customer specified the lot, rather than pick release rules | |
| SERIAL_NUMBER | VARCHAR2 | (30) | Serial number of item | |
| LOCATOR_ID | NUMBER | Locator of item | ||
| DATE_REQUESTED | DATE | Date on which the line is requested | ||
| DATE_SCHEDULED | DATE | Date on which the line is scheduled | ||
| MASTER_CONTAINER_ITEM_ID | NUMBER | Master container item identifier | ||
| DETAIL_CONTAINER_ITEM_ID | NUMBER | Detail container item identifier | ||
| LOAD_SEQ_NUMBER | NUMBER | Load sequence number | ||
| SHIP_METHOD_CODE | VARCHAR2 | (30) | Ship method | |
| CARRIER_ID | NUMBER | Freight carrier | ||
| FREIGHT_TERMS_CODE | VARCHAR2 | (30) | Freight terms code | |
| SHIPMENT_PRIORITY_CODE | VARCHAR2 | (30) | Shipment priority | |
| FOB_CODE | VARCHAR2 | (30) | Freight on board code | |
| CUSTOMER_ITEM_ID | NUMBER | Foreign key to MTL_CUSTOMER_ITEMS | ||
| DEP_PLAN_REQUIRED_FLAG | VARCHAR2 | (1) | Indicates if departure planning is required | |
| CUSTOMER_PROD_SEQ | VARCHAR2 | (50) | Customer prod sequence | |
| CUSTOMER_DOCK_CODE | VARCHAR2 | (50) | Customer dock code | |
| NET_WEIGHT | NUMBER | Container Net and Loose Item weight | ||
| WEIGHT_UOM_CODE | VARCHAR2 | (3) | Unit of measure code for weight | |
| VOLUME | NUMBER | Volume | ||
| VOLUME_UOM_CODE | VARCHAR2 | (3) | Unit of measure code for volume | |
| SHIPPING_INSTRUCTIONS | VARCHAR2 | (2000) | Instructions for shipping | |
| PACKING_INSTRUCTIONS | VARCHAR2 | (2000) | Instructions for packing | |
| PROJECT_ID | NUMBER | Project Identifier | ||
| TASK_ID | NUMBER | Task Identifier | ||
| ORG_ID | NUMBER | Identifier for operating unit | ||
| OE_INTERFACED_FLAG | VARCHAR2 | (1) | Indicates if line is interfaced to OM | |
| MVT_STAT_STATUS | VARCHAR2 | (30) | Mvt statistics status | |
| TRACKING_NUMBER | VARCHAR2 | (30) | Tracking number | |
| TRANSACTION_TEMP_ID | NUMBER | Foreign key to inventory transaction temp tables | ||
| TP_ATTRIBUTE_CATEGORY | VARCHAR2 | (240) | Trading Partner Descriptive Flexfield structure | |
| TP_ATTRIBUTE1 | VARCHAR2 | (240) | Trading Partner Descriptive Flexfield segment | |
| TP_ATTRIBUTE2 | VARCHAR2 | (240) | Trading Partner Descriptive Flexfield segment | |
| TP_ATTRIBUTE3 | VARCHAR2 | (240) | Trading Partner Descriptive Flexfield segment | |
| TP_ATTRIBUTE4 | VARCHAR2 | (240) | Trading Partner Descriptive Flexfield segment | |
| TP_ATTRIBUTE5 | VARCHAR2 | (240) | Trading Partner Descriptive Flexfield segment | |
| TP_ATTRIBUTE6 | VARCHAR2 | (240) | Trading Partner Descriptive Flexfield segment | |
| TP_ATTRIBUTE7 | VARCHAR2 | (240) | Trading Partner Descriptive Flexfield segment | |
| TP_ATTRIBUTE8 | VARCHAR2 | (240) | Trading Partner Descriptive Flexfield segment | |
| TP_ATTRIBUTE9 | VARCHAR2 | (240) | Trading Partner Descriptive Flexfield segment | |
| TP_ATTRIBUTE10 | VARCHAR2 | (240) | Trading Partner Descriptive Flexfield segment | |
| TP_ATTRIBUTE11 | VARCHAR2 | (240) | Trading Partner Descriptive Flexfield segment | |
| TP_ATTRIBUTE12 | VARCHAR2 | (240) | Trading Partner Descriptive Flexfield segment | |
| TP_ATTRIBUTE13 | VARCHAR2 | (240) | Trading Partner Descriptive Flexfield segment | |
| TP_ATTRIBUTE14 | VARCHAR2 | (240) | Trading Partner Descriptive Flexfield segment | |
| TP_ATTRIBUTE15 | VARCHAR2 | (240) | Trading Partner Descriptive Flexfield segment | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfields structure | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfields segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfields segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfields segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfields segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfields segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfields segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfields segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfields segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfields segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfields segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfields segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfields segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfields segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfields segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfields 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 | ||
| MOVEMENT_ID | NUMBER | Movement statistics identifier | ||
| SPLIT_FROM_DELIVERY_DETAIL_ID | NUMBER | Delivery detail identifier that the line is split from | ||
| INV_INTERFACED_FLAG | VARCHAR2 | (1) | Indicates if line is interfaced to INV | |
| SEAL_CODE | VARCHAR2 | (30) | Seal Code | |
| MINIMUM_FILL_PERCENT | NUMBER | Minimum fill percentage | ||
| MAXIMUM_VOLUME | NUMBER | Mzximum volume | ||
| MAXIMUM_LOAD_WEIGHT | NUMBER | Maximum loading weight | ||
| MASTER_SERIAL_NUMBER | VARCHAR2 | (30) | Master serial number | |
| GROSS_WEIGHT | NUMBER | Gross weight of the line | ||
| FILL_PERCENT | NUMBER | Fill percentage | ||
| CONTAINER_NAME | VARCHAR2 | (30) | Container name | |
| CONTAINER_TYPE_CODE | VARCHAR2 | (30) | Container type code | |
| CONTAINER_FLAG | VARCHAR2 | (1) | Yes | Y for container N for order line |
| PREFERRED_GRADE | VARCHAR2 | (150) | Preferred grade | |
| SRC_REQUESTED_QUANTITY2 | NUMBER | Dual ordered quantity | ||
| SRC_REQUESTED_QUANTITY_UOM2 | VARCHAR2 | (3) | Dual UOM | |
| REQUESTED_QUANTITY2 | NUMBER | Dual requested quantity | ||
| SHIPPED_QUANTITY2 | NUMBER | Dual shipped quantity | ||
| DELIVERED_QUANTITY2 | NUMBER | Dual delivered quantity | ||
| CANCELLED_QUANTITY2 | NUMBER | Dual cancelled quantity | ||
| QUALITY_CONTROL_QUANTITY2 | NUMBER | Dual quality control quantity | ||
| CYCLE_COUNT_QUANTITY2 | NUMBER | Dual cycle count quantity | ||
| REQUESTED_QUANTITY_UOM2 | VARCHAR2 | (3) | Dual requested quantity | |
| SUBLOT_NUMBER | VARCHAR2 | (32) | Obsoleted (Sublot number) | |
| UNIT_PRICE | NUMBER | Unit price | ||
| CURRENCY_CODE | VARCHAR2 | (15) | Currency code | |
| UNIT_NUMBER | VARCHAR2 | (30) | Unit number | |
| FREIGHT_CLASS_CAT_ID | NUMBER | Freight Class Category | ||
| COMMODITY_CODE_CAT_ID | NUMBER | Commodity Code Category | ||
| LPN_CONTENT_ID | NUMBER | |||
| SHIP_TO_SITE_USE_ID | NUMBER | Site identifier for ship to destination | ||
| DELIVER_TO_SITE_USE_ID | NUMBER | Site identifier for deliver to destination | ||
| LPN_ID | NUMBER | container id for WMS | ||
| INSPECTION_FLAG | VARCHAR2 | (1) | Inspection Flag | |
| ORIGINAL_SUBINVENTORY | VARCHAR2 | (10) | Original Subinventory | |
| SOURCE_HEADER_NUMBER | VARCHAR2 | (150) | The user visible identifier for the header, Ex. Order number | |
| SOURCE_LINE_NUMBER | VARCHAR2 | (150) | User visible line number in source system | |
| PICKABLE_FLAG | VARCHAR2 | (1) | Pickable Flag | |
| CUSTOMER_PRODUCTION_LINE | VARCHAR2 | (50) | Customer Production Line | |
| CUSTOMER_JOB | VARCHAR2 | (50) | Customer Job | |
| CUST_MODEL_SERIAL_NUMBER | VARCHAR2 | (50) | Customer Model Serial Number | |
| TO_SERIAL_NUMBER | VARCHAR2 | (30) | To Serial Number | |
| PICKED_QUANTITY | NUMBER | Picked Quantity | ||
| PICKED_QUANTITY2 | NUMBER | Secondary Picked Quantity | ||
| RECEIVED_QUANTITY | NUMBER | Quantity received by consignee (in REQUESTED_QUANTITY_UOM) | ||
| RECEIVED_QUANTITY2 | NUMBER | Secondary Quantity received by consignee (in REQUESTED_QUANTITY_UOM2) | ||
| SOURCE_LINE_SET_ID | NUMBER | Source Line Set ID | ||
| BATCH_ID | NUMBER | Foreign key to WSH_PICKING_BATCHES | ||
| TRANSACTION_ID | NUMBER | Transaction Identifier | ||
| SERVICE_LEVEL | VARCHAR2 | (30) | Service level for ship method | |
| MODE_OF_TRANSPORT | VARCHAR2 | (30) | Mode of transport for ship method | |
| EARLIEST_PICKUP_DATE | DATE | Date on which this line is to be first picked up | ||
| LATEST_PICKUP_DATE | DATE | Latest date on which this line can be picked up | ||
| EARLIEST_DROPOFF_DATE | DATE | Earliest date on which the line needs to be delivered | ||
| LATEST_DROPOFF_DATE | DATE | Latest date at which this line is to be delivered to customer | ||
| REQUEST_DATE_TYPE_CODE | VARCHAR2 | (30) | Request date type code | |
| TP_DELIVERY_DETAIL_ID | NUMBER | Delivery detail id in Transportation Planning | ||
| SOURCE_DOCUMENT_TYPE_ID | NUMBER | To be collected from source order header | ||
| VENDOR_ID | NUMBER | if delivery detail is for ship from supplier or return to supplier | ||
| SHIP_FROM_SITE_ID | NUMBER | Customer or supplier ship from site | ||
| IGNORE_FOR_PLANNING | VARCHAR2 | (1) | Y= Transportation Planning will ignore, N= Transportation Planning will use | |
| LINE_DIRECTION | VARCHAR2 | (30) | I= Inbound, O= Outbound, D= Drop ship, IO= InternalSales Order | |
| PARTY_ID | NUMBER | Party linked to vendor | ||
| ROUTING_REQ_ID | NUMBER | Reference to routing request received from supplier | ||
| SHIPPING_CONTROL | VARCHAR2 | (30) | Shipment is managed by Buyer/Supplier | |
| SOURCE_BLANKET_REFERENCE_ID | NUMBER | Reference: Release ID in PO | ||
| SOURCE_BLANKET_REFERENCE_NUM | NUMBER | Reference: Release number in PO | ||
| PO_SHIPMENT_LINE_ID | NUMBER | Reference: PO line id | ||
| PO_SHIPMENT_LINE_NUMBER | NUMBER | Reference: PO line number | ||
| SCHEDULED_QUANTITY | NUMBER | Quantity expected to be shipped by supplier | ||
| RETURNED_QUANTITY | NUMBER | Quantity to be returned on shipment | ||
| SCHEDULED_QUANTITY2 | NUMBER | Secondary quantity expected to be shipped by supplier | ||
| RETURNED_QUANTITY2 | NUMBER | Secondary quantity to be returned on shipment | ||
| SOURCE_LINE_TYPE_CODE | VARCHAR2 | (30) | GB_OSP: goods based lines with outside processing | |
| RCV_SHIPMENT_LINE_ID | NUMBER | Reference: RCV shipment line | ||
| SUPPLIER_ITEM_NUMBER | VARCHAR2 | (50) | Supplier item number | |
| FILLED_VOLUME | NUMBER | Volume of the Container Contents | ||
| UNIT_WEIGHT | NUMBER | Unit Weight of the item on this delivery detail | ||
| UNIT_VOLUME | NUMBER | Unit Volume of the item on this delivery detail | ||
| WV_FROZEN_FLAG | VARCHAR2 | (1) | 'Y' if the W/V is entered manually. 'N' if the W/V is automatically computed by system | |
| PO_REVISION_NUMBER | NUMBER | Purchase Order Revision Number | ||
| RELEASE_REVISION_NUMBER | NUMBER | Release Revision Number | ||
| REPLENISHMENT_STATUS | VARCHAR2 | (1) | This field indicates the replenishment status when delivery detail lines is at ready to release (R) or backorder (B). Valida values are 'R' (replenishment requested), 'C' (replenishment completed) and null(not applicalble). |
Cut, paste (and edit) the following text to query this object:
SELECT DELIVERY_DETAIL_ID
, SOURCE_CODE
, SOURCE_HEADER_ID
, SOURCE_LINE_ID
, SOURCE_HEADER_TYPE_ID
, SOURCE_HEADER_TYPE_NAME
, CUST_PO_NUMBER
, CUSTOMER_ID
, SOLD_TO_CONTACT_ID
, INVENTORY_ITEM_ID
, ITEM_DESCRIPTION
, SHIP_SET_ID
, ARRIVAL_SET_ID
, TOP_MODEL_LINE_ID
, ATO_LINE_ID
, HOLD_CODE
, SHIP_MODEL_COMPLETE_FLAG
, HAZARD_CLASS_ID
, COUNTRY_OF_ORIGIN
, CLASSIFICATION
, SHIP_FROM_LOCATION_ID
, ORGANIZATION_ID
, SHIP_TO_LOCATION_ID
, SHIP_TO_CONTACT_ID
, DELIVER_TO_LOCATION_ID
, DELIVER_TO_CONTACT_ID
, INTMED_SHIP_TO_LOCATION_ID
, INTMED_SHIP_TO_CONTACT_ID
, SHIP_TOLERANCE_ABOVE
, SHIP_TOLERANCE_BELOW
, SRC_REQUESTED_QUANTITY
, SRC_REQUESTED_QUANTITY_UOM
, CANCELLED_QUANTITY
, REQUESTED_QUANTITY
, REQUESTED_QUANTITY_UOM
, SHIPPED_QUANTITY
, DELIVERED_QUANTITY
, QUALITY_CONTROL_QUANTITY
, CYCLE_COUNT_QUANTITY
, MOVE_ORDER_LINE_ID
, SUBINVENTORY
, REVISION
, LOT_NUMBER
, RELEASED_STATUS
, CUSTOMER_REQUESTED_LOT_FLAG
, SERIAL_NUMBER
, LOCATOR_ID
, DATE_REQUESTED
, DATE_SCHEDULED
, MASTER_CONTAINER_ITEM_ID
, DETAIL_CONTAINER_ITEM_ID
, LOAD_SEQ_NUMBER
, SHIP_METHOD_CODE
, CARRIER_ID
, FREIGHT_TERMS_CODE
, SHIPMENT_PRIORITY_CODE
, FOB_CODE
, CUSTOMER_ITEM_ID
, DEP_PLAN_REQUIRED_FLAG
, CUSTOMER_PROD_SEQ
, CUSTOMER_DOCK_CODE
, NET_WEIGHT
, WEIGHT_UOM_CODE
, VOLUME
, VOLUME_UOM_CODE
, SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS
, PROJECT_ID
, TASK_ID
, ORG_ID
, OE_INTERFACED_FLAG
, MVT_STAT_STATUS
, TRACKING_NUMBER
, TRANSACTION_TEMP_ID
, 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
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, MOVEMENT_ID
, SPLIT_FROM_DELIVERY_DETAIL_ID
, INV_INTERFACED_FLAG
, SEAL_CODE
, MINIMUM_FILL_PERCENT
, MAXIMUM_VOLUME
, MAXIMUM_LOAD_WEIGHT
, MASTER_SERIAL_NUMBER
, GROSS_WEIGHT
, FILL_PERCENT
, CONTAINER_NAME
, CONTAINER_TYPE_CODE
, CONTAINER_FLAG
, PREFERRED_GRADE
, SRC_REQUESTED_QUANTITY2
, SRC_REQUESTED_QUANTITY_UOM2
, REQUESTED_QUANTITY2
, SHIPPED_QUANTITY2
, DELIVERED_QUANTITY2
, CANCELLED_QUANTITY2
, QUALITY_CONTROL_QUANTITY2
, CYCLE_COUNT_QUANTITY2
, REQUESTED_QUANTITY_UOM2
, SUBLOT_NUMBER
, UNIT_PRICE
, CURRENCY_CODE
, UNIT_NUMBER
, FREIGHT_CLASS_CAT_ID
, COMMODITY_CODE_CAT_ID
, LPN_CONTENT_ID
, SHIP_TO_SITE_USE_ID
, DELIVER_TO_SITE_USE_ID
, LPN_ID
, INSPECTION_FLAG
, ORIGINAL_SUBINVENTORY
, SOURCE_HEADER_NUMBER
, SOURCE_LINE_NUMBER
, PICKABLE_FLAG
, CUSTOMER_PRODUCTION_LINE
, CUSTOMER_JOB
, CUST_MODEL_SERIAL_NUMBER
, TO_SERIAL_NUMBER
, PICKED_QUANTITY
, PICKED_QUANTITY2
, RECEIVED_QUANTITY
, RECEIVED_QUANTITY2
, SOURCE_LINE_SET_ID
, BATCH_ID
, TRANSACTION_ID
, SERVICE_LEVEL
, MODE_OF_TRANSPORT
, EARLIEST_PICKUP_DATE
, LATEST_PICKUP_DATE
, EARLIEST_DROPOFF_DATE
, LATEST_DROPOFF_DATE
, REQUEST_DATE_TYPE_CODE
, TP_DELIVERY_DETAIL_ID
, SOURCE_DOCUMENT_TYPE_ID
, VENDOR_ID
, SHIP_FROM_SITE_ID
, IGNORE_FOR_PLANNING
, LINE_DIRECTION
, PARTY_ID
, ROUTING_REQ_ID
, SHIPPING_CONTROL
, SOURCE_BLANKET_REFERENCE_ID
, SOURCE_BLANKET_REFERENCE_NUM
, PO_SHIPMENT_LINE_ID
, PO_SHIPMENT_LINE_NUMBER
, SCHEDULED_QUANTITY
, RETURNED_QUANTITY
, SCHEDULED_QUANTITY2
, RETURNED_QUANTITY2
, SOURCE_LINE_TYPE_CODE
, RCV_SHIPMENT_LINE_ID
, SUPPLIER_ITEM_NUMBER
, FILLED_VOLUME
, UNIT_WEIGHT
, UNIT_VOLUME
, WV_FROZEN_FLAG
, PO_REVISION_NUMBER
, RELEASE_REVISION_NUMBER
, REPLENISHMENT_STATUS
FROM WSH.WSH_DELIVERY_DETAILS;
WSH.WSH_DELIVERY_DETAILS does not reference any database object
WSH.WSH_DELIVERY_DETAILS is referenced by following:
APPS
JAI_OM_WDD_ARIUD_T1
WSH_DELIVERY_DETAILS
|
|
|
|