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_PLAN_ZIP_LOCATIONS

Object Details

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

It stores all the locations in plan.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
PLAN_ID	NUMBER		Yes	FK to MST_PLANS.
ZIP_LOCATION_ID	NUMBER		Yes	Sequence number
COUNTRY	VARCHAR2	(60)	Yes	country name
STATE	VARCHAR2	(60)	Yes	state name
COUNTY	VARCHAR2	(60)		country name
CITY	VARCHAR2	(60)		city name
ZIP	VARCHAR2	(60)		zip code

Query Text

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


SELECT PLAN_ID
,      ZIP_LOCATION_ID
,      COUNTRY
,      STATE
,      COUNTY
,      CITY
,      ZIP
FROM MST.MST_PLAN_ZIP_LOCATIONS;

Dependencies

[top of page]

MST.MST_PLAN_ZIP_LOCATIONS does not reference any database object

MST.MST_PLAN_ZIP_LOCATIONS is referenced by following:

APPS: MST_PLAN_ZIP_LOCATIONS