[Home] [Help] [Dependency Information]
Object Name: | MSC_DRP_ITEM_ALLOC_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSIGNMENT_SET_ID | NUMBER | Assignment set ID | ||
ALLOCATION_RULE_ID | NUMBER | Allocation rule id | ||
INVENTORY_ITEM_ID | NUMBER | Item ID | ||
SRC_ORGANIZATION_ID | NUMBER | Source organization | ||
SRC_SR_INSTANCE_ID | NUMBER | Source org's instance id | ||
ORGANIZATION_ID | NUMBER | Yes | Receiving org id | |
SR_INSTANCE_ID | NUMBER | Yes | Receiving org instance id | |
EFFECTIVE_DATE | DATE | Yes | Effective date | |
DISABLE_DATE | DATE | Disable date | ||
DMD_PRIORITY | NUMBER | Demand priority | ||
RANK | NUMBER | Order in which order sizes are applied to each receiving org | ||
ALLOCATION_PERCENT | NUMBER | Allocation percent for fixed allocation percent | ||
ORDER_SIZE | NUMBER | Fixed lot multiplier for sizing shipments | ||
DMD_PRI_OVERRIDE | NUMBER | Yes | Demand priority override method | |
FAIR_SHARE_ALLOC | NUMBER | Yes | Fair share allocation method |
Cut, paste (and edit) the following text to query this object:
SELECT ASSIGNMENT_SET_ID
, ALLOCATION_RULE_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
FROM APPS.MSC_DRP_ITEM_ALLOC_V;
APPS.MSC_DRP_ITEM_ALLOC_V is not referenced by any database object
|
|
|