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

TABLE: MSC.MSC_ST_ZN_AGGR_IBUC

Object Details
Object Name: MSC_ST_ZN_AGGR_IBUC
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_ST_ZN_AGGR_IBUC
Subobject Name:
Status: VALID

This is the staging table that Stores the aggregated quantity
of the install base item instances at item,date,zone level

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SR_INVENTORY_ITEM_ID NUMBER
Yes Source inventory item identifier
SAMPLE_DATE DATE
Yes Daily Date
ZONE VARCHAR2 (60)
Zone identifier
SR_INSTANCE_ID NUMBER
Yes Instance id
QUANTITY NUMBER

Aggregated Quantity at Item-Zone level
REFRESH_ID NUMBER

REFRESH Id - Cycle Id of Planning Data pull
DELETED_FLAG NUMBER

Yes/No flag indicates whether corresponding record in ODS will be deleted
LAST_UPDATE_DATE DATE
Yes STANDARD WHO COLUMN
LAST_UPDATED_BY NUMBER
Yes STANDARD WHO COLUMN
CREATION_DATE DATE
Yes STANDARD WHO COLUMN
CREATED_BY NUMBER
Yes STANDARD WHO COLUMN
LAST_UPDATE_LOGIN NUMBER

STANDARD WHO COLUMN
REGION_ID NUMBER

Stores the Id for the corresponding zone
Query Text

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


SELECT SR_INVENTORY_ITEM_ID
,      SAMPLE_DATE
,      ZONE
,      SR_INSTANCE_ID
,      QUANTITY
,      REFRESH_ID
,      DELETED_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REGION_ID
FROM MSC.MSC_ST_ZN_AGGR_IBUC;

Dependencies

[top of page]

MSC.MSC_ST_ZN_AGGR_IBUC does not reference any database object

MSC.MSC_ST_ZN_AGGR_IBUC is referenced by following:

SchemaMSC
ViewMSC_ST_ZN_AGGR_IBUC#