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: |
---|
This table stores 445/544 period calendar
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_445_PERIOD_CALENDAR_U1 | NONUNIQUE | APPS_TS_TX_IDX | DIMENSION_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIMENSION_KEY | NUMBER | Y | Hierarchy identifier | |
DAY_START_DATE | DATE | Day start date | ||
DAY_OF_FISCAL_YEAR | NUMBER | Day of the fiscal year | ||
JULIAN_DATE | NUMBER | Unique julian date identifier | ||
DAY_OF_FISCAL_WEEK | NUMBER | Day of the fiscal week | ||
DAY_TIME_SPAN | NUMBER | Time span for the day | ||
DAY | DATE | Report date | ||
DAY_ID | NUMBER | Day identifier | ||
DAY_DAY_CODE | NUMBER | Day code | ||
DAY_DESCRIPTION | VARCHAR2 | (2000) | Description for Day | |
DAY_NAME | VARCHAR2 | (25) | Day name | |
DAY_END_DATE | DATE | Day end date | ||
DAY_OF_FISCAL_QUARTER | NUMBER | Day of the fiscal quarter | ||
DAY_OF_FISCAL_MONTH | NUMBER | Day of the fiscal month | ||
FISCAL_WEEK_START_DATE | DATE | Fiscal week start date | ||
FISCAL_WEEK_FIS_WEEK_CODE | NUMBER | Fiscal week code | ||
FISCAL_WEEK_DESCRIPTION | VARCHAR2 | (2000) | Description for fiscal week | |
WEEK_OF_FISCAL_MONTH | NUMBER | Week of the fiscal month | ||
FISCAL_WEEK_TIME_SPAN | NUMBER | Time span for the fiscal week | ||
WEEK_OF_FISCAL_YEAR | NUMBER | Week of the fiscal year | ||
FIS_WEEK_NUMBER | NUMBER | Fiscal week number | ||
FISCAL_WEEK_END_DATE | DATE | Fiscal week end date | ||
FISCAL_WEEK_ID | NUMBER | Fiscal week identifier | ||
FISCAL_WEEK_NAME | VARCHAR2 | (25) | Fiscal week name | |
WEEK_OF_FISCAL_QUARTER | NUMBER | Week of the fiscal quarter | ||
FISCAL_MONTH_START_DATE | DATE | Fiscal month start date | ||
FISCAL_MONTH_FIS_MONTH_CODE | NUMBER | Fiscal month code | ||
FISCAL_MONTH_DESCRIPTION | VARCHAR2 | (2000) | Description of the fiscal month | |
MONTH_OF_FISCAL_QUARTER | NUMBER | Month of the fiscal quarter | ||
FISCAL_MONTH_END_DATE | DATE | Fiscal month end date | ||
FISCAL_MONTH_ID | NUMBER | Fiscal month identifier | ||
FISCAL_MONTH_NAME | VARCHAR2 | (25) | Fiscal month name | |
FIS_MONTH_NUMBER | NUMBER | Fiscal month number | ||
FISCAL_MONTH_TIME_SPAN | NUMBER | Time span for the fiscal month | ||
MONTH_OF_FISCAL_YEAR | NUMBER | Month of the fiscal year | ||
FISCAL_QUARTER_TIME_SPAN | NUMBER | Time span for the fiscal quarter | ||
QUARTER_OF_FISCAL_YEAR | NUMBER | Quarter of the fiscal year | ||
FISCAL_QUARTER_FIS_QUARTER_CO | NUMBER | Fiscal quarter code | ||
FIS_QUARTER_NUMBER | NUMBER | Fiscal quarter number | ||
FISCAL_QUARTER_NAME | VARCHAR2 | (25) | Fiscal quarter number | |
FISCAL_QUARTER_END_DATE | DATE | Fiscal quarter name | ||
FISCAL_QUARTER_ID | NUMBER | Fiscal quarter identifier | ||
FISCAL_QUARTER_DESCRIPTION | VARCHAR2 | (2000) | Description for fiscal quarter | |
FISCAL_QUARTER_START_DATE | DATE | Fiscal quarter start date | ||
FISCAL_YEAR_ID | NUMBER | Fiscal year identifier | ||
FISCAL_YEAR_NAME | VARCHAR2 | (25) | Fiscal year name | |
FIS_YEAR_NUMBER | NUMBER | Fiscal year number | ||
FISCAL_YEAR_START_DATE | DATE | Fiscal year start date | ||
FISCAL_YEAR_TIME_SPAN | NUMBER | Time span for the fiscal year | ||
FISCAL_YEAR_FIS_YEAR_CODE | NUMBER | Fiscal year code | ||
FISCAL_YEAR_DESCRIPTION | VARCHAR2 | (2000) | Description for fiscal year | |
FISCAL_YEAR_END_DATE | DATE | Fiscal year end date | ||
CREATED_BY | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
CREATION_DATE | DATE | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Standard Who column |
MTH.MTH_445_PERIOD_CALENDAR does not reference any database object
MTH.MTH_445_PERIOD_CALENDAR is referenced by following:
Description: |
---|
This table stores information on day level definition for time dimension.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_DAY_D_U1 | UNIQUE | APPS_TS_TX_IDX | REPORT_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REPORT_DATE_JULIAN | NUMBER | Y | Unique Julian date identifier | |
REPORT_DATE | DATE | Y | Report date | |
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column |
MTH.MTH_DAY_D does not reference any database object
MTH.MTH_DAY_D is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REPORT_DATE | DATE | Y | ||
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
SYSTEM_FK | VARCHAR2 | (120) | ||
PROCESSING_FLAG | NUMBER |
MTH.MTH_DAY_STG does not reference any database object
MTH.MTH_DAY_STG is referenced by following:
Description: |
---|
Interface table for MTH_EQUIP_ENTITIES_MST
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEPARTMENT_ID | NUMBER | Internal column for EBS integration only | ||
DEPARTMENT_CODE | VARCHAR2 | (120) | Y | Internal column for EBS integration only |
SOURCE_ORG_CODE | VARCHAR2 | (120) | Y | Internal column for EBS integration only |
DB_GLOBAL_NAME | VARCHAR2 | (120) | Y | Internal column for EBS integration only |
ENTITY_TYPE | VARCHAR2 | (30) | Y | Internal column for EBS integration only |
USER_ATTR1 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR2 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR3 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR4 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR5 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_MEASURE1 | NUMBER | Internal column for EBS integration only | ||
USER_MEASURE2 | NUMBER | Internal column for EBS integration only | ||
USER_MEASURE3 | NUMBER | Internal column for EBS integration only | ||
USER_MEASURE4 | NUMBER | Internal column for EBS integration only | ||
USER_MEASURE5 | NUMBER | Internal column for EBS integration only | ||
HUB_ORGANIZATION_CODE | VARCHAR2 | (120) | Y | Internal column for EBS integration only |
MTH.MTH_DEPT_ENTITIES_I_STG does not reference any database object
MTH.MTH_DEPT_ENTITIES_I_STG is referenced by following:
Description: | This table is the hierarchy master table for all dimensions. |
---|
This table is the hierarchy master table for all dimensions.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_DIM_HIERARCHY_U1 | UNIQUE | APPS_TS_TX_IDX |
HIERARCHY_NAME
DIMENSION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIMENSION_ID | NUMBER | Y | Dimension identifier | |
HIERARCHY_ID | NUMBER | Y | Hierarchy identifier | |
DIMENSION_NAME | VARCHAR2 | (100) | Y | Dimension name |
HIERARCHY_NAME | VARCHAR2 | (100) | Y | Hierarchy name, unique within a dimension |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
HIER_INTERNAL_NAME | VARCHAR2 | (32) | Internal name for the hierarchy | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
CATEGORY_SET_NAME | VARCHAR2 | (30) | Category set name | |
HIERARCHY_DISPLAY_NAME | VARCHAR2 | (100) | Hierarchy display name |
MTH.MTH_DIM_HIERARCHY does not reference any database object
MTH.MTH_DIM_HIERARCHY is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIMENSION_NAME | VARCHAR2 | (100) | ||
HIERARCHY_NAME | VARCHAR2 | (100) | ||
CATEGORY_SET_NAME | VARCHAR2 | (30) | ||
HIERARCHY_DISPLAY_NAME | VARCHAR2 | (100) | ||
PROCESSING_FLAG | NUMBER |
MTH.MTH_DIM_HIERARCHY_STG does not reference any database object
MTH.MTH_DIM_HIERARCHY_STG is referenced by following:
Description: |
---|
This table stores the level information for the dimension hierarchies. It holds information on level number, level name and level type.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_DIM_LEVEL_LOOKUP_U1 | UNIQUE | APPS_TS_TX_IDX |
LEVEL_NUM
HIERARCHY_ID DIMENSION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIMENSION_ID | NUMBER | Y | Dimension identifier | |
HIERARCHY_ID | NUMBER | Y | Hierarchy identifier | |
LEVEL_NUM | NUMBER | Y | Level number in the hierarchy | |
LEVEL_TYPE | VARCHAR2 | (30) | Level type used for the level | |
LEVEL_NAME | VARCHAR2 | (30) | Level name defined for the level | |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column |
MTH.MTH_DIM_LEVEL_LOOKUP does not reference any database object
MTH.MTH_DIM_LEVEL_LOOKUP is referenced by following:
Description: |
---|
Error table for MTH_DIM_LEVEL_LOOKUP
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HIERARCHY_NAME | VARCHAR2 | (100) | Hierarchy name, unique within a dimension | |
DIMENSION_NAME | VARCHAR2 | (100) | Dimension name | |
LEVEL_NUM | NUMBER | Level number in the hierarchy | ||
LEVEL_TYPE | VARCHAR2 | (30) | Level type used for the level | |
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate reprocessing of errored rows | |
LEVEL_NAME | VARCHAR2 | (30) | Level number in the hierarchy | |
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_DIM_LEVEL_LOOKUP_ERR does not reference any database object
MTH.MTH_DIM_LEVEL_LOOKUP_ERR is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HIERARCHY_NAME | VARCHAR2 | (100) | ||
DIMENSION_NAME | VARCHAR2 | (100) | ||
LEVEL_NUM | NUMBER | |||
LEVEL_TYPE | VARCHAR2 | (30) | ||
LEVEL_NAME | VARCHAR2 | (30) | ||
PROCESSING_FLAG | NUMBER |
MTH.MTH_DIM_LEVEL_LOOKUP_STG does not reference any database object
MTH.MTH_DIM_LEVEL_LOOKUP_STG is referenced by following:
Description: |
---|
This table stores information about equipments. It holds information like Equipment name, Equipment description and Fixed asset value and Organization.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_EQUIPMENTS_D_U1 | UNIQUE | APPS_TS_TX_IDX | EQUIPMENT_PK |
MTH_EQUIPMENTS_D_U2 | UNIQUE | APPS_TS_TX_IDX |
EQUIPMENT_NAME
EQUIPMENT_PK_KEY |
MTH_EQUIPMENTS_D_U3 | UNIQUE | APPS_TS_TX_IDX |
EQUIPMENT_PK_KEY
EQUIPMENT_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EQUIPMENT_PK_KEY | NUMBER | Y | System generated surrogate key for equipment | |
EQUIPMENT_PK | VARCHAR2 | (120) | Y | Equipment identifier |
EBS_ORGANIZATION_ID | NUMBER | Oracle E-business suite organization identifier | ||
EBS_EQUIPMENT_ID | NUMBER | Oracle E-business suite equipment identifier | ||
PLANT_FK_KEY | NUMBER | Y | Reference to plant | |
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
SOURCE_ORG_CODE | VARCHAR2 | (120) | Organization code in source system | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
FIXED_ASSET_VALUE | NUMBER | Fixed asset value | ||
EQUIPMENT_NAME | VARCHAR2 | (100) | Y | Equipment name |
EQUIPMENT_DESCRIPTION | VARCHAR2 | (240) | Equipment description | |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
STD_UTILIZATION | NUMBER | Standard utilization of equipment in percentage | ||
STD_EFFICIENCY | NUMBER | Standard efficiency of equipment in percentage |
MTH.MTH_EQUIPMENTS_D does not reference any database object
MTH.MTH_EQUIPMENTS_D is referenced by following:
Description: |
---|
Error table for MTH_EQUIPMENTS_D
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EQUIPMENT_PK | VARCHAR2 | (120) | Y | Equipment identifier |
EBS_ORGANIZATION_ID | NUMBER | Oracle E-business suite organization identifier | ||
EBS_EQUIPMENT_ID | NUMBER | Oracle E-business suite equipment identifier | ||
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
FIXED_ASSET_VALUE | NUMBER | Fixed asset value | ||
EQUIPMENT_NAME | VARCHAR2 | (100) | Y | Equipment name |
EQUIPMENT_DESCRIPTION | VARCHAR2 | (240) | Equipment description | |
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate reprocessing of errored rows | |
SOURCE_ORG_CODE | VARCHAR2 | (120) | Organization code in source system | |
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
STD_UTILIZATION | NUMBER | Standard utilization of equipment in percentage | ||
STD_EFFICIENCY | NUMBER | Standard efficiency of equipment in percentage | ||
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_EQUIPMENTS_ERR does not reference any database object
MTH.MTH_EQUIPMENTS_ERR is referenced by following:
Description: |
---|
This table stores the extensible attributes for equipments
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_EQUIP_EXT_B_U1 | UNIQUE | APPS_TS_TX_IDX | EXTENSION_ID |
MTH_EQUIP_EXT_B_N1 | NONUNIQUE | APPS_TS_TX_IDX | EQUIPMENT_PK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTENSION_ID | NUMBER | Y | System generated surrogate key for the table. This is generated using EGO sequence. | |
ATTR_GROUP_ID | NUMBER | Attribute group identifier | ||
EQUIPMENT_PK_KEY | NUMBER | Reference to equipment identifier | ||
C_EXT_ATTR1 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR2 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR3 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR4 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR5 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR6 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR7 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR8 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR9 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR10 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR11 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR12 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR13 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR14 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR15 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR16 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR17 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR18 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR19 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR20 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR21 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR22 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR23 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR24 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR25 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR26 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR27 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR28 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR29 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR30 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
N_EXT_ATTR1 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR2 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR3 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR4 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR5 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR6 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR7 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR8 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR9 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR10 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR11 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR12 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR13 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR14 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR15 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR16 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR17 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR18 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR19 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR20 | NUMBER | Column to store extensible attribute number data | ||
D_EXT_ATTR1 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR2 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR3 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR4 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR5 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR6 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR7 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR8 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR9 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR10 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR11 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR12 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR13 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR14 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR15 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR16 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR17 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR18 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR19 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR20 | DATE | Column to store extensible attribute date | ||
WORKORDER_FK_KEY | NUMBER | Reference to Work Order identifier | ||
SEGMENT_FK_KEY | NUMBER | Reference to operation identifier | ||
SHIFT_WORKDAY_FK_KEY | NUMBER | Reference to shift workday identifier | ||
ITEM_FK_KEY | NUMBER | Reference to item identifier | ||
TRANSIENT | VARCHAR2 | (2) | This flag can be used to differntiate between a time bound and non time bound data row. Currently it is not used. | |
READ_TIME | DATE | Read time of the tag data for the given equipment. | ||
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
RECIPE_VERSION | VARCHAR2 | (15) | Recipe version | |
RECIPE_NUM | VARCHAR2 | (30) | Recipe number |
MTH.MTH_EQUIPMENTS_EXT_B does not reference any database object
MTH.MTH_EQUIPMENTS_EXT_B is referenced by following:
Description: |
---|
This table stores the translatable extensible attributes for Equipments
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_EQUIP_EXT_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
LANGUAGE
EXTENSION_ID |
MTH_EQUIP_EXT_TL_N1 | NONUNIQUE | APPS_TS_TX_IDX |
LANGUAGE
EQUIPMENT_PK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTENSION_ID | NUMBER | Y | System generated surrogate key for the table. This is generated using EGO sequence. | |
ATTR_GROUP_ID | NUMBER | Attribute group identifier | ||
EQUIPMENT_PK_KEY | NUMBER | Reference to equipment identifier | ||
TL_EXT_ATTR1 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR2 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR3 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR4 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR5 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR6 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR7 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR8 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR9 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR10 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR11 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR12 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR13 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR14 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR15 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR16 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR17 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR18 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR19 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR20 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR21 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR22 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR23 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR24 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR25 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR26 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR27 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR28 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR29 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR30 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
SOURCE_LANG | VARCHAR2 | (30) | Source language of the data stored in the columns | |
LANGUAGE | VARCHAR2 | (30) | Language of the data stored in the columns | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column |
MTH.MTH_EQUIPMENTS_EXT_TL does not reference any database object
MTH.MTH_EQUIPMENTS_EXT_TL is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EQUIPMENT_PK | VARCHAR2 | (120) | Y | |
EBS_ORGANIZATION_ID | NUMBER | |||
EBS_EQUIPMENT_ID | NUMBER | |||
SYSTEM_FK | VARCHAR2 | (120) | ||
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
FIXED_ASSET_VALUE | NUMBER | |||
EQUIPMENT_NAME | VARCHAR2 | (100) | Y | |
EQUIPMENT_DESCRIPTION | VARCHAR2 | (240) | ||
SOURCE_ORG_CODE | VARCHAR2 | (120) | ||
STD_UTILIZATION | NUMBER | |||
STD_EFFICIENCY | NUMBER | |||
PROCESSING_FLAG | NUMBER |
MTH.MTH_EQUIPMENTS_STG does not reference any database object
MTH.MTH_EQUIPMENTS_STG is referenced by following:
Description: |
---|
This table stores denormalized data for equipment hierarchy.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_EQUIPMENT_DENORM_D_N1 | NONUNIQUE | APPS_TS_TX_IDX | LEVEL8_LEVEL_NAME |
MTH_EQUIPMENT_DENORM_D_N2 | NONUNIQUE | APPS_TS_TX_IDX | LEVEL9_LEVEL_NAME |
MTH_EQUIPMENT_DENORM_D_U1 | NONUNIQUE | APPS_TS_TX_IDX | DIMENSION_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIMENSION_KEY | NUMBER | Y | Dimension identifier | |
LEVEL1_LEVEL_KEY | NUMBER | Reference to Level 1 level identifier | ||
LEVEL1_DESCRIPTION | VARCHAR2 | (40) | Description for Level 1 | |
LEVEL1_HIERARCHY_KEY | NUMBER | Reference to Level 1 hierarchy identifier | ||
LEVEL1_ID | NUMBER | Level 1 identifier | ||
LEVEL2_HIERARCHY_KEY | NUMBER | Reference to Level 2 hierarchy identifier | ||
LEVEL2_DESCRIPTION | VARCHAR2 | (40) | Description for Level 2 | |
LEVEL2_EFFECTIVE_DATE | DATE | Level 2 effective date | ||
LEVEL2_EXPIRATION_DATE | DATE | Level 2 expiration date | ||
LEVEL2_ID | NUMBER | Level 2 identifier | ||
LEVEL2_LEVEL_KEY | NUMBER | Reference to Level 2 level identifier | ||
LEVEL2_PARENT_KEY | NUMBER | Reference to Level 2 parent | ||
LEVEL3_PARENT_KEY | NUMBER | Reference to Level 2 parent | ||
LEVEL3_DESCRIPTION | VARCHAR2 | (40) | Description for Level 3 | |
LEVEL3_EFFECTIVE_DATE | DATE | Level 3 effective date | ||
LEVEL3_LEVEL_KEY | NUMBER | Reference to Level 3 level identifier | ||
LEVEL3_ID | NUMBER | Level 3 identifier | ||
LEVEL3_HIERARCHY_KEY | NUMBER | Reference to Level 3 hierarchy identifier | ||
LEVEL3_EXPIRATION_DATE | DATE | Level 3 expiration date | ||
LEVEL4_EXPIRATION_DATE | DATE | Level 4 expiration date | ||
LEVEL4_DESCRIPTION | VARCHAR2 | (40) | Description for Level 4 | |
LEVEL4_LEVEL_KEY | NUMBER | Reference to Level 4 level identifier | ||
LEVEL4_ID | NUMBER | Level 4 identifier | ||
LEVEL4_HIERARCHY_KEY | NUMBER | Reference to Level 4 hierarchy identifier | ||
LEVEL4_PARENT_KEY | NUMBER | Reference to Level 4 parent | ||
LEVEL4_EFFECTIVE_DATE | DATE | Level 4 effective date | ||
LEVEL5_ID | NUMBER | Level 5 identifier | ||
LEVEL5_LEVEL_KEY | NUMBER | Reference to Level 5 level identifier | ||
LEVEL5_DESCRIPTION | VARCHAR2 | (40) | Description for Level 5 | |
LEVEL5_EXPIRATION_DATE | DATE | Level 5 expiration date | ||
LEVEL5_HIERARCHY_KEY | NUMBER | Reference to Level 5 hierarchy identifier | ||
LEVEL5_PARENT_KEY | NUMBER | Reference to Level 6 parent | ||
LEVEL5_EFFECTIVE_DATE | DATE | Level 5 effective date | ||
LEVEL6_DESCRIPTION | VARCHAR2 | (40) | Description for Level 6 | |
LEVEL6_LEVEL_KEY | NUMBER | Reference to Level 6 level identifier | ||
LEVEL6_PARENT_KEY | NUMBER | Reference to Level 6 parent | ||
LEVEL6_HIERARCHY_KEY | NUMBER | Reference to Level 6 hierarchy identifier | ||
LEVEL6_ID | NUMBER | Level 6 identifier | ||
LEVEL6_EFFECTIVE_DATE | DATE | Level 6 effective date | ||
LEVEL6_EXPIRATION_DATE | DATE | Level 6 expiration date | ||
LEVEL7_EFFECTIVE_DATE | DATE | Level 7 effective date | ||
LEVEL7_PARENT_KEY | NUMBER | Reference to Level 7 parent | ||
LEVEL7_LEVEL_KEY | NUMBER | Reference to Level 7 level identifier | ||
LEVEL7_DESCRIPTION | VARCHAR2 | (40) | Description for Level 7 | |
LEVEL7_HIERARCHY_KEY | NUMBER | Reference to Level 7 hierarchy identifier | ||
LEVEL7_EXPIRATION_DATE | DATE | Level 7 expiration date | ||
LEVEL7_ID | NUMBER | Level 7 identifier | ||
LEVEL8_HIERARCHY_KEY | NUMBER | Reference to Level 8 hierarchy identifier | ||
LEVEL8_PARENT_KEY | NUMBER | Reference to Level 8 parent | ||
LEVEL8_DESCRIPTION | VARCHAR2 | (40) | Description for Level 8 | |
LEVEL8_LEVEL_KEY | NUMBER | Reference to Level 8 level identifier | ||
LEVEL8_ID | NUMBER | Level 8 identifier | ||
LEVEL8_EXPIRATION_DATE | DATE | Level 8 expiration date | ||
LEVEL8_EFFECTIVE_DATE | DATE | Level 8 effective date | ||
LEVEL9_PARENT_KEY | NUMBER | Reference to Level 9 parent | ||
LEVEL9_ID | NUMBER | Level 9 identifier | ||
LEVEL9_EXPIRATION_DATE | DATE | Level 9 expiration date | ||
LEVEL9_EFFECTIVE_DATE | DATE | Level 10 effective date | ||
LEVEL9_HIERARCHY_KEY | NUMBER | Reference to Level 9 hierarchy identifier | ||
LEVEL9_LEVEL_KEY | NUMBER | Reference to Level 9 level identifier | ||
LEVEL9_DESCRIPTION | VARCHAR2 | (40) | Description for Level 9 | |
EQUIPMENT_FK_KEY | NUMBER | Reference to Equipment level identifier | ||
EQUIPMENT_EXPIRATION_DATE | DATE | Equipment expiration date | ||
EQUIPMENT_HIERARCHY_KEY | NUMBER | Reference to Equipment hierarchy identifier | ||
EQUIPMENT_ID | NUMBER | Equipment identifier | ||
EQUIPMENT_PARENT_KEY | NUMBER | Reference to Equipment parent | ||
EQUIPMENT_DESCRIPTION | VARCHAR2 | (40) | Equipment description | |
EQUIPMENT_EFFECTIVE_DATE | DATE | Equipment effective date | ||
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Standard who column | ||
LAST_UPDATE_DATE | DATE | Standard who column | ||
LEVEL1_LEVEL_NAME | VARCHAR2 | (100) | Level1 level name | |
LEVEL2_LEVEL_NAME | VARCHAR2 | (100) | Level2 level name | |
LEVEL3_LEVEL_NAME | VARCHAR2 | (100) | Level3 level name | |
LEVEL4_LEVEL_NAME | VARCHAR2 | (100) | Level4 level name | |
LEVEL5_LEVEL_NAME | VARCHAR2 | (100) | Level5 level name | |
LEVEL6_LEVEL_NAME | VARCHAR2 | (100) | Level6 level name | |
LEVEL7_LEVEL_NAME | VARCHAR2 | (100) | Level7 level name | |
LEVEL8_LEVEL_NAME | VARCHAR2 | (100) | Level8 level name | |
LEVEL9_LEVEL_NAME | VARCHAR2 | (100) | Level9 level name | |
EQUIPMENT_LEVEL_NAME | VARCHAR2 | (100) | Equipment name | |
LEVEL_NUM | NUMBER | Level number in the hierarchy |
MTH.MTH_EQUIPMENT_DENORM_D does not reference any database object
MTH.MTH_EQUIPMENT_DENORM_D is referenced by following:
Description: |
---|
This table stores shift information at equipment level.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_EQUIPMENT_SHIFTS_D_U1 | UNIQUE | APPS_TS_TX_IDX |
EQUIPMENT_FK_KEY
SHIFT_WORKDAY_FK_KEY LINE_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EQUIPMENT_FK_KEY | NUMBER | Y | Reference to equipment | |
AVAILABILITY_DATE | DATE | Y | Date on which equipment availability details are provided | |
SHIFT_WORKDAY_FK_KEY | NUMBER | Y | Reference to shift workday | |
FROM_DATE | DATE | Y | From date | |
TO_DATE | DATE | Y | To date | |
AVAILABILITY_FLAG | VARCHAR2 | (1) | Y | Flag to identify the record, whether the equipment is available or not for the time span |
REASON | VARCHAR2 | (30) | Equipment availability reason | |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LINE_NUM | NUMBER | Y | Line number for workday shift details | |
RESOURCE_FK_KEY | NUMBER | Reference to resource | ||
RESOURCE_COST | NUMBER | Resource cost |
MTH.MTH_EQUIPMENT_SHIFTS_D does not reference any database object
MTH.MTH_EQUIPMENT_SHIFTS_D is referenced by following:
Description: |
---|
This table stores the entity definitions for equipment dimension. It holds information on Entity name and Entity type.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_EQUIP_ENTITIES_MST_U1 | UNIQUE | APPS_TS_TX_IDX | ENTITY_PK |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ENTITY_PK_KEY | NUMBER | Y | System generated surrogate key for entity | |
ENTITY_PK | VARCHAR2 | (120) | Y | Entity identifier |
ENTITY_NAME | VARCHAR2 | (100) | Y | Entity name |
ENTITY_TYPE | VARCHAR2 | (30) | Y | Entity type |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column |
MTH.MTH_EQUIP_ENTITIES_MST does not reference any database object
MTH.MTH_EQUIP_ENTITIES_MST is referenced by following:
Description: |
---|
Staging table for MTH_EQUIP_ENTITIES_MST
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ENTITY_PK | VARCHAR2 | (120) | Y | Entity identifier |
ENTITY_NAME | VARCHAR2 | (100) | Y | Entity name |
ENTITY_TYPE | VARCHAR2 | (30) | Y | Entity type |
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
USER_ATTR1 | VARCHAR2 | (150) | User Defined Attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User Defined Attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User Defined Attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User Defined Attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User Defined Attribute | |
USER_MEASURE1 | NUMBER | User Defined Measure | ||
USER_MEASURE2 | NUMBER | User Defined Measure | ||
USER_MEASURE3 | NUMBER | User Defined Measure | ||
USER_MEASURE4 | NUMBER | User Defined Measure | ||
USER_MEASURE5 | NUMBER | User Defined Measure |
MTH.MTH_EQUIP_ENTITIES_STG does not reference any database object
MTH.MTH_EQUIP_ENTITIES_STG is referenced by following:
Description: |
---|
This table stores the history of parent - child relationship for equipment hierarchy.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_EQUIP_HIERARCHY_U1 | UNIQUE | APPS_TS_TX_IDX |
LEVEL_NUM
EFFECTIVE_DATE HIERARCHY_ID LEVEL_FK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HIERARCHY_ID | NUMBER | Y | Hierarchy Identifier | |
LEVEL_NUM | NUMBER | Y | Level number in the hierarchy | |
LEVEL_FK_KEY | NUMBER | Y | Reference to the level | |
PARENT_FK_KEY | NUMBER | Y | Reference to the parent level | |
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
EFFECTIVE_DATE | DATE | Effective date for the relationship | ||
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LEVEL_NAME | VARCHAR2 | (100) | Level name | |
PARENT_NAME | VARCHAR2 | (100) | Parent level name | |
GROUP_ID | NUMBER | (For Internal Use) |
MTH.MTH_EQUIP_HIERARCHY does not reference any database object
MTH.MTH_EQUIP_HIERARCHY is referenced by following:
Description: |
---|
Error table for MTH_EQUIPMENT_HIERARCHY
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HIERARCHY_NAME | VARCHAR2 | (100) | Y | Hierarchy name, unique within a dimension |
LEVEL_NUM | NUMBER | Y | Level number in the hierarchy | |
LEVEL_FK | VARCHAR2 | (120) | Y | Reference to the source level |
PARENT_FK | VARCHAR2 | (120) | Reference to the source parent level | |
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate reprocessing of errored rows | |
EFFECTIVE_DATE | DATE | Effective date for the relationship | ||
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_EQUIP_HIERARCHY_ERR does not reference any database object
MTH.MTH_EQUIP_HIERARCHY_ERR is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HIERARCHY_NAME | VARCHAR2 | (100) | Y | |
LEVEL_NUM | NUMBER | Y | ||
LEVEL_FK | VARCHAR2 | (120) | Y | |
PARENT_FK | VARCHAR2 | (120) | ||
SYSTEM_FK | VARCHAR2 | (120) | ||
EFFECTIVE_DATE | DATE | |||
PROCESSING_FLAG | NUMBER |
MTH.MTH_EQUIP_HIERARCHY_STG does not reference any database object
MTH.MTH_EQUIP_HIERARCHY_STG is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EQUIPMENT_FK | VARCHAR2 | (120) | Y | |
ITEM_FK | VARCHAR2 | (120) | Y | |
SHIFT_WORKDAY_FK | VARCHAR2 | (120) | ||
WORKORDER_FK | VARCHAR2 | (240) | ||
READING_TIME | DATE | Y | ||
QTY_COMPLETED | NUMBER | |||
QTY_SCRAP | NUMBER | |||
QTY_REJECTED | NUMBER | |||
QTY_REWORK | NUMBER | |||
QTY_UOM | VARCHAR2 | (5) | ||
QTY_GOOD | NUMBER | |||
QTY_OUTPUT | NUMBER | |||
SYSTEM_FK | VARCHAR2 | (120) | ||
RECIPE_VERSION | VARCHAR2 | (15) | ||
RECIPE_NUM | VARCHAR2 | (30) | ||
SEGMENT_FK | VARCHAR2 | (120) | ||
USER_DIM1_FK | VARCHAR2 | (120) | ||
USER_DIM2_FK | VARCHAR2 | (120) | ||
USER_DIM3_FK | VARCHAR2 | (120) | ||
USER_DIM4_FK | VARCHAR2 | (120) | ||
USER_DIM5_FK | VARCHAR2 | (120) | ||
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
PROCESSING_FLAG | NUMBER |
MTH.MTH_EQUIP_OUTPUT_STG does not reference any database object
MTH.MTH_EQUIP_OUTPUT_STG is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EQUIPMENT_FK | VARCHAR2 | (120) | Y | |
WORKORDER_FK | VARCHAR2 | (240) | ||
SEGMENT_FK | VARCHAR2 | (120) | ||
SHIFT_WORKDAY_FK | VARCHAR2 | (120) | ||
ITEM_FK | VARCHAR2 | (120) | ||
ACTUAL_FROM_DATE | DATE | Y | ||
ACTUAL_TO_DATE | DATE | Y | ||
SYSTEM_FK | VARCHAR2 | (120) | ||
USER_DIM1_FK | VARCHAR2 | (120) | ||
USER_DIM2_FK | VARCHAR2 | (120) | ||
USER_DIM3_FK | VARCHAR2 | (120) | ||
USER_DIM4_FK | VARCHAR2 | (120) | ||
USER_DIM5_FK | VARCHAR2 | (120) | ||
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
PROCESSING_FLAG | NUMBER |
MTH.MTH_EQUIP_PROD_PERFORMANCE_STG does not reference any database object
MTH.MTH_EQUIP_PROD_PERFORMANCE_STG is referenced by following:
Description: |
---|
Error table for MTH_EQUIP_PROD_SCHEDULE_F
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EQUIP_SCHEDULE_PK | VARCHAR2 | (120) | Y | Equipment schedule identifier |
EQUIPMENT_FK | VARCHAR2 | (120) | Y | Reference to source equipment |
WORKORDER_FK | VARCHAR2 | (240) | Reference to source workorder | |
SEGMENT_FK | VARCHAR2 | (120) | Reference to source operation | |
SHIFT_WORKDAY_FK | VARCHAR2 | (120) | Reference to source shift workday | |
ITEM_FK | VARCHAR2 | (120) | Reference to primary source product | |
SCHEDULE_FROM_DATE | DATE | Y | Schedule from date | |
SCHEDULE_TO_DATE | DATE | Y | Schedule to date | |
PLANNED_QTY_G | NUMBER | Planned quantity in primary unit of measure | ||
PLANNED_QTY_SG | NUMBER | Planned quantity in secondary unit of measure | ||
PRIMARY_UOM | VARCHAR2 | (5) | Primary unit of measure | |
SECONDARY_UOM | VARCHAR2 | (5) | Secondary unit of measure | |
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate re-processing of errored rows | |
USER_DIM1_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM2_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM3_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM4_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM5_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_EQUIP_PROD_SCHEDULE_ERR does not reference any database object
MTH.MTH_EQUIP_PROD_SCHEDULE_ERR is referenced by following:
Description: |
---|
This table stores information on scheduled quantity on every equipment. It holds additional information on the work order and operation it is scheduled.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_EQUIP_PROD_SCHEDULE_F_U1 | UNIQUE | APPS_TS_TX_IDX | EQUIP_SCHEDULE_PK |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EQUIP_SCHEDULE_PK_KEY | NUMBER | Y | System generated surrogate key for equipment schedule | |
EQUIP_SCHEDULE_PK | VARCHAR2 | (120) | Y | Equipment schedule identifier |
EQUIPMENT_FK_KEY | NUMBER | Y | Reference to equipment | |
WORKORDER_FK_KEY | NUMBER | Reference to workorder | ||
SEGMENT_FK_KEY | NUMBER | Reference to operation | ||
SHIFT_WORKDAY_FK_KEY | NUMBER | Reference to shift workday | ||
ITEM_FK_KEY | NUMBER | Reference to primary product | ||
SCHEDULE_FROM_DATE | DATE | Y | Schedule from date | |
SCHEDULE_TO_DATE | DATE | Y | Schedule to date | |
PLANNED_QTY_G | NUMBER | Planned quantity in Primary unit of measure | ||
PLANNED_QTY_SG | NUMBER | Planned quantity in Secondary unit of measure | ||
PRIMARY_UOM | VARCHAR2 | (5) | Primary unit of measure | |
SECONDARY_UOM | VARCHAR2 | (5) | Secondary unit of measure | |
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
USER_DIM1_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM2_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM3_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM4_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM5_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
ITEM_COST | NUMBER | Item cost | ||
STANDARD_RATE_1 | NUMBER | Standard production rate in units per hour | ||
STATUS_CODE | NUMBER | Work Order status code |
MTH.MTH_EQUIP_PROD_SCHEDULE_F does not reference any database object
MTH.MTH_EQUIP_PROD_SCHEDULE_F is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EQUIP_SCHEDULE_PK | VARCHAR2 | (120) | Y | |
EQUIPMENT_FK | VARCHAR2 | (120) | Y | |
WORKORDER_FK | VARCHAR2 | (240) | ||
SEGMENT_FK | VARCHAR2 | (120) | ||
SHIFT_WORKDAY_FK | VARCHAR2 | (120) | ||
ITEM_FK | VARCHAR2 | (120) | ||
SCHEDULE_FROM_DATE | DATE | Y | ||
SCHEDULE_TO_DATE | DATE | Y | ||
PLANNED_QTY_G | NUMBER | |||
PLANNED_QTY_SG | NUMBER | |||
PRIMARY_UOM | VARCHAR2 | (5) | ||
SECONDARY_UOM | VARCHAR2 | (5) | ||
SYSTEM_FK | VARCHAR2 | (120) | ||
USER_DIM1_FK | VARCHAR2 | (120) | ||
USER_DIM2_FK | VARCHAR2 | (120) | ||
USER_DIM3_FK | VARCHAR2 | (120) | ||
USER_DIM4_FK | VARCHAR2 | (120) | ||
USER_DIM5_FK | VARCHAR2 | (120) | ||
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
PROCESSING_FLAG | NUMBER |
MTH.MTH_EQUIP_PROD_SCHEDULE_STG does not reference any database object
MTH.MTH_EQUIP_PROD_SCHEDULE_STG is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EQUIPMENT_FK | VARCHAR2 | (120) | Y | |
SHIFT_WORKDAY_FK | VARCHAR2 | (120) | ||
ITEM_FK | VARCHAR2 | (120) | ||
STANDARD_RATE_1 | NUMBER | |||
STANDARD_RATE_2 | NUMBER | |||
STANDARD_RATE_3 | NUMBER | |||
SOURCE_ORG_CODE | VARCHAR2 | (120) | ||
SYSTEM_FK | VARCHAR2 | (120) | ||
USER_DIM1_FK | VARCHAR2 | (120) | ||
USER_DIM2_FK | VARCHAR2 | (120) | ||
USER_DIM3_FK | VARCHAR2 | (120) | ||
USER_DIM4_FK | VARCHAR2 | (120) | ||
USER_DIM5_FK | VARCHAR2 | (120) | ||
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
RECIPE_NUM | VARCHAR2 | (30) | ||
RECIPE_VERSION | VARCHAR2 | (15) | ||
PROCESSING_FLAG | NUMBER |
MTH.MTH_EQUIP_STANDARD_RATES_STG does not reference any database object
MTH.MTH_EQUIP_STANDARD_RATES_STG is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EQUIPMENT_FK | VARCHAR2 | (120) | Y | |
SHIFT_WORKDAY_FK | VARCHAR2 | (120) | ||
FROM_DATE | DATE | Y | ||
TO_DATE | DATE | |||
STATUS | VARCHAR2 | (30) | Y | |
SYSTEM_FK | VARCHAR2 | (120) | ||
USER_DIM1_FK | VARCHAR2 | (120) | ||
USER_DIM2_FK | VARCHAR2 | (120) | ||
USER_DIM3_FK | VARCHAR2 | (120) | ||
USER_DIM4_FK | VARCHAR2 | (120) | ||
USER_DIM5_FK | VARCHAR2 | (120) | ||
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
PROCESSING_FLAG | NUMBER |
MTH.MTH_EQUIP_STATUSES_STG does not reference any database object
MTH.MTH_EQUIP_STATUSES_STG is referenced by following:
Description: |
---|
Error table for MTH_EQUIPMENTS_EXT_B, MTH_EQUIPMENTS_EXT_TL, MTH_ITEMS_EXT_B, MTH_ITEMS_EXT_TL, MTH_PRODUCTION_SCHEDULES_EXT_B, MTH_PRODUCTION_SCHEDULE_EXT_TL, MTH_OTHERS_EXT_B and MTH_OTHERS_EXT_TL
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ATTR_GRP_NAME | VARCHAR2 | (150) | Internal name for the Attribute Group | |
ATTR_NAME | VARCHAR2 | (150) | Internal name for the Attribute | |
ATTR_VALUE | VARCHAR2 | (150) | Attribute data | |
GROUP_ID | NUMBER | Row identifier for a group of rows in error table |
MTH.MTH_EXT_ATTR_ERR does not reference any database object
MTH.MTH_EXT_ATTR_ERR is referenced by following:
Description: |
---|
Interface table for MTH_EQUIPMENTS_EXT_B, MTH_EQUIPMENTS_EXT_TL, MTH_ITEMS_EXT_B, MTH_ITEMS_EXT_TL, MTH_PRODUCTION_SCHEDULES_EXT_B, MTH_PRODUCTION_SCHEDULE_EXT_TL, MTH_OTHERS_EXT_B and MTH_OTHERS_EXT_TL
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ATTR_GRP_NAME | VARCHAR2 | (150) | Internal name for the Attribute Group | |
ATTR_NAME | VARCHAR2 | (150) | Internal name for the Attribute | |
ATTR_VALUE | VARCHAR2 | (150) | Attribute data | |
GROUP_ID | NUMBER | Row identifier for a group of rows in error table |
MTH.MTH_EXT_ATTR_I_STG does not reference any database object
MTH.MTH_EXT_ATTR_I_STG is referenced by following:
Description: |
---|
Staging table for MTH_EQUIPMENTS_EXT_B, MTH_EQUIPMENTS_EXT_TL, MTH_ITEMS_EXT_B, MTH_ITEMS_EXT_TL, MTH_PRODUCTION_SCHEDULES_EXT_B, MTH_PRODUCTION_SCHEDULE_EXT_TL, MTH_OTHERS_EXT_B and MTH_OTHERS_EXT_TL
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ATTR_GROUP_ID | NUMBER | Attribute group identifier | ||
ATTR_NAME | VARCHAR2 | (150) | Internal name for the Attribute | |
ATTR_VALUE | VARCHAR2 | (150) | Attribute data | |
GROUP_ID | NUMBER | Row identifier for a group of rows in error table | ||
DB_COL | VARCHAR2 | (30) | Database column in which this attribute value is stored | |
UNIQUE_KEY_FLAG | VARCHAR2 | (3) | Determines if this attribute is part of Unique key |
MTH.MTH_EXT_ATTR_T_STG does not reference any database object
MTH.MTH_EXT_ATTR_T_STG is referenced by following:
Description: |
---|
This table stores gregorian calendar
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_GREGORIAN_CALENDAR_U1 | UNIQUE | APPS_TS_TX_IDX | DIMENSION_KEY |
MTH_GREGORIAN_CALENDAR_N1 | NONUNIQUE | APPS_TS_TX_IDX |
CALENDAR_MONTH_NAME
DAY_ID CALENDAR_MONTH_ID |
MTH_GREGORIAN_CALENDAR_N2 | NONUNIQUE | APPS_TS_TX_IDX |
DAY
DAY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIMENSION_KEY | NUMBER | Y | Hierarchy identifier | |
DAY_DESCRIPTION | VARCHAR2 | (2000) | Description for Day | |
DAY_NAME | VARCHAR2 | (25) | Day name | |
DAY_START_DATE | DATE | Day start date | ||
DAY | DATE | Report date | ||
DAY_END_DATE | DATE | Day end date | ||
DAY_OF_CAL_YEAR | NUMBER | Day of the calendar year | ||
DAY_ID | NUMBER | Day identifier | ||
DAY_OF_CAL_WEEK | NUMBER | Day of the calendar week | ||
DAY_OF_CAL_QUARTER | NUMBER | Day of the calendar quarter | ||
JULIAN_DATE | NUMBER | Unique Julian date identifier | ||
DAY_TIME_SPAN | NUMBER | Time span for the day | ||
DAY_OF_CAL_MONTH | NUMBER | Day of the calendar month | ||
DAY_DAY_CODE | NUMBER | Day code | ||
CALENDAR_MONTH_ID | NUMBER | Calendar month identifier | ||
MONTH_OF_YEAR | NUMBER | Month of the calendar year | ||
CALENDAR_MONTH_DESCRIPTION | VARCHAR2 | (2000) | Description for calendar month | |
CAL_MONTH_NUMBER | NUMBER | Calendar month number | ||
CALENDAR_MONTH_TIME_SPAN | NUMBER | Time span for the calendar month | ||
CALENDAR_MONTH_START_DATE | DATE | Calendar month start date | ||
CALENDAR_MONTH_CAL_MONTH_CODE | NUMBER | Calendar month code | ||
CALENDAR_MONTH_NAME | VARCHAR2 | (25) | Calendar month name | |
MONTH_OF_QUARTER | NUMBER | Month of the quarter | ||
CALENDAR_MONTH_END_DATE | DATE | Calendar month end date | ||
CALENDAR_QUARTER_TIME_SPAN | NUMBER | Time span for the calendar quarter | ||
CALENDAR_QUART_CAL_QUARTER_CO | NUMBER | Calendar quarter code | ||
CALENDAR_QUARTER_START_DATE | DATE | Calendar quarter start date | ||
CALENDAR_QUARTER_END_DATE | DATE | Calendar quarter end date | ||
CALENDAR_QUARTER_ID | NUMBER | Calendar quarter identifier | ||
CALENDAR_QUARTER_DESCRIPTION | VARCHAR2 | (2000) | Description for calendar quarter | |
CAL_QUARTER_NUMBER | NUMBER | Calendar quarter number | ||
CALENDAR_QUARTER_NAME | VARCHAR2 | (25) | Calendar quarter name | |
QUARTER_OF_YEAR | NUMBER | Quarter of the year | ||
CALENDAR_YEAR_END_DATE | DATE | Calendar year end date | ||
CALENDAR_YEAR_ID | NUMBER | Calendar year identifier | ||
CAL_YEAR_NUMBER | NUMBER | Calendar year number | ||
CALENDAR_YEAR_NAME | VARCHAR2 | (25) | Calendar year name | |
CALENDAR_YEAR_TIME_SPAN | NUMBER | Time span for the calendar year | ||
CALENDAR_YEAR_CAL_YEAR_CODE | NUMBER | Calendar year code | ||
CALENDAR_YEAR_DESCRIPTION | VARCHAR2 | (2000) | Calendar year description | |
CALENDAR_YEAR_START_DATE | DATE | Calendar year start date | ||
CREATED_BY | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
CREATION_DATE | DATE | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Standard Who column |
MTH.MTH_GREGORIAN_CALENDAR does not reference any database object
MTH.MTH_GREGORIAN_CALENDAR is referenced by following:
Description: |
---|
This table stores information on items and its attributes. It holds information like Item name, Item description, Base item, Primary UOM, Secondary UOM, Unit weight, Weight UOM, Unit volume and Volume UOM.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_ITEMS_D_U1 | UNIQUE | APPS_TS_TX_IDX | ITEM_PK |
MTH_ITEMS_D_U2 | UNIQUE | APPS_TS_TX_IDX |
ITEM_NAME
ITEM_PK_KEY |
MTH_ITEMS_D_U3 | UNIQUE | APPS_TS_TX_IDX |
ITEM_PK_KEY
ITEM_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_PK_KEY | NUMBER | Y | System generated surrogate key for item | |
ITEM_PK | VARCHAR2 | (120) | Y | Item identifier |
PRIMARY_UOM | VARCHAR2 | (5) | Y | Primary unit of measure |
PLANT_FK_KEY | NUMBER | Y | Reference to plant | |
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
SECONDARY_UOM | VARCHAR2 | (5) | Secondary unit of measure | |
EBS_ITEM_ID | NUMBER | Oracle E-business suite item identifier | ||
EBS_ORGANIZATION_ID | NUMBER | Oracle E-business suite organization identifier | ||
UNIT_WEIGHT | NUMBER | Unit weight | ||
WEIGHT_UOM | VARCHAR2 | (5) | Weight unit of measure | |
UNIT_VOLUME | NUMBER | Unit volume | ||
VOLUME_UOM | VARCHAR2 | (5) | Volume unit of measure | |
ITEM_NAME | VARCHAR2 | (240) | Y | Item name |
DESCRIPTION | VARCHAR2 | (240) | Item description | |
BASE_ITEM | VARCHAR2 | (240) | Model number | |
SOURCE_ORG_CODE | VARCHAR2 | (120) | Organization code in source system | |
USER_ATTR1 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR6 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR7 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR8 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR9 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR10 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR11 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR12 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR13 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR14 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR15 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR16 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR17 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR18 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR19 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR20 | VARCHAR2 | (240) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column |
MTH.MTH_ITEMS_D does not reference any database object
MTH.MTH_ITEMS_D is referenced by following:
Description: |
---|
Error table for MTH_ITEMS_D
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_PK | VARCHAR2 | (120) | Y | Item identifier |
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
SOURCE_ORG_CODE | VARCHAR2 | (120) | Y | Organization code in source system |
ITEM_NAME | VARCHAR2 | (240) | Y | Item name |
PRIMARY_UOM | VARCHAR2 | (5) | Y | Primary unit of measure |
SECONDARY_UOM | VARCHAR2 | (5) | Secondary unit of measure | |
EBS_ITEM_ID | NUMBER | Oracle E-business suite item identifier | ||
EBS_ORG_ID | NUMBER | Oracle E-business suite organization identifier | ||
DESCRIPTION | VARCHAR2 | (240) | Item description | |
UNIT_WEIGHT | NUMBER | Unit weight | ||
WEIGHT_UOM | VARCHAR2 | (5) | Weight unit of measure | |
UNIT_VOLUME | NUMBER | Unit volume | ||
VOLUME_UOM | VARCHAR2 | (5) | Volume unit of measure | |
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate reprocessing of errored rows | |
BASE_ITEM | VARCHAR2 | (240) | Model number | |
USER_ATTR1 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR6 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR7 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR8 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR9 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR10 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR11 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR12 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR13 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR14 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR15 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR16 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR17 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR18 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR19 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR20 | VARCHAR2 | (240) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_ITEMS_ERR does not reference any database object
MTH.MTH_ITEMS_ERR is referenced by following:
Description: |
---|
This table stores the extensible attributes for items
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_ITEMS_EXT_B_U1 | UNIQUE | APPS_TS_TX_IDX | EXTENSION_ID |
MTH_ITEMS_EXT_B_N1 | NONUNIQUE | APPS_TS_TX_IDX | ITEM_PK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTENSION_ID | NUMBER | Y | System generated surrogate key for the table. This is generated using EGO sequence. | |
ATTR_GROUP_ID | NUMBER | Attribute group identifier | ||
ITEM_PK_KEY | NUMBER | Reference to item identifier | ||
C_EXT_ATTR1 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR2 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR3 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR4 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR5 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR6 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR7 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR8 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR9 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR10 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR11 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR12 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR13 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR14 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR15 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR16 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR17 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR18 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR19 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR20 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR21 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR22 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR23 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR24 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR25 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR26 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR27 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR28 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR29 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR30 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
N_EXT_ATTR1 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR2 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR3 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR4 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR5 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR6 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR7 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR8 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR9 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR10 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR11 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR12 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR13 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR14 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR15 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR16 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR17 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR18 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR19 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR20 | NUMBER | Column to store extensible attribute number data | ||
D_EXT_ATTR1 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR2 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR3 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR4 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR5 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR6 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR7 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR8 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR9 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR10 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR11 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR12 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR13 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR14 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR15 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR16 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR17 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR18 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR19 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR20 | DATE | Column to store extensible attribute date | ||
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column |
MTH.MTH_ITEMS_EXT_B does not reference any database object
MTH.MTH_ITEMS_EXT_B is referenced by following:
Description: |
---|
This table stores the translatable extensible attributes for Items
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_ITEMS_EXT_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
LANGUAGE
EXTENSION_ID |
MTH_ITEMS_EXT_TL_N1 | NONUNIQUE | APPS_TS_TX_IDX |
LANGUAGE
ITEM_PK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTENSION_ID | NUMBER | Y | System generated surrogate key for the table. This is generated using EGO sequence. | |
ATTR_GROUP_ID | NUMBER | Attribute group identifier | ||
ITEM_PK_KEY | NUMBER | Reference to item identifier | ||
TL_EXT_ATTR1 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR2 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR3 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR4 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR5 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR6 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR7 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR8 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR9 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR10 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR11 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR12 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR13 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR14 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR15 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR16 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR17 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR18 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR19 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR20 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR21 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR22 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR23 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR24 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR25 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR26 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR27 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR28 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR29 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR30 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
SOURCE_LANG | VARCHAR2 | (30) | Source language of the data stored in the columns | |
LANGUAGE | VARCHAR2 | (30) | Language of the data stored in the columns | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column |
MTH.MTH_ITEMS_EXT_TL does not reference any database object
MTH.MTH_ITEMS_EXT_TL is referenced by following:
Description: |
---|
Interface table for MTH_ITEMS_D
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DB_GLOBAL_NAME | VARCHAR2 | (120) | Internal column for EBS integration only | |
ITEM_NAME | VARCHAR2 | (240) | Y | Internal column for EBS integration only |
PRIMARY_UOM | VARCHAR2 | (5) | Y | Internal column for EBS integration only |
SECONDARY_UOM | VARCHAR2 | (5) | Internal column for EBS integration only | |
EBS_ITEM_ID | NUMBER | Y | Internal column for EBS integration only | |
EBS_ORG_ID | NUMBER | Y | Internal column for EBS integration only | |
DESCRIPTION | VARCHAR2 | (240) | Internal column for EBS integration only | |
UNIT_WEIGHT | NUMBER | Internal column for EBS integration only | ||
WEIGHT_UOM | VARCHAR2 | (5) | Internal column for EBS integration only | |
UNIT_VOLUME | NUMBER | Internal column for EBS integration only | ||
VOLUME_UOM | VARCHAR2 | (5) | Internal column for EBS integration only | |
SOURCE_ORG_CODE | VARCHAR2 | (120) | Y | Internal column for EBS integration only |
HUB_ORG_CODE | VARCHAR2 | (120) | Y | Internal column for EBS integration only |
BASE_ITEM | VARCHAR2 | (240) | Internal column for EBS integration only | |
USER_ATTR1 | VARCHAR2 | (240) | Internal column for EBS integration only | |
USER_ATTR2 | VARCHAR2 | (240) | Internal column for EBS integration only | |
USER_ATTR3 | VARCHAR2 | (240) | Internal column for EBS integration only | |
USER_ATTR4 | VARCHAR2 | (240) | Internal column for EBS integration only | |
USER_ATTR5 | VARCHAR2 | (240) | Internal column for EBS integration only | |
USER_ATTR6 | VARCHAR2 | (240) | Internal column for EBS integration only | |
USER_ATTR7 | VARCHAR2 | (240) | Internal column for EBS integration only | |
USER_ATTR8 | VARCHAR2 | (240) | Internal column for EBS integration only | |
USER_ATTR9 | VARCHAR2 | (240) | Internal column for EBS integration only | |
USER_ATTR10 | VARCHAR2 | (240) | Internal column for EBS integration only | |
USER_ATTR11 | VARCHAR2 | (240) | Internal column for EBS integration only | |
USER_ATTR12 | VARCHAR2 | (240) | Internal column for EBS integration only | |
USER_ATTR13 | VARCHAR2 | (240) | Internal column for EBS integration only | |
USER_ATTR14 | VARCHAR2 | (240) | Internal column for EBS integration only | |
USER_ATTR15 | VARCHAR2 | (240) | Internal column for EBS integration only | |
USER_ATTR16 | VARCHAR2 | (240) | Internal column for EBS integration only | |
USER_ATTR17 | VARCHAR2 | (240) | Internal column for EBS integration only | |
USER_ATTR18 | VARCHAR2 | (240) | Internal column for EBS integration only | |
USER_ATTR19 | VARCHAR2 | (240) | Internal column for EBS integration only | |
USER_ATTR20 | VARCHAR2 | (240) | Internal column for EBS integration only | |
USER_MEASURE1 | NUMBER | Internal column for EBS integration only | ||
USER_MEASURE2 | NUMBER | Internal column for EBS integration only | ||
USER_MEASURE3 | NUMBER | Internal column for EBS integration only | ||
USER_MEASURE4 | NUMBER | Internal column for EBS integration only | ||
USER_MEASURE5 | NUMBER | Internal column for EBS integration only |
MTH.MTH_ITEMS_I_STG does not reference any database object
MTH.MTH_ITEMS_I_STG is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_PK | VARCHAR2 | (120) | Y | |
SYSTEM_FK | VARCHAR2 | (120) | ||
SOURCE_ORG_CODE | VARCHAR2 | (120) | Y | |
ITEM_NAME | VARCHAR2 | (240) | Y | |
PRIMARY_UOM | VARCHAR2 | (5) | Y | |
SECONDARY_UOM | VARCHAR2 | (5) | ||
EBS_ITEM_ID | NUMBER | |||
EBS_ORG_ID | NUMBER | |||
DESCRIPTION | VARCHAR2 | (240) | ||
UNIT_WEIGHT | NUMBER | |||
WEIGHT_UOM | VARCHAR2 | (5) | ||
UNIT_VOLUME | NUMBER | |||
VOLUME_UOM | VARCHAR2 | (5) | ||
BASE_ITEM | VARCHAR2 | (240) | ||
USER_ATTR1 | VARCHAR2 | (240) | ||
USER_ATTR2 | VARCHAR2 | (240) | ||
USER_ATTR3 | VARCHAR2 | (240) | ||
USER_ATTR4 | VARCHAR2 | (240) | ||
USER_ATTR5 | VARCHAR2 | (240) | ||
USER_ATTR6 | VARCHAR2 | (240) | ||
USER_ATTR7 | VARCHAR2 | (240) | ||
USER_ATTR8 | VARCHAR2 | (240) | ||
USER_ATTR9 | VARCHAR2 | (240) | ||
USER_ATTR10 | VARCHAR2 | (240) | ||
USER_ATTR11 | VARCHAR2 | (240) | ||
USER_ATTR12 | VARCHAR2 | (240) | ||
USER_ATTR13 | VARCHAR2 | (240) | ||
USER_ATTR14 | VARCHAR2 | (240) | ||
USER_ATTR15 | VARCHAR2 | (240) | ||
USER_ATTR16 | VARCHAR2 | (240) | ||
USER_ATTR17 | VARCHAR2 | (240) | ||
USER_ATTR18 | VARCHAR2 | (240) | ||
USER_ATTR19 | VARCHAR2 | (240) | ||
USER_ATTR20 | VARCHAR2 | (240) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
PROCESSING_FLAG | NUMBER |
MTH.MTH_ITEMS_STG does not reference any database object
MTH.MTH_ITEMS_STG is referenced by following:
Description: |
---|
This table stores information on Item Categories.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_ITEM_CATEGORIES_D_U1 | UNIQUE | APPS_TS_TX_IDX | CATEGORY_PK |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CATEGORY_PK_KEY | NUMBER | Y | System generated surrogate key for category identifier | |
CATEGORY_PK | VARCHAR2 | (120) | Y | Category identifier |
EBS_CATEGORY_ID | NUMBER | Oracle E-business suite item category identifier | ||
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
CATEGORY_NAME | VARCHAR2 | (240) | Y | Item Category name |
DESCRIPTION | VARCHAR2 | (240) | Category description | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column |
MTH.MTH_ITEM_CATEGORIES_D does not reference any database object
MTH.MTH_ITEM_CATEGORIES_D is referenced by following:
Description: |
---|
Interface table for MTH_ITEM_CATEGORIES_D
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DB_GLOBAL_NAME | VARCHAR2 | (120) | Y | Internal column for EBS integration only |
CATEGORY_SET_ID | NUMBER | Y | Internal column for EBS integration only | |
CATEGORY_ID | NUMBER | Internal column for EBS integration only | ||
CATEGORY_NAME | VARCHAR2 | (240) | Y | Internal column for EBS integration only |
DESCRIPTION | VARCHAR2 | (240) | Internal column for EBS integration only | |
PARENT_CATEGORY_ID | NUMBER | Internal column for EBS integration only | ||
HIERARCHY_NAME | VARCHAR2 | (100) | Y | Internal column for EBS integration only |
USER_ATTR1 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR2 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR3 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR4 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR5 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_MEASURE1 | NUMBER | Internal column for EBS integration only | ||
USER_MEASURE2 | NUMBER | Internal column for EBS integration only | ||
USER_MEASURE3 | NUMBER | Internal column for EBS integration only | ||
USER_MEASURE4 | NUMBER | Internal column for EBS integration only | ||
USER_MEASURE5 | NUMBER | Internal column for EBS integration only |
MTH.MTH_ITEM_CATEGORIES_I_STG does not reference any database object
MTH.MTH_ITEM_CATEGORIES_I_STG is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CATEGORY_PK | VARCHAR2 | (120) | Y | |
SYSTEM_FK | VARCHAR2 | (120) | ||
CATEGORY_NAME | VARCHAR2 | (240) | Y | |
DESCRIPTION | VARCHAR2 | (240) | ||
EBS_CATEGORY_ID | NUMBER | |||
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
PROCESSING_FLAG | NUMBER |
MTH.MTH_ITEM_CATEGORIES_STG does not reference any database object
MTH.MTH_ITEM_CATEGORIES_STG is referenced by following:
Description: |
---|
This table stores the information about item cost history. It holds information on item cost for every cost element of the item.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_FK_KEY | NUMBER | Y | Reference to item | |
FROM_DATE | DATE | Y | From date | |
TO_DATE | DATE | To date | ||
COST | NUMBER | Y | Item cost | |
COST_ELEMENT | VARCHAR2 | (30) | Cost element | |
ISCURRENT | NUMBER | Y | Flag indicating latest cost | |
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column |
MTH.MTH_ITEM_COST does not reference any database object
MTH.MTH_ITEM_COST is referenced by following:
Description: |
---|
Error table for MTH_ITEMS_COST
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
ITEM_FK | VARCHAR2 | (120) | Y | Reference to source item |
ITEM_COST | NUMBER | Y | Item cost | |
FROM_DATE | DATE | Y | From date | |
TO_DATE | DATE | To date | ||
COST_ELEMENT | VARCHAR2 | (30) | Cost element | |
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate reprocessing of errored rows | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_ITEM_COST_ERR does not reference any database object
MTH.MTH_ITEM_COST_ERR is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SYSTEM_FK | VARCHAR2 | (120) | ||
ITEM_FK | VARCHAR2 | (120) | Y | |
ITEM_COST | NUMBER | Y | ||
FROM_DATE | DATE | Y | ||
COST_ELEMENT | VARCHAR2 | (30) | ||
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
TO_DATE | DATE | |||
PROCESSING_FLAG | NUMBER |
MTH.MTH_ITEM_COST_STG does not reference any database object
MTH.MTH_ITEM_COST_STG is referenced by following:
Description: |
---|
This table stores denormalized data for item hierarchy.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_ITEM_DENORM_D_N1 | NONUNIQUE | APPS_TS_TX_IDX | LEVEL7_NAME |
MTH_ITEM_DENORM_D_N2 | NONUNIQUE | APPS_TS_TX_IDX | LEVEL8_NAME |
MTH_ITEM_DENORM_D_N3 | NONUNIQUE | APPS_TS_TX_IDX | LEVEL9_NAME |
MTH_ITEM_DENORM_D_U1 | NONUNIQUE | APPS_TS_TX_IDX |
HIERARCHY_ID
ITEM_FK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HIERARCHY_ID | NUMBER | Y | Hierarchy identifier | |
ITEM_FK_KEY | NUMBER | Reference to item identifier | ||
LEVEL9_FK_KEY | NUMBER | Reference to level 9 of the hierarchy | ||
LEVEL8_FK_KEY | NUMBER | Reference to level 8 of the hierarchy | ||
LEVEL7_FK_KEY | NUMBER | Reference to level 7 of the hierarchy | ||
LEVEL6_FK_KEY | NUMBER | Reference to level 6 of the hierarchy | ||
LEVEL5_FK_KEY | NUMBER | Reference to level 5 of the hierarchy | ||
LEVEL4_FK_KEY | NUMBER | Reference to level 4 of the hierarchy | ||
LEVEL3_FK_KEY | NUMBER | Reference to level 3 of the hierarchy | ||
LEVEL2_FK_KEY | NUMBER | Reference to level 2 of the hierarchy | ||
LEVEL1_FK_KEY | NUMBER | Reference to level 1 of the hierarchy | ||
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Standard who column | ||
LAST_UPDATE_DATE | DATE | Standard who column | ||
LEVEL_NUM | NUMBER | Level number in the hierarchy | ||
ITEM_NAME | VARCHAR2 | (240) | Item name | |
LEVEL9_NAME | VARCHAR2 | (240) | Level 9 name | |
LEVEL8_NAME | VARCHAR2 | (240) | Level 8 name | |
LEVEL7_NAME | VARCHAR2 | (240) | Level 7 name | |
LEVEL6_NAME | VARCHAR2 | (240) | Level 6 name | |
LEVEL5_NAME | VARCHAR2 | (240) | Level 5 name | |
LEVEL4_NAME | VARCHAR2 | (240) | Level 4 name | |
LEVEL3_NAME | VARCHAR2 | (240) | Level 3 name | |
LEVEL2_NAME | VARCHAR2 | (240) | Level 2 name | |
LEVEL1_NAME | VARCHAR2 | (240) | Level 1 name |
MTH.MTH_ITEM_DENORM_D does not reference any database object
MTH.MTH_ITEM_DENORM_D is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HIERARCHY_ID | NUMBER | |||
ITEM_FK_KEY | NUMBER | |||
LEVEL9_FK_KEY | NUMBER | |||
LEVEL8_FK_KEY | NUMBER | |||
LEVEL7_FK_KEY | NUMBER | |||
LEVEL6_FK_KEY | NUMBER | |||
LEVEL5_FK_KEY | NUMBER | |||
LEVEL4_FK_KEY | NUMBER | |||
LEVEL3_FK_KEY | NUMBER | |||
LEVEL2_FK_KEY | NUMBER | |||
LEVEL1_FK_KEY | NUMBER | |||
LEVEL_NUM | NUMBER | |||
ITEM_NAME | VARCHAR2 | (240) | ||
LEVEL9_NAME | VARCHAR2 | (240) | ||
LEVEL8_NAME | VARCHAR2 | (240) | ||
LEVEL7_NAME | VARCHAR2 | (240) | ||
LEVEL6_NAME | VARCHAR2 | (240) | ||
LEVEL5_NAME | VARCHAR2 | (240) | ||
LEVEL4_NAME | VARCHAR2 | (240) | ||
LEVEL3_NAME | VARCHAR2 | (240) | ||
LEVEL2_NAME | VARCHAR2 | (240) | ||
LEVEL1_NAME | VARCHAR2 | (240) |
MTH.MTH_ITEM_DENORM_D_TMP does not reference any database object
MTH.MTH_ITEM_DENORM_D_TMP is referenced by following:
Description: |
---|
This table stores the latest parent - child relationship for item hierarchy.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_ITEM_HIERARCHY_U1 | UNIQUE | APPS_TS_TX_IDX |
LEVEL_FK_KEY
HIERARCHY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HIERARCHY_ID | NUMBER | Y | Hierarchy identifier | |
LEVEL_NUM | NUMBER | Level number in the hierarchy | ||
LEVEL_FK_KEY | NUMBER | Y | Reference to level identifier | |
PARENT_FK_KEY | NUMBER | Y | Reference to parent | |
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LEVEL_NAME | VARCHAR2 | (240) | Level name | |
PARENT_NAME | VARCHAR2 | (240) | Parent level name |
MTH.MTH_ITEM_HIERARCHY does not reference any database object
MTH.MTH_ITEM_HIERARCHY is referenced by following:
Description: |
---|
Error table for MTH_ITEM_HIERARCHY
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEVEL_FK | VARCHAR2 | (120) | Y | Reference to source level identifier |
PARENT_FK | VARCHAR2 | (120) | Y | Reference to source parent |
HIERARCHY_NAME | VARCHAR2 | (120) | Y | Hierarchy name, unique within a dimension |
LEVEL_NUM | NUMBER | Level number in the hierarchy | ||
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate reprocessing of errored rows | |
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_ITEM_HIERARCHY_ERR does not reference any database object
MTH.MTH_ITEM_HIERARCHY_ERR is referenced by following:
Description: |
---|
Interface table for MTH_ITEM_HIERARCHY
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Y | Internal column for EBS integration only | |
CATEGORY_ID | NUMBER | Y | Internal column for EBS integration only | |
HIERARCHY_NAME | VARCHAR2 | (120) | Y | Internal column for EBS integration only |
DB_GLOBAL_NAME | VARCHAR2 | (120) | Y | Internal column for EBS integration only |
EBS_ORG_ID | NUMBER | Y | Internal column for EBS integration only | |
SOURCE_ORG_CODE | VARCHAR2 | (120) | Y | Internal column for EBS integration only |
HUB_ORG_CODE | VARCHAR2 | (120) | Y | Internal column for EBS integration only |
MTH.MTH_ITEM_HIERARCHY_I_STG does not reference any database object
MTH.MTH_ITEM_HIERARCHY_I_STG is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEVEL_FK | VARCHAR2 | (120) | Y | |
PARENT_FK | VARCHAR2 | (120) | ||
HIERARCHY_NAME | VARCHAR2 | (120) | ||
LEVEL_NUM | NUMBER | |||
SYSTEM_FK | VARCHAR2 | (120) | ||
PROCESSING_FLAG | NUMBER |
MTH.MTH_ITEM_HIERARCHY_STG does not reference any database object
MTH.MTH_ITEM_HIERARCHY_STG is referenced by following:
Description: |
---|
This table stores information related to Manufacturing Operations Center instance and its attributes .
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MTH_INSTANCE_CODE | VARCHAR2 | (32) | Y | Manufacturing Operations Center instance code, which should uniquely identify the instance |
MTH_INSTANCE_NAME | VARCHAR2 | (240) | Y | Manufacturing Operations Center instance name |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column |
MTH.MTH_MASTER_SETUP does not reference any database object
MTH.MTH_MASTER_SETUP is referenced by following:
Description: |
---|
Error table for MTH_MTL_CONSUMED_TXN_LOT_F
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WO_MAT_TXN_FK | VARCHAR2 | (120) | Y | Transaction Identifier for the material consumption |
PRODUCT_LOT | VARCHAR2 | (120) | Product lot number | |
PRODUCT_SUBLOT | VARCHAR2 | (120) | Product sub lot number | |
PRODUCT_SERIAL_NO | VARCHAR2 | (120) | Product serial number | |
TRANSACTION_QTY | NUMBER | The quantity of material consumed in transaction unit of measure | ||
TRANSACTION_QTY_G | NUMBER | The quantity of material consumed in primary unit of measure | ||
TRANSACTION_QTY_SG | NUMBER | The quantity of material consumed in secondary unit of measure | ||
TRANSACTION_UOM | VARCHAR2 | (5) | Transaction unit of measure | |
PRIMARY_UOM | VARCHAR2 | (5) | Primary unit of measure | |
SECONDARY_UOM | VARCHAR2 | (5) | Secondary unit of measure | |
MATERIAL_LOT | VARCHAR2 | (120) | Material lot number | |
MATERIAL_SUBLOT | VARCHAR2 | (120) | Material sub lot number | |
MATERIAL_SERIAL_NO | VARCHAR2 | (120) | Material serial number | |
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate re-processing of errored rows | |
USER_DIM1_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM2_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM3_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM4_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM5_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
GRADE | VARCHAR2 | (30) | Grade code | |
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_MTL_CONSUMED_TXN_LOT_ERR does not reference any database object
MTH.MTH_MTL_CONSUMED_TXN_LOT_ERR is referenced by following:
Description: |
---|
This table stores the lot, sub-lot and serial number level information for both the product and components used
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WO_MAT_TXN_FK_KEY | NUMBER | Y | Reference to the material consumption transaction | |
PRODUCT_LOT | VARCHAR2 | (120) | Product lot number | |
PRODUCT_SUBLOT | VARCHAR2 | (120) | Product sub lot number | |
PRODUCT_SERIAL_NO | VARCHAR2 | (120) | Product serial number | |
TRANSACTION_QTY | NUMBER | The quantity of Material Consumed in transaction unit of measure | ||
TRANSACTION_QTY_G | NUMBER | The quantity of Material Consumed in Primary unit of measure | ||
TRANSACTION_QTY_SG | NUMBER | The quantity of Material Consumed in Secondary unit of measure | ||
TRANSACTION_UOM | VARCHAR2 | (5) | Transaction unit of measure | |
PRIMARY_UOM | VARCHAR2 | (5) | Primary unit of measure | |
SECONDARY_UOM | VARCHAR2 | (5) | Secondary unit of measure | |
MATERIAL_LOT | VARCHAR2 | (120) | Material lot number | |
MATERIAL_SUBLOT | VARCHAR2 | (120) | Material sub-lot number | |
MATERIAL_SERIAL_NO | VARCHAR2 | (120) | Material serial number | |
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
USER_DIM1_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM2_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM3_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM4_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM5_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
GRADE | VARCHAR2 | (30) | Grade code |
MTH.MTH_MTL_CONSUMED_TXN_LOT_F does not reference any database object
MTH.MTH_MTL_CONSUMED_TXN_LOT_F is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WO_MAT_TXN_FK | VARCHAR2 | (120) | Y | |
PRODUCT_LOT | VARCHAR2 | (120) | ||
PRODUCT_SUBLOT | VARCHAR2 | (120) | ||
PRODUCT_SERIAL_NO | VARCHAR2 | (120) | ||
TRANSACTION_QTY | NUMBER | |||
TRANSACTION_QTY_G | NUMBER | |||
TRANSACTION_QTY_SG | NUMBER | |||
TRANSACTION_UOM | VARCHAR2 | (5) | ||
PRIMARY_UOM | VARCHAR2 | (5) | ||
SECONDARY_UOM | VARCHAR2 | (5) | ||
MATERIAL_LOT | VARCHAR2 | (120) | ||
MATERIAL_SUBLOT | VARCHAR2 | (120) | ||
MATERIAL_SERIAL_NO | VARCHAR2 | (120) | ||
SYSTEM_FK | VARCHAR2 | (120) | ||
USER_DIM1_FK | VARCHAR2 | (120) | ||
USER_DIM2_FK | VARCHAR2 | (120) | ||
USER_DIM3_FK | VARCHAR2 | (120) | ||
USER_DIM4_FK | VARCHAR2 | (120) | ||
USER_DIM5_FK | VARCHAR2 | (120) | ||
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
GRADE | VARCHAR2 | (30) | ||
PROCESSING_FLAG | NUMBER |
MTH.MTH_MTL_CONSUMED_TXN_LOT_STG does not reference any database object
MTH.MTH_MTL_CONSUMED_TXN_LOT_STG is referenced by following:
Description: |
---|
Error table for MTH_MTL_PRODUCED_TXN_LOT_F
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate re-processing of errored rows | |
WO_COMP_FK | VARCHAR2 | (120) | Y | Workorder component identifier |
TRANSACTION_QTY | NUMBER | The quantity of material produced in transaction unit of measure | ||
TRANSACTION_QTY_G | NUMBER | The quantity of material produced in primary unit of measure | ||
TRANSACTION_QTY_SG | NUMBER | The quantity of material produced in secondary unit of measure | ||
PRODUCT_LOT | VARCHAR2 | (120) | Product lot number | |
PRODUCT_SUBLOT | VARCHAR2 | (120) | Product sub lot number | |
PRODUCT_SERIAL_NO | VARCHAR2 | (120) | Product serial number | |
TRANSACTION_UOM | VARCHAR2 | (5) | Transaction unit of measure | |
PRIMARY_UOM | VARCHAR2 | (5) | Primary unit of measure | |
SECONDARY_UOM | VARCHAR2 | (5) | Secondary unit of measure | |
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
USER_DIM1_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM2_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM3_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM4_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM5_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
GRADE | VARCHAR2 | (30) | Grade code | |
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_MTL_PRODUCED_TXN_LOT_ERR does not reference any database object
MTH.MTH_MTL_PRODUCED_TXN_LOT_ERR is referenced by following:
Description: |
---|
This table stores the lot, sub-lot and serial number level information for the products manufactured
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WO_COMP_FK_KEY | NUMBER | Y | Reference to workorder component | |
TRANSACTION_QTY | NUMBER | The quantity of material produced in transaction unit of measure | ||
TRANSACTION_QTY_G | NUMBER | The quantity of material produced in Primary unit of measure | ||
TRANSACTION_QTY_SG | NUMBER | The quantity of material produced in Secondary unit of measure | ||
PRODUCT_LOT | VARCHAR2 | (120) | Product lot number | |
PRODUCT_SUBLOT | VARCHAR2 | (120) | Product sub-lot number | |
PRODUCT_SERIAL_NO | VARCHAR2 | (120) | Product serial number | |
TRANSACTION_UOM | VARCHAR2 | (5) | Transaction unit of measure | |
PRIMARY_UOM | VARCHAR2 | (5) | Primary unit of measure | |
SECONDARY_UOM | VARCHAR2 | (5) | Secondary unit of measure | |
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
USER_DIM1_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM2_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM3_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM4_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM5_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
GRADE | VARCHAR2 | (30) | Grade code |
MTH.MTH_MTL_PRODUCED_TXN_LOT_F does not reference any database object
MTH.MTH_MTL_PRODUCED_TXN_LOT_F is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WO_COMP_FK | VARCHAR2 | (120) | Y | |
TRANSACTION_QTY | NUMBER | |||
TRANSACTION_QTY_G | NUMBER | |||
TRANSACTION_QTY_SG | NUMBER | |||
PRODUCT_LOT | VARCHAR2 | (120) | ||
PRODUCT_SUBLOT | VARCHAR2 | (120) | ||
PRODUCT_SERIAL_NO | VARCHAR2 | (120) | ||
TRANSACTION_UOM | VARCHAR2 | (5) | ||
PRIMARY_UOM | VARCHAR2 | (5) | ||
SECONDARY_UOM | VARCHAR2 | (5) | ||
SYSTEM_FK | VARCHAR2 | (120) | ||
USER_DIM1_FK | VARCHAR2 | (120) | ||
USER_DIM2_FK | VARCHAR2 | (120) | ||
USER_DIM3_FK | VARCHAR2 | (120) | ||
USER_DIM4_FK | VARCHAR2 | (120) | ||
USER_DIM5_FK | VARCHAR2 | (120) | ||
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
GRADE | VARCHAR2 | (30) | ||
PROCESSING_FLAG | NUMBER |
MTH.MTH_MTL_PRODUCED_TXN_LOT_STG does not reference any database object
MTH.MTH_MTL_PRODUCED_TXN_LOT_STG is referenced by following:
Description: |
---|
This table stores information for the organization dimension. It provides information like Organization name, Organization code, Currency code, Primary cost method and whether the organization is Process enabled.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_ORGANIZATIONS_L_U1 | UNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_CODE
SYSTEM_FK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_NAME | VARCHAR2 | (240) | Y | Organization name |
PROCESS_ENABLED_FLAG | VARCHAR2 | (1) | Y | Flag for process manufacturing enabled organization |
CURRENCY_CODE | VARCHAR2 | (15) | Y | Currency code |
EBS_ORGANIZATION_ID | NUMBER | Oracle E-business suite organization identifier | ||
PRIMARY_COST_METHOD | NUMBER | Primary costing method used for the organization | ||
ORGANIZATION_CODE | VARCHAR2 | (120) | Y | Organization code |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
IMPLEMENT_IN_PLANT_FLAG | VARCHAR2 | (1) | Plant implemented Yes/ No | |
PLANT_FK_KEY | NUMBER | Reference to plant | ||
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column |
MTH.MTH_ORGANIZATIONS_L does not reference any database object
MTH.MTH_ORGANIZATIONS_L is referenced by following:
Description: |
---|
This table stores classifications for "Others" entity
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_OTHERS_D_U1 | UNIQUE | APPS_TS_TX_IDX | OTHER_CLASSIFICATION |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OTHER_PK_KEY | NUMBER | Y | System generated surrogate key for "Others" entity | |
OTHER_CLASSIFICATION | VARCHAR2 | (150) | Y | Classification name for "Others" entity |
OTHER_DESCRIPTION | VARCHAR2 | (2000) | Calssification description for "Others" entity | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column |
MTH.MTH_OTHERS_D does not reference any database object
MTH.MTH_OTHERS_D is referenced by following:
Description: |
---|
This table stores the extensible attributes for OTHERS entity
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_OTHERS_EXT_B_U1 | UNIQUE | APPS_TS_TX_IDX | EXTENSION_ID |
MTH_OTHERS_EXT_B_N1 | NONUNIQUE | APPS_TS_TX_IDX | OTHER_PK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTENSION_ID | NUMBER | Y | System generated surrogate key for the table. This is generated using EGO sequence. | |
ATTR_GROUP_ID | NUMBER | Attribute group identifier | ||
OTHER_PK_KEY | NUMBER | Reference to "Others" identifier | ||
C_EXT_ATTR1 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR2 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR3 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR4 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR5 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR6 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR7 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR8 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR9 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR10 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR11 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR12 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR13 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR14 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR15 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR16 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR17 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR18 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR19 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR20 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR21 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR22 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR23 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR24 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR25 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR26 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR27 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR28 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR29 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR30 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
N_EXT_ATTR1 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR2 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR3 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR4 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR5 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR6 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR7 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR8 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR9 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR10 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR11 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR12 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR13 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR14 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR15 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR16 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR17 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR18 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR19 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR20 | NUMBER | Column to store extensible attribute number data | ||
D_EXT_ATTR1 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR2 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR3 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR4 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR5 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR6 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR7 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR8 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR9 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR10 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR11 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR12 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR13 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR14 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR15 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR16 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR17 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR18 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR19 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR20 | DATE | Column to store extensible attribute date | ||
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column |
MTH.MTH_OTHERS_EXT_B does not reference any database object
MTH.MTH_OTHERS_EXT_B is referenced by following:
Description: |
---|
This table stores the translatable extensible attributes for OTHERS entity
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_OTHERS_EXT_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
LANGUAGE
EXTENSION_ID |
MTH_OTHERS_EXT_TL_N1 | NONUNIQUE | APPS_TS_TX_IDX |
OTHER_PK_KEY
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTENSION_ID | NUMBER | Y | System generated surrogate key for the table. This is generated using EGO sequence. | |
ATTR_GROUP_ID | NUMBER | Attribute group identifier | ||
OTHER_PK_KEY | NUMBER | Reference to "Others" identifier | ||
TL_EXT_ATTR1 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR2 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR3 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR4 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR5 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR6 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR7 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR8 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR9 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR10 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR11 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR12 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR13 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR14 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR15 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR16 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR17 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR18 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR19 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR20 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR21 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR22 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR23 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR24 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR25 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR26 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR27 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR28 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR29 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR30 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
SOURCE_LANG | VARCHAR2 | (30) | Source language of the data stored in the columns | |
LANGUAGE | VARCHAR2 | (30) | Language of the data stored in the columns | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column |
MTH.MTH_OTHERS_EXT_TL does not reference any database object
MTH.MTH_OTHERS_EXT_TL is referenced by following:
Description: |
---|
This table stores information on period level definition for time dimension hierarchies.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_PERIOD_D_U1 | UNIQUE | APPS_TS_TX_IDX |
HIERARCHY_ID
NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HIERARCHY_ID | NUMBER | Y | Hierarchy identifier | |
PERIOD_ID | NUMBER | Y | Period identifier | |
NAME | VARCHAR2 | (100) | Y | Period name |
START_DATE | DATE | Start date | ||
END_DATE | DATE | End date | ||
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column |
MTH.MTH_PERIOD_D does not reference any database object
MTH.MTH_PERIOD_D is referenced by following:
Description: |
---|
Error table for MTH_PERIOD_D
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate reprocessing of errored rows | |
HIERARCHY_NAME | VARCHAR2 | (100) | Y | Hierarchy name, unique within a dimension |
NAME | VARCHAR2 | (100) | Y | Period name |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
END_DATE | DATE | End date | ||
START_DATE | DATE | Start date | ||
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_PERIOD_ERR does not reference any database object
MTH.MTH_PERIOD_ERR is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HIERARCHY_NAME | VARCHAR2 | (100) | Y | |
NAME | VARCHAR2 | (100) | Y | |
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
SYSTEM_FK | VARCHAR2 | (120) | ||
END_DATE | DATE | |||
START_DATE | DATE | |||
PROCESSING_FLAG | NUMBER |
MTH.MTH_PERIOD_STG does not reference any database object
MTH.MTH_PERIOD_STG is referenced by following:
Description: |
---|
This table stores information about personnel. It holds information like First name, Last name, Resource and Organization.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_PERSONNEL_D_U1 | UNIQUE | APPS_TS_TX_IDX | PERSONNEL_PK |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSONNEL_PK_KEY | NUMBER | Y | System generated surrogate key for personnel | |
PERSONNEL_PK | VARCHAR2 | (120) | Y | Personnel identifier |
EBS_PERSONNEL_ID | NUMBER | Oracle E-business suite personnel identifier | ||
EBS_ORGANIZATION_ID | NUMBER | Oracle E-business suite organization identifier | ||
FIRST_NAME | VARCHAR2 | (100) | Y | First name |
LAST_NAME | VARCHAR2 | (100) | Y | Last name |
PLANT_FK_KEY | NUMBER | Y | Reference to plant | |
SOURCE_ORG_CODE | VARCHAR2 | (120) | Organization code in source system. | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
RESOURCE_FK_KEY | NUMBER | Reference to resource | ||
PERSONNEL_DESCRIPTION | VARCHAR2 | (240) | Personnel description | |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column |
MTH.MTH_PERSONNEL_D does not reference any database object
MTH.MTH_PERSONNEL_D is referenced by following:
Description: |
---|
Error table for MTH_PERSONNEL_D
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSONNEL_PK | VARCHAR2 | (120) | Y | Personnel identifier |
EBS_PERSONNEL_ID | NUMBER | Oracle E-business suite personnel identifier | ||
EBS_ORGANIZATION_ID | NUMBER | Oracle E-business suite organization identifier | ||
FIRST_NAME | VARCHAR2 | (100) | Y | First name |
LAST_NAME | VARCHAR2 | (100) | Y | Last name |
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
RESOURCE_FK | VARCHAR2 | (120) | Reference to source resource | |
PERSONNEL_DESCRIPTION | VARCHAR2 | (240) | Personnel description | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate reprocessing of errored rows | |
SOURCE_ORG_CODE | VARCHAR2 | (120) | Organization code in source system | |
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_PERSONNEL_ERR does not reference any database object
MTH.MTH_PERSONNEL_ERR is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSONNEL_PK | VARCHAR2 | (120) | Y | |
EBS_PERSONNEL_ID | NUMBER | |||
EBS_ORGANIZATION_ID | NUMBER | |||
FIRST_NAME | VARCHAR2 | (100) | Y | |
LAST_NAME | VARCHAR2 | (100) | Y | |
SYSTEM_FK | VARCHAR2 | (120) | ||
RESOURCE_FK | VARCHAR2 | (120) | ||
PERSONNEL_DESCRIPTION | VARCHAR2 | (240) | ||
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
SOURCE_ORG_CODE | VARCHAR2 | (120) | ||
PROCESSING_FLAG | NUMBER |
MTH.MTH_PERSONNEL_STG does not reference any database object
MTH.MTH_PERSONNEL_STG is referenced by following:
Description: |
---|
This table stores information for the plant dimension. It provides information like Plant name, Currency code, Plant start date, Plant end date and Graveyard shift definition for the plant.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_PLANTS_D_U1 | UNIQUE | APPS_TS_TX_IDX | PLANT_PK |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLANT_PK_KEY | NUMBER | Y | System generated surrogate key for plant identifier | |
PLANT_PK | VARCHAR2 | (120) | Y | Plant identifier |
CURRENCY_CODE | VARCHAR2 | (3) | Y | Currency code |
SOURCE | NUMBER | Y | Source system type | |
PLANT_NAME | VARCHAR2 | (100) | Y | Plant name |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
TO_DATE | DATE | Plant end date | ||
GRAVEYARD_SHIFT_FLAG | NUMBER | Y | Flag indicating a graveyard shift should go to previous or following day | |
FROM_DATE | DATE | Y | Plant start date without time component | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column |
MTH.MTH_PLANTS_D does not reference any database object
MTH.MTH_PLANTS_D is referenced by following:
Description: |
---|
Error table for MTH_PRODUCTION_SCHEDULES_F
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKORDER_PK | VARCHAR2 | (240) | Y | Work Order identifier |
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
WORKORDER_TYPE | NUMBER | Y | Work Order type | |
STATUS | VARCHAR2 | (80) | Y | Work Order status code |
PLANNED_START_DATE | DATE | Work Order planned start date | ||
PLANNED_COMPLETION_DATE | DATE | Work Order planned completion date | ||
ACTUAL_START_DATE | DATE | Work Order actual start date | ||
ACTUAL_COMPLETION_DATE | DATE | Work Order actual completion date | ||
DATE_RELEASED | DATE | Date on which Work Order is released | ||
ERP_ACTUAL_START_DATE | DATE | Work Order actual start date from ERP | ||
ERP_ACTUAL_COMPLETION_DATE | DATE | Work Order actual completion date from ERP | ||
EBS_ENTITY_ID | NUMBER | Work Order identifier in the Oracle E-business suite | ||
EBS_ORGANIZATION_ID | NUMBER | Organization identifier in Oracle E-business suite | ||
BOM_REVISION | VARCHAR2 | (3) | Bill of Material revision for the primary assembly | |
ROUTING_REVISION | VARCHAR2 | (3) | Routing revision for the primary assembly | |
BOM_REVISION_DATE | DATE | Bill of Material revision date | ||
ROUTING_REVISION_DATE | DATE | Routing revision date | ||
ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | (10) | Alternate bill of material used in a Work Order | |
ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | (10) | Alternate routing used in a Work Order | |
COMPLETION_SUBINVENTORY | VARCHAR2 | (10) | Default completion subinventory for assemblies completed by the Work Order | |
COMPLETION_LOCATOR_ID | NUMBER | Default completion locator identifier for assemblies completed by the Work Order | ||
DEMAND_CLASS | VARCHAR2 | (30) | Type of demand the Work Order satisfies | |
SCHEDULE_GROUP_ID | NUMBER | Schedule group identifier for the Work Order | ||
BUILD_SEQUENCE | NUMBER | Build sequence | ||
WORKORDER_NAME | VARCHAR2 | (240) | Work Order name or flow schedule number | |
DEMAND_SOURCE_HEADER_ID | NUMBER | Demand source header identifier | ||
DEMAND_SOURCE_LINE | VARCHAR2 | (30) | Demand source line identifier | |
DEMAND_SOURCE_DELIVERY | VARCHAR2 | (30) | Delivery identifier for demand source | |
DEMAND_SOURCE_TYPE | NUMBER | Demand source type | ||
KANBAN_CARD_ID | NUMBER | Identifier for production kanban replenished by the job | ||
LINE_CODE | VARCHAR2 | (10) | Production line Identifier | |
PARENT_WORKORDER_ID | VARCHAR2 | (30) | Parent Work Order identifier in the source system | |
PARENT_OPERATION_SEQ_NUM | NUMBER | Parent Operation Sequence Number | ||
SOURCE_ORG_CODE | VARCHAR2 | (120) | Organization code in source system | |
USER_DIM1_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM2_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM3_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM4_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM5_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR6 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR7 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR8 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR9 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR10 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR11 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR12 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR13 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR14 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR15 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR16 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR17 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR18 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR19 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR20 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate reprocessing of errored rows | |
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
RECIPE_NUM | VARCHAR2 | (30) | Recipe Number | |
RECIPE_VERSION | VARCHAR2 | (15) | Recipe Version | |
FORMULA_NUM | VARCHAR2 | (30) | Formula Number | |
FORMULA_VERSION | VARCHAR2 | (15) | Formula Version | |
REQ_COMPLETION_DATE | DATE | Required Completion Date | ||
BATCH_TYPE | VARCHAR2 | (240) | Batch Type | |
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_PRODUCTION_SCHEDULES_ERR does not reference any database object
MTH.MTH_PRODUCTION_SCHEDULES_ERR is referenced by following:
Description: |
---|
This table stores the extensible attributes for Work Orders
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_PROD_SCH_EXT_B_U1 | UNIQUE | APPS_TS_TX_IDX | EXTENSION_ID |
MTH_PROD_SCH_EXT_B_N1 | NONUNIQUE | APPS_TS_TX_IDX | WORKORDER_PK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTENSION_ID | NUMBER | Y | System generated surrogate key for the table. This is generated using EGO sequence. | |
ATTR_GROUP_ID | NUMBER | Attribute group identifier | ||
WORKORDER_PK_KEY | NUMBER | Reference to Work Order identifier | ||
C_EXT_ATTR1 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR2 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR3 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR4 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR5 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR6 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR7 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR8 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR9 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR10 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR11 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR12 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR13 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR14 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR15 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR16 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR17 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR18 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR19 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR20 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR21 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR22 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR23 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR24 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR25 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR26 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR27 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR28 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR29 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
C_EXT_ATTR30 | VARCHAR2 | (150) | Column to store extensible attribute character data | |
N_EXT_ATTR1 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR2 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR3 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR4 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR5 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR6 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR7 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR8 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR9 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR10 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR11 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR12 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR13 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR14 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR15 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR16 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR17 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR18 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR19 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR20 | NUMBER | Column to store extensible attribute number data | ||
D_EXT_ATTR1 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR2 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR3 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR4 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR5 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR6 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR7 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR8 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR9 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR10 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR11 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR12 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR13 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR14 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR15 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR16 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR17 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR18 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR19 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR20 | DATE | Column to store extensible attribute date | ||
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column |
MTH.MTH_PRODUCTION_SCHEDULES_EXT_B does not reference any database object
MTH.MTH_PRODUCTION_SCHEDULES_EXT_B is referenced by following:
Description: |
---|
This table stores the work order information for all types of work orders. It holds information on work order type, status, the scheduled and the actual start and end dates, the BOM and Routing information used on the work order, the demand source information and other data pertaining to the work orders.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_PRODUCTION_SCHEDULES_F_U1 | UNIQUE | APPS_TS_TX_IDX | WORKORDER_PK |
MTH_PRODUCTION_SCHEDULES_F_U2 | UNIQUE | APPS_TS_TX_IDX | WORKORDER_PK_KEY |
MTH_PRODUCTION_SCHEDULES_F_B1 | NONUNIQUE | APPS_TS_TX_IDX | STATUS_CODE |
MTH_PRODUCTION_SCHEDULES_F_N1 | NONUNIQUE | APPS_TS_TX_IDX | WORKORDER_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKORDER_PK_KEY | NUMBER | Y | System generated surrogate key for Work Order identifier | |
WORKORDER_PK | VARCHAR2 | (240) | Y | Work Order identifier |
WORKORDER_NAME | VARCHAR2 | (240) | Work Order name or flow schedule number | |
PLANT_FK_KEY | NUMBER | Y | Reference to plant | |
WORKORDER_TYPE | NUMBER | Y | Work Order type | |
STATUS_CODE | NUMBER | Y | Work Order status code | |
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
SOURCE_ORG_CODE | VARCHAR2 | (120) | Organization code in source system | |
PLANNED_START_DATE | DATE | Work Order planned start date | ||
PLANNED_COMPLETION_DATE | DATE | Work Order planned completion date | ||
ACTUAL_START_DATE | DATE | Work Order actual start date | ||
ACTUAL_COMPLETION_DATE | DATE | Work Order actual completion date | ||
DATE_RELEASED | DATE | Date on which Work Order is released | ||
ERP_ACTUAL_START_DATE | DATE | Work Order actual start date from ERP | ||
ERP_ACTUAL_COMPLETION_DATE | DATE | Work Order actual completion date from ERP | ||
EBS_ENTITY_ID | NUMBER | Work Order identifier in the Oracle E-business suite | ||
EBS_ORGANIZATION_ID | NUMBER | Organization identifier in Oracle E-business suite | ||
LINE_CODE | VARCHAR2 | (10) | Production line Identifier | |
BOM_REVISION | VARCHAR2 | (3) | Bill of Material revision for the primary assembly | |
ROUTING_REVISION | VARCHAR2 | (3) | Routing revision for the primary assembly | |
BOM_REVISION_DATE | DATE | Bill of Material revision date | ||
ROUTING_REVISION_DATE | DATE | Routing revision date | ||
ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | (10) | Alternate bill of material used in a Work Order | |
ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | (10) | Alternate routing used in a Work Order | |
COMPLETION_SUBINVENTORY | VARCHAR2 | (10) | Default completion subinventory for assemblies completed by the Work Order | |
COMPLETION_LOCATOR_ID | NUMBER | Default completion locator identifier for assemblies completed by the Work Order | ||
DEMAND_CLASS | VARCHAR2 | (30) | Type of demand the Work Order satisfies | |
SCHEDULE_GROUP_ID | NUMBER | Schedule group identifier for the Work Order | ||
BUILD_SEQUENCE | NUMBER | Build sequence | ||
DEMAND_SOURCE_HEADER_ID | NUMBER | Demand source header identifier | ||
DEMAND_SOURCE_LINE | VARCHAR2 | (30) | Demand source line identifier | |
DEMAND_SOURCE_DELIVERY | VARCHAR2 | (30) | Delivery identifier for demand source | |
DEMAND_SOURCE_TYPE | NUMBER | Demand source type | ||
KANBAN_CARD_ID | NUMBER | Identifier for production kanban replenished by the job | ||
PARENT_OPERATION_SEQ_NUM | NUMBER | Parent Operation Sequence Number | ||
USER_DIM1_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM2_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM3_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM4_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM5_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR6 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR7 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR8 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR9 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR10 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR11 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR12 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR13 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR14 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR15 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR16 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR17 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR18 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR19 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR20 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
PARENT_WORKORDER_ID | VARCHAR2 | (30) | Parent Work Order identifier in the source system | |
RECIPE_NUM | VARCHAR2 | (30) | Recipe Number | |
RECIPE_VERSION | VARCHAR2 | (15) | Recipe Version | |
FORMULA_NUM | VARCHAR2 | (30) | Formula Number | |
FORMULA_VERSION | VARCHAR2 | (15) | Formula Version | |
REQ_COMPLETION_DATE | DATE | Required Completion Date | ||
BATCH_TYPE | VARCHAR2 | (240) | Batch Type |
MTH.MTH_PRODUCTION_SCHEDULES_F does not reference any database object
MTH.MTH_PRODUCTION_SCHEDULES_F is referenced by following:
Description: |
---|
Interface table for MTH_PRODUCTION_SCHEDULES_F
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WIP_ENTITY_ID | NUMBER | Y | Internal column for EBS integration only | |
WIP_ENTITY_NAME | VARCHAR2 | (240) | Y | Internal column for EBS integration only |
ORGANIZATION_CODE | VARCHAR2 | (120) | Y | Internal column for EBS integration only |
ORGANIZATION_ID | NUMBER | Y | Internal column for EBS integration only | |
DB_GLOBAL_NAME | VARCHAR2 | (120) | Y | Internal column for EBS integration only |
WORKORDER_TYPE | NUMBER | Y | Internal column for EBS integration only | |
STATUS | VARCHAR2 | (80) | Y | Internal column for EBS integration only |
PLANNED_START_DATE | DATE | Y | Internal column for EBS integration only | |
PLANNED_COMPLETION_DATE | DATE | Internal column for EBS integration only | ||
ACTUAL_START_DATE | DATE | Internal column for EBS integration only | ||
ACTUAL_COMPLETION_DATE | DATE | Internal column for EBS integration only | ||
DATE_RELEASED | DATE | Internal column for EBS integration only | ||
BOM_REVISION | VARCHAR2 | (3) | Internal column for EBS integration only | |
ROUTING_REVISION | VARCHAR2 | (3) | Internal column for EBS integration only | |
BOM_REVISION_DATE | DATE | Internal column for EBS integration only | ||
ROUTING_REVISION_DATE | DATE | Internal column for EBS integration only | ||
ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | (10) | Internal column for EBS integration only | |
ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | (10) | Internal column for EBS integration only | |
COMPLETION_SUBINVENTORY | VARCHAR2 | (10) | Internal column for EBS integration only | |
COMPLETION_LOCATOR_ID | NUMBER | Internal column for EBS integration only | ||
DEMAND_CLASS | VARCHAR2 | (30) | Internal column for EBS integration only | |
SCHEDULE_GROUP_ID | NUMBER | Internal column for EBS integration only | ||
BUILD_SEQUENCE | NUMBER | Internal column for EBS integration only | ||
DEMAND_SOURCE_HEADER_ID | NUMBER | Internal column for EBS integration only | ||
DEMAND_SOURCE_LINE | VARCHAR2 | (30) | Internal column for EBS integration only | |
DEMAND_SOURCE_DELIVERY | VARCHAR2 | (30) | Internal column for EBS integration only | |
DEMAND_SOURCE_TYPE | NUMBER | Internal column for EBS integration only | ||
KANBAN_CARD_ID | NUMBER | Internal column for EBS integration only | ||
LINE_CODE | VARCHAR2 | (10) | Internal column for EBS integration only | |
PARENT_WORKORDER | VARCHAR2 | (30) | Internal column for EBS integration only | |
PARENT_OPERATION_SEQ_NUM | NUMBER | Internal column for EBS integration only | ||
HUB_ORGANIZATION_CODE | VARCHAR2 | (120) | Internal column for EBS integration only | |
USER_ATTR1 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR2 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR3 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR4 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR5 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR6 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR7 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR8 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR9 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR10 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR11 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR12 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR13 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR14 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR15 | VARCHAR2 | (150) | Internal column for EBS integration only | |
RECIPE_NUM | VARCHAR2 | (30) | Internal column for EBS integration only | |
RECIPE_VERSION | VARCHAR2 | (15) | Internal column for EBS integration only | |
FORMULA_NUM | VARCHAR2 | (30) | Internal column for EBS integration only | |
FORMULA_VERSION | VARCHAR2 | (15) | Internal column for EBS integration only | |
BATCH_TYPE | VARCHAR2 | (20) | Internal column for EBS integration only | |
REQ_COMPLETION_DATE | DATE | Internal column for EBS integration only |
MTH.MTH_PRODUCTION_SCHEDULES_I_STG does not reference any database object
MTH.MTH_PRODUCTION_SCHEDULES_I_STG is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKORDER_PK | VARCHAR2 | (240) | Y | |
SYSTEM_FK | VARCHAR2 | (120) | ||
WORKORDER_TYPE | NUMBER | Y | ||
STATUS | VARCHAR2 | (80) | Y | |
PLANNED_START_DATE | DATE | |||
PLANNED_COMPLETION_DATE | DATE | |||
ACTUAL_START_DATE | DATE | |||
ACTUAL_COMPLETION_DATE | DATE | |||
DATE_RELEASED | DATE | |||
ERP_ACTUAL_START_DATE | DATE | |||
ERP_ACTUAL_COMPLETION_DATE | DATE | |||
EBS_ENTITY_ID | NUMBER | |||
EBS_ORGANIZATION_ID | NUMBER | |||
BOM_REVISION | VARCHAR2 | (3) | ||
ROUTING_REVISION | VARCHAR2 | (3) | ||
BOM_REVISION_DATE | DATE | |||
ROUTING_REVISION_DATE | DATE | |||
ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | (10) | ||
ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | (10) | ||
COMPLETION_SUBINVENTORY | VARCHAR2 | (10) | ||
COMPLETION_LOCATOR_ID | NUMBER | |||
DEMAND_CLASS | VARCHAR2 | (30) | ||
SCHEDULE_GROUP_ID | NUMBER | |||
BUILD_SEQUENCE | NUMBER | |||
WORKORDER_NAME | VARCHAR2 | (240) | ||
DEMAND_SOURCE_HEADER_ID | NUMBER | |||
DEMAND_SOURCE_LINE | VARCHAR2 | (30) | ||
DEMAND_SOURCE_DELIVERY | VARCHAR2 | (30) | ||
DEMAND_SOURCE_TYPE | NUMBER | |||
KANBAN_CARD_ID | NUMBER | |||
LINE_CODE | VARCHAR2 | (10) | ||
PARENT_WORKORDER_ID | VARCHAR2 | (30) | ||
PARENT_OPERATION_SEQ_NUM | NUMBER | |||
SOURCE_ORG_CODE | VARCHAR2 | (120) | ||
USER_DIM1_FK | VARCHAR2 | (120) | ||
USER_DIM2_FK | VARCHAR2 | (120) | ||
USER_DIM3_FK | VARCHAR2 | (120) | ||
USER_DIM4_FK | VARCHAR2 | (120) | ||
USER_DIM5_FK | VARCHAR2 | (120) | ||
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_ATTR6 | VARCHAR2 | (150) | ||
USER_ATTR7 | VARCHAR2 | (150) | ||
USER_ATTR8 | VARCHAR2 | (150) | ||
USER_ATTR9 | VARCHAR2 | (150) | ||
USER_ATTR10 | VARCHAR2 | (150) | ||
USER_ATTR11 | VARCHAR2 | (150) | ||
USER_ATTR12 | VARCHAR2 | (150) | ||
USER_ATTR13 | VARCHAR2 | (150) | ||
USER_ATTR14 | VARCHAR2 | (150) | ||
USER_ATTR15 | VARCHAR2 | (150) | ||
USER_ATTR16 | VARCHAR2 | (150) | ||
USER_ATTR17 | VARCHAR2 | (150) | ||
USER_ATTR18 | VARCHAR2 | (150) | ||
USER_ATTR19 | VARCHAR2 | (150) | ||
USER_ATTR20 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
RECIPE_NUM | VARCHAR2 | (30) | ||
RECIPE_VERSION | VARCHAR2 | (15) | ||
FORMULA_NUM | VARCHAR2 | (30) | ||
FORMULA_VERSION | VARCHAR2 | (15) | ||
BATCH_TYPE | VARCHAR2 | (240) | ||
REQ_COMPLETION_DATE | DATE | |||
PROCESSING_FLAG | NUMBER |
MTH.MTH_PRODUCTION_SCHEDULES_STG does not reference any database object
MTH.MTH_PRODUCTION_SCHEDULES_STG is referenced by following:
Description: |
---|
This table stores the translatable extensible attributes for Work Orders
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_PROD_SCH_EXT_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
LANGUAGE
EXTENSION_ID |
MTH_PROD_SCH_EXT_TL_N1 | NONUNIQUE | APPS_TS_TX_IDX |
WORKORDER_PK_KEY
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTENSION_ID | NUMBER | Y | System generated surrogate key for the table. This is generated using EGO sequence. | |
ATTR_GROUP_ID | NUMBER | Attribute group identifier | ||
WORKORDER_PK_KEY | NUMBER | Reference to Work Order identifier | ||
TL_EXT_ATTR1 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR2 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR3 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR4 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR5 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR6 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR7 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR8 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR9 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR10 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR11 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR12 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR13 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR14 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR15 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR16 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR17 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR18 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR19 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR20 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR21 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR22 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR23 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR24 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR25 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR26 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR27 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR28 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR29 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR30 | VARCHAR2 | (150) | Column to store extensible attribute transalatable character data | |
SOURCE_LANG | VARCHAR2 | (30) | Source language of the data stored in the columns | |
LANGUAGE | VARCHAR2 | (30) | Language of the data stored in the columns | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column |
MTH.MTH_PRODUCTION_SCHEDULE_EXT_TL does not reference any database object
MTH.MTH_PRODUCTION_SCHEDULE_EXT_TL is referenced by following:
Description: |
---|
Error Table for MTH_PRODUCTION_SEGMENTS_F
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKORDER_FK | VARCHAR2 | (240) | Y | Reference to source work order |
SEGMENT_PK | VARCHAR2 | (120) | Y | Work Order segment identifier |
ITEM_FK | VARCHAR2 | (120) | Reference to source item | |
START_QUANTITY_G | NUMBER | Scheduled quantity for the operation in primary unit of measure | ||
START_QUANTITY_SG | NUMBER | Scheduled quantity for the operation in secondary unit of measure | ||
PRIMARY_UOM | VARCHAR2 | (5) | Primary unit of measure | |
SECONDARY_UOM | VARCHAR2 | (5) | Secondary unit of measure | |
ACTUAL_COMP_QTY_G | NUMBER | Actual completed quantity for the operation in primary unit of measure | ||
ACTUAL_COMP_QTY_SG | NUMBER | Actual completed quantity for the operation in secondary unit of measure | ||
ACTUAL_REJECTED_QTY_G | NUMBER | Actual quantity rejected for the operation in primary unit of measure | ||
ACTUAL_REWORKED_QTY_G | NUMBER | Actual quantity reworked for the operation in primary unit of measure | ||
ACTUAL_SCRAP_QTY_G | NUMBER | Actual quantity scrapped for the operation in primary unit of measure | ||
ACTUAL_REJECTED_QTY_SG | NUMBER | Actual quantity rejected for the operation in secondary unit of measure | ||
ACTUAL_REWORKED_QTY_SG | NUMBER | Actual quantity reworked for the operation in secondary unit of measure | ||
ACTUAL_SCRAP_QTY_SG | NUMBER | Actual quantity scrapped for the operation in secondary unit of measure | ||
ACTUAL_START_DATE | DATE | Actual start date for the operation | ||
ACTUAL_COMPLETION_DATE | DATE | Actual completion date for the operation | ||
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate reprocessing of errored rows | |
USER_DIM1_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM2_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM3_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM4_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM5_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
SEGMENT_STATUS | VARCHAR2 | (30) | Operation status | |
PLANNED_START_DATE | DATE | Planned start date for the operation | ||
PLANNED_COMPLETION_DATE | DATE | Planned completion date for the operation | ||
REQ_COMPLETION_DATE | DATE | Required completion date for the operation | ||
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_PRODUCTION_SEGMENTS_ERR does not reference any database object
MTH.MTH_PRODUCTION_SEGMENTS_ERR is referenced by following:
Description: |
---|
This table stores information on operations for various types of work orders. It holds information on Scheduled quantity, actual completed, scrapped, rejected, reworked and actual start and completion dates.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_PRODUCTION_SEGMENTS_F_U1 | UNIQUE | APPS_TS_TX_IDX | SEGMENT_PK |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKORDER_FK_KEY | NUMBER | Y | Reference to work order | |
SEGMENT_PK_KEY | NUMBER | Y | System generated surrogate key for Work Order segment identifier | |
SEGMENT_PK | VARCHAR2 | (120) | Y | Work Order segment identifier |
ITEM_FK_KEY | NUMBER | Reference to item | ||
START_QUANTITY_G | NUMBER | Scheduled quantity for the operation in primary unit of measure | ||
START_QUANTITY_SG | NUMBER | Scheduled quantity for the operation in secondary unit of measure | ||
PRIMARY_UOM | VARCHAR2 | (5) | Primary unit of measure | |
SECONDARY_UOM | VARCHAR2 | (5) | Secondary unit of measure | |
ACTUAL_COMP_QTY_G | NUMBER | Actual completed quantity for the operation in primary unit of measure | ||
ACTUAL_COMP_QTY_SG | NUMBER | Actual completed quantity for the operation in secondary unit of measure | ||
ACTUAL_REJECTED_QTY_G | NUMBER | Actual quantity rejected for the operation in primary unit of measure | ||
ACTUAL_REWORKED_QTY_G | NUMBER | Actual quantity reworked for the operation in primary unit of measure | ||
ACTUAL_SCRAP_QTY_G | NUMBER | Actual quantity scrapped for the operation in primary unit of measure | ||
ACTUAL_REJECTED_QTY_SG | NUMBER | Actual quantity rejected for the operation in secondary unit of measure | ||
ACTUAL_REWORKED_QTY_SG | NUMBER | Actual quantity reworked for the operation in secondary unit of measure | ||
ACTUAL_SCRAP_QTY_SG | NUMBER | Actual quantity scrapped for the operation in secondary unit of measure | ||
ACTUAL_START_DATE | DATE | Actual start date for the operation | ||
ACTUAL_COMPLETION_DATE | DATE | Actual completion date for the operation | ||
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
USER_DIM1_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM2_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM3_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM4_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM5_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
SEGMENT_STATUS | VARCHAR2 | (30) | Operation status | |
PLANNED_START_DATE | DATE | Planned start date for the operation | ||
PLANNED_COMPLETION_DATE | DATE | Planned completion date for the operation | ||
REQ_COMPLETION_DATE | DATE | Required completion date for the operation |
MTH.MTH_PRODUCTION_SEGMENTS_F does not reference any database object
MTH.MTH_PRODUCTION_SEGMENTS_F is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKORDER_FK | VARCHAR2 | (240) | Y | |
SEGMENT_PK | VARCHAR2 | (120) | Y | |
ITEM_FK | VARCHAR2 | (120) | ||
START_QUANTITY_G | NUMBER | |||
START_QUANTITY_SG | NUMBER | |||
PRIMARY_UOM | VARCHAR2 | (5) | ||
SECONDARY_UOM | VARCHAR2 | (5) | ||
ACTUAL_COMP_QTY_G | NUMBER | |||
ACTUAL_COMP_QTY_SG | NUMBER | |||
ACTUAL_REJECTED_QTY_G | NUMBER | |||
ACTUAL_REWORKED_QTY_G | NUMBER | |||
ACTUAL_SCRAP_QTY_G | NUMBER | |||
ACTUAL_REJECTED_QTY_SG | NUMBER | |||
ACTUAL_REWORKED_QTY_SG | NUMBER | |||
ACTUAL_SCRAP_QTY_SG | NUMBER | |||
ACTUAL_START_DATE | DATE | |||
ACTUAL_COMPLETION_DATE | DATE | |||
SYSTEM_FK | VARCHAR2 | (120) | ||
SEGMENT_STATUS | VARCHAR2 | (30) | ||
PLANNED_START_DATE | DATE | |||
PLANNED_COMPLETION_DATE | DATE | |||
REQ_COMPLETION_DATE | DATE | |||
USER_DIM1_FK | VARCHAR2 | (120) | ||
USER_DIM2_FK | VARCHAR2 | (120) | ||
USER_DIM3_FK | VARCHAR2 | (120) | ||
USER_DIM4_FK | VARCHAR2 | (120) | ||
USER_DIM5_FK | VARCHAR2 | (120) | ||
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
PROCESSING_FLAG | NUMBER |
MTH.MTH_PRODUCTION_SEGMENTS_STG does not reference any database object
MTH.MTH_PRODUCTION_SEGMENTS_STG is referenced by following:
Description: |
---|
Error table for MTH_PROD_MTL_CONSUMED_F
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WO_MAT_REQ_PK | VARCHAR2 | (120) | Y | Material requirement identifier for the operation |
PRODUCT_FK | VARCHAR2 | (120) | Reference to primary source product | |
MATERIAL_FK | VARCHAR2 | (120) | Y | Reference to input source material |
SEGMENT_FK | VARCHAR2 | (120) | Reference to source operation | |
PRIMARY_UOM | VARCHAR2 | (5) | Primary unit of measure | |
SECONDARY_UOM | VARCHAR2 | (5) | Secondary unit of measure | |
REQUIRED_QTY_G | NUMBER | Required quantity for the operation in primary unit of measure | ||
REQUIRED_QTY_SG | NUMBER | Required quantity for the operation in secondary unit of measure | ||
ACTUAL_QTY_G | NUMBER | Actual quantity consumed by the operation in primary unit of measure | ||
ACTUAL_QTY_SG | NUMBER | Actual quantity consumed by the operation in secondary unit of measure | ||
UNIT_STANDARD_QTY_G | NUMBER | Unit standard quantity for the operation in primary unit of measure | ||
UNIT_STANDARD_QTY_SG | NUMBER | Unit standard quantity for the operation in secondary unit of measure | ||
REQUIRED_BY_DATE | DATE | Date by when the material is required by the operation | ||
SOURCE_ORG_CODE | VARCHAR2 | (120) | Organization code in source system | |
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate re-processing of errored rows | |
USER_DIM1_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM2_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM3_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM4_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM5_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
WORKORDER_FK | VARCHAR2 | (240) | Y | Reference to source workorder |
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
MAT_SCRAP_QTY_G | NUMBER | Scrap quantity in primary unit of measure | ||
MAT_SCRAP_QTY_SG | NUMBER | Scrap quantity in secondary unit of measure | ||
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_PROD_MTL_CONSUMED_ERR does not reference any database object
MTH.MTH_PROD_MTL_CONSUMED_ERR is referenced by following:
Description: |
---|
This table stores the information on planned and actual usage quantities for components
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_PROD_MTL_CONSUMED_F_U1 | UNIQUE | APPS_TS_TX_IDX | WO_MAT_REQ_PK |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WO_MAT_REQ_PK_KEY | NUMBER | Y | System generated surrogate key for material requirement identifer | |
WO_MAT_REQ_PK | VARCHAR2 | (120) | Y | Material requirement identifier for the operation |
WORKORDER_FK_KEY | NUMBER | Y | Reference to workorder | |
PRODUCT_FK_KEY | NUMBER | Reference primary product | ||
MATERIAL_FK_KEY | NUMBER | Y | Reference to input material | |
SEGMENT_FK_KEY | NUMBER | Reference to operation | ||
PRIMARY_UOM | VARCHAR2 | (5) | Primary unit of measure | |
SECONDARY_UOM | VARCHAR2 | (5) | Secondary unit of measure | |
REQUIRED_QTY_G | NUMBER | Required Quantity for the operation in primary unit of measure | ||
REQUIRED_QTY_SG | NUMBER | Required Quantity for the operation in secondary unit of measure | ||
ACTUAL_QTY_G | NUMBER | Actual Quantity consumed by the operation in primary unit of measure | ||
ACTUAL_QTY_SG | NUMBER | Actual Quantity consumed by the operation in secondary unit of measure | ||
UNIT_STANDARD_QTY_G | NUMBER | Unit Standard Quantity for the operation in Primary unit of measure | ||
UNIT_STANDARD_QTY_SG | NUMBER | Unit Standard Quantity for the Operation in Secondary unit of measure | ||
REQUIRED_BY_DATE | DATE | Date by when the material is required by the Operation | ||
PLANT_FK_KEY | NUMBER | Y | Reference to plant | |
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
SOURCE_ORG_CODE | VARCHAR2 | (120) | Organization code in source system | |
USER_DIM1_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM2_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM3_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM4_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM5_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
MAT_SCRAP_QTY_G | NUMBER | Scrap quantity in primary unit of measure | ||
MAT_SCRAP_QTY_SG | NUMBER | Scrap quantity in secondary unit of measure | ||
ITEM_COST | NUMBER | Item cost | ||
PLANNED_START_DATE | DATE | Work Order planned start date | ||
PLANNED_COMPLETION_DATE | DATE | Work Order planned completion date | ||
ACTUAL_START_DATE | DATE | Work Order actual start date | ||
ACTUAL_COMPLETION_DATE | DATE | Work Order actual completion date |
MTH.MTH_PROD_MTL_CONSUMED_F does not reference any database object
MTH.MTH_PROD_MTL_CONSUMED_F is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WO_MAT_REQ_PK | VARCHAR2 | (120) | Y | |
PRODUCT_FK | VARCHAR2 | (120) | ||
MATERIAL_FK | VARCHAR2 | (120) | Y | |
SEGMENT_FK | VARCHAR2 | (120) | ||
PRIMARY_UOM | VARCHAR2 | (5) | ||
SECONDARY_UOM | VARCHAR2 | (5) | ||
REQUIRED_QTY_G | NUMBER | |||
REQUIRED_QTY_SG | NUMBER | |||
ACTUAL_QTY_G | NUMBER | |||
ACTUAL_QTY_SG | NUMBER | |||
UNIT_STANDARD_QTY_G | NUMBER | |||
UNIT_STANDARD_QTY_SG | NUMBER | |||
REQUIRED_BY_DATE | DATE | |||
SOURCE_ORG_CODE | VARCHAR2 | (120) | ||
SYSTEM_FK | VARCHAR2 | (120) | ||
USER_DIM1_FK | VARCHAR2 | (120) | ||
USER_DIM2_FK | VARCHAR2 | (120) | ||
USER_DIM3_FK | VARCHAR2 | (120) | ||
USER_DIM4_FK | VARCHAR2 | (120) | ||
USER_DIM5_FK | VARCHAR2 | (120) | ||
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
WORKORDER_FK | VARCHAR2 | (240) | Y | |
MAT_SCRAP_QTY_G | NUMBER | |||
MAT_SCRAP_QTY_SG | NUMBER | |||
PROCESSING_FLAG | NUMBER |
MTH.MTH_PROD_MTL_CONSUMED_STG does not reference any database object
MTH.MTH_PROD_MTL_CONSUMED_STG is referenced by following:
Description: |
---|
Error table for MTH_PROD_MTL_CONSUMED_TXN_F
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WO_MAT_TXN_PK | VARCHAR2 | (120) | Y | Transaction Identifier for the material consumption |
WORKORDER_FK | VARCHAR2 | (240) | Y | Reference to source workorder |
PRODUCT_FK | VARCHAR2 | (120) | Reference to primary source product | |
MATERIAL_FK | VARCHAR2 | (120) | Y | Reference to input source material |
SEGMENT_FK | VARCHAR2 | (120) | Reference to source operation | |
TRANSACTION_QTY | NUMBER | Quantity of material consumed in transaction unit of measure | ||
TRANSACTION_QTY_G | NUMBER | Quantity of material consumed in primary unit of measure | ||
TRANSACTION_QTY_SG | NUMBER | Quantity of material consumed in secondary unit of measure | ||
TRANSACTION_UOM | VARCHAR2 | (5) | Transaction unit of measure | |
PRIMARY_UOM | VARCHAR2 | (5) | Primary unit of measure | |
SECONDARY_UOM | VARCHAR2 | (5) | Secondary unit of measure | |
TRANSACTION_DATE | DATE | Y | Transaction date for the material consumption | |
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
SOURCE_ORG_CODE | VARCHAR2 | (120) | Organization code in source system | |
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate re-processing of errored rows | |
USER_DIM1_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM2_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM3_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM4_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM5_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_PROD_MTL_CONSUMED_TXN_ERR does not reference any database object
MTH.MTH_PROD_MTL_CONSUMED_TXN_ERR is referenced by following:
Description: |
---|
This table stores the information on transactions that consume the component material at the operation level of the work orders
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_PROD_MTL_CONSUMED_TXN_F_U1 | UNIQUE | APPS_TS_TX_IDX | WO_MAT_TXN_PK |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WO_MAT_TXN_PK_KEY | NUMBER | Y | System generated surrogate key for the material consumption transaction identifier | |
WO_MAT_TXN_PK | VARCHAR2 | (120) | Y | Transaction identifier for the material consumption |
WORKORDER_FK_KEY | NUMBER | Y | Reference to workorder | |
PRODUCT_FK_KEY | NUMBER | Reference to primary product | ||
MATERIAL_FK_KEY | NUMBER | Y | Reference to input material | |
SEGMENT_FK_KEY | NUMBER | Reference to operation | ||
TRANSACTION_QTY | NUMBER | Quantity of Material Consumed in Transaction unit of measure | ||
TRANSACTION_QTY_G | NUMBER | Quantity of Material Consumed in Primary unit of measure | ||
TRANSACTION_QTY_SG | NUMBER | The Quantity of Material Consumed in Transaction Quantity in Secondary unit of measure | ||
TRANSACTION_UOM | VARCHAR2 | (5) | Transaction unit of measure | |
PRIMARY_UOM | VARCHAR2 | (5) | Primary unit of measure | |
SECONDARY_UOM | VARCHAR2 | (5) | Secondary unit of measure | |
TRANSACTION_DATE | DATE | Y | Transaction date for the material consumption | |
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
PLANT_FK_KEY | NUMBER | Y | Reference to plant | |
SHIFT_WORKDAY_FK_KEY | NUMBER | Y | Reference to shift workday | |
SOURCE_ORG_CODE | VARCHAR2 | (120) | Organization code in source system | |
USER_DIM1_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM2_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM3_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM4_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM5_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column |
MTH.MTH_PROD_MTL_CONSUMED_TXN_F does not reference any database object
MTH.MTH_PROD_MTL_CONSUMED_TXN_F is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WO_MAT_TXN_PK | VARCHAR2 | (120) | Y | |
WORKORDER_FK | VARCHAR2 | (240) | Y | |
PRODUCT_FK | VARCHAR2 | (120) | ||
MATERIAL_FK | VARCHAR2 | (120) | Y | |
SEGMENT_FK | VARCHAR2 | (120) | ||
TRANSACTION_QTY | NUMBER | |||
TRANSACTION_QTY_G | NUMBER | |||
TRANSACTION_QTY_SG | NUMBER | |||
TRANSACTION_UOM | VARCHAR2 | (5) | ||
PRIMARY_UOM | VARCHAR2 | (5) | ||
SECONDARY_UOM | VARCHAR2 | (5) | ||
TRANSACTION_DATE | DATE | Y | ||
SYSTEM_FK | VARCHAR2 | (120) | ||
SOURCE_ORG_CODE | VARCHAR2 | (120) | ||
USER_DIM1_FK | VARCHAR2 | (120) | ||
USER_DIM2_FK | VARCHAR2 | (120) | ||
USER_DIM3_FK | VARCHAR2 | (120) | ||
USER_DIM4_FK | VARCHAR2 | (120) | ||
USER_DIM5_FK | VARCHAR2 | (120) | ||
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
PROCESSING_FLAG | NUMBER |
MTH.MTH_PROD_MTL_CONSUMED_TXN_STG does not reference any database object
MTH.MTH_PROD_MTL_CONSUMED_TXN_STG is referenced by following:
Description: |
---|
Error table for MTH_PROD_MTL_PRODUCED_F
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKORDER_FK | VARCHAR2 | (240) | Y | Reference to source work order |
ITEM_FK | VARCHAR2 | (120) | Y | Reference to source item |
START_QUANTITY_G | NUMBER | Work Order start quantity in primary unit of measure | ||
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
START_QUANTITY_SG | NUMBER | Work Order start quantity in secondary unit of measure | ||
EXPECTED_YIELD | NUMBER | Expected Yield % for the Work Order | ||
PRIMARY_UOM | VARCHAR2 | (5) | Primary unit of measure | |
SECONDARY_UOM | VARCHAR2 | (5) | Secondary unit of measure | |
ACTUAL_COMP_QTY_G | NUMBER | Actual completed quantity in primary unit of measure | ||
ACTUAL_COMP_QTY_SG | NUMBER | Actual completed quantity in secondary unit of measure | ||
ACTUAL_REJECTED_QTY_G | NUMBER | Actual rejected quantity in primary unit of measure | ||
ACTUAL_REJECTED_QTY_SG | NUMBER | Actual rejected quantity in secondary unit of measure | ||
ACTUAL_REWORKED_QTY_G | NUMBER | Actual reworked quantity in primary unit of measure | ||
ACTUAL_REWORKED_QTY_SG | NUMBER | Actual reworked quantity in secondary unit of measure | ||
ACTUAL_SCRAP_QTY_G | NUMBER | Actual scrapped quantity in primary unit of measure | ||
ACTUAL_SCRAP_QTY_SG | NUMBER | Actual scrapped quantity in secondary unit of measure | ||
ITEM_TYPE_CODE | VARCHAR2 | (80) | Item type code | |
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate reprocessing of errored rows | |
USER_DIM1_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM2_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM3_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM4_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM5_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
WIP_PLAN_QTY_G | NUMBER | WIP planned quantity in primary unit of measure | ||
WIP_PLAN_QTY_SG | NUMBER | WIP planned quantity in secondary unit of measure | ||
CONTRIBUTE_YIELD_FLAG | VARCHAR2 | (1) | Flag indicating material produced contributing to yield | |
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_PROD_MTL_PRODUCED_ERR does not reference any database object
MTH.MTH_PROD_MTL_PRODUCED_ERR is referenced by following:
Description: |
---|
This table stores the work order item information. It holds information about the quantity of each item to be assembled, the actual quantity completed along with the scrap, reject and the reworked quantities, the type of the item and its expected yield
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_PROD_MTL_PRODUCED_F_U1 | UNIQUE | APPS_TS_TX_IDX |
ITEM_FK_KEY
WORKORDER_FK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKORDER_FK_KEY | NUMBER | Y | Reference to work order | |
ITEM_FK_KEY | NUMBER | Y | Reference to item | |
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
START_QUANTITY_G | NUMBER | Work Order start quantity in primary unit of measure | ||
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
START_QUANTITY_SG | NUMBER | Work Order start quantity in secondary unit of measure | ||
EXPECTED_YIELD | NUMBER | Expected Yield % for the Work Order | ||
PRIMARY_UOM | VARCHAR2 | (5) | Primary unit of measure | |
SECONDARY_UOM | VARCHAR2 | (5) | Secondary unit of measure | |
ACTUAL_COMP_QTY_G | NUMBER | Actual completed quantity in primary unit of measure | ||
ACTUAL_COMP_QTY_SG | NUMBER | Actual completed quantity in secondary unit of measure | ||
ACTUAL_REJECTED_QTY_G | NUMBER | Actual rejected quantity in primary unit of measure | ||
ACTUAL_REJECTED_QTY_SG | NUMBER | Actual rejected quantity in secondary unit of measure | ||
ACTUAL_REWORKED_QTY_G | NUMBER | Actual reworked quantity in primary unit of measure | ||
ACTUAL_REWORKED_QTY_SG | NUMBER | Actual reworked quantity in secondary unit of measure | ||
ACTUAL_SCRAP_QTY_G | NUMBER | Actual scrapped quantity in primary unit of measure | ||
ACTUAL_SCRAP_QTY_SG | NUMBER | Actual scrapped quantity in secondary unit of measure | ||
ITEM_TYPE_CODE | NUMBER | Item type code | ||
USER_DIM1_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM2_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM3_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM4_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM5_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
STATUS_CODE | NUMBER | Work Order status code | ||
PLANNED_START_DATE | DATE | Work Order planned start date | ||
PLANNED_COMPLETION_DATE | DATE | Work Order planned completion date | ||
ACTUAL_START_DATE | DATE | Work Order actual start date | ||
ACTUAL_COMPLETION_DATE | DATE | Work Order actual completion date | ||
WIP_PLAN_QTY_G | NUMBER | WIP planned quantity in primary unit of measure | ||
WIP_PLAN_QTY_SG | NUMBER | WIP planned quantity in secondary unit of measure | ||
CONTRIBUTE_YIELD_FLAG | VARCHAR2 | (1) | Flag indicating material produced contributing to yield |
MTH.MTH_PROD_MTL_PRODUCED_F does not reference any database object
MTH.MTH_PROD_MTL_PRODUCED_F is referenced by following:
Description: |
---|
Interface table for MTH_PROD_MTL_PRODUCED_F
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WIP_ENTITY_ID | NUMBER | Y | Internal column for EBS integration only | |
ORGANIZATION_CODE | VARCHAR2 | (120) | Y | Internal column for EBS integration only |
ORGANIZATION_ID | NUMBER | Y | Internal column for EBS integration only | |
DB_GLOBAL_NAME | VARCHAR2 | (120) | Y | Internal column for EBS integration only |
PRIMARY_ITEM_ID | NUMBER | Y | Internal column for EBS integration only | |
START_QUANTITY_G | NUMBER | Y | Internal column for EBS integration only | |
START_QUANTITY_SG | NUMBER | Internal column for EBS integration only | ||
EXPECTED_YIELD | NUMBER | Internal column for EBS integration only | ||
ACTUAL_COMP_QTY_G | NUMBER | Internal column for EBS integration only | ||
ACTUAL_COMP_QTY_SG | NUMBER | Internal column for EBS integration only | ||
ACTUAL_REJECTED_QTY_G | NUMBER | Internal column for EBS integration only | ||
ACTUAL_REJECTED_QTY_SG | NUMBER | Internal column for EBS integration only | ||
ACTUAL_REWORKED_QTY_G | NUMBER | Internal column for EBS integration only | ||
ACTUAL_REWORKED_QTY_SG | NUMBER | Internal column for EBS integration only | ||
ACTUAL_SCRAP_QTY_G | NUMBER | Internal column for EBS integration only | ||
ACTUAL_SCRAP_QTY_SG | NUMBER | Internal column for EBS integration only | ||
ITEM_TYPE_CODE | VARCHAR2 | (80) | Internal column for EBS integration only | |
HUB_ORGANIZATION_CODE | VARCHAR2 | (120) | Internal column for EBS integration only | |
WIP_PLAN_QTY_SG | NUMBER | WIP planned quantity in secondary unit of measure | ||
WIP_PLAN_QTY_G | NUMBER | WIP planned quantity in primary unit of measure | ||
CONTRIBUTE_YIELD_FLAG | VARCHAR2 | (1) | Flag indicating material produced contributing to yield |
MTH.MTH_PROD_MTL_PRODUCED_I_STG does not reference any database object
MTH.MTH_PROD_MTL_PRODUCED_I_STG is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKORDER_FK | VARCHAR2 | (240) | Y | |
ITEM_FK | VARCHAR2 | (120) | Y | |
START_QUANTITY_G | NUMBER | |||
SYSTEM_FK | VARCHAR2 | (120) | ||
START_QUANTITY_SG | NUMBER | |||
EXPECTED_YIELD | NUMBER | |||
PRIMARY_UOM | VARCHAR2 | (5) | ||
SECONDARY_UOM | VARCHAR2 | (5) | ||
ACTUAL_COMP_QTY_G | NUMBER | |||
ACTUAL_COMP_QTY_SG | NUMBER | |||
ACTUAL_REJECTED_QTY_G | NUMBER | |||
ACTUAL_REJECTED_QTY_SG | NUMBER | |||
ACTUAL_REWORKED_QTY_G | NUMBER | |||
ACTUAL_REWORKED_QTY_SG | NUMBER | |||
ACTUAL_SCRAP_QTY_G | NUMBER | |||
ACTUAL_SCRAP_QTY_SG | NUMBER | |||
ITEM_TYPE_CODE | VARCHAR2 | (80) | ||
USER_DIM1_FK | VARCHAR2 | (120) | ||
USER_DIM2_FK | VARCHAR2 | (120) | ||
USER_DIM3_FK | VARCHAR2 | (120) | ||
USER_DIM4_FK | VARCHAR2 | (120) | ||
USER_DIM5_FK | VARCHAR2 | (120) | ||
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
WIP_PLAN_QTY_G | NUMBER | |||
WIP_PLAN_QTY_SG | NUMBER | |||
CONTRIBUTE_YIELD_FLAG | VARCHAR2 | (1) | ||
PROCESSING_FLAG | NUMBER |
MTH.MTH_PROD_MTL_PRODUCED_STG does not reference any database object
MTH.MTH_PROD_MTL_PRODUCED_STG is referenced by following:
Description: |
---|
Error table for MTH_PROD_MTL_PRODUCED_TXN_F
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate re-processing of errored rows | |
WO_COMP_PK | VARCHAR2 | (120) | Y | Workorder component identifier |
WORKORDER_FK | VARCHAR2 | (240) | Y | Reference to source workorder |
ITEM_FK | VARCHAR2 | (120) | Y | Reference to source item |
SEGMENT_FK | VARCHAR2 | (120) | Reference to source operation | |
TRANSACTION_TYPE | VARCHAR2 | (80) | Y | Material produced transaction type |
TRANSACTION_QTY | NUMBER | Quantity produced in transaction unit of measure | ||
TRANSACTION_QTY_G | NUMBER | Quantity produced in primary unit of measure | ||
TRANSACTION_QTY_SG | NUMBER | Quantity produced in secondary unit of measure | ||
TRANSACTION_UOM | VARCHAR2 | (5) | Transaction unit of measure | |
PRIMARY_UOM | VARCHAR2 | (5) | Primary unit of measure | |
SECONDARY_UOM | VARCHAR2 | (5) | Secondary unit of measure | |
TRANSACTION_DATE | DATE | Y | Transaction Date | |
SOURCE_ORG_CODE | VARCHAR2 | (120) | Organization code in source system | |
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
USER_DIM1_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM2_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM3_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM4_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM5_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_PROD_MTL_PRODUCED_TXN_ERR does not reference any database object
MTH.MTH_PROD_MTL_PRODUCED_TXN_ERR is referenced by following:
Description: |
---|
This table stores information on assembly completion transactions at the operation level of the work orders
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_PROD_MTL_PRODUCED_TXN_F_U1 | UNIQUE | APPS_TS_TX_IDX | WO_COMP_PK |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WO_COMP_PK_KEY | NUMBER | Y | System generated surrogate key For workorder component Identifier | |
WO_COMP_PK | VARCHAR2 | (120) | Y | workorder component identifier |
WORKORDER_FK_KEY | NUMBER | Y | Reference to workorder | |
ITEM_FK_KEY | NUMBER | Y | Reference to item | |
SEGMENT_FK_KEY | NUMBER | Reference to operation | ||
TRANSACTION_TYPE | VARCHAR2 | (80) | Y | material produced transaction type |
TRANSACTION_QTY | NUMBER | Quantity Produced in Transaction unit of measure | ||
TRANSACTION_QTY_G | NUMBER | Quantity Produced in Primary unit of measure | ||
TRANSACTION_QTY_SG | NUMBER | Quantity Produced in Secondary unit of measure | ||
TRANSACTION_UOM | VARCHAR2 | (5) | Transaction unit of measure | |
PRIMARY_UOM | VARCHAR2 | (5) | Primary unit of measure | |
SECONDARY_UOM | VARCHAR2 | (5) | Secondary unit of measure | |
TRANSACTION_DATE | DATE | Y | Transaction Date | |
SHIFT_WORKDAY_FK_KEY | NUMBER | Y | Reference to shift workday | |
PLANT_FK_KEY | NUMBER | Y | Reference to plant | |
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
SOURCE_ORG_CODE | VARCHAR2 | (120) | Organization code in source system | |
USER_DIM1_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM2_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM3_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM4_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM5_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column |
MTH.MTH_PROD_MTL_PRODUCED_TXN_F does not reference any database object
MTH.MTH_PROD_MTL_PRODUCED_TXN_F is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WO_COMP_PK | VARCHAR2 | (120) | Y | |
WORKORDER_FK | VARCHAR2 | (240) | Y | |
ITEM_FK | VARCHAR2 | (120) | Y | |
SEGMENT_FK | VARCHAR2 | (120) | ||
TRANSACTION_TYPE | VARCHAR2 | (80) | Y | |
TRANSACTION_QTY | NUMBER | |||
TRANSACTION_QTY_G | NUMBER | |||
TRANSACTION_QTY_SG | NUMBER | |||
TRANSACTION_UOM | VARCHAR2 | (5) | ||
PRIMARY_UOM | VARCHAR2 | (5) | ||
SECONDARY_UOM | VARCHAR2 | (5) | ||
TRANSACTION_DATE | DATE | Y | ||
SOURCE_ORG_CODE | VARCHAR2 | (120) | ||
SYSTEM_FK | VARCHAR2 | (120) | ||
USER_DIM1_FK | VARCHAR2 | (120) | ||
USER_DIM2_FK | VARCHAR2 | (120) | ||
USER_DIM3_FK | VARCHAR2 | (120) | ||
USER_DIM4_FK | VARCHAR2 | (120) | ||
USER_DIM5_FK | VARCHAR2 | (120) | ||
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
PROCESSING_FLAG | NUMBER |
MTH.MTH_PROD_MTL_PRODUCED_TXN_STG does not reference any database object
MTH.MTH_PROD_MTL_PRODUCED_TXN_STG is referenced by following:
Description: |
---|
Error table for MTH_PROD_SEGMENTS_TXN_F
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKORDER_FK | VARCHAR2 | (240) | Y | Reference to source work order |
FROM_SEGMENT_FK | VARCHAR2 | (120) | Y | Reference to source "From" segment |
TO_SEGMENT_FK | VARCHAR2 | (120) | Y | Reference to source "To" segment |
ITEM_FK | VARCHAR2 | (120) | Y | Reference to source item |
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
TRANSACTION_DATE | DATE | Y | Transaction date | |
TRANSACTION_QTY | NUMBER | Move quantity for the transaction in transaction unit of measure | ||
TRANSACTION_QTY_G | NUMBER | Move quantity for the transaction in primary unit of measure | ||
TRANSACTION_QTY_SG | NUMBER | Move quantity for the transaction in secondary unit of measure | ||
PRIMARY_UOM | VARCHAR2 | (5) | Primary unit of measure | |
SECONDARY_UOM | VARCHAR2 | (5) | Secondary unit of measure | |
TRANSACTION_UOM | VARCHAR2 | (5) | Transaction unit of measure | |
FROM_STEP_TYPE | VARCHAR2 | (80) | "From" intraoperation step for the transaction | |
TO_STEP_TYPE | VARCHAR2 | (80) | "To" intraoperation step for the transaction | |
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate reprocessing of errored rows | |
USER_DIM1_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM2_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM3_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM4_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM5_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
SUB_SEGMENT_FK | VARCHAR2 | (120) | Reference to sub-segment | |
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_PROD_SEGMENTS_TXN_ERR does not reference any database object
MTH.MTH_PROD_SEGMENTS_TXN_ERR is referenced by following:
Description: |
---|
This table stores information about the intra-operation transactions that take place at the operation level. It holds information on quantity moved from one intra-operation type to another intra-operation type of the same or a different operation.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_PROD_SEGMENTS_TXN_F_U1 | UNIQUE | APPS_TS_TX_IDX |
WORKORDER_FK_KEY
TRANSACTION_DATE FROM_SEGMENT_FK_KEY TO_SEGMENT_FK_KEY ITEM_FK_KEY FROM_STEP_TYPE TO_STEP_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKORDER_FK_KEY | NUMBER | Y | Reference to work order | |
FROM_SEGMENT_FK_KEY | NUMBER | Y | Reference to "From" segment identifier for the transaction | |
TO_SEGMENT_FK_KEY | NUMBER | Y | Reference to "To" segment identifier for the transaction | |
ITEM_FK_KEY | NUMBER | Y | Reference to item | |
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
SHIFT_WORKDAY_FK_KEY | NUMBER | Y | Reference to shift workday | |
TRANSACTION_DATE | DATE | Y | Transaction date | |
TRANSACTION_QTY | NUMBER | Move quantity for the transaction in transaction unit of measure | ||
TRANSACTION_QTY_G | NUMBER | Move quantity for the transaction in primary unit of measure | ||
TRANSACTION_QTY_SG | NUMBER | Move quantity for the transaction in secondary unit of measure | ||
TRANSACTION_UOM | VARCHAR2 | (5) | Transaction unit of measure | |
PRIMARY_UOM | VARCHAR2 | (5) | Primary unit of measure | |
SECONDARY_UOM | VARCHAR2 | (5) | Secondary unit of measure | |
FROM_STEP_TYPE | VARCHAR2 | (80) | "From" intraoperation step for the transaction | |
TO_STEP_TYPE | VARCHAR2 | (80) | "To" intraoperation step for the transaction | |
USER_DIM1_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM2_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM3_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM4_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM5_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
SUB_SEGMENT_FK_KEY | NUMBER | Reference to sub-segment |
MTH.MTH_PROD_SEGMENTS_TXN_F does not reference any database object
MTH.MTH_PROD_SEGMENTS_TXN_F is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKORDER_FK | VARCHAR2 | (240) | Y | |
FROM_SEGMENT_FK | VARCHAR2 | (120) | Y | |
TO_SEGMENT_FK | VARCHAR2 | (120) | Y | |
ITEM_FK | VARCHAR2 | (120) | Y | |
SYSTEM_FK | VARCHAR2 | (120) | ||
SUB_SEGMENT_FK | VARCHAR2 | (120) | ||
TRANSACTION_DATE | DATE | Y | ||
TRANSACTION_QTY | NUMBER | |||
TRANSACTION_QTY_G | NUMBER | |||
TRANSACTION_QTY_SG | NUMBER | |||
TRANSACTION_UOM | VARCHAR2 | (5) | ||
PRIMARY_UOM | VARCHAR2 | (5) | ||
SECONDARY_UOM | VARCHAR2 | (5) | ||
FROM_STEP_TYPE | VARCHAR2 | (80) | ||
TO_STEP_TYPE | VARCHAR2 | (80) | ||
USER_DIM1_FK | VARCHAR2 | (120) | ||
USER_DIM2_FK | VARCHAR2 | (120) | ||
USER_DIM3_FK | VARCHAR2 | (120) | ||
USER_DIM4_FK | VARCHAR2 | (120) | ||
USER_DIM5_FK | VARCHAR2 | (120) | ||
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
PROCESSING_FLAG | NUMBER |
MTH.MTH_PROD_SEGMENTS_TXN_STG does not reference any database object
MTH.MTH_PROD_SEGMENTS_TXN_STG is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUB_SEGMENT_PK | VARCHAR2 | (120) | Y | |
SEGMENT_FK | VARCHAR2 | (120) | Y | |
SYSTEM_FK | VARCHAR2 | (120) | ||
DESCRIPTION | VARCHAR2 | (240) | ||
ACTUAL_START_DATE | DATE | |||
ACTUAL_COMPLETION_DATE | DATE | |||
PLANNED_START_DATE | DATE | |||
PLANNED_COMPLETION_DATE | DATE | |||
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
PROCESSING_FLAG | NUMBER |
MTH.MTH_PROD_SUB_SEGMENTS_STG does not reference any database object
MTH.MTH_PROD_SUB_SEGMENTS_STG is referenced by following:
Description: |
---|
This table stores information on quarter level definition for time dimension hierarchies.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_QUARTER_D_U1 | UNIQUE | APPS_TS_TX_IDX |
HIERARCHY_ID
NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HIERARCHY_ID | NUMBER | Y | Hierarchy identifier | |
QUARTER_ID | NUMBER | Y | Quarter identifier | |
NAME | VARCHAR2 | (100) | Y | Quarter name |
START_DATE | DATE | Start date | ||
END_DATE | DATE | End date | ||
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column |
MTH.MTH_QUARTER_D does not reference any database object
MTH.MTH_QUARTER_D is referenced by following:
Description: |
---|
Error table for MTH_QUARTER_D
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate reprocessing of errored rows | |
HIERARCHY_NAME | VARCHAR2 | (100) | Y | Hierarchy name, unique within a dimension |
NAME | VARCHAR2 | (100) | Y | Quarter name |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
END_DATE | DATE | End date | ||
START_DATE | DATE | Start date | ||
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_QUARTER_ERR does not reference any database object
MTH.MTH_QUARTER_ERR is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HIERARCHY_NAME | VARCHAR2 | (100) | Y | |
NAME | VARCHAR2 | (100) | Y | |
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
SYSTEM_FK | VARCHAR2 | (120) | ||
END_DATE | DATE | |||
START_DATE | DATE | |||
PROCESSING_FLAG | NUMBER |
MTH.MTH_QUARTER_STG does not reference any database object
MTH.MTH_QUARTER_STG is referenced by following:
Description: |
---|
This table stores information about resources. It holds information like Resource name, Resource description, Resource type, Usage UOM, Resource capacity, whether the resource is available for 24 hours or shift based, Disable date, Department and Organization.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_RESOURCES_D_U1 | UNIQUE | APPS_TS_TX_IDX | RESOURCE_PK |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_PK_KEY | NUMBER | Y | System generated surrogate key for resource | |
RESOURCE_PK | VARCHAR2 | (120) | Y | Resource identifier |
RESOURCE_TYPE | NUMBER | Y | Resource type | |
EBS_RESOURCE_ID | NUMBER | Oracle E-business Suite resource identifier | ||
EBS_DEPARTMENT_ID | NUMBER | Oracle E-business Suite department identifier | ||
EBS_ORGANIZATION_ID | NUMBER | Oracle E-business Suite organization identifier | ||
USAGE_UOM | VARCHAR2 | (5) | Resource usage unit of measure | |
CAPACITY_UNIT | NUMBER | Resource capacity | ||
AVAILABLE_24_HOUR_FLAG | NUMBER | Flag to indicate whether resource is 24 hour available or shift based | ||
PLANT_FK_KEY | NUMBER | Y | Reference to plant | |
SOURCE_ORG_CODE | VARCHAR2 | (120) | Organization code in the source system | |
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
DISABLE_DATE | DATE | Resource disabled date | ||
RESOURCE_NAME | VARCHAR2 | (32) | Y | Resource name |
RESOURCE_DESCRIPTION | VARCHAR2 | (240) | Resource description | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR6 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR7 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR8 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR9 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR10 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR11 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR12 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR13 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR14 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR15 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR16 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR17 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR18 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR19 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR20 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
STD_UTILIZATION | NUMBER | Standard utilization of resource in percentage | ||
STD_EFFICIENCY | NUMBER | Standard efficiency of resource in percentage |
MTH.MTH_RESOURCES_D does not reference any database object
MTH.MTH_RESOURCES_D is referenced by following:
Description: |
---|
Error table for MTH_RESOURCES_D
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_PK | VARCHAR2 | (120) | Y | Resource identifier |
RESOURCE_TYPE | NUMBER | Y | Resource type | |
EBS_RESOURCE_ID | NUMBER | Oracle E-business Suite resource identifier | ||
EBS_DEPARTMENT_ID | NUMBER | Oracle E-business Suite department identifier | ||
EBS_ORGANIZATION_ID | NUMBER | Oracle E-business Suite organization identifier | ||
USAGE_UOM | VARCHAR2 | (5) | Resource usage unit of measure | |
CAPACITY_UNITS | NUMBER | Resource capacity | ||
AVAILABLE_24_HOUR_FLAG | NUMBER | Flag to indicate whether resource is 24 hour available or shift based | ||
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
DISABLE_DATE | DATE | Resource disabled date | ||
RESOURCE_NAME | VARCHAR2 | (32) | Y | Resource name |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR6 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR7 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR8 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR9 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR10 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR11 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR12 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR13 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR14 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR15 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR16 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR17 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR18 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR19 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR20 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate reprocessing of errored rows | |
SOURCE_ORG_CODE | VARCHAR2 | (120) | Organization code in the source system | |
RESOURCE_DESCRIPTION | VARCHAR2 | (240) | Resource description | |
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
STD_UTILIZATION | NUMBER | Standard utilization of resource in percentage | ||
STD_EFFICIENCY | NUMBER | Standard efficiency of resource in percentage | ||
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_RESOURCES_ERR does not reference any database object
MTH.MTH_RESOURCES_ERR is referenced by following:
Description: |
---|
Interface table for MTH_RESOURCES_D
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_ID | NUMBER | Internal column for EBS integration only | ||
DEPARTMENT_ID | NUMBER | Internal column for EBS integration only | ||
ORGANIZATION_ID | NUMBER | Internal column for EBS integration only | ||
RESOURCE_TYPE | NUMBER | Y | Internal column for EBS integration only | |
USAGE_UOM | VARCHAR2 | (5) | Internal column for EBS integration only | |
CAPACITY_UNITS | NUMBER | Internal column for EBS integration only | ||
AVAILABLE_24_HOUR_FLAG | NUMBER | Internal column for EBS integration only | ||
DISABLE_DATE | DATE | Internal column for EBS integration only | ||
RESOURCE_NAME | VARCHAR2 | (32) | Y | Internal column for EBS integration only |
HUB_ORGANIZATION_CODE | VARCHAR2 | (120) | Y | Internal column for EBS integration only |
DEPARTMENT_CODE | VARCHAR2 | (120) | Y | Internal column for EBS integration only |
RESOURCE_GROUP_NAME | VARCHAR2 | (120) | Internal column for EBS integration only | |
DB_GLOBAL_NAME | VARCHAR2 | (120) | Y | Internal column for EBS integration only |
USER_ATTR1 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR2 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR3 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR4 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR5 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR6 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR7 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR8 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR9 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR10 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR11 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR12 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR13 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR14 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR15 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR16 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR17 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR18 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR19 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR20 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_MEASURE1 | NUMBER | Internal column for EBS integration only | ||
USER_MEASURE2 | NUMBER | Internal column for EBS integration only | ||
USER_MEASURE3 | NUMBER | Internal column for EBS integration only | ||
USER_MEASURE4 | NUMBER | Internal column for EBS integration only | ||
USER_MEASURE5 | NUMBER | Internal column for EBS integration only | ||
SOURCE_ORG_CODE | VARCHAR2 | (120) | Y | Internal column for EBS integration only |
RESOURCE_DESCRIPTION | VARCHAR2 | (240) | Internal column for EBS integration only |
MTH.MTH_RESOURCES_I_STG does not reference any database object
MTH.MTH_RESOURCES_I_STG is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_PK | VARCHAR2 | (120) | Y | |
RESOURCE_TYPE | NUMBER | Y | ||
EBS_RESOURCE_ID | NUMBER | |||
EBS_DEPARTMENT_ID | NUMBER | |||
EBS_ORGANIZATION_ID | NUMBER | |||
USAGE_UOM | VARCHAR2 | (5) | ||
CAPACITY_UNITS | NUMBER | |||
AVAILABLE_24_HOUR_FLAG | NUMBER | |||
SYSTEM_FK | VARCHAR2 | (120) | ||
DISABLE_DATE | DATE | |||
RESOURCE_NAME | VARCHAR2 | (32) | Y | |
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_ATTR6 | VARCHAR2 | (150) | ||
USER_ATTR7 | VARCHAR2 | (150) | ||
USER_ATTR8 | VARCHAR2 | (150) | ||
USER_ATTR9 | VARCHAR2 | (150) | ||
USER_ATTR10 | VARCHAR2 | (150) | ||
USER_ATTR11 | VARCHAR2 | (150) | ||
USER_ATTR12 | VARCHAR2 | (150) | ||
USER_ATTR13 | VARCHAR2 | (150) | ||
USER_ATTR14 | VARCHAR2 | (150) | ||
USER_ATTR15 | VARCHAR2 | (150) | ||
USER_ATTR16 | VARCHAR2 | (150) | ||
USER_ATTR17 | VARCHAR2 | (150) | ||
USER_ATTR18 | VARCHAR2 | (150) | ||
USER_ATTR19 | VARCHAR2 | (150) | ||
USER_ATTR20 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
SOURCE_ORG_CODE | VARCHAR2 | (120) | ||
RESOURCE_DESCRIPTION | VARCHAR2 | (240) | ||
STD_UTILIZATION | NUMBER | |||
STD_EFFICIENCY | NUMBER | |||
PROCESSING_FLAG | NUMBER |
MTH.MTH_RESOURCES_STG does not reference any database object
MTH.MTH_RESOURCES_STG is referenced by following:
Description: |
---|
This table stores the information about resource cost history. It holds information on resource cost for every cost element of the resource.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_FK_KEY | NUMBER | Y | Reference to resource | |
FROM_DATE | DATE | From date | ||
TO_DATE | DATE | To date | ||
COST | NUMBER | Y | Resource cost | |
COST_ELEMENT | VARCHAR2 | (30) | Cost element | |
ISCURRENT | NUMBER | Y | Flag indicating latest cost | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
SYSTEM_FK_KEY | NUMBER | Y | Standard who column | |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column |
MTH.MTH_RESOURCE_COST does not reference any database object
MTH.MTH_RESOURCE_COST is referenced by following:
Description: |
---|
Error table for MTH_RESOURCE_COST
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_FK | VARCHAR2 | (120) | Y | Reference to source resource |
FROM_DATE | DATE | From date | ||
TO_DATE | DATE | To date | ||
COST_ELEMENT | VARCHAR2 | (30) | Cost element | |
COST | NUMBER | Y | Resource cost | |
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate reprocessing of errored rows | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_RESOURCE_COST_ERR does not reference any database object
MTH.MTH_RESOURCE_COST_ERR is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_FK | VARCHAR2 | (120) | Y | |
FROM_DATE | DATE | |||
TO_DATE | DATE | |||
COST_ELEMENT | VARCHAR2 | (30) | ||
COST | NUMBER | Y | ||
SYSTEM_FK | VARCHAR2 | (120) | ||
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
PROCESSING_FLAG | NUMBER |
MTH.MTH_RESOURCE_COST_STG does not reference any database object
MTH.MTH_RESOURCE_COST_STG is referenced by following:
Description: |
---|
Error table for MTH_RESOURCE_REQUIREMENTS_F
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate re-processing of errored rows | |
WORKORDER_FK | VARCHAR2 | (240) | Y | Reference to source workorder |
PRODUCT_FK | VARCHAR2 | (120) | Reference to primary source product | |
RESOURCE_FK | VARCHAR2 | (120) | Y | Reference to source resource |
SEGMENT_FK | VARCHAR2 | (120) | Reference to source operation | |
PLANNED_USAGE_QTY | NUMBER | Planned usage quantity for the resource | ||
USAGE_UOM | VARCHAR2 | (5) | Usage unit of measure | |
UNIT_STANDARD_QTY | NUMBER | Standard resource usage quantity in primary unit of measure per unit of the primary product | ||
SOURCE_ORG_CODE | VARCHAR2 | (120) | Organization code in source system | |
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
USER_DIM1_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM2_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM3_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM4_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM5_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
SUB_SEGMENT_FK | VARCHAR2 | (120) | Reference to sub-segment | |
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_RESOURCE_REQUIREMENTS_ERR does not reference any database object
MTH.MTH_RESOURCE_REQUIREMENTS_ERR is referenced by following:
Description: |
---|
This table stores information on planned resource usages at each operation level on the work order
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKORDER_FK_KEY | NUMBER | Y | Reference to workorder | |
PRODUCT_FK_KEY | NUMBER | Reference to primary product | ||
RESOURCE_FK_KEY | NUMBER | Y | Reference to resource | |
SEGMENT_FK_KEY | NUMBER | Reference to operation | ||
PLANNED_USAGE_QTY | NUMBER | Planned Usage quantity for the Resource | ||
USAGE_UOM | VARCHAR2 | (5) | Usage unit of measure | |
UNIT_STANDARD_QTY | NUMBER | Standard Resource Usage Quantity in Primary unit of measure per Unit of the primary product | ||
PLANT_FK_KEY | NUMBER | Y | Reference to plant | |
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
SOURCE_ORG_CODE | VARCHAR2 | (120) | Organization code in source system | |
USER_DIM1_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM2_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM3_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM4_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM5_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
SUB_SEGMENT_FK_KEY | NUMBER | Reference to sub-segment | ||
RESOURCE_COST | NUMBER | Resource cost | ||
PLANNED_START_DATE | DATE | Work Order planned start date | ||
PLANNED_COMPLETION_DATE | DATE | Work Order planned completion date | ||
ACTUAL_START_DATE | DATE | Work Order actual start date | ||
ACTUAL_COMPLETION_DATE | DATE | Work Order actual completion date |
MTH.MTH_RESOURCE_REQUIREMENTS_F does not reference any database object
MTH.MTH_RESOURCE_REQUIREMENTS_F is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKORDER_FK | VARCHAR2 | (240) | Y | |
PRODUCT_FK | VARCHAR2 | (120) | ||
RESOURCE_FK | VARCHAR2 | (120) | Y | |
SEGMENT_FK | VARCHAR2 | (120) | ||
PLANNED_USAGE_QTY | NUMBER | |||
USAGE_UOM | VARCHAR2 | (5) | ||
UNIT_STANDARD_QTY | NUMBER | |||
SOURCE_ORG_CODE | VARCHAR2 | (120) | ||
SYSTEM_FK | VARCHAR2 | (120) | ||
USER_DIM1_FK | VARCHAR2 | (120) | ||
USER_DIM2_FK | VARCHAR2 | (120) | ||
USER_DIM3_FK | VARCHAR2 | (120) | ||
USER_DIM4_FK | VARCHAR2 | (120) | ||
USER_DIM5_FK | VARCHAR2 | (120) | ||
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
SUB_SEGMENT_FK | VARCHAR2 | (120) | ||
PROCESSING_FLAG | NUMBER |
MTH.MTH_RESOURCE_REQUIREMENTS_STG does not reference any database object
MTH.MTH_RESOURCE_REQUIREMENTS_STG is referenced by following:
Description: |
---|
Error table for MTH_RESOURCE_TXN_F
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate re-processing of errored rows | |
WORKORDER_FK | VARCHAR2 | (240) | Y | Reference to source workorder |
RESOURCE_FK | VARCHAR2 | (120) | Y | Reference to source resource |
PRODUCT_FK | VARCHAR2 | (120) | Reference to source item | |
SEGMENT_FK | VARCHAR2 | (120) | Reference to source operation | |
USAGE_QTY | NUMBER | Usage quantity for the resource | ||
USAGE_UOM | VARCHAR2 | (5) | Usage unit of measure | |
TRANSACTION_DATE | DATE | Y | Transaction date | |
SOURCE_ORG_CODE | VARCHAR2 | (120) | Organization code in source system | |
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
USER_DIM1_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM2_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM3_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM4_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM5_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
SUB_SEGMENT_FK | VARCHAR2 | (120) | Reference to source activity | |
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_RESOURCE_TXN_ERR does not reference any database object
MTH.MTH_RESOURCE_TXN_ERR is referenced by following:
Description: |
---|
This table stores information on actual resource usages at each operation level on the work order
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKORDER_FK_KEY | NUMBER | Y | Reference to workorder | |
RESOURCE_FK_KEY | NUMBER | Y | Reference to resource | |
PRODUCT_FK_KEY | NUMBER | Reference to item | ||
SEGMENT_FK_KEY | NUMBER | Reference to operation | ||
USAGE_QTY | NUMBER | Usage quantity of the resource | ||
USAGE_UOM | VARCHAR2 | (5) | Usage unit of measure | |
TRANSACTION_DATE | DATE | Y | Transaction date | |
SHIFT_WORKDAY_FK_KEY | NUMBER | Y | Reference to shift workday | |
PLANT_FK_KEY | NUMBER | Y | Reference to plant | |
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
SOURCE_ORG_CODE | VARCHAR2 | (120) | Organization code in source system | |
USER_DIM1_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM2_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM3_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM4_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM5_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
SUB_SEGMENT_FK_KEY | NUMBER | Reference to activity | ||
RESOURCE_COST | NUMBER | Resource cost | ||
PLANNED_START_DATE | DATE | Work Order planned start date | ||
PLANNED_COMPLETION_DATE | DATE | Work Order planned completion date | ||
ACTUAL_START_DATE | DATE | Work Order actual start date | ||
ACTUAL_COMPLETION_DATE | DATE | Work Order actual completion date |
MTH.MTH_RESOURCE_TXN_F does not reference any database object
MTH.MTH_RESOURCE_TXN_F is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKORDER_FK | VARCHAR2 | (240) | Y | |
RESOURCE_FK | VARCHAR2 | (120) | Y | |
PRODUCT_FK | VARCHAR2 | (120) | ||
SEGMENT_FK | VARCHAR2 | (120) | ||
USAGE_QTY | NUMBER | |||
USAGE_UOM | VARCHAR2 | (5) | ||
TRANSACTION_DATE | DATE | Y | ||
SOURCE_ORG_CODE | VARCHAR2 | (120) | ||
SYSTEM_FK | VARCHAR2 | (120) | ||
USER_DIM1_FK | VARCHAR2 | (120) | ||
USER_DIM2_FK | VARCHAR2 | (120) | ||
USER_DIM3_FK | VARCHAR2 | (120) | ||
USER_DIM4_FK | VARCHAR2 | (120) | ||
USER_DIM5_FK | VARCHAR2 | (120) | ||
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
SUB_SEGMENT_FK | VARCHAR2 | (120) | ||
PROCESSING_FLAG | NUMBER |
MTH.MTH_RESOURCE_TXN_STG does not reference any database object
MTH.MTH_RESOURCE_TXN_STG is referenced by following:
Description: |
---|
Interface table for MTH_EQUIP_ENTITIES_MST
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOOKUP_CODE | VARCHAR2 | (120) | Y | Internal column for EBS integration only |
MEANING | VARCHAR2 | (100) | Y | Internal column for EBS integration only |
ENTITY_TYPE | VARCHAR2 | (30) | Y | Internal column for EBS integration only |
DB_GLOBAL_NAME | VARCHAR2 | (120) | Y | Internal column for EBS integration only |
USER_ATTR1 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR2 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR3 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR4 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR5 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_MEASURE1 | NUMBER | Internal column for EBS integration only | ||
USER_MEASURE2 | NUMBER | Internal column for EBS integration only | ||
USER_MEASURE3 | NUMBER | Internal column for EBS integration only | ||
USER_MEASURE4 | NUMBER | Internal column for EBS integration only | ||
USER_MEASURE5 | NUMBER | Internal column for EBS integration only |
MTH.MTH_RES_GRP_ENTITIES_I_STG does not reference any database object
MTH.MTH_RES_GRP_ENTITIES_I_STG is referenced by following:
Description: |
---|
Log table for internal processing
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FACT_TABLE | VARCHAR2 | (30) | Y | Fact table identifier |
EBS_ORGANIZATION_ID | NUMBER | Organization Identifier | ||
EBS_ORGANIZATION_CODE | VARCHAR2 | (120) | Oracle E-business suite organization code | |
HUB_ORGANIZATION_CODE | VARCHAR2 | (120) | Organization code at MOC level | |
FROM_TXN_ID | NUMBER | Start Transaction Identifier | ||
TO_TXN_ID | NUMBER | End Transaction Identifier | ||
FROM_DATE | DATE | Last Collection Date | ||
TO_DATE | DATE | Last Collection Date | ||
SOURCE | NUMBER | Identifier to distinguish discrete and process. 1 = discrete, 2 = process. Needed only when source tables are different for discrete/process | ||
DB_GLOBAL_NAME | VARCHAR2 | (120) | Source system name | |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
COLLECTION_PARAMETER | VARCHAR2 | (240) | Additional collection parameter as needed | |
PLANT_START_DATE | DATE | Plant start date without time component | ||
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column |
MTH.MTH_RUN_LOG does not reference any database object
MTH.MTH_RUN_LOG is referenced by following:
Description: |
---|
This table stores information related to MOC source systems and their attributes.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_SYSTEMS_SETUP_U1 | UNIQUE | APPS_TS_TX_IDX | SYSTEM_PK |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SYSTEM_PK_KEY | NUMBER | Y | System generated surrogate key for the System Code | |
SYSTEM_PK | VARCHAR2 | (120) | Y | System Code defined in Manufacturing Operations Center |
SYSTEM_NAME | VARCHAR2 | (240) | Y | User defined system name for the system code |
SYSTEM_TYPE | VARCHAR2 | (10) | Y | Type of source system |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column |
MTH.MTH_SYSTEMS_SETUP does not reference any database object
MTH.MTH_SYSTEMS_SETUP is referenced by following:
Description: | This table contains the Manufacturing Hub processed tag data |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | Tag context group identifier | ||
READING_TIME | DATE | Y | Reading time for the tag data | |
TAG_CODE | VARCHAR2 | (255) | Y | Tag code |
TAG_DATA | VARCHAR2 | (255) | Tag data | |
MTH_ENTITY | NUMBER | Manufacturing Hub entity identifier | ||
ATTRIBUTE_GROUP | NUMBER | UDA attribute group identifier | ||
ATTRIBUTE | NUMBER | UDA attribute identifier | ||
EQUIPMENT_FK_KEY | NUMBER | Reference to equipment | ||
PLANT_FK_KEY | NUMBER | Reference to plant | ||
WORKORDER_FK_KEY | NUMBER | Reference to Work Order | ||
SEGMENT_FK_KEY | NUMBER | Reference to Work Order Segment | ||
SHIFT_WORKDAY_FK_KEY | NUMBER | Reference to shift workday | ||
ITEM_FK_KEY | NUMBER | Reference to primary product | ||
USER_ATTR1 | VARCHAR2 | (150) | User defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User defined attribute | |
USER_MEASURE1 | NUMBER | User defined measure | ||
USER_MEASURE2 | NUMBER | User defined measure | ||
USER_MEASURE3 | NUMBER | User defined measure | ||
USER_MEASURE4 | NUMBER | User defined measure | ||
USER_MEASURE5 | NUMBER | User defined measure | ||
QUALITY_FLAG | NUMBER | Flag to denote the quality of data | ||
PROCESSED_FLAG | NUMBER | Flag to denote the processing of data. 0: not processed; 1: processed. | ||
CREATION_DATE | DATE | Standard Who Column | ||
LAST_UPDATE_DATE | DATE | Standard Who Column | ||
CREATION_SYSTEM_ID | NUMBER | Standard Who Column | ||
LAST_UPDATE_SYSTEM_ID | NUMBER | Standard Who Column | ||
CREATED_BY | NUMBER | (15) | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard Who Column | |
RECIPE_NUM | VARCHAR2 | (30) | ||
RECIPE_VERSION | VARCHAR2 | (15) |
MTH.MTH_TAG_READINGS does not reference any database object
MTH.MTH_TAG_READINGS is referenced by following:
Description: |
---|
This table stores the latest parent - child relationship for time hierarchy.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_TIME_HIERARCHY_U1 | UNIQUE | APPS_TS_TX_IDX |
HIERARCHY_ID
LEVEL_FK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HIERARCHY_ID | NUMBER | Y | Hierarchy identifier | |
LEVEL_NUM | NUMBER | Y | Level number in the hierarchy | |
LEVEL_FK_KEY | NUMBER | Y | Reference to level identifier | |
PARENT_FK_KEY | NUMBER | Y | Reference to parent level | |
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column |
MTH.MTH_TIME_HIERARCHY does not reference any database object
MTH.MTH_TIME_HIERARCHY is referenced by following:
Description: |
---|
Error table for MTH_TIME_HIERARCHY
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate reprocessing of errored rows | |
HIERARCHY_NAME | VARCHAR2 | (100) | Y | Hierarchy name, unique within a dimension |
CHILD_FK | VARCHAR2 | (100) | Y | Reference to source level identifier |
PARENT_FK | VARCHAR2 | (100) | Y | Reference to source parent level |
LEVEL_NUMBER_OF_CHILD | NUMBER | Y | Level number in the hierarchy | |
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_TIME_HIERARCHY_ERR does not reference any database object
MTH.MTH_TIME_HIERARCHY_ERR is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HIERARCHY_NAME | VARCHAR2 | (100) | Y | |
CHILD_FK | VARCHAR2 | (100) | Y | |
PARENT_FK | VARCHAR2 | (100) | Y | |
LEVEL_NUMBER_OF_CHILD | NUMBER | Y | ||
SYSTEM_FK | VARCHAR2 | (120) | ||
PROCESSING_FLAG | NUMBER |
MTH.MTH_TIME_HIERARCHY_STG does not reference any database object
MTH.MTH_TIME_HIERARCHY_STG is referenced by following:
Description: |
---|
Error table for MTH_USER_DIM_ENTITIES
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIMENSION_NAME | VARCHAR2 | (100) | Y | Dimension name |
ENTITY_PK | VARCHAR2 | (120) | Y | Entity identifier. Recommended to concatenate the Entity identifier with Dimension identifier |
ENTITY_NAME | VARCHAR2 | (100) | Y | Entity name |
ENTITY_TYPE | VARCHAR2 | (30) | Entity type | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate reprocessing of errored rows | |
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_USER_DIM_ENTITIES_ERR does not reference any database object
MTH.MTH_USER_DIM_ENTITIES_ERR is referenced by following:
Description: |
---|
This table stores the entity definitions for user-defined dimensions. It holds information on Entity name and Entity type.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_USER_DIM_ENTITIES_MST_U1 | UNIQUE | APPS_TS_TX_IDX | ENTITY_PK |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIMENSION_ID | NUMBER | Y | Dimension identifier | |
ENTITY_PK_KEY | NUMBER | Y | System generated surrogate key for the entity | |
ENTITY_PK | VARCHAR2 | (120) | Y | Entity identifier. Recommended to concatenate the Entity identifier with Dimension identifier |
ENTITY_NAME | VARCHAR2 | (100) | Y | Entity name |
ENTITY_TYPE | VARCHAR2 | (30) | Y | Entity type |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column |
MTH.MTH_USER_DIM_ENTITIES_MST does not reference any database object
MTH.MTH_USER_DIM_ENTITIES_MST is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIMENSION_NAME | VARCHAR2 | (100) | Y | |
ENTITY_PK | VARCHAR2 | (120) | Y | |
ENTITY_NAME | VARCHAR2 | (100) | Y | |
ENTITY_TYPE | VARCHAR2 | (30) | ||
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
SYSTEM_FK | VARCHAR2 | (120) | ||
PROCESSING_FLAG | NUMBER |
MTH.MTH_USER_DIM_ENTITIES_STG does not reference any database object
MTH.MTH_USER_DIM_ENTITIES_STG is referenced by following:
Description: |
---|
This table stores the latest parent-child hierarchy relationship for user-defined hierarchies.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_USER_DIM_HIERARCHY_U1 | UNIQUE | APPS_TS_TX_IDX |
LEVEL_FK_KEY
HIERARCHY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIMENSION_ID | NUMBER | Y | Dimension identifier | |
HIERARCHY_ID | NUMBER | Y | Hierarchy identifier | |
LEVEL_NUM | NUMBER | Y | Level number in the hierarchy | |
LEVEL_FK_KEY | NUMBER | Y | Reference to the level | |
PARENT_FK_KEY | NUMBER | Y | Reference to the parent level | |
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column |
MTH.MTH_USER_DIM_HIERARCHY does not reference any database object
MTH.MTH_USER_DIM_HIERARCHY is referenced by following:
Description: |
---|
Error table for MTH_USER_DIM_HIERARCHY
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIMENSION_NAME | VARCHAR2 | (100) | Dimension name | |
HIERARCHY_NAME | VARCHAR2 | (100) | Hierarchy name, unique within a dimension | |
LEVEL_NUM | NUMBER | Y | Level number in the hierarchy | |
LEVEL_FK | VARCHAR2 | (120) | Y | Reference to the source level |
PARENT_FK | VARCHAR2 | (120) | Reference to the source parent level | |
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate reprocessing of errored rows | |
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_USER_DIM_HIERARCHY_ERR does not reference any database object
MTH.MTH_USER_DIM_HIERARCHY_ERR is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIMENSION_NAME | VARCHAR2 | (100) | ||
HIERARCHY_NAME | VARCHAR2 | (100) | ||
LEVEL_NUM | NUMBER | Y | ||
LEVEL_FK | VARCHAR2 | (120) | Y | |
PARENT_FK | VARCHAR2 | (120) | ||
SYSTEM_FK | VARCHAR2 | (120) | ||
PROCESSING_FLAG | NUMBER |
MTH.MTH_USER_DIM_HIERARCHY_STG does not reference any database object
MTH.MTH_USER_DIM_HIERARCHY_STG is referenced by following:
Description: |
---|
This table stores information on week level definition for time dimension hierarchies.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_WEEK_D_U1 | UNIQUE | APPS_TS_TX_IDX |
HIERARCHY_ID
NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HIERARCHY_ID | NUMBER | Y | Hierarchy identifier | |
WEEK_ID | NUMBER | Y | Week identifier | |
NAME | VARCHAR2 | (100) | Y | Week name |
START_DATE | DATE | Start date | ||
END_DATE | DATE | End date | ||
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column |
MTH.MTH_WEEK_D does not reference any database object
MTH.MTH_WEEK_D is referenced by following:
Description: |
---|
Error table for MTH_WEEK_D
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate reprocessing of errored rows | |
HIERARCHY_NAME | VARCHAR2 | (100) | Y | Hierarchy name, unique within a dimension |
NAME | VARCHAR2 | (100) | Y | Week name |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
END_DATE | DATE | End date | ||
START_DATE | DATE | Start date | ||
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_WEEK_ERR does not reference any database object
MTH.MTH_WEEK_ERR is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HIERARCHY_NAME | VARCHAR2 | (100) | Y | |
NAME | VARCHAR2 | (100) | Y | |
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
SYSTEM_FK | VARCHAR2 | (120) | ||
END_DATE | DATE | |||
START_DATE | DATE | |||
PROCESSING_FLAG | NUMBER |
MTH.MTH_WEEK_STG does not reference any database object
MTH.MTH_WEEK_STG is referenced by following:
Description: |
---|
This table stores the workday shifts definition for the time dimension. It provides information like Shift date, Shift From Time, Shift To Time, Shift name and Shift number.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_WORKDAY_SHIFTS_D_U1 | UNIQUE | APPS_TS_TX_IDX |
SHIFT_WORKDAY_PK
PLANT_FK_KEY |
MTH_WORKDAY_SHIFTS_D_U2 | UNIQUE | APPS_TS_TX_IDX | SHIFT_WORKDAY_PK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIFT_WORKDAY_PK_KEY | NUMBER | Y | System generated surrogate key for shift workday identifier | |
SHIFT_WORKDAY_PK | VARCHAR2 | (120) | Y | Shift workday identifier |
SHIFT_DATE | DATE | Y | Shift date | |
SHIFT_DATE_JULIAN | NUMBER | Y | Julian date for the shift_date | |
PLANT_FK_KEY | NUMBER | Y | Reference to plant | |
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
FROM_DATE | DATE | Start date of the shift including timestamp | ||
TO_DATE | DATE | End date of shift including timestamp | ||
SHIFT_NUM | NUMBER | Shift number | ||
SHIFT_NAME | VARCHAR2 | (240) | Shift name | |
SOURCE_ORG_CODE | VARCHAR2 | (120) | Organization code in source system | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column |
MTH.MTH_WORKDAY_SHIFTS_D does not reference any database object
MTH.MTH_WORKDAY_SHIFTS_D is referenced by following:
Description: |
---|
Interface table for MTH_WORKDAY_SHIFTS_D
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIFT_NUM | NUMBER | Y | Internal column for EBS integration only | |
SHIFT_DATE | DATE | Y | Internal column for EBS integration only | |
FROM_TIME | NUMBER | Y | Internal column for EBS integration only | |
TO_TIME | NUMBER | Y | Internal column for EBS integration only | |
USER_ATTR1 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR2 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR3 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR4 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_ATTR5 | VARCHAR2 | (150) | Internal column for EBS integration only | |
USER_MEASURE1 | NUMBER | Internal column for EBS integration only | ||
USER_MEASURE2 | NUMBER | Internal column for EBS integration only | ||
USER_MEASURE3 | NUMBER | Internal column for EBS integration only | ||
USER_MEASURE4 | NUMBER | Internal column for EBS integration only | ||
USER_MEASURE5 | NUMBER | Internal column for EBS integration only | ||
ORGANIZATION_ID | NUMBER | Internal column for EBS integration only | ||
EBS_ORGANIZATION_CODE | VARCHAR2 | (120) | Internal column for EBS integration only | |
DB_GLOBAL_NAME | VARCHAR2 | (120) | Y | Internal column for EBS integration only |
HUB_ORGANIZATION_CODE | VARCHAR2 | (120) | Internal column for EBS integration only | |
SHIFT_NAME | VARCHAR2 | (240) | Internal column for EBS integration only |
MTH.MTH_WORKDAY_SHIFTS_DIS_I_STG does not reference any database object
MTH.MTH_WORKDAY_SHIFTS_DIS_I_STG is referenced by following:
Description: |
---|
Error table for MTH_WORKDAY_SHIFTS_D
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate reprocessing of errored rows | |
SHIFT_DATE | DATE | Y | Shift date | |
SOURCE_ORG_CODE | VARCHAR2 | (120) | Organization code in source system | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
SHIFT_WORKDAY_PK | VARCHAR2 | (120) | Y | Shift workday identifier |
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
FROM_DATE | DATE | Start date of the shift including timestamp | ||
TO_DATE | DATE | End date of shift including timestamp | ||
SHIFT_NUM | NUMBER | Shift number | ||
SHIFT_NAME | VARCHAR2 | (240) | Shift name | |
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_WORKDAY_SHIFTS_ERR does not reference any database object
MTH.MTH_WORKDAY_SHIFTS_ERR is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIFT_DATE | DATE | Y | ||
SOURCE_ORG_CODE | VARCHAR2 | (120) | ||
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
SHIFT_WORKDAY_PK | VARCHAR2 | (120) | Y | |
SYSTEM_FK | VARCHAR2 | (120) | ||
FROM_DATE | DATE | |||
SHIFT_NUM | NUMBER | |||
TO_DATE | DATE | |||
SHIFT_NAME | VARCHAR2 | (240) | ||
PROCESSING_FLAG | NUMBER |
MTH.MTH_WORKDAY_SHIFTS_STG does not reference any database object
MTH.MTH_WORKDAY_SHIFTS_STG is referenced by following:
Description: |
---|
Error table for MTH_WO_SALES_ORDERS_F
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKORDER_FK | VARCHAR2 | (240) | Y | Reference to source work order |
SALESORDER_NUMBER | VARCHAR2 | (30) | Y | Sales Order number |
SALESORDER_LNUMBER | VARCHAR2 | (30) | Y | Sales Order line number |
CUSTOMER | VARCHAR2 | (100) | Customer name | |
REQUESTED_DATE | DATE | Sales order line requested date | ||
PROMISED_DATE | DATE | Sales order line promised date | ||
SCHEDULED_SHIP_DATE | DATE | Sales order line scheduled ship date | ||
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
QUANTITY_G | NUMBER | (for future use) | ||
PRIMARY_UOM | VARCHAR2 | (5) | (for future use) | |
PRODUCT_FK | VARCHAR2 | (120) | Reference to source product | |
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate reprocessing of errored rows | |
USER_DIM1_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM2_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM3_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM4_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_DIM5_FK | VARCHAR2 | (120) | Reference to source user defined dimension | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_WO_SALES_ORDERS_ERR does not reference any database object
MTH.MTH_WO_SALES_ORDERS_ERR is referenced by following:
Description: |
---|
This table stores information on the sales orders that originate the demand for the work orders. It holds information about the sales order line that originated the demand for a given work order, order quantity, customer name, requested, promised and the scheduled dates
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_WO_SALES_ORDER_F_U1 | UNIQUE | APPS_TS_TX_IDX |
SALESORDER_NUMBER
SALESORDER_LNUMBER WORKORDER_FK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKORDER_FK_KEY | NUMBER | Y | Reference to work order | |
SALESORDER_NUMBER | VARCHAR2 | (30) | Y | Sales Order number |
SALESORDER_LNUMBER | VARCHAR2 | (30) | Y | Sales Order line number |
CUSTOMER | VARCHAR2 | (100) | Customer name | |
REQUESTED_DATE | DATE | Sales order line requested date | ||
PROMISED_DATE | DATE | Sales order line promised date | ||
SCHEDULED_SHIP_DATE | DATE | Sales order line scheduled ship date | ||
QUANTITY_G | NUMBER | (for future use) | ||
PRIMARY_UOM | VARCHAR2 | (5) | (for future use) | |
PRODUCT_FK_KEY | NUMBER | Reference to product | ||
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
USER_DIM1_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM2_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM3_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM4_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM5_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
PLANNED_START_DATE | DATE | Work Order planned start date | ||
PLANNED_COMPLETION_DATE | DATE | Work Order planned completion date | ||
ACTUAL_START_DATE | DATE | Work Order actual start date | ||
ACTUAL_COMPLETION_DATE | DATE | Work Order actual completion date |
MTH.MTH_WO_SALES_ORDERS_F does not reference any database object
MTH.MTH_WO_SALES_ORDERS_F is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKORDER_FK | VARCHAR2 | (240) | Y | |
SALESORDER_NUMBER | VARCHAR2 | (30) | Y | |
SALESORDER_LNUMBER | VARCHAR2 | (30) | Y | |
CUSTOMER | VARCHAR2 | (100) | ||
REQUESTED_DATE | DATE | |||
PROMISED_DATE | DATE | |||
SCHEDULED_SHIP_DATE | DATE | |||
SYSTEM_FK | VARCHAR2 | (120) | ||
QUANTITY_G | NUMBER | |||
PRIMARY_UOM | VARCHAR2 | (5) | ||
PRODUCT_FK | VARCHAR2 | (120) | ||
USER_DIM1_FK | VARCHAR2 | (120) | ||
USER_DIM2_FK | VARCHAR2 | (120) | ||
USER_DIM3_FK | VARCHAR2 | (120) | ||
USER_DIM4_FK | VARCHAR2 | (120) | ||
USER_DIM5_FK | VARCHAR2 | (120) | ||
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
PROCESSING_FLAG | NUMBER |
MTH.MTH_WO_SALES_ORDERS_STG does not reference any database object
MTH.MTH_WO_SALES_ORDERS_STG is referenced by following:
Description: |
---|
This table stores information on year level definition for time dimension hierarchies.
Index | Type | Tablespace | Column |
---|---|---|---|
MTH_YEAR_D_U1 | UNIQUE | APPS_TS_TX_IDX |
HIERARCHY_ID
NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HIERARCHY_ID | NUMBER | Y | Hierarchy identifier | |
YEAR_ID | NUMBER | Y | Year identifier | |
NAME | VARCHAR2 | (100) | Y | Year name |
START_DATE | DATE | Start date | ||
END_DATE | DATE | End date | ||
SYSTEM_FK_KEY | NUMBER | Y | Reference to system | |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Y | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column |
MTH.MTH_YEAR_D does not reference any database object
MTH.MTH_YEAR_D is referenced by following:
Description: |
---|
Error table for MTH_YEAR_D
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REPROCESS_READY_YN | VARCHAR2 | (1) | Flag to indicate reprocessing of errored rows | |
HIERARCHY_NAME | VARCHAR2 | (100) | Y | Hierarchy name, unique within a dimension |
NAME | VARCHAR2 | (100) | Y | Year name |
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
SYSTEM_FK | VARCHAR2 | (120) | Reference to source system | |
END_DATE | DATE | End date | ||
START_DATE | DATE | Start date | ||
ERR$$$_AUDIT_RUN_ID | NUMBER | (22) | Internal column | |
ERR$$$_AUDIT_DETAIL_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | (22) | Internal column | |
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
ERR_CODE | VARCHAR2 | (240) | Error code |
MTH.MTH_YEAR_ERR does not reference any database object
MTH.MTH_YEAR_ERR is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HIERARCHY_NAME | VARCHAR2 | (100) | Y | |
NAME | VARCHAR2 | (100) | Y | |
USER_ATTR1 | VARCHAR2 | (150) | ||
USER_ATTR2 | VARCHAR2 | (150) | ||
USER_ATTR3 | VARCHAR2 | (150) | ||
USER_ATTR4 | VARCHAR2 | (150) | ||
USER_ATTR5 | VARCHAR2 | (150) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
SYSTEM_FK | VARCHAR2 | (120) | ||
END_DATE | DATE | |||
START_DATE | DATE | |||
PROCESSING_FLAG | NUMBER |
MTH.MTH_YEAR_STG does not reference any database object
MTH.MTH_YEAR_STG is referenced by following:
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |