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

TABLE: MSC.MSC_DRP_ALLOC_RULE_DATES

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


Time phases of drp allocation rules


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_DRP_ALLOC_DATES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRULE_ID
ColumnEFFECTIVE_DATE
ColumnDISABLE_DATE
Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER
Yes Rule ID. FK to msc_drp_alloc_rules
TIME_PHASE_ID NUMBER
Yes Time phase ID
EFFECTIVE_DATE DATE
Yes Date this time phase of the allocation rule becomes effective
DISABLE_DATE DATE

Date this time phase of the allocation rule becomes inactive
DMD_PRI_OVERRIDE NUMBER
Yes Demand priority override type
FAIR_SHARE_ALLOC NUMBER
Yes Fair share allocation type
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER
Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
RES_SAFETY_QTY NUMBER

Reserved Safety Quantity
RES_SAFETY_PERCENT NUMBER

Reserved Safety Percent
Query Text

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


SELECT RULE_ID
,      TIME_PHASE_ID
,      EFFECTIVE_DATE
,      DISABLE_DATE
,      DMD_PRI_OVERRIDE
,      FAIR_SHARE_ALLOC
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      RES_SAFETY_QTY
,      RES_SAFETY_PERCENT
FROM MSC.MSC_DRP_ALLOC_RULE_DATES;

Dependencies

[top of page]

MSC.MSC_DRP_ALLOC_RULE_DATES does not reference any database object

MSC.MSC_DRP_ALLOC_RULE_DATES is referenced by following:

SchemaMSC
ViewMSC_DRP_ALLOC_RULE_DATES#