[Home] [Help] [Dependency Information]

TABLE: APPS.MSC_PHUB_ITEM_CATEGORIES_MV

Object Details

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

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_PHUB_ITEM_CATEGORIES_MV_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	CATEGORY_SET_ID SR_INSTANCE_ID SR_CATEGORY_ID ORGANIZATION_ID INVENTORY_ITEM_ID
MSC_PHUB_ITEM_CATEGORIES_MV_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	CATEGORY_SET_ID SR_INSTANCE_ID SR_CATEGORY_ID
MSC_PHUB_ITEM_CATEGORIES_MV_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	CATEGORY_SET_ID SR_INSTANCE_ID ORGANIZATION_ID INVENTORY_ITEM_ID

Columns

Query Text

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

SELECT CATEGORY_SET_ID
,      SR_INSTANCE_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      SR_CATEGORY_ID
FROM APPS.MSC_PHUB_ITEM_CATEGORIES_MV;

Dependencies

[top of page]

APPS.MSC_PHUB_ITEM_CATEGORIES_MV does not reference any database object

APPS.MSC_PHUB_ITEM_CATEGORIES_MV is referenced by following:

APPS

MSC_DEMAND_PKG - show dependent code

MSC_EXCEPTION_PKG - show dependent code

MSC_ITEM_PKG - show dependent code

MSC_PHUB_COST_PKG - show dependent code

MSC_PHUB_EXCESS_PKG - show dependent code

MSC_PHUB_ITEM_CATEGORIES_MV

MSC_PHUB_PKG - show dependent code

MSC_SUPPLIER_PKG - show dependent code

MSC_SUPPLY_PKG - show dependent code