[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_ALLOCATION_BUCKETS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
BUCKET_INDEX
CURR_FLAG ORGANIZATION_ID PLAN_ID SR_INSTANCE_ID |
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 |
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;
MSC.MSC_ALLOCATION_BUCKETS does not reference any database object
MSC.MSC_ALLOCATION_BUCKETS is referenced by following:
|
|
|