eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.WSHFV_DELIVERIES

Object Details

Object Name:	WSHFV_DELIVERIES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WSH.WSHFV_DELIVERIES
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_ID	NUMBER		Yes	Delivery Id
NAME	VARCHAR2	(30)	Yes	Delivery Name
ORGANIZATION_ID	NUMBER
ORGANIZATION_CODE	VARCHAR2	(3)
ORGANIZATION_NAME	VARCHAR2	(240)
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER
_LA:STATUS_CODE	CHAR	(51)		Lookup - Status Code
CONFIRM_DATE	DATE			Confirm Date
LOADING_SEQUENCE	NUMBER			Loading Sequence
CUSTOMER_ID	NUMBER			Customer Id
CUSTOMER_NAME	VARCHAR2	(360)		Customer Name
CUSTOMER_NUMBER	VARCHAR2	(30)		Customer Number
ULTIMATE_DROPOFF_LOCATION_ID	NUMBER		Yes	Ultimate Dropoff Location Id
ULTIMATE_DROPOFF_DESCRIPTION	VARCHAR2	(500)		Ultimate Dropoff Location Description
INTMED_SHIP_TO_LOCATION_ID	NUMBER			Intermediate Ship To Location Id
INTMED_SHIP_TO_DESCRIPTION	VARCHAR2	(500)		Intermediate Ship To Location Description
POOLED_SHIP_TO_LOCATION_ID	NUMBER
POOLED_SHIP_TO_DESCRIPTION	VARCHAR2	(500)		Pooled Ship To Location Description
WAYBILL	VARCHAR2	(30)		Waybill
GROSS_WEIGHT	NUMBER			Gross Weight
WEIGHT_UOM_CODE	VARCHAR2	(3)		Weight UOM Code
VOLUME	NUMBER			Volume
VOLUME_UOM_CODE	VARCHAR2	(3)		Volume UOM Code
ULTIMATE_DROPOFF_DATE	DATE			Ultimate Dropoff Date
ASN_DATE_SENT	DATE			ASN Date Sent
ASN_SEQ_NUMBER	NUMBER			ASN Sequence Number
LOADING_ORDER_FLAG	VARCHAR2	(2)		Loading Order Flag
FREIGHT_TERMS_CODE	VARCHAR2	(30)		Freight Terms Code
CURRENCY_CODE	VARCHAR2	(15)		Currency Code
_LA:PLANNED_FLAG	CHAR	(43)		Lookup - Planned Flag
INITIAL_PICKUP_DATE	DATE			Initial Pickup Date
INITIAL_PICKUP_LOCATION_ID	NUMBER		Yes	Initial Pickup Location Id
INIT_PICKUP_LOCATION	VARCHAR2	(500)		Initial Pickup Location Description
FOB_LOCATION_ID	NUMBER			FOB Location Id
FOB_LOCATION	VARCHAR2	(500)		FOB Location Description
_LA:ACCEPTANCE_FLAG	CHAR	(46)		Lookup - Acceptance Flag
ACCEPTED_BY	VARCHAR2	(150)		Accepted By
ACCEPTED_DATE	DATE			Accepted Date
ACKNOWLEDGED_BY	VARCHAR2	(150)		Acknowledged By
CONFIRMED_BY	VARCHAR2	(150)		Confirmed By
REASON_OF_TRANSPORT	VARCHAR2	(30)		Reason Of Transport
DESCRIPTION	VARCHAR2	(30)		Description
NET_WEIGHT	NUMBER			Net Weight
PORT_OF_DISCHARGE	VARCHAR2	(150)		Port of Discharge
PORT_OF_LOADING	VARCHAR2	(150)		Port of Loading
ADDITIONAL_SHIPMENT_INFO	VARCHAR2	(500)		Additional Shipment Information
BOOKING_NUMBER	VARCHAR2	(30)		Booking Number
COD_AMOUNT	NUMBER			COD Amount
COD_CURRENCY_CODE	VARCHAR2	(15)		COD Currency Code
SERVICE_CONTRACT	VARCHAR2	(30)		Service Contract
COD_REMIT_TO	VARCHAR2	(150)		COD Remit to
COD_CHARGE_PAID_BY	VARCHAR2	(150)		COD Charge Paid By
PROBLEM_CONTACT_REFERENCE	VARCHAR2	(500)		Problem Contact Reference
BILL_FREIGHT_TO	VARCHAR2	(1000)		Bill Freight To
CARRIED_BY	VARCHAR2	(150)		Carried By
DOCK_CODE	VARCHAR2	(30)		Dock Code
DELIVERY_TYPE	VARCHAR2	(30)	Yes	Delivery Type
CARRIER_ID	NUMBER			Carrier id
NUMBER_OF_LPN	NUMBER			Number of LPN
_LA:SHIP_METHOD_CODE	CHAR	(61)		Lookup - Ship Method Code
_LA:FOB_CODE	CHAR	(45)		Lookup - FOB Code
_DF:DELIVERY	CHAR	(30)		Descriptive Flexfield - Delivery
_DF:AUTOMOTIVE	CHAR	(34)		Descriptive Flexfield - Automotive
_DF:GLOBAL	CHAR	(32)		Descriptive Flexfield - Global

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DELIVERY_ID
,      NAME
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      _LA:STATUS_CODE
,      CONFIRM_DATE
,      LOADING_SEQUENCE
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      ULTIMATE_DROPOFF_LOCATION_ID
,      ULTIMATE_DROPOFF_DESCRIPTION
,      INTMED_SHIP_TO_LOCATION_ID
,      INTMED_SHIP_TO_DESCRIPTION
,      POOLED_SHIP_TO_LOCATION_ID
,      POOLED_SHIP_TO_DESCRIPTION
,      WAYBILL
,      GROSS_WEIGHT
,      WEIGHT_UOM_CODE
,      VOLUME
,      VOLUME_UOM_CODE
,      ULTIMATE_DROPOFF_DATE
,      ASN_DATE_SENT
,      ASN_SEQ_NUMBER
,      LOADING_ORDER_FLAG
,      FREIGHT_TERMS_CODE
,      CURRENCY_CODE
,      _LA:PLANNED_FLAG
,      INITIAL_PICKUP_DATE
,      INITIAL_PICKUP_LOCATION_ID
,      INIT_PICKUP_LOCATION
,      FOB_LOCATION_ID
,      FOB_LOCATION
,      _LA:ACCEPTANCE_FLAG
,      ACCEPTED_BY
,      ACCEPTED_DATE
,      ACKNOWLEDGED_BY
,      CONFIRMED_BY
,      REASON_OF_TRANSPORT
,      DESCRIPTION
,      NET_WEIGHT
,      PORT_OF_DISCHARGE
,      PORT_OF_LOADING
,      ADDITIONAL_SHIPMENT_INFO
,      BOOKING_NUMBER
,      COD_AMOUNT
,      COD_CURRENCY_CODE
,      SERVICE_CONTRACT
,      COD_REMIT_TO
,      COD_CHARGE_PAID_BY
,      PROBLEM_CONTACT_REFERENCE
,      BILL_FREIGHT_TO
,      CARRIED_BY
,      DOCK_CODE
,      DELIVERY_TYPE
,      CARRIER_ID
,      NUMBER_OF_LPN
,      _LA:SHIP_METHOD_CODE
,      _LA:FOB_CODE
,      _DF:DELIVERY
,      _DF:AUTOMOTIVE
,      _DF:GLOBAL
FROM APPS.WSHFV_DELIVERIES;

Dependencies

[top of page]

APPS.WSHFV_DELIVERIES references the following:

APPS: HR_ALL_ORGANIZATION_UNITS; HZ_CUST_ACCOUNTS; HZ_PARTIES; MTL_PARAMETERS; WSH_LOCATIONS; WSH_NEW_DELIVERIES

APPS.WSHFV_DELIVERIES is not referenced by any database object