DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.WSHFV_DELIVERY_DETAILS

Object Details
Object Name: WSHFV_DELIVERY_DETAILS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWSH.WSHFV_DELIVERY_DETAILS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
DELIVERY_DETAIL_ID NUMBER
Yes
SOURCE_CODE VARCHAR2 (30) Yes
SOURCE_HEADER_ID NUMBER

SOURCE_LINE_ID NUMBER
Yes
SOURCE_HEADER_TYPE_ID NUMBER

SRC_HEADER_TYPE_NAME VARCHAR2 (240)
CUST_PO_NUMBER VARCHAR2 (50)
CUSTOMER_ID NUMBER

CUSTOMER_NAME VARCHAR2 (360)
Customer Name
SOLD_TO_CONTACT_ID NUMBER

SOLD_TO_CONTACT_NAME VARCHAR2 (301)
Sold To Contact Name
ITEM_DESCRIPTION VARCHAR2 (250)
SHIP_SET_ID NUMBER

SHIP_SET_NAME VARCHAR2 (30)
Ship Set Name
ARRIVAL_SET_ID NUMBER

ARRIVAL_SET_NAME VARCHAR2 (30)
Arrival Set Name
TOP_MODEL_LINE_ID NUMBER

ATO_LINE_ID NUMBER

HOLD_CODE VARCHAR2 (1)
_LA:SMC_FLAG CHAR (59)
Ship Model Complete Flag
HAZARD_CLASS_ID NUMBER

COUNTRY_OF_ORIGIN VARCHAR2 (50)
CLASSIFICATION VARCHAR2 (30)
SHIP_FROM_LOCATION_ID NUMBER

SHIP_FROM_LOCATION VARCHAR2 (500)
Ship From Location
ORGANIZATION_ID NUMBER

SHIP_TO_LOCATION_ID NUMBER

SHIP_TO_LOCATION VARCHAR2 (500)
Ship To Location
SHIP_TO_CONTACT_ID NUMBER

SHIP_TO_CONTACT_NAME VARCHAR2 (301)
Ship To Contact Name
DELIVER_TO_LOCATION_ID NUMBER

DELIVER_TO_LOCATION VARCHAR2 (500)
Deliver To Location
DELIVER_TO_CONTACT_ID NUMBER

DELIVER_TO_CONTACT_NAME VARCHAR2 (301)
Deliver To Contact Name
INTMED_SHIP_TO_LOCATION_ID NUMBER

INTMED_SHIP_TO_LOCATION VARCHAR2 (500)
Intermediate Ship To Location
INTMED_SHIP_TO_CONTACT_ID NUMBER

INTMED_SHIP_TO_CONTACT_NAME VARCHAR2 (301)
Intermediate Ship To Contact Name
SHIP_TOLERANCE_ABOVE NUMBER

SHIP_TOLERANCE_BELOW NUMBER

SRC_REQUESTED_QUANTITY NUMBER

SRC_REQUESTED_QUANTITY_UOM VARCHAR2 (3)
CANCELLED_QUANTITY NUMBER

REQUESTED_QUANTITY NUMBER
Yes
REQUESTED_QUANTITY_UOM VARCHAR2 (3) Yes
SHIPPED_QUANTITY NUMBER

DELIVERED_QUANTITY NUMBER

QUALITY_CONTROL_QUANTITY NUMBER

CYCLE_COUNT_QUANTITY NUMBER

MOVE_ORDER_LINE_ID NUMBER

MOVE_ORDER_LINE_NUMBER NUMBER

Move Order Line Number
SUBINVENTORY VARCHAR2 (10)
SUBINV_DESCRIPTION VARCHAR2 (50)
Subinventory Description
REVISION VARCHAR2 (3)
LOT_NUMBER VARCHAR2 (80)
RELEASED_STATUS VARCHAR2 (1)
_LA:CUST_REQUESTED_LOT_FLAG CHAR (62)
Customer Requested Lot Flag
SERIAL_NUMBER VARCHAR2 (30)
LOCATOR_ID NUMBER

_KF:INVENTORY_LOCATOR_ID CHAR (16)
Inventory Locator Id
DATE_REQUESTED DATE

DATE_SCHEDULED DATE

LOAD_SEQ_NUMBER NUMBER

_LA:SHIP_METHOD_CODE CHAR (65)
Ship Method Code
CARRIER_ID NUMBER

_LA:FREIGHT_TERMS_CODE CHAR (69)
Freight Terms Code
_LA:SHIPMENT_PRIORITY_CODE CHAR (77)
Shipment Priority Code
_LA:FOB_CODE CHAR (39)
Freight On Board Code
_LA:DEP_PLAN_REQUIRED_FLAG CHAR (57)
Departure Plan Required Flag
CUSTOMER_PROD_SEQ VARCHAR2 (50)
CUSTOMER_DOCK_CODE VARCHAR2 (50)
NET_WEIGHT NUMBER

WEIGHT_UOM_CODE VARCHAR2 (3)
VOLUME NUMBER

VOLUME_UOM_CODE VARCHAR2 (3)
SHIPPING_INSTRUCTIONS VARCHAR2 (2000)
PACKING_INSTRUCTIONS VARCHAR2 (2000)
PROJECT_ID NUMBER

PROJECT_NAME VARCHAR2 (30)
Project Name
TASK_ID NUMBER

TASK_NUMBER VARCHAR2 (25)
Task Number
ORG_ID NUMBER

OE_INTERFACED_FLAG VARCHAR2 (1)
MVT_STAT_STATUS VARCHAR2 (30)
TRACKING_NUMBER VARCHAR2 (30)
TRANSACTION_TEMP_ID NUMBER

CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER

MOVEMENT_ID NUMBER

MOVEMENT_TYPE VARCHAR2 (30)
MOVEMENT_STATUS VARCHAR2 (30)
SPLIT_FROM_DEL_DETAIL_ID NUMBER

INV_INTERFACED_FLAG VARCHAR2 (1)
SEAL_CODE VARCHAR2 (30)
MINIMUM_FILL_PERCENT NUMBER

MAXIMUM_VOLUME NUMBER

MAXIMUM_LOAD_WEIGHT NUMBER

MASTER_SERIAL_NUMBER VARCHAR2 (30)
GROSS_WEIGHT NUMBER

FILL_PERCENT NUMBER

CONTAINER_NAME VARCHAR2 (30)
CONTAINER_TYPE_CODE VARCHAR2 (30)
_LA:CONTAINER_FLAG CHAR (49)
Container Flag
PREFERRED_GRADE VARCHAR2 (150)
SRC_REQUESTED_QUANTITY2 NUMBER

SRC_REQUESTED_QUANTITY_UOM2 VARCHAR2 (3)
REQUESTED_QUANTITY2 NUMBER

SHIPPED_QUANTITY2 NUMBER

DELIVERED_QUANTITY2 NUMBER

CANCELLED_QUANTITY2 NUMBER

QUALITY_CONTROL_QUANTITY2 NUMBER

CYCLE_COUNT_QUANTITY2 NUMBER

REQUESTED_QUANTITY_UOM2 VARCHAR2 (3)
SUBLOT_NUMBER VARCHAR2 (32)
UNIT_PRICE NUMBER

CURRENCY_CODE VARCHAR2 (15)
UNIT_NUMBER VARCHAR2 (30)
FREIGHT_CLASS_CAT_ID NUMBER

COMMODITY_CODE_CAT_ID NUMBER

SOURCE_HEADER_NUMBER VARCHAR2 (150)
SOURCE_LINE_NUMBER VARCHAR2 (150)
SHIP_TO_SITE_USE_ID NUMBER

SHIP_TO_SITE_USE_LOCATION VARCHAR2 (40)
Ship To Site Use Location
SHIP_TO_SITE_USE_ADDRESS1 VARCHAR2 (240)
Ship To Site Use Address 1
SHIP_TO_SITE_USE_ADDRESS2 VARCHAR2 (240)
Ship To Site Use Address 2
SHIP_TO_SITE_USE_ADDRESS3 VARCHAR2 (240)
Ship To Site Use Address 3
SHIP_TO_SITE_USE_ADDRESS4 VARCHAR2 (240)
Ship To Site Use Address 4
SHIP_TO_SITE_USE_CITY VARCHAR2 (120)
Ship To Site Use City
SHIP_TO_SITE_USE_STATE VARCHAR2 (120)
Ship To Site Use State
SHIP_TO_SITE_USE_POSTAL_CODE VARCHAR2 (60)
Ship To Site Use Postal Code
SHIP_TO_SITE_USE_PROVINCE VARCHAR2 (120)
Ship To Site Use Province
SHIP_TO_SITE_USE_COUNTY VARCHAR2 (120)
Ship To Site Use County
SHIP_TO_SITE_USE_COUNTRY VARCHAR2 (120)
Ship To Site Use Country
DELIVER_TO_SITE_USE_ID NUMBER

