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

TABLE: INV.MTL_USER_DEMAND

Object Details
Object Name: MTL_USER_DEMAND
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_USER_DEMAND
Subobject Name:
Status: VALID


MTL_USER_DEMAND provides an interface mechanism for users to
populate their own demand information, ie, the demand sources that are
not predefined by Oracle Inventory, to be included in ATP calculation.
Once the table is populated, the information can be viewed by the
Supply / Demand Detail window. Furthermore, users can utilize ATP
rules to include/exclude this demand source in the ATP calculation.
If "Include User-Defined Demand" option in the ATP rule is set to
Yes, then the ATP calculation will include the demand information
stored in this table. Otherwise, no demand information in this table
is included.
.
The SOURCE_TYPE_ID column stores the source type, for example, 2 for
sales order, 3 for account number, 4 for WIP job/schedule and 5 for
account alias. SOURCE_ID stores the sources for source types. This
column is context sensitive; it depends on source type. For example,
if the source type is Sales Order, then this column represents sales
order id. If source type is WIP job/schedule, this means WIP entity
id. If source type is account number, then source id should store the
GL code combination id for the account number.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_USER_DEMAND_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVENTORY_ITEM_ID
ColumnORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
ORGANIZATION_ID NUMBER
Yes Organization identifier
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
SOURCE_TYPE_ID NUMBER
Yes Code to indicate the source of the demand
SOURCE_ID NUMBER
Yes Header ID for the source of the demand.
SOURCE_NAME VARCHAR2 (30)
Identifier for user-defined source type
PRIMARY_UOM_QUANTITY NUMBER
Yes Demanded quantity expressed in the item's primary unit of measure
REQUIREMENT_DATE DATE

Planned ship/issue date for demand
DEMAND_CLASS VARCHAR2 (30)
Demand class to be used if demand class ATP is on.
Query Text

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


SELECT LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      SOURCE_TYPE_ID
,      SOURCE_ID
,      SOURCE_NAME
,      PRIMARY_UOM_QUANTITY
,      REQUIREMENT_DATE
,      DEMAND_CLASS
FROM INV.MTL_USER_DEMAND;

Dependencies

[top of page]

INV.MTL_USER_DEMAND does not reference any database object

INV.MTL_USER_DEMAND is referenced by following:

SchemaAPPS
SynonymMTL_USER_DEMAND