[Home] [Help] [Dependency Information]
Object Name: | WSHFV_DELIVERY_DETAILS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | WSH.WSHFV_DELIVERY_DETAILS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
APPS.WSHFV_DELIVERY_DETAILS is not referenced by any database object
|
|
|