CST_WO_UPDATE_EVENTS_GT
Transaction Global temporary table exposed for external systems, e.g. MFG to transfer work order modification information (currently work order status) after the work order has been previously interfaced to costing. External systems will directly write to this table and then invoke a plsql api to transfer the data from their system to cost management.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
CST_WO_UPDATE_EVENTS_GT_PK |
EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID, EVENT_DATE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Yes | Code identifying the external system owning this work order definition. | |
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Yes | Surrogate ID identifying the work order in the source system. Manufacturing work order ID. | |
| EVENT_DATE | TIMESTAMP | Yes | Identifies the system date time when the work order update was performed. | ||
| TRANSACTION_DATE | TIMESTAMP | Indicates the date and time to be used to value this status change transaction. | |||
| WORK_ORDER_STATUS_ID | NUMBER | 18 | Yes | Surrogate ID identifying the current work order status. | |
| PRIOR_WORK_ORDER_STATUS_ID | NUMBER | 18 | Surrogate ID identifying the prior work order status. | ||
| REASON | VARCHAR2 | 240 | User entered reason for the performing the work order status update. | ||
| STATUS_CODE | VARCHAR2 | 30 | Internal, should not be populated by interfacing application. Indicates the transfer status of this row. SUCCESS or ERROR depending on whether the row was successfully posted to the interface table. | ||
| ERROR_MESSAGE_NAME | VARCHAR2 | 30 | Internal, should not be populated by interfacing application. FND error message name identifying the error that occurred during import. | ||
| TOKEN1_NAME | VARCHAR2 | 30 | Internal, should not be populated by interfacing application. Token name. | ||
| TOKEN1_VALUE | VARCHAR2 | 240 | Internal, should not be populated by interfacing application. Token Value. | ||
| TOKEN2_NAME | VARCHAR2 | 30 | Internal, should not be populated by interfacing application. Token name. | ||
| TOKEN2_VALUE | VARCHAR2 | 240 | Internal, should not be populated by interfacing application. Token Value. | ||
| TOKEN3_NAME | VARCHAR2 | 30 | Internal, should not be populated by interfacing application. Token name. | ||
| TOKEN3_VALUE | VARCHAR2 | 240 | Internal, should not be populated by interfacing application. Token Value. | ||
| TOKEN4_NAME | VARCHAR2 | 30 | Internal, should not be populated by interfacing application. Token name. | ||
| TOKEN4_VALUE | VARCHAR2 | 240 | Internal, should not be populated by interfacing application. Token Value. | ||
| TOKEN5_NAME | VARCHAR2 | 30 | Internal, should not be populated by interfacing application. Token name. | ||
| TOKEN5_VALUE | VARCHAR2 | 20 | Internal, should not be populated by interfacing application. Token Value. | ||
| TOKEN6_NAME | VARCHAR2 | 30 | Internal, should not be populated by interfacing application. Token name. | ||
| TOKEN6_VALUE | VARCHAR2 | 240 | Internal, should not be populated by interfacing application. Token Value. | ||
| MESSAGE_TEXT | VARCHAR2 | 240 | Internal, should not be populated by interfacing application. Expanded, token substituted MESSAGE_TEXT from the FND table. | ||
| INVENTORY_ORGANIZATION_ID | NUMBER | 18 | Yes | Manufacturing organization identifier in which the work order is created for this work order update event. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_WO_UPDATE_EVENTS_GT_PK | Unique | EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID, EVENT_DATE |