[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MTL_DEMAND_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | INV |
| FND Design Data: |  INV.MTL_DEMAND_INTERFACE
|
| Subobject Name: | |
| Status: | VALID |
MTL_DEMAND_INTERFACE is the interface point between non-Inventory
applications and the Inventory demand module.
Records inserted into this table are processed by the Demand Manager
concurrent program. ACTION_CODE column determines which Inventory function to perform.
ACTION_CODE also governs the requirements for different parameters.
In other words, different functions may require different parameters.
MTL_DEMAND_INTERFACE follows the Inventory standard for interfacing
flexfields. Any parameters which are represented by flexfields may be
entered in the interface table either as code combination identifiers
or as flexfield segment combinations. The Demand Manager will
validate that any given identifiers are valid and enabled. If no
identifier is given, then the Demand Manager will validate and decode
the flexfield segment values where appropriate. The Demand Manger
creates new sales order flexfield combinations in the database, if the
passed one does not exist.
The Demand Manager uses the columns TRANSACTION_MODE, PROCESS_FLAG,
and ERROR_CODE to manipulate the records in the table. Only records
with PROCESS_FLAG of '1' and ERROR_CODE of NULL will be processed. If
a record fails to process completely, then ERROR_CODE will be given a
number indicating what type of error has occurred.
Almost all the demand and reservation functions can be performed
through this interface table. Again, ACTION_CODE determines what
function to perform. The following lists all the demand reservation
functions that are currently supported through interface table.
Action: 100 Function: ATP Check
Perform a group ATP check.
Action: 110 Function: Demand Add
Add a new demand or replace an existing demand.
Action: 130 Function: Reservation Add
Add a new reservation or replace an existing reservation.
Action: 140 Function: Reservation Modify
Modify an existing reservation.
Action: 150 Function: Demand and Reservation Add
Add/replace a demand and a reservation
Action: 160 Function: Demand and Reservation Transfer
Transfer an open demand or a reservation to a new delivery..
Action: 210 Function: Link Supply Demand
Establish a linkage between a demand and a WIP job (ie, a supply
source).
Action: 220 Function: Delink Supply Demand
Remove a linkage between a demand and a WIP job (ie, a supply source).
Action: 320 Function: WIP Job Completion
Convert a WIP job reservation to an on-hand reservation..
Action: 330 Function: WIP Job Return
Convert an on-hand reservation back to a WIP job reservation.
Action: 410 Function: Update Forecast Attributes
Update forecast attributes.
Action: 420 Function: Pick Release
Pick release demands or reservations.
Action: 610 Function: ATS Query
Provide the on-hand quantity and available to reserve quantity for an
item given a specified inventory control detail.
Action: 620 Function: ATS Quick Pick
Provide all the on-hand quantity and available to reserve quantity for
an item within each specified control detail.
Action: 630 Function: Link Configuration Item
Create a configuration demand and deactivate a set of demands that
represent the customer order.
Action: 640 Function: Delink Configuration Item
Delete a configuration demand and reactivate the corresponding set of
customer demands.
Action: 650 Function: Decrease Configuration Item Quantity
Decrease a configuration item quantity. The quantities in the
corresponding set of customer demands are decremented accordingly.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MTL_DEMAND_INTERFACE_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
 SCHEDULE_GROUP_ID
N_COLUMN5
|
| MTL_DEMAND_INTERFACE_N10 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
PROCESS_FLAG
|
| MTL_DEMAND_INTERFACE_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
ATP_GROUP_ID
INVENTORY_ITEM_ID
|
| MTL_DEMAND_INTERFACE_N3 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
EXPLOSION_GROUP_ID
|
| MTL_DEMAND_INTERFACE_N5 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
DEMAND_SOURCE_LINE
|
| MTL_DEMAND_INTERFACE_N6 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
DEMAND_SOURCE_DELIVERY
|
| MTL_DEMAND_INTERFACE_N7 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
ORGANIZATION_ID
INVENTORY_ITEM_ID
|
| MTL_DEMAND_INTERFACE_N8 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
SESSION_ID
SCHEDULE_GROUP_ID
|
| MTL_DEMAND_INTERFACE_N9 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
SCHEDULE_GROUP_ID
TRANSACTION_MODE
PROCESS_FLAG
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SCHEDULE_GROUP_ID | NUMBER | Identifies a group of transactions that are to be processed together. All transactions in the group must succeed or the group will be failed | ||
| DEMAND_SOURCE_TYPE | NUMBER | Code to indicate the source of the demand | ||
| DEMAND_SOURCE_HEADER_ID | NUMBER | Header ID for the source of the demand. For Sales order demand: MTL_SALES_ORDERS.SALES_ORDER_ID, For Account number: GL_CODE_COMBINATIONS.CODE_COMBINATION_ID, For Account Alias: MTL_GENERIC_DISPOSITIONS.DISPOSITION_ID | ||
| DEMAND_SOURCE_LINE | VARCHAR2 | (30) | Line id of demand source. For Sales Order demand this is: SO_LINES.LINE_ID | |
| DEMAND_SOURCE_DELIVERY | VARCHAR2 | (30) | For Sales Order demand, Line id of Sales order line detail row (SO_LINE_DETAILS.LINE_DETAIL_ID) | |
| LOCK_FLAG | NUMBER | Used by demand functions to lock a parent row when updating so that other processes will not update this parent and its children rows at the same time | ||
| ATP_CHECK | NUMBER | Flag to indicate if the item in the row should be ATP checked. If null then the validator will atomatically populate it from ATP_FLAG in MTL_SYSTEM_ITEMS | ||
| ACTION_CODE | NUMBER | An interface code to activate one of the Inventory demand functions | ||
| VALIDATE_ROWS | NUMBER | Flag to indicate if the row need to be validated before being processed. Should be set to Yes in most situations | ||
| TRANSACTION_MODE | NUMBER | A flag to indicate processing mode: 1 - Online; 2 - Immediate Concurrent Program Mode; ; 3 - Batch | ||
| PROCESS_FLAG | NUMBER | A flag to indicate if row should be processed by demand interface processor. | ||
| SINGLE_LOT_FLAG | NUMBER | Flag to indicate if the reservation should reserve the request quantity from a single lot | ||
| DETAIL_RESERVE_FLAG | NUMBER | (not currently used) | ||
| RESERVE_LEVEL | NUMBER | Code to indicate which level of detail for the reservation. 0 - Organization Level; 1 - Item Level; 2 - Revision Level; 3 - Lot Level; 5 - Subinventory Level; 6 - Locator Level | ||
| CHECK_ATR | NUMBER | Flag to indicate if Available to Reserve check should be completed. In most situation this flag should be set to Yes | ||
| 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 | ||
| ERROR_CODE | NUMBER | Error code returned by the demand processor | ||
| ERR_EXPLANATION | VARCHAR2 | (240) | Error explanation text | |
| REQUIREMENT_DATE | DATE | Earliest date that demand should be scheduled. If null then it is treated as today's date | ||
| LINE_ITEM_UNIT_OF_MEASURE | VARCHAR2 | (25) | Long name of the unit of measure of the LINE_ITEM_QUANTITY | |
| LINE_ITEM_UOM | VARCHAR2 | (3) | Unit of mesaure code of line item quantity. If both LINE_ITEM_UOM and LINE_ITEM_UNIT_OF_MEASURE are not specified, validator will automatically populate it as primary uom code | |
| LINE_ITEM_QUANTITY | NUMBER | Yes | The item quantity with respect to the line item uom. | |
| LINE_ITEM_RESERVATION_QTY | NUMBER | Item reservation quantity in terms of line item uom | ||
| PRIMARY_UOM | VARCHAR2 | (3) | The line item qty with respect to the item's primary uom from MTL_SYSTEM_ITEMS. The validator automatically populates this column | |
| PRIMARY_UOM_QUANTITY | NUMBER | The line item qty with respect to the item's primary uom, vaidator populated | ||
| RESERVATION_QUANTITY | NUMBER | Reservation quantity in terms of primary unit of measure of the item, validator populated | ||
| ATP_RULE_ID | NUMBER | ATP rule identifier, validator populated if null | ||
| ORGANIZATION_ID | NUMBER | Organization identifier | ||
| ORGANIZATION_NAME | VARCHAR2 | (60) | Organization identifier by name | |
| INVENTORY_ITEM_ID | NUMBER | Inventory item identifier | ||
| ITEM_SEGMENT1 | VARCHAR2 | (40) | Item Flexfield segment column | |
| ITEM_SEGMENT2 | VARCHAR2 | (40) | Item Flexfield segment column | |
| ITEM_SEGMENT3 | VARCHAR2 | (40) | Item Flexfield segment column | |
| ITEM_SEGMENT4 | VARCHAR2 | (40) | Item Flexfield segment column | |
| ITEM_SEGMENT5 | VARCHAR2 | (40) | Item Flexfield segment column | |
| ITEM_SEGMENT6 | VARCHAR2 | (40) | Item Flexfield segment column | |
| ITEM_SEGMENT7 | VARCHAR2 | (40) | Item Flexfield segment column | |
| ITEM_SEGMENT8 | VARCHAR2 | (40) | Item Flexfield segment column | |
| ITEM_SEGMENT9 | VARCHAR2 | (40) | Item Flexfield segment column | |
| ITEM_SEGMENT10 | VARCHAR2 | (40) | Item Flexfield segment column | |
| ITEM_SEGMENT11 | VARCHAR2 | (40) | Item Flexfield segment column | |
| ITEM_SEGMENT12 | VARCHAR2 | (40) | Item Flexfield segment column | |
| ITEM_SEGMENT13 | VARCHAR2 | (40) | Item Flexfield segment column | |
| ITEM_SEGMENT14 | VARCHAR2 | (40) | Item Flexfield segment column | |
| ITEM_SEGMENT15 | VARCHAR2 | (40) | Item Flexfield segment column | |
| ITEM_SEGMENT16 | VARCHAR2 | (40) | Item Flexfield segment column | |
| ITEM_SEGMENT17 | VARCHAR2 | (40) | Item Flexfield segment column | |
| ITEM_SEGMENT18 | VARCHAR2 | (40) | Item Flexfield segment column | |
| ITEM_SEGMENT19 | VARCHAR2 | (40) | Item Flexfield segment column | |
| ITEM_SEGMENT20 | VARCHAR2 | (40) | Item Flexfield segment column | |
| DEMAND_HEADER_SEGMENT1 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT2 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT3 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT4 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT5 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT6 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT7 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT8 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT9 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT10 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT11 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT12 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT13 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT14 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT15 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT16 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT17 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT18 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT19 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT20 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT21 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT22 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT23 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT24 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT25 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT26 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT27 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT28 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT29 | VARCHAR2 | (40) | Flexfield segment column | |
| DEMAND_HEADER_SEGMENT30 | VARCHAR2 | (40) | Flexfield segment column | |
| EXTERNAL_SOURCE_CODE | VARCHAR2 | (30) | Used to document external sourced demand | |
| EXTERNAL_SOURCE_LINE_ID | NUMBER | Used to document external sourced demand | ||
| SUPPLY_SOURCE_TYPE | NUMBER | Source of supply for reservation, only populated if reservation is not to on hand | ||
| SUPPLY_HEADER_ID | NUMBER | Header id of reservation supply source, for example if supply source is WIP then it is WIP_DISCRETE_JOBS.WIP_ENTITY_ID | ||
| USER_LINE_NUM | VARCHAR2 | (30) | For sales order demand this is SO_LINES.LINE_NUMBER, used for display only | |
| USER_DELIVERY | VARCHAR2 | (30) | User identifier of demand source. For sales order demand it is taken from SO_LINES.LINE_NUMBER of the schedule line, used for display only | |
| REVISION | VARCHAR2 | (3) | The item revision reserved, only populated for reservation rows that reference a specific revision | |
| LOT_NUMBER | VARCHAR2 | (80) | The specific lot number reserved, only populated for reservation rows for a specific lot number | |
| SERIAL_NUMBER | VARCHAR2 | (30) | (not currently used) | |
| SUBINVENTORY | VARCHAR2 | (10) | Subinventory demanded or reserved, can be populated for summary demand rows | |
| LOCATOR_ID | NUMBER | Location identifier for reserved item, only populated when reservation is specific to a locator | ||
| LOC_SEGMENT1 | VARCHAR2 | (40) | Locator flexfield segment column | |
| LOC_SEGMENT2 | VARCHAR2 | (40) | Locator flexfield segment column | |
| LOC_SEGMENT3 | VARCHAR2 | (40) | Locator flexfield segment column | |
| LOC_SEGMENT4 | VARCHAR2 | (40) | Locator flexfield segment column | |
| LOC_SEGMENT5 | VARCHAR2 | (40) | Locator flexfield segment column | |
| LOC_SEGMENT6 | VARCHAR2 | (40) | Locator flexfield segment column | |
| LOC_SEGMENT7 | VARCHAR2 | (40) | Locator flexfield segment column | |
| LOC_SEGMENT8 | VARCHAR2 | (40) | Locator flexfield segment column | |
| LOC_SEGMENT9 | VARCHAR2 | (40) | Locator flexfield segment column | |
| LOC_SEGMENT10 | VARCHAR2 | (40) | Locator flexfield segment column | |
| LOC_SEGMENT11 | VARCHAR2 | (40) | Locator flexfield segment column | |
| LOC_SEGMENT12 | VARCHAR2 | (40) | Locator flexfield segment column | |
| LOC_SEGMENT13 | VARCHAR2 | (40) | Locator flexfield segment column | |
| LOC_SEGMENT14 | VARCHAR2 | (40) | Locator flexfield segment column | |
| LOC_SEGMENT15 | VARCHAR2 | (40) | Locator flexfield segment column | |
| LOC_SEGMENT16 | VARCHAR2 | (40) | Locator flexfield segment column | |
| LOC_SEGMENT17 | VARCHAR2 | (40) | Locator flexfield segment column | |
| LOC_SEGMENT18 | VARCHAR2 | (40) | Locator flexfield segment column | |
| LOC_SEGMENT19 | VARCHAR2 | (40) | Locator flexfield segment column | |
| LOC_SEGMENT20 | VARCHAR2 | (40) | Locator flexfield segment column | |
| AUTODETAIL_GROUP_ID | NUMBER | ID used when calling the Autodetail process | ||
| COMPONENT_SEQUENCE_ID | NUMBER | Id of BOM structure for demand associated with ATO Models, if DEMAND_TYPE is 1 (Model) then is BOM_BILL_OF_MATERIALS.BILL_SEQUENCE_ID, if DEMAND_TYPE != 1 (Option or Opt Class) then is BOM_INVENTORY_COMPONENTS.COMPONENT_SEQUENCE_ID | ||
| PARENT_COMPONENT_SEQ_ID | NUMBER | MTL_DEMAND.COMPONENT_SEQUENCE_ID of parent in BOM structure | ||
| RTO_MODEL_SOURCE_LINE | VARCHAR2 | (30) | DEMAND_SOURCE_LINE of the Model demand row for all demand and reservation rows associated with ATO Model demand | |
| RTO_PREVIOUS_QTY | NUMBER | (not used in this table) | ||
| CONFIG_STATUS | NUMBER | Code to indicate status of Configured item creation for ATO Model demand | ||
| OLD_REVISION | VARCHAR2 | (3) | Used to identify existing reservation row for certain action codes | |
| OLD_LOT_NUMBER | VARCHAR2 | (80) | Used to identify existing reservation row for certain action codes | |
| OLD_SERIAL_NUMBER | VARCHAR2 | (30) | (not currently used) | |
| OLD_SUBINVENTORY | VARCHAR2 | (10) | Used to identify existing reservation row for certain action codes | |
| OLD_LOCATOR_ID | NUMBER | Used to identify existing reservation row for certain action codes | ||
| OLD_LOC_SEGMENT1 | VARCHAR2 | (40) | Old location flexfield segment | |
| OLD_LOC_SEGMENT2 | VARCHAR2 | (40) | Old location flexfield segment | |
| OLD_LOC_SEGMENT3 | VARCHAR2 | (40) | Old location flexfield segment | |
| OLD_LOC_SEGMENT4 | VARCHAR2 | (40) | Old location flexfield segment | |
| OLD_LOC_SEGMENT5 | VARCHAR2 | (40) | Old location flexfield segment | |
| OLD_LOC_SEGMENT6 | VARCHAR2 | (40) | Old location flexfield segment | |
| OLD_LOC_SEGMENT7 | VARCHAR2 | (40) | Old location flexfield segment | |
| OLD_LOC_SEGMENT8 | VARCHAR2 | (40) | Old location flexfield segment | |
| OLD_LOC_SEGMENT9 | VARCHAR2 | (40) | Old location flexfield segment | |
| OLD_LOC_SEGMENT10 | VARCHAR2 | (40) | Old location flexfield segment | |
| OLD_LOC_SEGMENT11 | VARCHAR2 | (40) | Old location flexfield segment | |
| OLD_LOC_SEGMENT12 | VARCHAR2 | (40) | Old location flexfield segment | |
| OLD_LOC_SEGMENT13 | VARCHAR2 | (40) | Old location flexfield segment | |
| OLD_LOC_SEGMENT14 | VARCHAR2 | (40) | Old location flexfield segment | |
| OLD_LOC_SEGMENT15 | VARCHAR2 | (40) | Old location flexfield segment | |
| OLD_LOC_SEGMENT16 | VARCHAR2 | (40) | Old location flexfield segment | |
| OLD_LOC_SEGMENT17 | VARCHAR2 | (40) | Old location flexfield segment | |
| OLD_LOC_SEGMENT18 | VARCHAR2 | (40) | Old location flexfield segment | |
| OLD_LOC_SEGMENT19 | VARCHAR2 | (40) | Old location flexfield segment | |
| OLD_LOC_SEGMENT20 | VARCHAR2 | (40) | Old location flexfield segment | |
| SUPPLY_GROUP_ID | NUMBER | (not used in this table) | ||
| DEMAND_CLASS | VARCHAR2 | (30) | Demand class, used for ATP and Plannning purposes | |
| CUSTOMER_ID | NUMBER | Customer identifier associated with the demand, used by MRP to consume forecast entries | ||
| TERRITORY_ID | NUMBER | Territory identifier used by MRP to consume forecast entries | ||
| BILL_TO_SITE_USE_ID | NUMBER | Bill to identifier used by MRP to consume forecast entries | ||
| SHIP_TO_SITE_USE_ID | NUMBER | Ship to identifier used by MRP to consume forecast entries | ||
| DESCRIPTION | VARCHAR2 | (50) | (not currently used) | |
| LOT_EXPIRATION_CUTOFF_DATE | DATE | For autodetailing, if specificed all lots with earlier expiration dates will be ignored | ||
| PARTIALS_ALLOWED_FLAG | NUMBER | Used in autodetail and other reservation actions to indicate if a partial quantity should be reserved when the total quantity is not available | ||
| AUTOSCHEDULE_DEMAND_QUANTITY | NUMBER | (not currently used) | ||
| REQUEST_DATE_ATP_QUANTITY | NUMBER | Available quantity on the request date, populated by ATP | ||
| EARLIEST_ATP_DATE | DATE | The earliest date that can satisfy the requested quantity regardless of the request date, populated by ATP | ||
| EARLIEST_ATP_DATE_QUANTITY | NUMBER | Maximum quantity available on the Earliest ATP Date, populated by ATP | ||
| REQUEST_ATP_DATE | DATE | First date on/after the required date that has enough to satisfy the requested quantity, populated by ATP | ||
| REQUEST_ATP_DATE_QUANTITY | NUMBER | Maximum available quantity on the Request ATP date, populated by ATP | ||
| GROUP_AVAILABLE_DATE | DATE | The earliest date that all the requested quantity for each item in the group can be satisfied | ||
| ACCUMULATION_WINDOW | NUMBER | (not currently used, comes from ATP Rule) | ||
| ATP_LEAD_TIME | NUMBER | Number of days earlier than the parent requirement date that a component must be available to allow for assembly of the parent | ||
| INFINITE_TIME_FENCE_DATE | DATE | On and after this date an infinite supply is assumed, populated by ATP, use to determine if available date is from infinite supply | ||
| GROUP_ATP_CHECK | NUMBER | Flag to indicate if all the items under the same group id will be treated as a group atp (ie, return the same GROUP_AVAIABLE_DATE), if not passed, validator populates with 2 (No). | ||
| BOM_LEVEL | NUMBER | Used by BOM exploder to store the level for the explosion process | ||
| EXPLOSION_EFFECTIVITY_DATE | DATE | Date used by BOM exploder when a fixed BOM structure as of a certain date is required | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| C_COLUMN1 | VARCHAR2 | (240) | (not currently used) | |
| C_COLUMN2 | VARCHAR2 | (240) | Partial allowed flag within an ATP group | |
| C_COLUMN3 | VARCHAR2 | (240) | Partial allowed flag for the schedule group | |
| C_COLUMN4 | VARCHAR2 | (240) | (not currently used) | |
| C_COLUMN5 | VARCHAR2 | (240) | (not currently used) | |
| C_COLUMN6 | VARCHAR2 | (240) | (not currently used) | |
| C_COLUMN7 | VARCHAR2 | (240) | (not currently used) | |
| C_COLUMN8 | VARCHAR2 | (240) | (not currently used) | |
| N_COLUMN1 | NUMBER | Column used to identify record originated from Supply Demand Inquiry | ||
| N_COLUMN2 | NUMBER | (not currently used) | ||
| N_COLUMN3 | NUMBER | (not currently used) | ||
| N_COLUMN4 | NUMBER | Column used to mark record and its detail in MTL_SUPPLY_DEMAND_TEMP for deletion | ||
| N_COLUMN5 | NUMBER | Column used to create a unique sequence for array management while processing | ||
| D_COLUMN1 | DATE | (not currently used) | ||
| D_COLUMN2 | DATE | (not currently used) | ||
| D_COLUMN3 | DATE | (not currently used) | ||
| D_COLUMN4 | DATE | (not currently used) | ||
| D_COLUMN5 | DATE | (not currently used) | ||
| ATP_GROUP_ID | NUMBER | Identifies a group of items that will be passed to the ATP function as a group. Also see GROUP_ATP_CHECK. Each atp group id corresponds to at most one schedule group id. sequence MTL_DEAMND_INTERFACE_S | ||
| TRANSACTION_PROCESS_ORDER | NUMBER | Order of request processing within a SCHEDULE_GROUP_ID | ||
| DEMAND_ID | NUMBER | Demand identifier for a demand record in MTL_DEMAND table | ||
| SESSION_ID | NUMBER | ID used by OE to delete rows after processing, based on sequence MTL_DEMAND_SESSION_S | ||
| DEMAND_SOURCE_NAME | VARCHAR2 | (30) | Identifier of user-defined Source Type | |
| DEMAND_TYPE | NUMBER | Code for type of demand | ||
| AUTODETAILED_QUANTITY | NUMBER | Used to return the quantity that has be successfully autodetailed | ||
| AVAILABLE_TO_RESERVE | NUMBER | Used to return the quantity available to reserve | ||
| QUANTITY_ON_HAND | NUMBER | Used to return the quantity on hand | ||
| EXPLOSION_GROUP_ID | NUMBER | Identifier passed to Bom exploder to identify row to explode | ||
| RESERVATION_TYPE | NUMBER | Code for type of reservation | ||
| ORDERED_ITEM_ID | NUMBER | Item id of the top item that caused this demand or reservation to be placed | ||
| ATP_COMPONENTS_FLAG | NUMBER | Flag to indicate if item should be exploded to find ATP_CHECK = Yes components prior to ATP check of Item. Validator will default from MTL_SYSTEM_ITEMS if null. | ||
| LATEST_ACCEPTABLE_DATE | DATE | This date is lastest date that demand should be scheduled. | ||
| ATP_CALENDAR_ORGANIZATION_ID | NUMBER | The identifier for the organization that ATP will use to get the calendar for ATP computations. | ||
| AUTODETAIL_EXPENSE_SUBINV_FLAG | NUMBER | A flag to indicate whether the autodetail process should include expense subinventories | ||
| VENDOR_ID | NUMBER | Supplier identifier | ||
| VENDOR_SITE_ID | NUMBER | Supplier site identifier | ||
| INTRANSIT_LEAD_TIME | NUMBER | Intransit lead time | ||
| SHIP_METHOD | VARCHAR2 | (30) | Ship method | |
| RESOURCE_ID | NUMBER | Resource identifier | ||
| DEPARTMENT_ID | NUMBER | Department identifier |
Cut, paste (and edit) the following text to query this object:
SELECT SCHEDULE_GROUP_ID
, DEMAND_SOURCE_TYPE
, DEMAND_SOURCE_HEADER_ID
, DEMAND_SOURCE_LINE
, DEMAND_SOURCE_DELIVERY
, LOCK_FLAG
, ATP_CHECK
, ACTION_CODE
, VALIDATE_ROWS
, TRANSACTION_MODE
, PROCESS_FLAG
, SINGLE_LOT_FLAG
, DETAIL_RESERVE_FLAG
, RESERVE_LEVEL
, CHECK_ATR
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ERROR_CODE
, ERR_EXPLANATION
, REQUIREMENT_DATE
, LINE_ITEM_UNIT_OF_MEASURE
, LINE_ITEM_UOM
, LINE_ITEM_QUANTITY
, LINE_ITEM_RESERVATION_QTY
, PRIMARY_UOM
, PRIMARY_UOM_QUANTITY
, RESERVATION_QUANTITY
, ATP_RULE_ID
, ORGANIZATION_ID
, ORGANIZATION_NAME
, INVENTORY_ITEM_ID
, ITEM_SEGMENT1
, ITEM_SEGMENT2
, ITEM_SEGMENT3
, ITEM_SEGMENT4
, ITEM_SEGMENT5
, ITEM_SEGMENT6
, ITEM_SEGMENT7
, ITEM_SEGMENT8
, ITEM_SEGMENT9
, ITEM_SEGMENT10
, ITEM_SEGMENT11
, ITEM_SEGMENT12
, ITEM_SEGMENT13
, ITEM_SEGMENT14
, ITEM_SEGMENT15
, ITEM_SEGMENT16
, ITEM_SEGMENT17
, ITEM_SEGMENT18
, ITEM_SEGMENT19
, ITEM_SEGMENT20
, DEMAND_HEADER_SEGMENT1
, DEMAND_HEADER_SEGMENT2
, DEMAND_HEADER_SEGMENT3
, DEMAND_HEADER_SEGMENT4
, DEMAND_HEADER_SEGMENT5
, DEMAND_HEADER_SEGMENT6
, DEMAND_HEADER_SEGMENT7
, DEMAND_HEADER_SEGMENT8
, DEMAND_HEADER_SEGMENT9
, DEMAND_HEADER_SEGMENT10
, DEMAND_HEADER_SEGMENT11
, DEMAND_HEADER_SEGMENT12
, DEMAND_HEADER_SEGMENT13
, DEMAND_HEADER_SEGMENT14
, DEMAND_HEADER_SEGMENT15
, DEMAND_HEADER_SEGMENT16
, DEMAND_HEADER_SEGMENT17
, DEMAND_HEADER_SEGMENT18
, DEMAND_HEADER_SEGMENT19
, DEMAND_HEADER_SEGMENT20
, DEMAND_HEADER_SEGMENT21
, DEMAND_HEADER_SEGMENT22
, DEMAND_HEADER_SEGMENT23
, DEMAND_HEADER_SEGMENT24
, DEMAND_HEADER_SEGMENT25
, DEMAND_HEADER_SEGMENT26
, DEMAND_HEADER_SEGMENT27
, DEMAND_HEADER_SEGMENT28
, DEMAND_HEADER_SEGMENT29
, DEMAND_HEADER_SEGMENT30
, EXTERNAL_SOURCE_CODE
, EXTERNAL_SOURCE_LINE_ID
, SUPPLY_SOURCE_TYPE
, SUPPLY_HEADER_ID
, USER_LINE_NUM
, USER_DELIVERY
, REVISION
, LOT_NUMBER
, SERIAL_NUMBER
, SUBINVENTORY
, LOCATOR_ID
, LOC_SEGMENT1
, LOC_SEGMENT2
, LOC_SEGMENT3
, LOC_SEGMENT4
, LOC_SEGMENT5
, LOC_SEGMENT6
, LOC_SEGMENT7
, LOC_SEGMENT8
, LOC_SEGMENT9
, LOC_SEGMENT10
, LOC_SEGMENT11
, LOC_SEGMENT12
, LOC_SEGMENT13
, LOC_SEGMENT14
, LOC_SEGMENT15
, LOC_SEGMENT16
, LOC_SEGMENT17
, LOC_SEGMENT18
, LOC_SEGMENT19
, LOC_SEGMENT20
, AUTODETAIL_GROUP_ID
, COMPONENT_SEQUENCE_ID
, PARENT_COMPONENT_SEQ_ID
, RTO_MODEL_SOURCE_LINE
, RTO_PREVIOUS_QTY
, CONFIG_STATUS
, OLD_REVISION
, OLD_LOT_NUMBER
, OLD_SERIAL_NUMBER
, OLD_SUBINVENTORY
, OLD_LOCATOR_ID
, OLD_LOC_SEGMENT1
, OLD_LOC_SEGMENT2
, OLD_LOC_SEGMENT3
, OLD_LOC_SEGMENT4
, OLD_LOC_SEGMENT5
, OLD_LOC_SEGMENT6
, OLD_LOC_SEGMENT7
, OLD_LOC_SEGMENT8
, OLD_LOC_SEGMENT9
, OLD_LOC_SEGMENT10
, OLD_LOC_SEGMENT11
, OLD_LOC_SEGMENT12
, OLD_LOC_SEGMENT13
, OLD_LOC_SEGMENT14
, OLD_LOC_SEGMENT15
, OLD_LOC_SEGMENT16
, OLD_LOC_SEGMENT17
, OLD_LOC_SEGMENT18
, OLD_LOC_SEGMENT19
, OLD_LOC_SEGMENT20
, SUPPLY_GROUP_ID
, DEMAND_CLASS
, CUSTOMER_ID
, TERRITORY_ID
, BILL_TO_SITE_USE_ID
, SHIP_TO_SITE_USE_ID
, DESCRIPTION
, LOT_EXPIRATION_CUTOFF_DATE
, PARTIALS_ALLOWED_FLAG
, AUTOSCHEDULE_DEMAND_QUANTITY
, REQUEST_DATE_ATP_QUANTITY
, EARLIEST_ATP_DATE
, EARLIEST_ATP_DATE_QUANTITY
, REQUEST_ATP_DATE
, REQUEST_ATP_DATE_QUANTITY
, GROUP_AVAILABLE_DATE
, ACCUMULATION_WINDOW
, ATP_LEAD_TIME
, INFINITE_TIME_FENCE_DATE
, GROUP_ATP_CHECK
, BOM_LEVEL
, EXPLOSION_EFFECTIVITY_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, 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
, ATP_GROUP_ID
, TRANSACTION_PROCESS_ORDER
, DEMAND_ID
, SESSION_ID
, DEMAND_SOURCE_NAME
, DEMAND_TYPE
, AUTODETAILED_QUANTITY
, AVAILABLE_TO_RESERVE
, QUANTITY_ON_HAND
, EXPLOSION_GROUP_ID
, RESERVATION_TYPE
, ORDERED_ITEM_ID
, ATP_COMPONENTS_FLAG
, LATEST_ACCEPTABLE_DATE
, ATP_CALENDAR_ORGANIZATION_ID
, AUTODETAIL_EXPENSE_SUBINV_FLAG
, VENDOR_ID
, VENDOR_SITE_ID
, INTRANSIT_LEAD_TIME
, SHIP_METHOD
, RESOURCE_ID
, DEPARTMENT_ID
FROM INV.MTL_DEMAND_INTERFACE;
INV.MTL_DEMAND_INTERFACE does not reference any database object
INV.MTL_DEMAND_INTERFACE is referenced by following:
APPS
MTL_DEMAND_INTERFACE
|
|
|
|