INV_SUPPLY_DEMAND_TEMP
INV_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.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SEQ_NUM | NUMBER | 18 | Yes | Group sequence id created by supply/demand query routine | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| GROUP_ID | NUMBER | 18 | Contains the session id from supply demand or ATP query. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| 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 | 18 | This identifies the inventory organization. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | This identifies the inventory item. | ||
| 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 | 18 | This code indicates type of supply/demand source. | ||
| SUPPLY_DEMAND_TYPE | NUMBER | 18 | This code indicates if it is demand (1) or supply (2). | ||
| DISPOSITION_TYPE | NUMBER | 18 | This indicates the type of disposition. | ||
| DISPOSITION_ID | NUMBER | 18 | This column identifies a disposition. | ||
| ATP | NUMBER | ATP quantity (available to promise quantity for an atp period) | |||
| QUANTITY | NUMBER | This is the supply/demand quantity. | |||
| ON_HAND_QUANTITY | NUMBER | Projected on hand quantity based on accumulating supply and demand | |||
| ATP_PERIOD_START_DATE | DATE | This is the start date of an ATP period. | |||
| ATP_PERIOD_END_DATE | DATE | This is the 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 | This is a generic character query column 2. | ||
| C_COLUMN3 | VARCHAR2 | 240 | This is a generic character query column 3. | ||
| C_COLUMN4 | VARCHAR2 | 240 | This is a generic character query column 4. | ||
| C_COLUMN5 | VARCHAR2 | 240 | This is a generic character query column 5. | ||
| C_COLUMN6 | VARCHAR2 | 240 | This is a generic character query column 6. | ||
| C_COLUMN7 | VARCHAR2 | 240 | This is a generic character query column 7. | ||
| C_COLUMN8 | VARCHAR2 | 240 | This is a generic character query column 8. | ||
| N_COLUMN1 | NUMBER | This is a generic numeric query column. | |||
| N_COLUMN2 | NUMBER | This is a generic numeric query column. | |||
| N_COLUMN3 | NUMBER | This is a generic numeric query column. | |||
| N_COLUMN4 | NUMBER | This is a generic numeric query column. | |||
| N_COLUMN5 | NUMBER | This is a generic numeric query column. | |||
| D_COLUMN1 | DATE | This is a generic date query column. | |||
| D_COLUMN2 | DATE | This is a generic date query column. | |||
| D_COLUMN3 | DATE | This is a generic date query column. | |||
| D_COLUMN4 | DATE | This is a generic date query column. | |||
| D_COLUMN5 | DATE | This is a 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 | Indicates the unit of measure for the quantity. | ||
| RESOURCE_ID | NUMBER | 18 | This column identifies the resource. | ||
| DEPARTMENT_ID | NUMBER | 18 | This identifies the department or WIP work center. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| INV_SUPPLY_DEMAND_TEMP | inv_org_parameters | ORGANIZATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| INV_SUPPLY_DEMAND_TEMP_N1 | Non Unique | Default | SEQ_NUM, INVENTORY_ITEM_ID, RECORD_TYPE |