This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.
The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend
This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.
Oracle is a registered trademark. AIM Advantage, Big Business. Small Business. All Business., CDM Advantage, .comference, ConText®, Des40®, Easy*Query, Easy*SQL®, Education Objects, EMM Advantage, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist, Hyper*SQL, instantOracle, "Internet Business Intelligence - Insight for Everyone", iSQL*Plus, JInitiator, NLS*Workbench®, Object Marketplace, ODP Pulse, ODP Techwire, OLA, On Oracle, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer, Oracle® Expert, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile, Oracle Names®, Oracle NetSolutions®, Oracle® One, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i, Oracle9i, PC Express®, Personal Express®, PJM Advantage, PL/SQL, Pro*Ada®, Pro*C, Pro*C/C++, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit, ProREXX, Report Card, Secure Access 2.0, Secure Network Services®, Security Without Compromise, SellingPoint®, SQL*Plus®, Tutor are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.
Description: | Stores the flitering criteria of flow manufacturing related query. |
---|
Foreign Key Column | Foreign Table |
---|---|
FLM_FILTER_CRITERIA.ORGANIZATION_ID | MTL_PARAMETERS |
FLM_FILTER_CRITERIA table stores the filtering criteria of flow manufacturing related query.
The filtering criteria are grouped using CRITERIA_GROUP_ID column. The type of the group criteria defined in CRITERIA_GROUP_TYPE column indicates the usage of the filtering criteria. Each group can contain one or more filtering criteria. Each filtering criteria in the filtering criteria group is identified using CRITERIA_NUM column. The type of each criteria is stored in CRITERIA_TYPE column. In one criteria, there can be one or more operations (defined in CRITERIA_OPERATION column).
Index | Type | Tablespace | Column |
---|---|---|---|
FLM_FILTER_CRITERIA_U1 | UNIQUE | APPS_TS_TX_IDX | CRITERIA_ID |
FLM_FILTER_CRITERIA_N1 | NONUNIQUE | APPS_TS_TX_IDX | CRITERIA_GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CRITERIA_ID | NUMBER | Y | Criteria identifier | |
CRITERIA_GROUP_ID | NUMBER | Y | Criteria group identifier | |
CRITERIA_NUM | NUMBER | Y | Criteria number | |
CRITERIA_GROUP_TYPE | NUMBER | Y | The type of criteria group. | |
CRITERIA_TYPE | NUMBER | Y | The type of criteria | |
ORGANIZATION_ID | NUMBER | Organization identifier | ||
OBJECT_VERSION_NUMBER | NUMBER | Y | Object Version Number | |
CRITERIA_OPERATION | NUMBER | Y | Criteria operation | |
CRITERIA_VALUE_TYPE | NUMBER | Y | The type of criteria value | |
CRITERIA_VALUE_NAME | VARCHAR2 | (240) | Criteria value with string datatype | |
CRITERIA_VALUE_NUM | NUMBER | Criteria value with number datatype | ||
CRITERIA_VALUE_DATE | DATE | Criteria value with date datatype | ||
CREATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | 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 |
FLM.FLM_FILTER_CRITERIA does not reference any database object
FLM.FLM_FILTER_CRITERIA is referenced by following:
Description: | Kanban Purging Temporary table |
---|
FLM_KANBAN_PURGE_TEMP table stores the temporary information for building kanban purging report.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Organization identifier | ||
ITEM_ID | NUMBER | Item identifier | ||
SUBINVENTORY_CODE | VARCHAR2 | (10) | Subinventory code | |
LOCATOR_ID | NUMBER | Locator identifier | ||
COUNT | NUMBER | Count | ||
TYPE | NUMBER | Type of data in the table.There are 3 different types : type 1 indicates the count of cards deleted for particular item in the subinventory/locator, type 2 indicates the pull sequence belonging to item in the subinventory/locator as the unreferenced pull sequence and type 3 indicates the pull sequence beloning to item in the subinventory/locator has been deleted. | ||
GROUP_ID | NUMBER | Group identifier |
FLM.FLM_KANBAN_PURGE_TEMP does not reference any database object
FLM.FLM_KANBAN_PURGE_TEMP is referenced by following:
Description: | Kanban Summary |
---|
Foreign Key Column | Foreign Table |
---|---|
FLM_KANBAN_SUMMARY.ORGANIZATION_ID | MTL_PARAMETERS |
FLM_KANBAN_SUMMARY.WIP_LINE_ID | WIP_LINES |
FLM_KANBAN_SUMMARY.SUBINVENTORY_NAME
FLM_KANBAN_SUMMARY.SOURCE_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
FLM_KANBAN_SUMMARY.SUPPLIER_SITE_ID | PO_VENDOR_SITES_ALL |
FLM_KANBAN_SUMMARY.SUPPLIER_ID | PO_VENDORS |
FLM_KANBAN_SUMMARY.SOURCE_ORGANIZATION_ID
FLM_KANBAN_SUMMARY.ORGANIZATION_ID |
MTL_INTERORG_PARAMETERS |
FLM_KANBAN_SUMMARY table stores the summary information for ranges of pull sequences that
are displayed in the Graphical Kanban Workbench
Index | Type | Tablespace | Column |
---|---|---|---|
FLM_KANBAN_SUMMARY_U1 | UNIQUE | APPS_TS_TX_IDX | SUMMARY_ID |
FLM_KANBAN_SUMMARY_N1 | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
SUMMARY_TYPE SUMMARY_CODE KANBAN_PLAN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUMMARY_ID | NUMBER | Y | Summary identifier | |
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
SUMMARY_TYPE | NUMBER | Y | Summary Type | |
SUMMARY_CODE | VARCHAR2 | (30) | Y | Summary Code |
KANBAN_PLAN_ID | NUMBER | Y | Kanban plan identifier | |
CREATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
NODE_TYPE | NUMBER | Node type | ||
SOURCE_ORGANIZATION_ID | NUMBER | Source organization identifier | ||
SUPPLIER_ID | NUMBER | Supplier identifier | ||
SUPPLIER_SITE_ID | NUMBER | Supplier site identifier | ||
SUBINVENTORY_NAME | VARCHAR2 | (10) | Subinventory name | |
LOCATOR_ID | NUMBER | Locator identifier | ||
WIP_LINE_ID | NUMBER | Production line identifier | ||
X_COORDINATE | NUMBER | The X coordinate for pull sequence summary node | ||
Y_COORDINATE | NUMBER | The Y coordinate for pull sequence summary node |
FLM.FLM_KANBAN_SUMMARY does not reference any database object
FLM.FLM_KANBAN_SUMMARY is referenced by following:
Description: | Mixed Model Map Lines |
---|
Foreign Key Column | Foreign Table |
---|---|
FLM_MMM_LINES.ORGANIZATION_ID
FLM_MMM_LINES.PLAN_ID |
% |
FLM_MMM_LINES.LINE_ID | WIP_LINES |
Foreign Key Column | Foreign Table |
---|---|
FLM_MMM_OPERATIONS.ORGANIZATION_ID
FLM_MMM_OPERATIONS.PLAN_ID FLM_MMM_OPERATIONS.OPERATION_TYPE FLM_MMM_OPERATIONS.LINE_ID |
FLM_MMM_LINES |
FLM_MMM_LINES table stores the mixed model map calculated result for lines.
Index | Type | Tablespace | Column |
---|---|---|---|
FLM_MMM_LINES_U1 | UNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
PLAN_ID CALCULATION_OPERATION_TYPE LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Y | Plan identifier | |
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
LINE_ID | NUMBER | Y | Line identifier | |
CALCULATION_OPERATION_TYPE | NUMBER | Y | The type of the operation : line operation or process | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
REQUEST_ID | NUMBER | Standard Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
PROGRAM_ID | NUMBER | Standard Who column | ||
PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
LINE_TAKT | NUMBER | Production line TAKT time | ||
HOURS_PER_DAY | NUMBER | Number of hours per day | ||
LINE_TAKT_AS_ASSIGNED | NUMBER | Production line TAKT time calculated for the assigned resources | ||
BOTTLENECK_RESOURCE_PERCENT | NUMBER | Biggest resource overcapacity percentage for all resources for this line | ||
BOTTLENECK_IPK_PERCENT | NUMBER | Biggest IPK overcapacity percentage for all operations for this line | ||
RESOURCE_UNDERCAPACITY | NUMBER | Biggest resource undercapacity percentage for all resources for this line | ||
IPK_UNDERCAPACITY | NUMBER | Biggest IPK undercapacity percentage for all operations for this line |
FLM.FLM_MMM_LINES does not reference any database object
FLM.FLM_MMM_LINES is referenced by following:
Description: | Mixed Model Map Operations |
---|
Foreign Key Column | Foreign Table |
---|---|
FLM_MMM_OPERATIONS.ORGANIZATION_ID
FLM_MMM_OPERATIONS.PLAN_ID FLM_MMM_OPERATIONS.OPERATION_TYPE FLM_MMM_OPERATIONS.LINE_ID |
FLM_MMM_LINES |
FLM_MMM_OPERATIONS.LINE_ID
FLM_MMM_OPERATIONS.OPERATION_TYPE FLM_MMM_OPERATIONS.STANDARD_OPERATION_ID |
BOM_STANDARD_OPERATIONS |
Foreign Key Column | Foreign Table |
---|---|
FLM_MMM_OP_ITEMS.ORGANIZATION_ID
FLM_MMM_OP_ITEMS.PLAN_ID FLM_MMM_OP_ITEMS.STANDARD_OPERATION_ID |
FLM_MMM_OPERATIONS |
FLM_MMM_OP_RESOURCES.ORGANIZATION_ID
FLM_MMM_OP_RESOURCES.PLAN_ID FLM_MMM_OP_RESOURCES.STANDARD_OPERATION_ID |
FLM_MMM_OPERATIONS |
FLM_MMM_OPERATIONS table stores the mixed model map calculated result for line operations and processes.
Index | Type | Tablespace | Column |
---|---|---|---|
FLM_MMM_OPERATIONS_U1 | UNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
PLAN_ID STANDARD_OPERATION_ID |
FLM_MMM_OPERATIONS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
PLAN_ID LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Y | Plan identifier | |
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
STANDARD_OPERATION_ID | NUMBER | Y | Standard operation identifier | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
REQUEST_ID | NUMBER | Standard Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
PROGRAM_ID | NUMBER | Standard Who column | ||
PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
LINE_ID | NUMBER | Y | Line identifier | |
OPERATION_TYPE | NUMBER | Y | Type of operation: 2 for process, 3 for line operation | |
OPERATION_TAKT | NUMBER | Operation TAKT time | ||
MACHINE_WEIGHTED_TIME | NUMBER | Weighted average time for machine resources for this operation | ||
LABOR_WEIGHTED_TIME | NUMBER | Weighted average time for labor resources for this operation | ||
ELAPSED_WEIGHTED_TIME | NUMBER | Weighted elapsed time for all resources for this operation | ||
IPK_NEEDED | NUMBER | in process kanban needed for this operation | ||
IPK_ASSIGNED | NUMBER | in process kanban assigned for this operation | ||
OP_TAKT_AS_ASSIGNED | NUMBER | Operation TAKT time calculated for assigned resources | ||
BOTTLENECK_RESOURCE_PERCENT | NUMBER | Biggest resource overcapacity percentage for all resources for this operation | ||
PROCESS_EFFICIENCY | NUMBER | Process efficiency for this operation | ||
RESOURCE_UNDERCAPACITY | NUMBER | Biggest resource undercapacity percentage for all resources for this operation |
FLM.FLM_MMM_OPERATIONS does not reference any database object
FLM.FLM_MMM_OPERATIONS is referenced by following:
Description: | Mixed Model Map Items |
---|
Foreign Key Column | Foreign Table |
---|---|
FLM_MMM_OP_ITEMS.ORGANIZATION_ID
FLM_MMM_OP_ITEMS.PLAN_ID FLM_MMM_OP_ITEMS.STANDARD_OPERATION_ID |
FLM_MMM_OPERATIONS |
FLM_MMM_OP_ITEMS.ASSEMBLY_ITEM_ID
FLM_MMM_OP_ITEMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
FLM_MMM_OP_ITEMS table stores the mixed model map calculated result for assembly items.
Index | Type | Tablespace | Column |
---|---|---|---|
FLM_MMM_OP_ITEMS_U1 | UNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
PLAN_ID STANDARD_OPERATION_ID ASSEMBLY_ITEM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Y | Plan identifier | |
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
ASSEMBLY_ITEM_ID | NUMBER | Y | Assembly item identifier | |
STANDARD_OPERATION_ID | NUMBER | Y | Standard operation identifier | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
REQUEST_ID | NUMBER | Standard Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
PROGRAM_ID | NUMBER | Standard Who column | ||
PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
LINE_ID | NUMBER | Production line identifier | ||
OPERATION_TYPE | NUMBER | Type of operation: 2 for process, 3 for line operation | ||
PROCESS_VOLUME | NUMBER | Volume processed for the item at the operation | ||
MACHINE_TIME | NUMBER | Time used for machine resources | ||
LABOR_TIME | NUMBER | Time used for labor resources | ||
ELAPSED_TIME | NUMBER | Elapsed time for the item at the operation |
FLM.FLM_MMM_OP_ITEMS does not reference any database object
FLM.FLM_MMM_OP_ITEMS is referenced by following:
Description: | Mixed Model Map Resources |
---|
Foreign Key Column | Foreign Table |
---|---|
FLM_MMM_OP_RESOURCES.ORGANIZATION_ID
FLM_MMM_OP_RESOURCES.PLAN_ID FLM_MMM_OP_RESOURCES.STANDARD_OPERATION_ID |
FLM_MMM_OPERATIONS |
FLM_MMM_OP_RESOURCES.RESOURCE_ID | BOM_RESOURCES |
FLM_MMM_OP_RESOURCES table stores the mixed model map calculated result for resources.
Index | Type | Tablespace | Column |
---|---|---|---|
FLM_MMM_OP_RESOURCES_U1 | UNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
PLAN_ID RESOURCE_ID STANDARD_OPERATION_ID |
FLM_MMM_OP_RESOURCES_N1 | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
PLAN_ID LINE_ID STANDARD_OPERATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Y | Plan identifier | |
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
RESOURCE_ID | NUMBER | Y | Resource identifier | |
STANDARD_OPERATION_ID | NUMBER | Y | Standard operation identifier | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
REQUEST_ID | NUMBER | Standard Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
PROGRAM_ID | NUMBER | Standard Who column | ||
PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
LINE_ID | NUMBER | Production line identifier | ||
OPERATION_TYPE | NUMBER | Type of operation: 2 for process, 3 for line operation | ||
WEIGHTED_RESOURCE_USAGE | NUMBER | Weight usage of the resource across all items at the operation | ||
RESOURCE_NEEDED | NUMBER | Resource needed for the operation | ||
RESOURCE_ASSIGNED | NUMBER | Resource assigned for the operation |
FLM.FLM_MMM_OP_RESOURCES does not reference any database object
FLM.FLM_MMM_OP_RESOURCES is referenced by following:
Description: | Mixed Model Map Plans |
---|
Foreign Key Column | Foreign Table |
---|---|
FLM_MMM_PLANS.ORGANIZATION_ID | MTL_PARAMETERS |
FLM_MMM_PLANS table stores the mixed model map plan information.
Index | Type | Tablespace | Column |
---|---|---|---|
FLM_MMM_PLANS_U1 | UNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
PLAN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Y | Plan Identifier | |
ORGANIZATION_ID | NUMBER | Y | Organization Identifier | |
PLAN_CODE | VARCHAR2 | (30) | Y | Name of the plan |
DESCRIPTION | VARCHAR2 | (240) | Description of the plan | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
REQUEST_ID | NUMBER | Standard Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
PROGRAM_ID | NUMBER | Standard Who column | ||
PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
PRODUCT_FAMILY_ID | NUMBER | Product family identifier | ||
LINE_ID | NUMBER | Production line identifier | ||
DEMAND_TYPE | NUMBER | Type of demand: 1 for forecast, 2 for MDS, 3 for MPS, 4 for actual production, 5 for sales order, 6 for planned order | ||
DEMAND_CODE | VARCHAR2 | (10) | Name of the demand | |
START_DATE | DATE | Plan start date | ||
END_DATE | DATE | Plan end date | ||
DEMAND_DAYS | NUMBER | Number of days of demands for the plan | ||
HOURS_PER_DAY | NUMBER | Number of hours of operation each day for the production line | ||
BOOST_PERCENT | NUMBER | Boost percentage for the calculation | ||
CALCULATION_OPTION | NUMBER | Option for MMM calculation: 1 for no IPK, 2 for one resource, 3 for resource assigned, 4 for IPK assigned | ||
TIME_UOM | NUMBER | Time unit of measure | ||
VIEW_BY | NUMBER | View by option for the plan: 1 for display sequence, 2 for operation code, 3 for description | ||
PRECISION | NUMBER | Precision of display for numbers |
FLM.FLM_MMM_PLANS does not reference any database object
FLM.FLM_MMM_PLANS is referenced by following:
Description: | Stores flow sequencing attribute definition. |
---|
Foreign Key Column | Foreign Table |
---|---|
FLM_SEQ_RULE_CONSTRAINTS.ATTRIBUTE_ID | FLM_SEQ_ATTRIBUTES |
FLM_SEQ_TASK_CONSTRAINTS.ATTRIBUTE_ID | FLM_SEQ_ATTRIBUTES |
FLM_SEQ_ATTRIBUTES table stores flow sequencing attribute definition.
The sequencing attribute must be defined before creating any constraint. It identifies the value domain on which the constraint is defined. As an example, we can define an attribute named 'Color'. For the given customer, the 'Color' is stored as the attribute1 column in the sales order table. Thus the 'Color' sequencing attribute will have ATTRIBUTE_NAME of 'Color', USER_DEFINED_FLAG of 'Y', ATTRIBUTE_TYPE of 'Sales Order Property', ATTRIBUTE_SOURCE of 'ATTRIBUTE1' and ATTRIBUTE_VALUE_TYPE of 'String'.
Index | Type | Tablespace | Column |
---|---|---|---|
FLM_SEQ_ATTRIBUTES_U1 | UNIQUE | APPS_TS_TX_IDX | ATTRIBUTE_ID |
FLM_SEQ_ATTRIBUTES_U2 | UNIQUE | APPS_TS_TX_IDX | ATTRIBUTE_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ATTRIBUTE_ID | NUMBER | Y | Attribute identifier | |
OBJECT_VERSION_NUMBER | NUMBER | Y | Object version number | |
ATTRIBUTE_NAME | VARCHAR2 | (80) | Y | Name of the attribute. |
DESCRIPTION | VARCHAR2 | (240) | Description of the attribute. | |
USER_DEFINED_FLAG | VARCHAR2 | (1) | Y | User defined flag |
ATTRIBUTE_TYPE | NUMBER | Y | To identify different type of attributes | |
ATTRIBUTE_SOURCE | VARCHAR2 | (30) | Attribute Source | |
ATTRIBUTE_VALUE_TYPE | NUMBER | Y | To identify the different type of the attribute value. | |
CREATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column |
FLM.FLM_SEQ_ATTRIBUTES does not reference any database object
FLM.FLM_SEQ_ATTRIBUTES is referenced by following:
Description: | Stores the association between production line and flow sequencing rule. |
---|
Foreign Key Column | Foreign Table |
---|---|
FLM_SEQ_LINE_RULES.RULE_ID | % |
FLM_SEQ_LINE_RULES.LINE_ID | WIP_LINES |
FLM_SEQ_LINE_RULES.ORGANIZATION_ID | MTL_PARAMETERS |
FLM_SEQ_LINE_RULES table stores the association between production line and flow sequencing rule.
A production line can be assigned to multiple rules, and a rule can be assigned to multiple production lines. Among many assigned rules to a production line, the user may choose one rule as the default rule to be used on the flow sequencing run. The user will also be able to overwrite the default rule assignment at the time of the flow sequencing run.
Index | Type | Tablespace | Column |
---|---|---|---|
FLM_SEQ_LINE_RULES_U1 | UNIQUE | APPS_TS_TX_IDX |
LINE_ID
RULE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_ID | NUMBER | Y | Rule identifier | |
LINE_ID | NUMBER | Y | Production line identifier | |
OBJECT_VERSION_NUMBER | NUMBER | Y | Object version number | |
ORGANIZATION_ID | NUMBER | Organization identifier | ||
CREATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column |
FLM.FLM_SEQ_LINE_RULES does not reference any database object
FLM.FLM_SEQ_LINE_RULES is referenced by following:
Description: | Stores flow sequencing rule definition. |
---|
Foreign Key Column | Foreign Table |
---|---|
FLM_SEQ_RULES.ORGANIZATION_ID | MTL_PARAMETERS |
Foreign Key Column | Foreign Table |
---|---|
FLM_SEQ_RULE_CONSTRAINTS.RULE_ID | FLM_SEQ_RULES |
FLM_SEQ_TASK_LINES.RULE_ID | FLM_SEQ_RULES |
FLM_SEQ_RULES table stores flow sequencing rule definition.
This table is the parent table of FLM_SEQ_RULE_CONTRAINTS table. It holds the group or collection of constraints.
Index | Type | Tablespace | Column |
---|---|---|---|
FLM_SEQ_RULES_U1 | UNIQUE | APPS_TS_TX_IDX | RULE_ID |
FLM_SEQ_RULES_U2 | UNIQUE | APPS_TS_TX_IDX |
RULE_NAME
ORGANIZATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_ID | NUMBER | Y | Rule unique identifier | |
OBJECT_VERSION_NUMBER | NUMBER | Y | Object version number | |
RULE_NAME | VARCHAR2 | (80) | Y | Name of the rule |
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
DESCRIPTION | VARCHAR2 | (240) | Description of the rule | |
DISABLE_DATE | DATE | Disable date | ||
CREATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column |
FLM.FLM_SEQ_RULES does not reference any database object
FLM.FLM_SEQ_RULES is referenced by following:
Description: | Stores flow sequencing constraint definition. |
---|
Foreign Key Column | Foreign Table |
---|---|
FLM_SEQ_RULE_CONSTRAINTS.RULE_ID | FLM_SEQ_RULES |
FLM_SEQ_RULE_CONSTRAINTS.ORGANIZATION_ID | MTL_PARAMETERS |
FLM_SEQ_RULE_CONSTRAINTS.ATTRIBUTE_ID | FLM_SEQ_ATTRIBUTES |
FLM_SEQ_RULE_CONTRAINTS table stores flow sequencing constraint definition.
A flow sequencing constraint is a restriction defined in the production line that dictates the order on how the assembly is built. The constraint is defined for a certain attribute.
As an example, we can have required constraint for attribute 'Color' in which assembly having color 'Red' must be followed by assembly having color 'Green'. Such constraint is defined with CONSTRAINT_TYPE of 1(Required Transition'), ATTRIBUTE_ID of X (that reference Attribute 'Color' in FLM_SEQ_ATTRIBUTES table), ATTRIBUTE_VALUE1_NAME of 'Red', and ATTRIBUTE_VALUE2_NAME of 'Green'.
The FLM_SEQ_RULE_CONTRAINTS is the child table of FLM_SEQ_RULES. One rule defined in FLM_SEQ_RULE table can have multiple constraints defined in FLM_SEQ_RULE_CONTRAINTS table. A priority will be defined for each of the constraints for a rule. The constraint having high priority (with lower number) must be satisfied before the constraint having lower priority is satisfied.
Index | Type | Tablespace | Column |
---|---|---|---|
FLM_SEQ_RULE_CONSTRAINTS_U1 | UNIQUE | APPS_TS_TX_IDX |
RULE_ID
CONSTRAINT_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_ID | NUMBER | Y | Rule identifier | |
CONSTRAINT_NUMBER | NUMBER | Y | Identifier of constraint within a rule | |
OBJECT_VERSION_NUMBER | NUMBER | Y | Object version number | |
ORGANIZATION_ID | NUMBER | Organization identifier | ||
PRIORITY | NUMBER | Priority of constraint | ||
CONSTRAINT_TYPE | NUMBER | Y | Type of the constraint | |
CONSTRAINT_TYPE_VALUE1 | NUMBER | The first value of constraint type. The meaning of this value is based on the constraint type. | ||
CONSTRAINT_TYPE_VALUE2 | NUMBER | The second value of constraint type. The meaning of this value is based on the constraint type. | ||
CONSTRAINT_TYPE_VALUE3 | NUMBER | The third value of constraint type. The meaning of this value is based on the constraint type. | ||
ATTRIBUTE_ID | NUMBER | Y | Attribute identifier | |
ATTRIBUTE_VALUE1_NAME | VARCHAR2 | (240) | The first attribute value for an attribute having string type | |
ATTRIBUTE_VALUE2_NAME | VARCHAR2 | (240) | The second attribute value for an attribute having string type | |
ATTRIBUTE_VALUE1_NUM | NUMBER | The first attribute value for an attribute having number type | ||
ATTRIBUTE_VALUE2_NUM | NUMBER | The second attribute value for an attribute having number type | ||
ATTRIBUTE_VALUE1_DATE | DATE | The first attribute value for an attribute having date type | ||
ATTRIBUTE_VALUE2_DATE | DATE | The second attribute value for an attribute having date type | ||
CREATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
PARENT_CONSTRAINT_NUMBER | NUMBER | Constraint Number for the parent constraint. |
FLM.FLM_SEQ_RULE_CONSTRAINTS does not reference any database object
FLM.FLM_SEQ_RULE_CONSTRAINTS is referenced by following:
Description: | Stores the flow sequencing task parameters. |
---|
Foreign Key Column | Foreign Table |
---|---|
FLM_SEQ_TASKS.SCHEDULE_GROUP_ID | WIP_SCHEDULE_GROUPS |
FLM_SEQ_TASKS.ORGANIZATION_ID | MTL_PARAMETERS |
Foreign Key Column | Foreign Table |
---|---|
FLM_SEQ_TASK_LINES.SEQ_TASK_ID | FLM_SEQ_TASKS |
FLM_SEQ_TASKS table stores the flow sequencing task parameters.
This is the parameter table that is used by the flow sequencing engine to control the behaviour of the sequencing process. It is populated by the user through the sequencing user interface. From this table, the user indicates the name of the sequencing run (SEQ_TASK_NAME column), the type of demand to be considered (SEQ_TASK_TYPE column), the demand horizon (DEMAND_START_DATE and DEMAND_END_DATE columns), the sequencing horizon (SEQ_START_DATE and SEQ_END_DATE columns), and optionally the schedule group (SCHEDULE_GROUP_ID column).
Index | Type | Tablespace | Column |
---|---|---|---|
FLM_SEQ_TASKS_U1 | UNIQUE | APPS_TS_TX_IDX | SEQ_TASK_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQ_TASK_ID | NUMBER | Y | Sequencing task identifier | |
OBJECT_VERSION_NUMBER | NUMBER | Y | Object version number | |
SEQ_TASK_NAME | VARCHAR2 | (80) | Y | Sequencing task name |
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
SEQ_TASK_TYPE | NUMBER | Y | Type of the sequencing. There are 3 types : sequencing sales order, sequencing planned order and resequence existing schedules | |
DEMAND_START_DATE | DATE | Start date of the demand | ||
DEMAND_END_DATE | DATE | End date of the demand | ||
SEQ_REQUEST_ID | NUMBER | Y | Request identifier | |
SEQ_START_DATE | DATE | Y | Start date of the sequencing horizon | |
SEQ_END_DATE | DATE | Y | End date of the seuencing horizon | |
SCHEDULE_GROUP_ID | NUMBER | Schedule group identifier | ||
ALTERNATE_ROUTING_FLAG | VARCHAR2 | (1) | To indicate if the sales order for an alternate routing will be considered | |
DEMAND_CRITERIA_GROUP_ID | NUMBER | The criteria group identifier for the demand filter. | ||
CREATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | 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 | ||
HONOR_PLANNING_FLAG | VARCHAR2 | (1) | To indicate honor or not planning recommendations |
FLM.FLM_SEQ_TASKS does not reference any database object
FLM.FLM_SEQ_TASKS is referenced by following:
Description: | Stores the flow sequencing constraint information for the flow sequencing task. |
---|
Foreign Key Column | Foreign Table |
---|---|
FLM_SEQ_TASK_CONSTRAINTS.LINE_ID
FLM_SEQ_TASK_CONSTRAINTS.SEQ_TASK_ID |
% |
FLM_SEQ_TASK_CONSTRAINTS.ATTRIBUTE_ID | FLM_SEQ_ATTRIBUTES |
FLM_SEQ_TASK_CONSTRAINTS.ORGANIZATION_ID | MTL_PARAMETERS |
Foreign Key Column | Foreign Table |
---|---|
FLM_SEQ_TASK_EXCEPTIONS.SEQ_TASK_ID
FLM_SEQ_TASK_EXCEPTIONS.CONSTRAINT_NUMBER FLM_SEQ_TASK_EXCEPTIONS.LINE_ID |
FLM_SEQ_TASK_CONSTRAINTS |
FLM_SEQ_TASK_CONSTRAINTS table stores the flow sequencing constraint information for the flow sequencing task.
It is the child table of FLM_SEQ_TASK_LINES. It holds the definition on constraints for each production line that are used by the sequencing engine. The rows will initially be copied from FLM_SEQ_RULE_CONTRAINTS table. They consist of all the constraints defined for the default sequencing rule of a production line. The user will be able to override the constraints, adding new constraints, and deleting constraints for the specific sequencing run.
Index | Type | Tablespace | Column |
---|---|---|---|
FLM_SEQ_TASK_CONSTRAINTS_U1 | UNIQUE | APPS_TS_TX_IDX |
SEQ_TASK_ID
LINE_ID CONSTRAINT_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQ_TASK_ID | NUMBER | Y | Sequencing task identifier | |
LINE_ID | NUMBER | Y | Production line identifier | |
CONSTRAINT_NUMBER | NUMBER | Y | Identifier of constraint within a rule | |
OBJECT_VERSION_NUMBER | NUMBER | Y | Object version number | |
ORGANIZATION_ID | NUMBER | Organization identifier | ||
PRIORITY | NUMBER | Priority of constraint | ||
CONSTRAINT_TYPE | NUMBER | Y | Type of the constraint | |
CONSTRAINT_TYPE_VALUE1 | NUMBER | The first value of constraint type. The meaning of this value is based on the constraint type. | ||
CONSTRAINT_TYPE_VALUE2 | NUMBER | The second value of constraint type. The meaning of this value is based on the constraint type. | ||
CONSTRAINT_TYPE_VALUE3 | NUMBER | The second value of constraint type. The meaning of this value is based on the constraint type. | ||
ATTRIBUTE_ID | NUMBER | Y | Attribute identifier | |
ATTRIBUTE_VALUE1_NAME | VARCHAR2 | (240) | The first attribute value for an attribute having string type | |
ATTRIBUTE_VALUE2_NAME | VARCHAR2 | (240) | The second attribute value for an attribute having string type | |
ATTRIBUTE_VALUE1_NUM | NUMBER | The first attribute value for an attribute having number type | ||
ATTRIBUTE_VALUE2_NUM | NUMBER | The second attribute value for an attribute having number type | ||
ATTRIBUTE_VALUE1_DATE | DATE | The first attribute value for an attribute having date type | ||
ATTRIBUTE_VALUE2_DATE | DATE | The second attribute value for an attribute having date type | ||
FULFILLED_TO_QTY | NUMBER | The number of quantity from the beginning of the horizon before the first violation. | ||
VIOLATION_COUNT | NUMBER | The number of violation | ||
CREATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | 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 | ||
PARENT_CONSTRAINT_NUMBER | NUMBER | Constraint Number for the parent constraint. |
FLM.FLM_SEQ_TASK_CONSTRAINTS does not reference any database object
FLM.FLM_SEQ_TASK_CONSTRAINTS is referenced by following:
Description: | Stores the demand information for the flow sequencing tasks. |
---|
Foreign Key Column | Foreign Table |
---|---|
FLM_SEQ_TASK_DEMANDS.LINE_ID
FLM_SEQ_TASK_DEMANDS.SEQ_TASK_ID |
% |
FLM_SEQ_TASK_DEMANDS.PRIMARY_ITEM_ID
FLM_SEQ_TASK_DEMANDS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
FLM_SEQ_TASK_DEMANDS.ALTERNATE_ROUTING_DESIGNATOR
FLM_SEQ_TASK_DEMANDS.ORGANIZATION_ID |
BOM_ALTERNATE_DESIGNATORS |
FLM_SEQ_TASK_DEMANDS.ORGANIZATION_ID | MTL_PARAMETERS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
FLM_SEQ_TASK_DEMANDS_U1 | UNIQUE | APPS_TS_TX_IDX |
SEQ_TASK_ID
LINE_ID DEMAND_ID SPLIT_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQ_TASK_ID | NUMBER | Y | Sequencing task identifier | |
LINE_ID | NUMBER | Y | Production line identifier | |
DEMAND_ID | NUMBER | Y | 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 | Y | Split number | |
OBJECT_VERSION_NUMBER | NUMBER | Y | Object version number | |
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
PRIMARY_ITEM_ID | NUMBER | Y | 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 | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | 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 |
FLM.FLM_SEQ_TASK_DEMANDS does not reference any database object
FLM.FLM_SEQ_TASK_DEMANDS is referenced by following:
Description: | Stores the flow sequencing constraint violation for the flow sequencing task. |
---|
Foreign Key Column | Foreign Table |
---|---|
FLM_SEQ_TASK_EXCEPTIONS.SEQ_TASK_ID
FLM_SEQ_TASK_EXCEPTIONS.CONSTRAINT_NUMBER FLM_SEQ_TASK_EXCEPTIONS.LINE_ID |
FLM_SEQ_TASK_CONSTRAINTS |
FLM_SEQ_TASK_EXCEPTIONS.ORGANIZATION_ID | MTL_PARAMETERS |
FLM_SEQ_TASK_EXCEPTIONS table stores the flow sequencing constraint violation for the flow sequencing task.
It is the child table of FLM_SEQ_TASK_CONSTRAINTS. It stores the exception information for each constraint defined in the FLM_SEQ_TASK_CONSTRAINTS table.
Index | Type | Tablespace | Column |
---|---|---|---|
FLM_SEQ_TASK_EXCEPTIONS_U1 | UNIQUE | APPS_TS_TX_IDX |
SEQ_TASK_ID
SEQ_EXCEPTION_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQ_TASK_ID | NUMBER | Y | Sequencing task identifier | |
SEQ_EXCEPTION_NUMBER | NUMBER | Y | Sequencing exception number | |
OBJECT_VERSION_NUMBER | NUMBER | Y | Object version number | |
EXCEPTION_TYPE | NUMBER | Y | Exception type | |
LINE_ID | NUMBER | Production line identifier | ||
CONSTRAINT_NUMBER | NUMBER | Identifier of constraint within a rule | ||
SCHEDULE_NUMBER | VARCHAR2 | (30) | Flow schedule number | |
ORGANIZATION_ID | NUMBER | Organization number | ||
VIOLATION_COUNT | NUMBER | Number of violation | ||
CREATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | 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 |
FLM.FLM_SEQ_TASK_EXCEPTIONS does not reference any database object
FLM.FLM_SEQ_TASK_EXCEPTIONS is referenced by following:
Description: | Stores the specific production line information for the flow sequencing task. |
---|
Foreign Key Column | Foreign Table |
---|---|
FLM_SEQ_TASK_LINES.SEQ_TASK_ID | FLM_SEQ_TASKS |
FLM_SEQ_TASK_LINES.LINE_ID | WIP_LINES |
FLM_SEQ_TASK_LINES.ORGANIZATION_ID | MTL_PARAMETERS |
FLM_SEQ_TASK_LINES.RULE_ID | FLM_SEQ_RULES |
FLM_SEQ_TASK_LINES table stores the specific production line information for the flow sequencing task.
It is the child table of FLM_SEQ_TASKS table. It holds the specific production line parameters for a specific run. The initial values will be defaulted from WIP_LINES (Production Line) table. Through the flow sequencing user interface, the user can override those values.
Index | Type | Tablespace | Column |
---|---|---|---|
FLM_SEQ_TASK_LINES_U1 | UNIQUE | APPS_TS_TX_IDX |
SEQ_TASK_ID
LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQ_TASK_ID | NUMBER | Y | Sequencing task identifier | |
LINE_ID | NUMBER | Y | Production line identifier | |
OBJECT_VERSION_NUMBER | NUMBER | Y | Object version number | |
ORGANIZATION_ID | NUMBER | Organization identifier | ||
SEQ_DIRECTION | NUMBER | Y | Sequencing direction. It is forward or backward direction. | |
START_TIME | NUMBER | Start time of the production line | ||
STOP_TIME | NUMBER | Stop time of the production line | ||
HOURLY_RATE | NUMBER | Hourly rate of production line | ||
CONNECT_FLAG | VARCHAR2 | (1) | Y | Flag to indicate whether to connect the new sequence with the existing sequence to the flow schedule that are scheduled prior to the sequencing horizon start date. |
FIX_SEQUENCE_TYPE | NUMBER | Y | Fix sequence type | |
FIX_SEQUENCE_AMOUNT | NUMBER | Fix sequence amount | ||
COMBINE_SCHEDULE_FLAG | VARCHAR2 | (1) | Y | Flag to indicate whether the flow sequencing engine need to combine multiple schedules having the same demand into one schedule. |
AVAILABLE_CAPACITY | NUMBER | Available capacity | ||
RESEQUENCED_QTY | NUMBER | Resequenced quantity | ||
RULE_ID | NUMBER | Sequencing rule identifier | ||
CREATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | 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 | ||
REQUESTED_RESEQUENCE_QTY | NUMBER | The requested qty that comes from existing flow schedules to be resequenced |
FLM.FLM_SEQ_TASK_LINES does not reference any database object
FLM.FLM_SEQ_TASK_LINES is referenced by following:
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | |||
DEPARTMENT_ID | NUMBER | |||
DEPARTMENT_CODE | VARCHAR2 | (10) | ||
RESOURCE_ID | NUMBER | |||
RESOURCE_CODE | VARCHAR2 | (10) | ||
OPERATION_TYPE | NUMBER | |||
AVAILABLE_UNITS | NUMBER | |||
ASSIGNED_UNITS | NUMBER |
APPS.FLM_MMM_DEPT_RESOURCES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
PLAN_ID | NUMBER | Y | ||
ORGANIZATION_ID | NUMBER | Y | ||
LINE_ID | NUMBER | Y | ||
LINE_CODE | VARCHAR2 | (10) | ||
LINE_DESCRIPTION | VARCHAR2 | (240) | ||
CALCULATION_OPERATION_TYPE | NUMBER | Y | ||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | Y | ||
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | Y | ||
LAST_UPDATE_LOGIN | NUMBER | |||
LINE_TAKT | NUMBER | |||
HOURS_PER_DAY | NUMBER | |||
LINE_TAKT_AS_ASSIGNED | NUMBER | |||
BOTTLENECK_RESOURCE_PERCENT | NUMBER | |||
BOTTLENECK_IPK_PERCENT | NUMBER | |||
RESOURCE_UNDERCAPACITY | NUMBER | |||
IPK_UNDERCAPACITY | NUMBER |
APPS.FLM_MMM_LINES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Y | ||
ORGANIZATION_ID | NUMBER | Y | ||
LINE_ID | NUMBER | |||
OPERATION_TYPE | NUMBER | |||
RESOURCE_ID | NUMBER | Y | ||
RESOURCE_CODE | VARCHAR2 | (10) | Y | |
RESOURCE_TYPE | NUMBER | |||
RESOURCE_TYPE_DISP | VARCHAR2 | (80) | ||
WEIGHTED_RESOURCE_USAGE | NUMBER | |||
RESOURCE_NEEDED | NUMBER | |||
RESOURCE_ASSIGNED | NUMBER |
APPS.FLM_MMM_LINE_RESOURCES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
PLAN_ID | NUMBER | Y | ||
ORGANIZATION_ID | NUMBER | Y | ||
STANDARD_OPERATION_ID | NUMBER | Y | ||
OPERATION_CODE | VARCHAR2 | (4) | ||
SEQUENCE_NUM | NUMBER | |||
OPERATION_DESCRIPTION | VARCHAR2 | (240) | ||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | Y | ||
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | Y | ||
LAST_UPDATE_LOGIN | NUMBER | |||
LINE_ID | NUMBER | Y | ||
LINE_CODE | VARCHAR2 | (10) | ||
OPERATION_TYPE | NUMBER | Y | ||
OPERATION_TAKT | NUMBER | |||
MACHINE_WEIGHTED_TIME | NUMBER | |||
LABOR_WEIGHTED_TIME | NUMBER | |||
ELAPSED_WEIGHTED_TIME | NUMBER | |||
IPK_NEEDED | NUMBER | |||
IPK_ASSIGNED | NUMBER | |||
OP_TAKT_AS_ASSIGNED | NUMBER | |||
BOTTLENECK_RESOURCE_PERCENT | NUMBER | |||
PROCESS_EFFICIENCY | NUMBER | |||
RESOURCE_UNDERCAPACITY | NUMBER |
APPS.FLM_MMM_OPERATIONS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
PLAN_ID | NUMBER | Y | ||
ORGANIZATION_ID | NUMBER | Y | ||
LINE_ID | NUMBER | |||
LINE_CODE | VARCHAR2 | (10) | ||
STANDARD_OPERATION_ID | NUMBER | Y | ||
OPERATION_CODE | VARCHAR2 | (4) | Y | |
OPERATION_TYPE | NUMBER | |||
OPERATION_DESCRIPTION | VARCHAR2 | (240) | ||
DEPARTMENT_ID | NUMBER | Y | ||
DEPARTMENT_CODE | VARCHAR2 | (10) | Y | |
RESOURCE_ID | NUMBER | Y | ||
RESOURCE_CODE | VARCHAR2 | (10) | ||
RESOURCE_TYPE | NUMBER | |||
RESOURCE_TYPE_DISP | VARCHAR2 | (80) | ||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | Y | ||
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | Y | ||
LAST_UPDATE_LOGIN | NUMBER | |||
WEIGHTED_RESOURCE_USAGE | NUMBER | |||
RESOURCE_NEEDED | NUMBER | |||
RESOURCE_ASSIGNED | NUMBER | |||
IPK_NEEDED | NUMBER | |||
IPK_ASSIGNED | NUMBER |
APPS.FLM_MMM_OP_RESOURCES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
PLAN_ID | NUMBER | Y | ||
ORGANIZATION_ID | NUMBER | Y | ||
PLAN_CODE | VARCHAR2 | (30) | Y | |
DESCRIPTION | VARCHAR2 | (240) | ||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | Y | ||
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | Y | ||
LAST_UPDATE_LOGIN | NUMBER | |||
PRODUCT_FAMILY_ID | NUMBER | |||
LINE_ID | NUMBER | |||
LINE_CODE | VARCHAR2 | (10) | ||
LINE_DESCRIPTION | VARCHAR2 | (240) | ||
DEMAND_TYPE | NUMBER | |||
DEMAND_CODE | VARCHAR2 | (10) | ||
START_DATE | DATE | |||
END_DATE | DATE | |||
DEMAND_DAYS | NUMBER | |||
HOURS_PER_DAY | NUMBER | |||
BOOST_PERCENT | NUMBER | |||
CALCULATION_OPTION | NUMBER | |||
TIME_UOM | NUMBER | |||
VIEW_BY | NUMBER | |||
PRECISION | NUMBER |
APPS.FLM_MMM_PLANS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Y | ||
ORGANIZATION_ID | NUMBER | Y | ||
RESOURCE_ID | NUMBER | Y | ||
RESOURCE_CODE | VARCHAR2 | (10) | ||
RESOURCE_TYPE | NUMBER | |||
RESOURCE_TYPE_DISP | VARCHAR2 | (80) | ||
OPERATION_TYPE | NUMBER | |||
WEIGHTED_RESOURCE_USAGE | NUMBER | |||
RESOURCE_NEEDED | NUMBER | |||
RESOURCE_ASSIGNED | NUMBER |
APPS.FLM_MMM_SUM_RESOURCES_V is not referenced by any database object
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |