Skip to content

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

TABLE: MSC.MSC_ORG_AGGR_IBUC

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

This table Stores the aggregated quantity
of the install base item instances at item,date,org level

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_ORG_AGGR_IBUC_U1 NORMAL UNIQUE Tablespace ColumnSR_INSTANCE_ID
ColumnINVENTORY_ITEM_ID
ColumnSAMPLE_DATE
ColumnZONE
Columns
Name Datatype Length Mandatory Comments
SR_INSTANCE_ID NUMBER
Yes Instance id
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
SAMPLE_DATE DATE
Yes Daily Date
ZONE VARCHAR2 (60)
Zone from which supplying_org_id was derived
SUPPLYING_ORG_ID NUMBER

Organization Identifer which will service the zone
QUANTITY NUMBER

Aggregated Quantity
REFRESH_NUMBER NUMBER

REFRESH NUMBER (ODS load cycle id)
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_INSTANCE_ID
,      INVENTORY_ITEM_ID
,      SAMPLE_DATE
,      ZONE
,      SUPPLYING_ORG_ID
,      QUANTITY
,      REFRESH_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REGION_ID
FROM MSC.MSC_ORG_AGGR_IBUC;

Dependencies

[top of page]

MSC.MSC_ORG_AGGR_IBUC does not reference any database object

MSC.MSC_ORG_AGGR_IBUC is referenced by following:

SchemaMSC
ViewMSC_ORG_AGGR_IBUC#