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: MSC.MSC_REGIONS_TEMP

Object Details

Object Name:	MSC_REGIONS_TEMP
Object Type:	TABLE
Owner:	MSC
FND Design Data:	MSC.MSC_REGIONS_TEMP
Subobject Name:
Status:	VALID

This table temporarily contains geographical regions data needed for specific ATP requests.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_REGIONS_TEMP_U1	NORMAL	UNIQUE	APPS_TS_NOLOGGING	SESSION_ID PARTNER_SITE_ID REGION_ID PARTNER_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
SESSION_ID	NUMBER		Yes	Session Id
PARTNER_SITE_ID	NUMBER		Yes	Partner Site Id
REGION_ID	NUMBER		Yes	Region Id
REGION_TYPE	NUMBER		Yes	(0) Country, (1) State, (2) City, (3) Zipcode
ZONE_FLAG	VARCHAR2	(1)		(Y) Region zone, (N) Region
PARTNER_TYPE	NUMBER			Partner_type: 1- Supplier, 2- Customer

Query Text

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


SELECT SESSION_ID
,      PARTNER_SITE_ID
,      REGION_ID
,      REGION_TYPE
,      ZONE_FLAG
,      PARTNER_TYPE
FROM MSC.MSC_REGIONS_TEMP;

Dependencies

[top of page]

MSC.MSC_REGIONS_TEMP does not reference any database object

MSC.MSC_REGIONS_TEMP is referenced by following:

APPS: MSC_REGIONS_TEMP