WIE_WORK_ORDERS_B
This table stores information about what it takes to make a product. It identifies the primary product and can optionally refer to the Item Structure used to define material requirements. Work Definition also specifies the sequence of operation steps and the related resources that are necessary to manufacture the product. Work Definition serves different purposes. It is used to calculate standard costs of the manufactured product(s). It is also used by planning/scheduling and serves as a template to create standard work orders
Details
-
Schema: FUSION
-
Object owner: WIE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
WIE_WORK_ORDERS_B_PK |
WORK_ORDER_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
WORK_ORDER_ID | NUMBER | 18 | Yes | The unique identifier of work order record. Its value is an application generated unique id. | |
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
ORGANIZATION_ID | NUMBER | 18 | Yes | The organization identifier that represents the manufacturing plant to which this work order belongs. | |
WORK_ORDER_NUMBER | VARCHAR2 | 120 | Yes | Represents the user-facing identifier of the work order. | |
WORK_METHOD_ID | NUMBER | 18 | Yes | Represents the work method identifier for this work order. The work method indicates the type of work being executed within the Fusion Manufacturing application. | |
WORK_ORDER_TYPE | VARCHAR2 | 30 | Yes | Indicates the type of this work order. Values are contained within the ORA_WIE_WO_TYPE lookup if this work order is a manufacturing work order. If this is a maintenance work order, valid values are contained within the ORA_MNT_WO_TYPE lookup. | |
WORK_ORDER_SUB_TYPE | VARCHAR2 | 30 | The subtype specifically will be populated for non-standard work. This is used to derive the appropriate costing account for non-standard work. Values are contained in the ORA_WIE_WO_SUB_TYPE lookup if this work order is a manufacturing work order. If this is a maintenance work order, valid values are contained within the ORA_MNT_WO_SUB_TYPE lookup. | ||
INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Refers to the top level, final assembly, subassembly, or model item which belongs to the given organization. | |
ITEM_REVISION | VARCHAR2 | 18 | If the primary product is revision controlled, this will have a value. | ||
ITEM_VERSION | NUMBER | 18 | If the item is version controlled, this value will be populated. At the time of work order creation, the work definition selection API returns the valid item version based on the work definition as of date. And that value will be persisted here. | ||
ITEM_STRUCTURE_NAME | VARCHAR2 | 80 | Item Structure Name (aka alternate_bom_designator). This is how it used to be called in EBS. In Fusion PIM it is called as Item Structure Name. This will be populated programmatically and will not be captured by the end user. | ||
TRANSFORM_FROM_ITEM_ID | NUMBER | 18 | Refers to the assembly item that is being transformed to a new assembly item on a Transform work order. | ||
WORK_DEFINITION_AS_OF_DATE | TIMESTAMP | The As-Of-Date is used to figure out the proper version of the work definition when the Org + Product + As-Of-Date is provided as the filter criteria in narrowing down the work order. | |||
WORK_DEFINITION_ID | NUMBER | 18 | The foreign key reference to the work definition. | ||
WORK_DEFINITION_VERSION_ID | NUMBER | 18 | The version of the work definition. | ||
WORK_ORDER_PRIORITY | NUMBER | Used to set the priority of the work order depending on the demand that needed to be prioritized. | |||
WORK_ORDER_STATUS_ID | NUMBER | 18 | Yes | Represents the internal identifier of the user-defined status of the work order. | |
SCHEDULING_METHOD | VARCHAR2 | 30 | Yes | The scheduling method indicates if the work order is scheduled or not. A value of 'NO_SCHEDULING' indicates the work order is not scheduled. A value of 'DEFAULT_SCHEDULER' indicates the work order will be scheduled using the default infinite scheduler. Valid values exist in the lookup with lookup type = ORA_WIE_WO_SCHEDULING_METHOD. | |
PLANNED_START_QUANTITY | NUMBER | Yes | Refers to the planned work order quantity which should be greater than zero for standard work orders, and can be equal to or greater than zero for non standard work orders. | ||
NETTABLE_SUPPLY_QTY_OVERRIDE | NUMBER | This is a user entered override of the completion quantity intended to indicate if there are work order specific variances compared to the calculated Completion Quantity | |||
UOM_CODE | VARCHAR2 | 3 | Yes | Represents the unit of measure code. The assembly quantity will be produced in this UOM. The transactions that moves the assembly from operation to operation and also eventually the completions will be performed in this UOM. | |
PRIMARY_PRODUCT_QUANTITY | NUMBER | Represents the output quantity of the primary product used to create the work order. | |||
PRIMARY_PRODUCT_UOM_CODE | VARCHAR2 | 3 | Represents the unit of measure code of the primary product used to create the work order. | ||
FIRM_PLANNED_FLAG | VARCHAR2 | 1 | Yes | Flag to allow or prevent Planning from suggesting rescheduling and re-planning recommendations with respect to the Work Order. When the flag is on, this work order will not be considered by MRP to reschedule or re-plan. | |
PLANNED_START_DATE | TIMESTAMP | Planned start date of the work order. | |||
PLANNED_COMPLETION_DATE | TIMESTAMP | Planned completion date of the work order. | |||
ACTUAL_START_DATE | TIMESTAMP | Actual start date of the work order. | |||
ACTUAL_COMPLETION_DATE | TIMESTAMP | Actual completion date of the work order. | |||
RELEASED_DATE | TIMESTAMP | Date when the work order is released. | |||
CLOSED_DATE | TIMESTAMP | Date when the work order is closed. | |||
CANCELED_DATE | TIMESTAMP | Date when the work order is canceled. | |||
CANCELED_REASON | VARCHAR2 | 240 | Reason for which the work order is canceled. This is a free format text. | ||
NEED_BY_DATE | TIMESTAMP | Date when the supply created by the work order will be used to fulfill a demand. | |||
STATUS_CHANGE_REASON | VARCHAR2 | 240 | The reason which is a free format capture of why the status is changed. The most current status change reason will be persisted in this column. | ||
COMPLETED_QUANTITY | NUMBER | Primary product quantity completed so far in the work order. This is a summary column. | |||
SCRAPPED_QUANTITY | NUMBER | Primary product quantity that is scrapped in the work order. This is a summary column. | |||
REJECTED_QUANTITY | NUMBER | Primary product quantity that is rejected in the work order. This is a summary column. | |||
OVERCOMPL_TOLERANCE_TYPE | VARCHAR2 | 30 | The tolerance type for over completions. Valid values exist in the lookup with lookup type = EGP_OVER_TOLTYPE. | ||
OVERCOMPL_TOLERANCE_VALUE | NUMBER | The percent or amount value that is allowed over the scheduled completion work order quantity. | |||
UNDERCOMPL_TOLERANCE_TYPE | VARCHAR2 | 30 | The tolerance type for under completions. Valid values exist in the lookup with lookup type = ORA_EGP_UNDER_COMP_TOL. | ||
UNDERCOMPL_TOLERANCE_VALUE | NUMBER | The percent or amount value that is allowed under the scheduled completion work order quantity. | |||
UNDER_COMPLETED_FLAG | VARCHAR2 | 1 | Flag to indicate that the work order is marked as under-completed. | ||
SUPPLY_TYPE | VARCHAR2 | 30 | The various supply types are "Assembly Pull", "Operation Pull", "Push", and "Phantom". Assembly Pull - Material will be backflushed at the completion of the assembly. Operation Pull - Material will be backflushed at the completion of the operation. Push - Material will have to manually issued. Phantom - For materials having lower level components, the components will be considered as inputs to this work order. Valid values exist in the lookup with lookup_type = EGP_WIP_SUP_TYPE + lookup_type = ORA_WIE_WO_SUPPLY_TYPE. | ||
COMPL_SUBINVENTORY_CODE | VARCHAR2 | 10 | The default completion subinventory for the primary product. | ||
COMPL_LOCATOR_ID | NUMBER | 18 | The default completion locator for the primary product, if the subinventory is locator controlled. | ||
SERIAL_TRACKING_FLAG | VARCHAR2 | 1 | Yes | Indicates that the end item (eg assembly in discrete manufacturing) is tracked by serial numbers during work execution. The partially finished assembly starts its serialization during the lifecycle of the work order. This again depends on the serial control policies of the primary product and the enablement of the serialization at a particular operation within the work order. | |
BACK_TO_BACK_FLAG | VARCHAR2 | 1 | Yes | Flag to indicate that the work order is created as a result of a back-to-back flow. | |
ORCHESTRATION_CODE | VARCHAR2 | 30 | Attribute made available for integrating stakeholders to retain and persist a handle in the work orders schema to filter out events that make only sense to them. Stakeholders include SCO and Planning. | ||
INTERFACE_SOURCE_CODE | VARCHAR2 | 30 | Attribute made available for integrating stakeholders to retain and persist a handle in the work orders schema to filter out events that make only sense to them. Stakeholders include SCO and Planning. | ||
SCO_SUPPLY_ORDER_ID | NUMBER | 18 | When Supply Chain Orchestration (SCO) creates the Work Order, this column contains an order reference populated by the SCO process. For manually created CM orders, or when Planning creates the CM Order in Manufacturing directly, this reference is not populated. SCO then reads these SCO unaware CM work orders via an ESS program and creates them in the SCO repository. | ||
CONTRACT_MFG_FLAG | VARCHAR2 | 1 | Yes | Flag to indicate that the work order is a contract manufacturing work order. | |
CM_PO_HEADER_ID | NUMBER | 18 | Represents the internal identifier of the contract manufacturer's purchase order. | ||
CM_PO_LINE_ID | NUMBER | 18 | The reference to the contract manufacturer's PO line identifier. In R11, The PO line will have the item that is identified as a CM Service Item (or also called as the CM FG Server in the examples) in the PO line. It is not the primary product on the work order. | ||
CM_PO_LINE_LOC_ID | NUMBER | 18 | The reference to the contract manufacturer's PO schedule line reference. This will be populated only when the WO is created in the contract manufacturing organization. | ||
ORDER_LESS_FLAG | VARCHAR2 | 1 | Yes | Flag to indicate if the work order represents an 'orderless' order. | |
SOURCE_SYSTEM_TYPE | VARCHAR2 | 30 | Indicates the type of source system (i.e. internal or external) from which data is being imported. Valid values exist in the lookup with lookup type = ORA_WIE_SOURCE_SYSTEM_TYPE. | ||
SOURCE_SYSTEM_ID | NUMBER | 18 | Represents the identifier of the source system. If the source system type = "INTERNAL" this value equates to the application id. If "EXTERNAL", then it is the source system as defined in the trading community (TCA) source systems table. | ||
SOURCE_HEADER_REF | VARCHAR2 | 240 | Represents the source system's user-facing header reference identifier. | ||
SOURCE_HEADER_REF_ID | NUMBER | 18 | Represents the source system's internal header reference identifier. | ||
SOURCE_LINE_REF | VARCHAR2 | 240 | Represents the source system's user-facing line reference identifier. | ||
SOURCE_LINE_REF_ID | NUMBER | 18 | Represents the source system's internal line reference identifier. | ||
MNT_FORECAST_ID | NUMBER | 18 | Reference to the maintenance forecast that created the work order. Foreign key to MNT_FORECASTS.FORECAST_ID. | ||
PJC_CONTEXT_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for project-related standardized cost collection. | ||
PJC_PROJECT_ID | NUMBER | 18 | Identifier of the project used to build the transaction descriptive flexfield for project-related transaction distributions. Foreign key to PJF_PROJECTS_ALL_B.PROJECT_ID. | ||
PJC_PROJECT_NUMBER | VARCHAR2 | 25 | The number assigned to a project. | ||
PJC_TASK_ID | NUMBER | 18 | Identifier of the task used to build the transaction descriptive flexfield for project-related transaction distributions. Foreign key to PJF_PROJ_ELEMENTS_B.PROJ_ELEMENT_ID (however uses an alias of TASK_ID). | ||
PJC_TASK_NUMBER | VARCHAR2 | 100 | The identifying number for a task which is a subdivision of project work. | ||
PJC_EXPENDITURE_TYPE_ID | NUMBER | 18 | Expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions. | ||
PJC_EXPENDITURE_ITEM_DATE | DATE | Date on which a project-related transaction is incurred. | |||
PJC_ORGANIZATION_ID | NUMBER | 18 | Identifier for expenditure organization used to build the transaction descriptive flexfield for project-related transaction distributions. | ||
PJC_BILLABLE_FLAG | VARCHAR2 | 1 | Flag that indicates if a project-related item is available to be billed to customers. Valid values are Y or N. | ||
PJC_CAPITALIZABLE_FLAG | VARCHAR2 | 1 | Flag that indicates if a project-related item is eligible for capitalization. Valid values are Y or N. | ||
PJC_WORK_TYPE_ID | NUMBER | 18 | Identifier for project-related classification of the worked performed. | ||
PJC_CONTRACT_ID | NUMBER | 18 | Identifier of contract. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. | ||
PJC_CONTRACT_LINE_ID | NUMBER | 18 | Tracks contract line information. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. | ||
PJC_FUNDING_ALLOCATION_ID | NUMBER | 18 | Specifies the name of the project funding override. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. | ||
PJC_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
IOT_SYNC_STATUS | VARCHAR2 | 30 | This column tracks the status of the data synchronization of the work order object to IoT Production Monitoring Cloud. Valid values exist in the lookup with lookup type = ORA_WIE_IOT_SYNC_STATUS. | ||
PREASSIGN_LOT_FLAG | VARCHAR2 | 1 | Flag used to indicate that the lots for primary product and outputs can be pre-assigned in the work order. | ||
RESEQUENCE_FLAG | VARCHAR2 | 1 | Flag used to indicate if the work order has operations which can be re-sequenced while executing the operation. Valid values are Y or N. | ||
MNT_COMPLETE_TO_INV_FLAG | VARCHAR2 | 1 | Flag indicating that the asset(s) involved in the work order will be completing to inventory upon completion of work. | ||
MNT_INCLUDE_IN_PLANNING_FLAG | VARCHAR2 | 1 | Flag indicating that the assets that are to be completed to inventory can be used as a supply in planning for any outstanding demand. | ||
MNT_OUT_OF_SEQUENCE_FLAG | VARCHAR2 | 1 | Flag indicating whether operations within the work order can be soft completed in an out of sequence fashion. | ||
MNT_TRANSFORM_TO_ITEM_ID | NUMBER | 18 | The end item that this asset will transform to upon completion of the work. | ||
MNT_ALLOW_MULTIPLE_ASSETS_FLAG | VARCHAR2 | 1 | Flag indicating that multiple assets can be associated to this maintenance work order. | ||
MNT_MATCH_TO_RES_FLAG | VARCHAR2 | 1 | Flag indicating whether qualified resources are to be considered in the execution of the work. This is done by simply matching the resource of the Technician to the work order operation resource. | ||
MNT_MATCH_TO_RES_INST_FLAG | VARCHAR2 | 1 | Flag indicating whether qualified resource instances are to be considered in the execution of the work. This is done by simply matching the labor instance of the Technician to the work order operation resource instance. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | 80 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR1 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR2 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR3 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR4 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR5 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR6 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR7 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR8 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR9 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR10 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR11 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR12 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR13 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR14 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR15 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR16 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR17 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR18 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR19 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR20 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
wie_wo_operation_materials | wie_work_orders_b | WORK_ORDER_ID |
wie_wo_op_work_instructions_b | wie_work_orders_b | WORK_ORDER_ID |
wie_ma_wo_assignment_sequences | wie_work_orders_b | WORK_ORDER_ID |
wie_ma_wo_tmp_assignment_seq | wie_work_orders_b | WORK_ORDER_ID |
wie_ma_mtl_assignments | wie_work_orders_b | WORK_ORDER_ID |
wie_wo_assets | wie_work_orders_b | WORK_ORDER_ID |
wie_wo_status_history | wie_work_orders_b | WORK_ORDER_ID |
wie_work_orders_tl | wie_work_orders_b | WORK_ORDER_ID |
wie_wo_operations_b | wie_work_orders_b | WORK_ORDER_ID |
wie_ma_mtl_tmp_assignments | wie_work_orders_b | WORK_ORDER_ID |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
WIE_WORK_ORDERS_B_N01 | Non Unique | Default | ORGANIZATION_ID, WORK_METHOD_ID, ORDER_LESS_FLAG, INVENTORY_ITEM_ID | |
WIE_WORK_ORDERS_B_N02 | Non Unique | Default | ORGANIZATION_ID, WORK_METHOD_ID, ORDER_LESS_FLAG, WORK_ORDER_STATUS_ID, PLANNED_COMPLETION_DATE | |
WIE_WORK_ORDERS_B_N03 | Non Unique | Default | ORGANIZATION_ID, WORK_METHOD_ID, ORDER_LESS_FLAG, WORK_ORDER_TYPE, WORK_ORDER_SUB_TYPE | |
WIE_WORK_ORDERS_B_N04 | Non Unique | Default | ORGANIZATION_ID, WORK_METHOD_ID, ORDER_LESS_FLAG, PLANNED_START_DATE, PLANNED_COMPLETION_DATE | |
WIE_WORK_ORDERS_B_N05 | Non Unique | Default | ORGANIZATION_ID, WORK_METHOD_ID, ORDER_LESS_FLAG, TRUNC("PLANNED_START_DATE"), TRUNC("PLANNED_COMPLETION_DATE") | |
WIE_WORK_ORDERS_B_N06 | Non Unique | Default | ORGANIZATION_ID, WORK_METHOD_ID, SOURCE_HEADER_REF, SOURCE_HEADER_REF_ID, SOURCE_LINE_REF, SOURCE_LINE_REF_ID | |
WIE_WORK_ORDERS_B_N07 | Non Unique | Default | ORGANIZATION_ID, WORK_METHOD_ID, ORDER_LESS_FLAG, UPPER("WORK_ORDER_NUMBER"), WORK_ORDER_TYPE | |
WIE_WORK_ORDERS_B_N08 | Non Unique | Default | PLANNED_START_DATE, WORK_ORDER_STATUS_ID, WORK_ORDER_NUMBER | Obsolete |
WIE_WORK_ORDERS_B_N09 | Non Unique | Default | PJC_PROJECT_ID | |
WIE_WORK_ORDERS_B_N10 | Non Unique | Default | PJC_TASK_ID | |
WIE_WORK_ORDERS_B_N11 | Non Unique | Default | MNT_FORECAST_ID | |
WIE_WORK_ORDERS_B_N12 | Non Unique | Default | UPPER("WORK_ORDER_NUMBER"), ORGANIZATION_ID, WORK_METHOD_ID, ORDER_LESS_FLAG, WORK_ORDER_TYPE, WORK_ORDER_STATUS_ID | |
WIE_WORK_ORDERS_B_N13 | Non Unique | Default | PLANNED_START_DATE, WORK_ORDER_STATUS_ID, WORK_ORDER_NUMBER, ORGANIZATION_ID, WORK_METHOD_ID, ORDER_LESS_FLAG | |
WIE_WORK_ORDERS_B_U01 | Unique | Default | WORK_ORDER_ID | |
WIE_WORK_ORDERS_B_U02 | Unique | Default | ORGANIZATION_ID, WORK_ORDER_NUMBER |