[Home] [Help] [Dependency Information]
Object Name: | CLN_WSH_SS_SHIPMENT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CLN.CLN_WSH_SS_SHIPMENT_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View of delivery header details
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DELIVERY_ID | NUMBER | Yes | Delivery ID. | |
ACTION_CODE | VARCHAR2 | (30) | Yes | Shipping Transaction History Action Code. |
DOCUMENT_NUMBER | VARCHAR2 | (120) | Yes | Shipping Transaction History Document Number. |
DOCUMENT_CREATION_DATE | DATE | Yes | Delivery Creation Date. | |
SHIP_FROM_LOCATION | VARCHAR2 | (60) | Yes | Delivery Ship From Location. |
SHIP_METHOD | VARCHAR2 | (30) | Delivery Shipment Method. | |
COUNTRY | VARCHAR2 | (120) | Initial Pickup Location Country. | |
ULTIMATE_DROPOFF_DATE | DATE | Ultimate Dropoff Date. | ||
INITIAL_PICKUP_DATE | DATE | Initial Pickup date. | ||
DESCRIPTION | VARCHAR2 | (30) | Delivery Description. | |
DOCUMENT_TYPE | VARCHAR2 | (30) | Yes | Shipping Transaction History Document Type. |
FREIGHT_TERMS | VARCHAR2 | (30) | Freight Terms. | |
GROSS_WEIGHT | NUMBER | Delivery Gross Weight. | ||
NET_WEIGHT | NUMBER | Delivery Net Weight. | ||
WEIGHT_UOM_CODE | VARCHAR2 | (3) | Weight Unit Of Measure. | |
NUMBER_OF_LPN | NUMBER | Number of LPN. | ||
VOLUME | NUMBER | Delivery Volume. | ||
VOLUME_UOM_CODE | VARCHAR2 | (3) | Volume Unit Of Measure. | |
SHIPPING_MARKS | VARCHAR2 | (100) | Shipping Marks. | |
SHIP_TO_LOCATION | VARCHAR2 | (40) | Yes | Ship To Location. |
FOB_CODE | VARCHAR2 | (30) | FOB Code. | |
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization Code. | |
ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | Organization Name. |
LOADING_SEQUENCE | NUMBER | Loading Sequence. | ||
ORIG_DOCUMENT_NUMBER | VARCHAR2 | (120) | Shipping Transaction History Orig Document Number. | |
WAYBILL | VARCHAR2 | (30) | Waybill. | |
CARRIER | VARCHAR2 | (360) | Delivery Carrier. | |
SERVICE_LEVEL | VARCHAR2 | (30) | Delivery Service Level. | |
TRANSPORTATION_METHOD | VARCHAR2 | (30) | Delivery Transportation Method. | |
SHIP_FROM_EDI_LOCATION_CODE1 | VARCHAR2 | (35) | ShipFrom EDI Location Code. | |
SHIP_FROM_EDI_LOCATION_CODE2 | VARCHAR2 | (35) | ShipFrom EDI Location Code. | |
SHIP_FROM_ADDRESS1 | VARCHAR2 | (240) | ShipFrom Address1. | |
SHIP_FROM_ADDRESS2 | VARCHAR2 | (240) | ShipFrom Address2. | |
SHIP_FROM_ADDRESS3 | VARCHAR2 | (240) | ShipFrom Address3. | |
SHIP_FROM_CITY | VARCHAR2 | (30) | ShipFrom City. | |
SHIP_FROM_COUNTRY_CODE | VARCHAR2 | (60) | ShipFrom Country Code. | |
SHIP_FROM_POSTAL_CODE | VARCHAR2 | (30) | ShipFrom Postal Code. | |
SHIP_FROM_REGION | VARCHAR2 | (120) | ShipFrom Region. | |
SHIP_TO_EDI_LOCATION_CODE1 | VARCHAR2 | (40) | ShipTo EDI Location Code. | |
SHIP_TO_EDI_LOCATION_CODE2 | VARCHAR2 | (40) | ShipTo EDI Location Code. | |
SHIP_TO_ADDRESS1 | VARCHAR2 | (240) | ShipTo Address1. | |
SHIP_TO_ADDRESS2 | VARCHAR2 | (240) | ShipTo Address2. | |
SHIP_TO_ADDRESS3 | VARCHAR2 | (240) | ShipTo Address3. | |
SHIP_TO_CITY | VARCHAR2 | (120) | ShipTo City. | |
SHIP_TO_COUNTRY_CODE | VARCHAR2 | (120) | ShipTo Country. | |
SHIP_TO_POSTAL_CODE | VARCHAR2 | (60) | ShipTo Postal Code. | |
SHIP_TO_REGION | VARCHAR2 | (0) | ShipTo Region. |
Cut, paste (and edit) the following text to query this object:
SELECT DELIVERY_ID
, ACTION_CODE
, DOCUMENT_NUMBER
, DOCUMENT_CREATION_DATE
, SHIP_FROM_LOCATION
, SHIP_METHOD
, COUNTRY
, ULTIMATE_DROPOFF_DATE
, INITIAL_PICKUP_DATE
, DESCRIPTION
, DOCUMENT_TYPE
, FREIGHT_TERMS
, GROSS_WEIGHT
, NET_WEIGHT
, WEIGHT_UOM_CODE
, NUMBER_OF_LPN
, VOLUME
, VOLUME_UOM_CODE
, SHIPPING_MARKS
, SHIP_TO_LOCATION
, FOB_CODE
, ORGANIZATION_CODE
, ORGANIZATION_NAME
, LOADING_SEQUENCE
, ORIG_DOCUMENT_NUMBER
, WAYBILL
, CARRIER
, SERVICE_LEVEL
, TRANSPORTATION_METHOD
, SHIP_FROM_EDI_LOCATION_CODE1
, SHIP_FROM_EDI_LOCATION_CODE2
, SHIP_FROM_ADDRESS1
, SHIP_FROM_ADDRESS2
, SHIP_FROM_ADDRESS3
, SHIP_FROM_CITY
, SHIP_FROM_COUNTRY_CODE
, SHIP_FROM_POSTAL_CODE
, SHIP_FROM_REGION
, SHIP_TO_EDI_LOCATION_CODE1
, SHIP_TO_EDI_LOCATION_CODE2
, SHIP_TO_ADDRESS1
, SHIP_TO_ADDRESS2
, SHIP_TO_ADDRESS3
, SHIP_TO_CITY
, SHIP_TO_COUNTRY_CODE
, SHIP_TO_POSTAL_CODE
, SHIP_TO_REGION
FROM APPS.CLN_WSH_SS_SHIPMENT_V;
APPS.CLN_WSH_SS_SHIPMENT_V is not referenced by any database object
|
|
|