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


TABLE: APPS.MSC_PHUB_CUSTOMERS_MV

Object Details
Object Name: MSC_PHUB_CUSTOMERS_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.MSC_PHUB_CUSTOMERS_MV
TableMSC.MSC_PHUB_CUSTOMERS_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_PHUB_CUSTOMERS_MV_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnCUSTOMER_ID
ColumnCUSTOMER_SITE_ID
ColumnSR_INSTANCE_ID
ColumnREGION_ID
MSC_PHUB_CUSTOMERS_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnCUSTOMER_ID
ColumnCUSTOMER_SITE_ID
MSC_PHUB_CUSTOMERS_MV_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnCUSTOMER_NAME
ColumnCUSTOMER_SITE
ColumnZONE
ColumnSR_INSTANCE_ID
ColumnCUSTOMER_ID
ColumnCUSTOMER_SITE_ID
ColumnREGION_ID
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_ID NUMBER

CUSTOMER_SITE_ID NUMBER

SR_INSTANCE_ID NUMBER

REGION_ID NUMBER

CUSTOMER_NAME VARCHAR2 (255)
CUSTOMER_SITE VARCHAR2 (332)
ZONE VARCHAR2 (244)
ADDRESS VARCHAR2 (1600)
COUNTRY_CODE VARCHAR2 (10)
STATE_CODE VARCHAR2 (10)
CITY_CODE VARCHAR2 (10)
COUNTRY VARCHAR2 (60)
STATE VARCHAR2 (150)
CITY VARCHAR2 (60)
Query Text

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


SELECT CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      SR_INSTANCE_ID
,      REGION_ID
,      CUSTOMER_NAME
,      CUSTOMER_SITE
,      ZONE
,      ADDRESS
,      COUNTRY_CODE
,      STATE_CODE
,      CITY_CODE
,      COUNTRY
,      STATE
,      CITY
FROM APPS.MSC_PHUB_CUSTOMERS_MV;

Dependencies

[top of page]

APPS.MSC_PHUB_CUSTOMERS_MV does not reference any database object

APPS.MSC_PHUB_CUSTOMERS_MV is referenced by following:

SchemaAPPS
Materialized ViewMSC_PHUB_CUSTOMERS_MV