DEL_TO_SITE_USE_LOCATION VARCHAR2 (40)
Deliver To Site Use Location
DEL_TO_SITE_USE_ADDRESS1 VARCHAR2 (240)
Deliver To Site Use Address 1
DEL_TO_SITE_USE_ADDRESS2 VARCHAR2 (240)
Deliver To Site Use Address 2
DEL_TO_SITE_USE_ADDRESS3 VARCHAR2 (240)
Deliver To Site Use Address 3
DEL_TO_SITE_USE_ADDRESS4 VARCHAR2 (240)
Deliver To Site Use Address 4
DEL_TO_SITE_USE_CITY VARCHAR2 (120)
Deliver To Site Use City
DEL_TO_SITE_USE_STATE VARCHAR2 (120)
Deliver To Site Use State
DEL_TO_SITE_POSTAL_CODE VARCHAR2 (60)
Deliver To Site Use Postal Code
DEL_TO_SITE_USE_PROVINCE VARCHAR2 (120)
Deliver To Site Use Province
DEL_TO_SITE_USE_COUNTY VARCHAR2 (120)
Deliver To Site Use County
DEL_TO_SITE_USE_COUNTRY VARCHAR2 (120)
Deliver To Site Use Country
LPN_ID NUMBER

LICENSE_PLATE_NUMBER VARCHAR2 (30)
License Plate Number
_LA:INSPECTION_FLAG CHAR (50)
Inspection Flag
ORIGINAL_SUBINVENTORY VARCHAR2 (10)
ORIGINAL_SUBINV_DESCRIPTION VARCHAR2 (50)
_LA:PICKABLE_FLAG CHAR (48)
Pickable Flag
_DF:EXTRA_DEL_DETAIL_INFO CHAR (32)
Extra Delivery Detail Information
_DF:EXTRA_TP_DEL_DETAIL_INFO CHAR (36)
Extra Trading Partner Delivery Detail Information
INVENTORY_ITEM_ID NUMBER

MASTER_CONTAINER_ITEM_ID NUMBER

DETAIL_CONTAINER_ITEM_ID NUMBER

