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

Object Details

Object Name:	MSC_LOCATIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MSC.MSC_LOCATIONS_V
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
FROM_LOCATION_ID	NUMBER	(15)
FROM_LOCATION	VARCHAR2	(4000)
FROM_LOCATION_DESC	VARCHAR2	(60)
FROM_ORGANIZATION_ID	NUMBER		Yes
SR_INSTANCE_ID	NUMBER		Yes
TO_LOCATION_ID	NUMBER	(15)
TO_LOCATION	VARCHAR2	(4000)
TO_LOCATION_DESC	VARCHAR2	(60)
TO_ORGANIZATION_ID	NUMBER		Yes
SR_INSTANCE_ID2	NUMBER		Yes
FROM_LOCATION_ORG_TYPE	NUMBER
TO_LOCATION_ORG_TYPE	NUMBER

Query Text

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


SELECT FROM_LOCATION_ID
,      FROM_LOCATION
,      FROM_LOCATION_DESC
,      FROM_ORGANIZATION_ID
,      SR_INSTANCE_ID
,      TO_LOCATION_ID
,      TO_LOCATION
,      TO_LOCATION_DESC
,      TO_ORGANIZATION_ID
,      SR_INSTANCE_ID2
,      FROM_LOCATION_ORG_TYPE
,      TO_LOCATION_ORG_TYPE
FROM APPS.MSC_LOCATIONS_V;

Dependencies

[top of page]

APPS.MSC_LOCATIONS_V references the following:

APPS: MSC_GET_NAME - show dependent code; MSC_INTERORG_SHIP_METHODS; MSC_TRADING_PARTNERS; MSC_TRADING_PARTNER_SITES

APPS.MSC_LOCATIONS_V is not referenced by any database object