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]

TABLE: MST.MST_TMP_PLN_LOC

Object Details

Object Name:	MST_TMP_PLN_LOC
Object Type:	TABLE
Owner:	MST
Subobject Name:
Status:	VALID

Snapshot creates table for storing locations associated with collected delivery details. These tables are created in table space in which MST_TMP_PLN_LOC is created and used the same extents as this table.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
PLAN_ID	NUMBER		Yes	This column stores the plan id
LOCATION_ID	NUMBER		Yes	This column stores the location id associated with collected delivery details

Query Text

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


SELECT PLAN_ID
,      LOCATION_ID
FROM MST.MST_TMP_PLN_LOC;

Dependencies

[top of page]

MST.MST_TMP_PLN_LOC does not reference any database object

MST.MST_TMP_PLN_LOC is referenced by following:

APPS: MST_TMP_PLN_LOC