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.CSP_SHIPPING_DETAILS_V

Object Details

Object Name:	CSP_SHIPPING_DETAILS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
SHIPPING_METHOD_MEANING	VARCHAR2	(80)	Shipping Method
SHIPPING_METHOD	VARCHAR2	(30)	Shipping Method Code
SHIPPING_COST	NUMBER		Shipping Cost
ARRIVAL_DATE	DATE		Expected Arrival Date
ORGANIZATION_ID	NUMBER	(15)	Organization identifier
FROM_LOCATION_ID	NUMBER		From Location Identifier
TO_LOCATION_ID	NUMBER		To Location Identifier
DESTINATION_TYPE	VARCHAR2	(1)	Destination Type
DEFAULT_FLAG	NUMBER		Default Shipping Method
CUTOFF_TIME	DATE		Cutoff Time
DELIVERY_TIME	DATE		Delivery Time
LEAD_TIME	NUMBER		Lead Time
LEAD_TIME_UOM	VARCHAR2	(3)	Lead Time Unit of Measure
SAFETY_ZONE	NUMBER		Safety Zone
INTRANSIT_TIME	NUMBER		Intransit Time
LOCATION_SOURCE	VARCHAR2	(4)	Location Source
DISTANCE	NUMBER
DISTANCE_UOM	VARCHAR2	(10)

Query Text

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


SELECT SHIPPING_METHOD_MEANING
,      SHIPPING_METHOD
,      SHIPPING_COST
,      ARRIVAL_DATE
,      ORGANIZATION_ID
,      FROM_LOCATION_ID
,      TO_LOCATION_ID
,      DESTINATION_TYPE
,      DEFAULT_FLAG
,      CUTOFF_TIME
,      DELIVERY_TIME
,      LEAD_TIME
,      LEAD_TIME_UOM
,      SAFETY_ZONE
,      INTRANSIT_TIME
,      LOCATION_SOURCE
,      DISTANCE
,      DISTANCE_UOM
FROM APPS.CSP_SHIPPING_DETAILS_V;

Dependencies

[top of page]

APPS.CSP_SHIPPING_DETAILS_V references the following:

APPS: CSP_CARRIER_DELIVERY_TIMES; CSP_PART_SEARCH_PVT - show dependent code; FND_LOOKUP_VALUES_VL; HR_ALL_ORGANIZATION_UNITS; MTL_INTERORG_SHIP_METHODS; WSH_REGION_LOCATIONS; WSH_ZONE_REGIONS_V

APPS.CSP_SHIPPING_DETAILS_V is referenced by following:

APPS: CSM_MULTI_MOBQRY_PKG - show dependent code; CSP_DC_PARTS_V; CSP_PARTS_ORDER - show dependent code; CSP_PART_SEARCH_PVT - show dependent code; CSP_SCH_INT_PVT - show dependent code; CS_CHARGE_DETAILS_PVT - show dependent code