[Home] [Help] [Dependency Information]
Object Name: | FLM_SEQ_TASK_DEMANDS |
---|---|
Object Type: | TABLE |
Owner: | FLM |
FND Design Data: | FLM.FLM_SEQ_TASK_DEMANDS |
Subobject Name: | |
Status: | VALID |
FLM_SEQ_TASK_DEMANDS table stores the demand information for the flow sequencing tasks.
It is the child table of FLM_SEQ_TASK_LINES table. It stores the demand for each production line that will be considered by the sequencing engine. There are 2 types of demands : sales order and planned order.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FLM_SEQ_TASK_DEMANDS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SEQ_TASK_ID
LINE_ID DEMAND_ID SPLIT_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQ_TASK_ID | NUMBER | Yes | Sequencing task identifier | |
LINE_ID | NUMBER | Yes | Production line identifier | |
DEMAND_ID | NUMBER | Yes | Demand identifier. It can be either referencing LINE_ID in OE_ORDER_LINES_ALL table for Saler Order or TRANSACTION_ID in MRP_RECOMMENDATIONS table. | |
SPLIT_NUMBER | NUMBER | Yes | Split number | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Object version number | |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
PRIMARY_ITEM_ID | NUMBER | Yes | Primary item identifier | |
ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | (30) | Alternate routing designator | |
OPEN_QTY | NUMBER | Open demand quantiy | ||
REQUESTED_QTY | NUMBER | Quantity requested to be sequenced | ||
FULFILLED_QTY | NUMBER | Quantity that is resequenced by the flow sequencing engine | ||
CREATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
REQUEST_ID | NUMBER | Standard Who column | ||
PROGRAM_ID | NUMBER | Standard Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
PROGRAM_UPDATE_DATE | DATE | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT SEQ_TASK_ID
, LINE_ID
, DEMAND_ID
, SPLIT_NUMBER
, OBJECT_VERSION_NUMBER
, ORGANIZATION_ID
, PRIMARY_ITEM_ID
, ALTERNATE_ROUTING_DESIGNATOR
, OPEN_QTY
, REQUESTED_QTY
, FULFILLED_QTY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
FROM FLM.FLM_SEQ_TASK_DEMANDS;
FLM.FLM_SEQ_TASK_DEMANDS does not reference any database object
FLM.FLM_SEQ_TASK_DEMANDS is referenced by following:
|
|
|