eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: MSC.MSC_DRP_ITEM_ALLOCATIONS

Object Details

Object Name:	MSC_DRP_ITEM_ALLOCATIONS
Object Type:	TABLE
Owner:	MSC
Subobject Name:
Status:	VALID

Denormalized table containing allocation rules used by the plan

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Mandatory	Comments
ASSIGNMENT_SET_ID	NUMBER		Assignment set id
ALLOCATION_RULE_ID	NUMBER	Yes	Allocation rule id
PLAN_ID	NUMBER	Yes	Plan id
INVENTORY_ITEM_ID	NUMBER	Yes	Item id
SRC_ORGANIZATION_ID	NUMBER	Yes	Source org id
SRC_SR_INSTANCE_ID	NUMBER	Yes	Source org's instance id
ORGANIZATION_ID	NUMBER	Yes	Destination org id
SR_INSTANCE_ID	NUMBER	Yes	Destination org's instance id
EFFECTIVE_DATE	DATE	Yes	Starting effective date for the rule
DISABLE_DATE	DATE		Disable date for the rule
DMD_PRIORITY	NUMBER		Demand priority for priority override
RANK	NUMBER		Rank
ALLOCATION_PERCENT	NUMBER		Allocation percent
ORDER_SIZE	NUMBER		Order size
DMD_PRI_OVERRIDE	NUMBER		Type of dmd priority override to use
FAIR_SHARE_ALLOC	NUMBER		Fair share allocation method
CREATED_BY	NUMBER	Yes	Standard who column
CREATION_DATE	DATE	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	Yes	Standard who column
LAST_UPDATE_DATE	DATE	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER		Standard who column
MIN_ORDER_QTY	NUMBER		Minimum Order Quantity
MAX_ORDER_QTY	NUMBER		Maximum Order Quantity

Query Text

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


SELECT ASSIGNMENT_SET_ID
,      ALLOCATION_RULE_ID
,      PLAN_ID
,      INVENTORY_ITEM_ID
,      SRC_ORGANIZATION_ID
,      SRC_SR_INSTANCE_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      EFFECTIVE_DATE
,      DISABLE_DATE
,      DMD_PRIORITY
,      RANK
,      ALLOCATION_PERCENT
,      ORDER_SIZE
,      DMD_PRI_OVERRIDE
,      FAIR_SHARE_ALLOC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      MIN_ORDER_QTY
,      MAX_ORDER_QTY
FROM MSC.MSC_DRP_ITEM_ALLOCATIONS;

Dependencies

[top of page]

MSC.MSC_DRP_ITEM_ALLOCATIONS does not reference any database object

MSC.MSC_DRP_ITEM_ALLOCATIONS is referenced by following:

MSC: MSC_DRP_ITEM_ALLOCATIONS#