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

TABLE: INV.MTL_SUPPLY_DEMAND_TEMP

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


MTL_SUPPLY_DEMAND_TEMP serves as a temporary table for ATP and
supply/demand detail queries. SEQ_NUM is created by the routines to
distinguish records from other queries. Furthermore, RECORD_TYPE is
used to distinguish an ATP record from a supply/demand record for the
same query (i.e., same SEQ_NUM). In an ATP query, both ATP and
supply/demand records are populated into this table. Thus, when
performing an ATP query, RECORD_TYPE is internally set as 'ATP' and
D_COLUMNs and N_COLUMNs are generic column names for storing
character, date and number information respectively.


Storage Details
Tablespace: TablespaceAPPS_TS_NOLOGGING
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_SUPPLY_DEMAND_TEMP_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_NOLOGGING ColumnSEQ_NUM
ColumnINVENTORY_ITEM_ID
ColumnRECORD_TYPE
Columns
Name Datatype Length Mandatory Comments
SEQ_NUM NUMBER
Yes Group sequence id created by supply/demand query routine
GROUP_ID NUMBER

Contains the session id from supply demand or ATP query.
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
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
ROW_NUMBER NUMBER

Row sequence number for the record
RECORD_TYPE VARCHAR2 (10)
Type to internally distinguish record between ATP and supply/demand queries
ORGANIZATION_ID NUMBER

Organization identifier
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
ATP_PERIOD_TOTAL_SUPPLY NUMBER

Total supply for an item in an ATP period
ATP_PERIOD_TOTAL_DEMAND NUMBER

Total demand for an item in an ATP period
SUPPLY_DEMAND_SOURCE_TYPE NUMBER

Supply/demand source code
SUPPLY_DEMAND_TYPE NUMBER

1 - demand, 2 - supply
DISPOSITION_TYPE NUMBER

Disposition type
DISPOSITION_ID NUMBER

Disposition id
ATP NUMBER

ATP quantity (available to promise quantity for an atp period)
QUANTITY NUMBER

Supply/demand quantity
ON_HAND_QUANTITY NUMBER

Projected on hand quantity based on accumulating supply and demand
ATP_PERIOD_START_DATE DATE

Start date of an ATP period
ATP_PERIOD_END_DATE DATE

End date of an ATP period
REQUIREMENT_DATE DATE

Requirement date for a supply/demand
C_COLUMN1 VARCHAR2 (240)
Source name from MTL_DEMAND, MTL_USER_DEMAND and MTL_USER_SUPPLY
C_COLUMN2 VARCHAR2 (240)
Generic character query column
C_COLUMN3 VARCHAR2 (240)
Generic character query column
C_COLUMN4 VARCHAR2 (240)
Generic character query column
C_COLUMN5 VARCHAR2 (240)
Generic character query column
C_COLUMN6 VARCHAR2 (240)
Generic character query column
C_COLUMN7 VARCHAR2 (240)
Generic character query column
C_COLUMN8 VARCHAR2 (240)
Generic character query column
N_COLUMN1 NUMBER

Generic numeric query column
N_COLUMN2 NUMBER

Generic numeric query column
N_COLUMN3 NUMBER

Generic numeric query column
N_COLUMN4 NUMBER

Generic numeric query column
N_COLUMN5 NUMBER

Generic numeric query column
D_COLUMN1 DATE

Generic date query column
D_COLUMN2 DATE

Generic date query column
D_COLUMN3 DATE

Generic date query column
D_COLUMN4 DATE

Generic date query column
D_COLUMN5 DATE

Generic date query column
PERIOD_NET_AVAILABLE NUMBER

ATP_PERIOD_TOTAL_SUPPLY - ATP_PERIOD_TOTAL_DEMAND, populated for Period ATP rows only
UOM_CODE VARCHAR2 (3)
The uom for the quantity.
RESOURCE_ID NUMBER

Resource identifier
DEPARTMENT_ID NUMBER

Department identifier
Query Text

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


SELECT SEQ_NUM
,      GROUP_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ROW_NUMBER
,      RECORD_TYPE
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      ATP_PERIOD_TOTAL_SUPPLY
,      ATP_PERIOD_TOTAL_DEMAND
,      SUPPLY_DEMAND_SOURCE_TYPE
,      SUPPLY_DEMAND_TYPE
,      DISPOSITION_TYPE
,      DISPOSITION_ID
,      ATP
,      QUANTITY
,      ON_HAND_QUANTITY
,      ATP_PERIOD_START_DATE
,      ATP_PERIOD_END_DATE
,      REQUIREMENT_DATE
,      C_COLUMN1
,      C_COLUMN2
,      C_COLUMN3
,      C_COLUMN4
,      C_COLUMN5
,      C_COLUMN6
,      C_COLUMN7
,      C_COLUMN8
,      N_COLUMN1
,      N_COLUMN2
,      N_COLUMN3
,      N_COLUMN4
,      N_COLUMN5
,      D_COLUMN1
,      D_COLUMN2
,      D_COLUMN3
,      D_COLUMN4
,      D_COLUMN5
,      PERIOD_NET_AVAILABLE
,      UOM_CODE
,      RESOURCE_ID
,      DEPARTMENT_ID
FROM INV.MTL_SUPPLY_DEMAND_TEMP;

Dependencies

[top of page]

INV.MTL_SUPPLY_DEMAND_TEMP does not reference any database object

INV.MTL_SUPPLY_DEMAND_TEMP is referenced by following:

SchemaINV
ViewMTL_SUPPLY_DEMAND_TEMP#