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

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
ACCESS_ID	NUMBER		Yes
FROM_ORGANIZATION_ID	NUMBER		Yes
TO_ORGANIZATION_ID	NUMBER		Yes
SHIP_METHOD_CODE	VARCHAR2	(100)	Yes
SHIP_MTD_MEANING	VARCHAR2	(80)
FREIGHT_CODE	VARCHAR2	(30)
FREIGHT_MEANING	VARCHAR2	(80)
LEAD_TIME	NUMBER
LEAD_TIME_UOM	VARCHAR2	(3)
DISTANCE	NUMBER
DISTANCE_UOM	VARCHAR2	(10)
INTRANSIT_TIME	NUMBER		Yes

Query Text

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


SELECT ACCESS_ID
,      FROM_ORGANIZATION_ID
,      TO_ORGANIZATION_ID
,      SHIP_METHOD_CODE
,      SHIP_MTD_MEANING
,      FREIGHT_CODE
,      FREIGHT_MEANING
,      LEAD_TIME
,      LEAD_TIME_UOM
,      DISTANCE
,      DISTANCE_UOM
,      INTRANSIT_TIME
FROM APPS.CSM_MTL_INTERORG_FREIGHTS_V;

Dependencies

[top of page]

APPS.CSM_MTL_INTERORG_FREIGHTS_V references the following:

APPS: ASG_BASE - show dependent code; CSM_INTERORG_FREIGHTS_ACC; CSP_CARRIER_DELIVERY_TIMES_V; MTL_INTERORG_SHIP_METHODS; ORG_FREIGHT_TL; WSH_CARRIER_SHIP_METHODS

APPS.CSM_MTL_INTERORG_FREIGHTS_V is not referenced by any database object