[Home] [Help] [Dependency Information]
Object Name: | MSC_SUPPLIER_TREE_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
Container: | MSC_SUPPLIER_TREE_MV |
---|---|
Updatable: | N |
Rewrite Enabled: | Y |
Rewrite Capability: | GENERAL |
Refresh Mode: | DEMAND |
Refresh Method: | COMPLETE |
Build Mode: | IMMEDIATE |
Fast Refreshable: | NO |
MSC_TRADING_PARTNERS
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Yes | ||
SUPPLIER_ID | NUMBER | Yes | ||
SUPPLIER_SITE_ID | NUMBER | |||
CATEGORY_SET_ID | NUMBER | Yes | ||
SUPPLIER_NAME | VARCHAR2 | (100) | Yes | |
PARTNER_TYPE | NUMBER | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, SUPPLIER_ID
, SUPPLIER_SITE_ID
, CATEGORY_SET_ID
, SUPPLIER_NAME
, PARTNER_TYPE
FROM MSC.MSC_SUPPLIER_TREE_MV;
MSC.MSC_SUPPLIER_TREE_MV is not referenced by any database object
|
|
|