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_FREIGHT_CHARGE

Object Details

Object Name:	WSHFV_FREIGHT_CHARGE
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OE.WSHFV_FREIGHT_CHARGE
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This shows charges for the shipping, handling and transportation of a shipment.

[View Source]

Columns

Name	Datatype	Length	Mandatory
FREIGHT_CHARGE_ID	NUMBER		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER
DELIVERY_ID	NUMBER
DELIVERY_NAME	VARCHAR2	(15)
HEADER_ID	NUMBER
ORDER_NUMBER	NUMBER
PICKING_LINE_DETAIL_ID	NUMBER
CONTAINER_ID	NUMBER
CONTAINER	NUMBER
CHARGE_TYPE_DESCRIPTION	VARCHAR2	(240)
FREIGHT_CHARGE_TYPE_ID	NUMBER		Yes
FREIGHT_CHARGE_TYPE_NAME	VARCHAR2	(30)	Yes
FREIGHT_CHARGE_TYPE_CODE	VARCHAR2	(30)	Yes
PICKING_HEADER_ID	NUMBER
AMOUNT	NUMBER
CURRENCY_CODE	VARCHAR2	(15)
CURRENCY_CONVERSION_DATE	DATE
CURRENCY_CONVERSION_RATE	NUMBER
CURRENCY_CONVERSION_TYPE_CODE	VARCHAR2	(30)
INVOICE_STATUS	VARCHAR2	(15)

Query Text

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


SELECT FREIGHT_CHARGE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DELIVERY_ID
,      DELIVERY_NAME
,      HEADER_ID
,      ORDER_NUMBER
,      PICKING_LINE_DETAIL_ID
,      CONTAINER_ID
,      CONTAINER
,      CHARGE_TYPE_DESCRIPTION
,      FREIGHT_CHARGE_TYPE_ID
,      FREIGHT_CHARGE_TYPE_NAME
,      FREIGHT_CHARGE_TYPE_CODE
,      PICKING_HEADER_ID
,      AMOUNT
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE_CODE
,      INVOICE_STATUS
FROM APPS.WSHFV_FREIGHT_CHARGE;

Dependencies

[top of page]

APPS.WSHFV_FREIGHT_CHARGE references the following:

APPS: SO_FREIGHT_CHARGES; SO_FREIGHT_CHARGE_TYPES; SO_HEADERS_ALL; SO_PICKING_HEADERS_ALL; WSH_DELIVERIES; WSH_PACKED_CONTAINERS

APPS.WSHFV_FREIGHT_CHARGE is not referenced by any database object