_KF:INVENTORY_ITEM_NUMBER CHAR (16)
Inventory Item Number
_KF:MASTER_CONTAINER_ITEM CHAR (24)
Master Container Item
_KF:DETAIL_CONTAINER_ITEM CHAR (24)
Detail Container Item
Query Text

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
,      SRC_HEADER_TYPE_NAME
,      CUST_PO_NUMBER
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      SOLD_TO_CONTACT_ID
,      SOLD_TO_CONTACT_NAME
,      ITEM_DESCRIPTION
,      SHIP_SET_ID
,      SHIP_SET_NAME
,      ARRIVAL_SET_ID
,      ARRIVAL_SET_NAME
,      TOP_MODEL_LINE_ID
,      ATO_LINE_ID
,      HOLD_CODE
,      _LA:SMC_FLAG
,      HAZARD_CLASS_ID
,      COUNTRY_OF_ORIGIN
,      CLASSIFICATION
,      SHIP_FROM_LOCATION_ID
,      SHIP_FROM_LOCATION
,      ORGANIZATION_ID
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION
,      SHIP_TO_CONTACT_ID
,      SHIP_TO_CONTACT_NAME
,      DELIVER_TO_LOCATION_ID
,      DELIVER_TO_LOCATION
,      DELIVER_TO_CONTACT_ID
,      DELIVER_TO_CONTACT_NAME
,      INTMED_SHIP_TO_LOCATION_ID
,      INTMED_SHIP_TO_LOCATION
,      INTMED_SHIP_TO_CONTACT_ID
,      INTMED_SHIP_TO_CONTACT_NAME
,      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
,      MOVE_ORDER_LINE_NUMBER
,      SUBINVENTORY
,      SUBINV_DESCRIPTION
,      REVISION
,      LOT_NUMBER
,      RELEASED_STATUS
,      _LA:CUST_REQUESTED_LOT_FLAG
,      SERIAL_NUMBER
,      LOCATOR_ID
,      _KF:INVENTORY_LOCATOR_ID
,      DATE_REQUESTED
,      DATE_SCHEDULED
,      LOAD_SEQ_NUMBER
,      _LA:SHIP_METHOD_CODE
,      CARRIER_ID
,      _LA:FREIGHT_TERMS_CODE
,      _LA:SHIPMENT_PRIORITY_CODE
,      _LA:FOB_CODE
,      _LA: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
,      PROJECT_NAME
,      TASK_ID
,      TASK_NUMBER
,      ORG_ID
,      OE_INTERFACED_FLAG
,      MVT_STAT_STATUS
,      TRACKING_NUMBER
,      TRANSACTION_TEMP_ID
,      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
,      MOVEMENT_TYPE
,      MOVEMENT_STATUS
,      SPLIT_FROM_DEL_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
,      _LA: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
,      SOURCE_HEADER_NUMBER
,      SOURCE_LINE_NUMBER
,      SHIP_TO_SITE_USE_ID
,      SHIP_TO_SITE_USE_LOCATION
,      SHIP_TO_SITE_USE_ADDRESS1
,      SHIP_TO_SITE_USE_ADDRESS2
,      SHIP_TO_SITE_USE_ADDRESS3
,      SHIP_TO_SITE_USE_ADDRESS4
,      SHIP_TO_SITE_USE_CITY
,      SHIP_TO_SITE_USE_STATE
,      SHIP_TO_SITE_USE_POSTAL_CODE
,      SHIP_TO_SITE_USE_PROVINCE
,      SHIP_TO_SITE_USE_COUNTY
,      SHIP_TO_SITE_USE_COUNTRY
,      DELIVER_TO_SITE_USE_ID
,      DEL_TO_SITE_USE_LOCATION
,      DEL_TO_SITE_USE_ADDRESS1
,      DEL_TO_SITE_USE_ADDRESS2
,      DEL_TO_SITE_USE_ADDRESS3
,      DEL_TO_SITE_USE_ADDRESS4
,      DEL_TO_SITE_USE_CITY
,      DEL_TO_SITE_USE_STATE
,      DEL_TO_SITE_POSTAL_CODE
,      DEL_TO_SITE_USE_PROVINCE
,      DEL_TO_SITE_USE_COUNTY
,      DEL_TO_SITE_USE_COUNTRY
,      LPN_ID
,      LICENSE_PLATE_NUMBER
,      _LA:INSPECTION_FLAG
,      ORIGINAL_SUBINVENTORY
,      ORIGINAL_SUBINV_DESCRIPTION
,      _LA:PICKABLE_FLAG
,      _DF:EXTRA_DEL_DETAIL_INFO
,      _DF:EXTRA_TP_DEL_DETAIL_INFO
,      INVENTORY_ITEM_ID
,      MASTER_CONTAINER_ITEM_ID
,      DETAIL_CONTAINER_ITEM_ID
,      _KF:INVENTORY_ITEM_NUMBER
,      _KF:MASTER_CONTAINER_ITEM
,      _KF:DETAIL_CONTAINER_ITEM
FROM APPS.WSHFV_DELIVERY_DETAILS;

Dependencies

[top of page]

APPS.WSHFV_DELIVERY_DETAILS references the following:

SchemaAPPS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_PARTIES
SynonymMTL_CUSTOMER_ITEMS
SynonymMTL_ITEM_LOCATIONS
SynonymMTL_MOVEMENT_STATISTICS
SynonymMTL_SECONDARY_INVENTORIES
SynonymMTL_SYSTEM_ITEMS
SynonymMTL_TXN_REQUEST_LINES
SynonymOE_SETS
SynonymPA_PROJECTS_ALL
SynonymPA_TASKS
SynonymWMS_LICENSE_PLATE_NUMBERS
SynonymWSH_DELIVERY_DETAILS
SynonymWSH_LOCATIONS

APPS.WSHFV_DELIVERY_DETAILS is not referenced by any database object