DBA Data[Home] [Help] [Dependency Information]

TABLE: MSC.MSC_ST_REGION_SITES

Object Details
Object Name: MSC_ST_REGION_SITES
Object Type: TABLE
Owner: MSC
Subobject Name:
Status: VALID


Stores mapping between regions and sites.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
REGION_ID NUMBER

Region Identifier
VENDOR_SITE_ID NUMBER

Supplier's site identifier
REGION_TYPE NUMBER

Region Type: 0 - Country, 1 - State/Province, 2 - City, 3 - Postal Code 10 - Region Types for Zones
ZONE_LEVEL NUMBER

Zone Level: 0 - Country , 1 - State/Province , 2 - City, 3 - Postal Code, Null - Zone level for regions
REFRESH_ID NUMBER

Refresh Number
SR_INSTANCE_ID NUMBER

Source instance identifier
SR_INSTANCE_CODE VARCHAR2 (3)
Source Instance code
DELETED_FLAG NUMBER

Deleted Flag
PROCESS_FLAG NUMBER

Process Flag
DATA_SOURCE_TYPE VARCHAR2 (15)
Source of Data
ST_TRANSACTION_ID NUMBER

Source Transaction id
ERROR_TEXT VARCHAR2 (2000)
Error text
BATCH_ID NUMBER

Batch identifier
MESSAGE_ID NUMBER

Message ID
COMPANY_NAME VARCHAR2 (255)
Company Name
VENDOR_NAME VARCHAR2 (255)
Supplier name
VENDOR_SITE_CODE VARCHAR2 (30)
Vendor Site Code
COUNTRY VARCHAR2 (60)
Country
COUNTRY_CODE VARCHAR2 (10)
Country Code
STATE VARCHAR2 (60)
State
STATE_CODE VARCHAR2 (10)
State Code
CITY VARCHAR2 (60)
City
CITY_CODE VARCHAR2 (10)
City Code
ZONE VARCHAR2 (60)
Zone
POSTAL_CODE_FROM VARCHAR2 (30)
Postal code from
POSTAL_CODE_TO VARCHAR2 (30)
Postal code to
CREATED_BY NUMBER

Standard WHO column
CREATION_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER

Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
REQUEST_ID NUMBER

Concurrent WHO column
PROGRAM_APPLICATION_ID NUMBER

Concurrent WHO column
PROGRAM_ID NUMBER

Concurrent WHO column
PROGRAM_UPDATE_DATE DATE

Concurrent WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
Query Text

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


SELECT REGION_ID
,      VENDOR_SITE_ID
,      REGION_TYPE
,      ZONE_LEVEL
,      REFRESH_ID
,      SR_INSTANCE_ID
,      SR_INSTANCE_CODE
,      DELETED_FLAG
,      PROCESS_FLAG
,      DATA_SOURCE_TYPE
,      ST_TRANSACTION_ID
,      ERROR_TEXT
,      BATCH_ID
,      MESSAGE_ID
,      COMPANY_NAME
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      COUNTRY
,      COUNTRY_CODE
,      STATE
,      STATE_CODE
,      CITY
,      CITY_CODE
,      ZONE
,      POSTAL_CODE_FROM
,      POSTAL_CODE_TO
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM MSC.MSC_ST_REGION_SITES;

Dependencies

[top of page]

MSC.MSC_ST_REGION_SITES does not reference any database object

MSC.MSC_ST_REGION_SITES is referenced by following:

SchemaMSC
ViewMSC_ST_REGION_SITES#