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

TABLE: MSC.MSC_ALLOCATION_BUCKETS

Object Details
Object Name: MSC_ALLOCATION_BUCKETS
Object Type: TABLE
Owner: MSC
Subobject Name:
Status: VALID


Allocation bucket start and end dates for distribution planning
Similar to msc_plan_buckets


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_ALLOCATION_BUCKETS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUCKET_INDEX
ColumnCURR_FLAG
ColumnORGANIZATION_ID
ColumnPLAN_ID
ColumnSR_INSTANCE_ID
Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes Plan Id
ORGANIZATION_ID NUMBER
Yes Organization ID
SR_INSTANCE_ID NUMBER
Yes Instance ID
BUCKET_INDEX NUMBER
Yes Bucket id
CURR_FLAG NUMBER
Yes Flag indicating whether this record is the current record
BKT_START_DATE DATE
Yes Bucket start date
BKT_END_DATE DATE
Yes Bucket End Date
DAYS_IN_BUCKET NUMBER
Yes Days in bucket
BUCKET_TYPE NUMBER
Yes Specift the bucket type: daily, weekly.
CREATION_DATE DATE
Yes Creation Date
CREATED_BY NUMBER
Yes Created by
LAST_UPDATE_DATE DATE
Yes Last update date
LAST_UPDATED_BY NUMBER
Yes Last update by
LAST_UPDATE_LOGIN NUMBER

Last update login
Query Text

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


SELECT PLAN_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      BUCKET_INDEX
,      CURR_FLAG
,      BKT_START_DATE
,      BKT_END_DATE
,      DAYS_IN_BUCKET
,      BUCKET_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM MSC.MSC_ALLOCATION_BUCKETS;

Dependencies

[top of page]

MSC.MSC_ALLOCATION_BUCKETS does not reference any database object

MSC.MSC_ALLOCATION_BUCKETS is referenced by following:

SchemaAPPS
SynonymMSC_ALLOCATION_BUCKETS