1. Tables and Views for SCM
  2. CST_WO_UPDATE_EVENT_TXNS_GT

CST_WO_UPDATE_EVENT_TXNS_GT

This table stores the work order close transactions before they are inserted into the persistent table.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Not-null Comments
CST_WORK_ORDER_ID NUMBER 18 Yes Surrogate ID identifying the work order for which update was performed.
COST_ORG_ID NUMBER 18 Yes Surrogate ID identifying the cost organization associated to the plant where the work order is executed.
COST_BOOK_ID NUMBER 18 Yes Surrogate ID identifying the cost book associated to the cost organization.
EVENT_DATE TIMESTAMP Yes Indicates the date and time when the work order update was performed.
TRANSACTION_DATE TIMESTAMP Indiates the date entered by the user while making the status change.
CST_WO_UPDATE_EVENT_ID NUMBER 18 Yes Surrogate ID identifying the source update event in costing.
INVENTORY_ORGANIZATION_ID NUMBER 18 Yes Surrogate ID identifying the plant associated to the work order.
TXN_SOURCE_DOC_TYPE VARCHAR2 50 Document Type of the transaction. E.g. "WO" indicating a Work Order.
TXN_SOURCE_DOC_NUMBER VARCHAR2 240 Document Number of the transaction. This is the Work Order Number.
TXN_SOURCE_REF_DOC_TYPE VARCHAR2 50 For R11, this is the same as the Transaction Source Doc Type. In later release this can be a FPO linked to a WO.
TXN_SOURCE_REF_DOC_NUMBER VARCHAR2 240 For R11, this is the same as the Transaction Source Doc Number. In later release this can be a FPO Number linked to a WO.
BASE_TXN_TYPE_ID NUMBER 18 Yes Transaction type identifier. For close transactions this value comes from CST_INTERNAL_TXN_TYPES_VL.
BASE_TXN_SOURCE_TYPE_ID NUMBER 18 Yes Transaction source type identifier. For close transactions this value will come from CST_INTERNAL_TXN_TYPES_VL. This value will always be 0.
BASE_TXN_ACTION_ID NUMBER 18 Yes Transaction action identifier. For close transactions this value will come from CST_INTERNAL_TXN_TYPES_VL.
ITEM_COST_PROFILE_ID NUMBER 18 Identifies the item cost profile of the primary product of the Work Order associated to the resource transaction.
COST_PROFILE_ID NUMBER 18 Surrogate ID identifying the cost profile.
COST_METHOD_CODE VARCHAR2 30 Cost method associated with ?? cost profile of the primary item. This will be used to determine how to process the job close transaction eg. to expense or create variance.
TOTAL_COMPLETION_QUANTITY NUMBER This value would be populated at the time of processing this transaction to indicate the total completion quantity.
UOM_CODE VARCHAR2 3 Indicates the unit of measure code for the completion quantity.
PRODUCT_ADJ_PROCESSED_FLAG VARCHAR2 1 Yes Indicates if product completions and returns have been adjusted after the work order close to reflect the latest WIP value. Default N. Valid values are X, N and Y.
SCRAP_ADJ_PROCESSED_FLAG VARCHAR2 1 Yes Indicates if scrap and scrap returns have been adjusted after the work order close to reflect the latest WIP value. Default N. Valid values are X, N and Y.
WORK_ORDER_STATUS_ID NUMBER 18 Yes Indicates the current status of the work order after the update.
PRIOR_WORK_ORDER_STATUS_ID NUMBER 18 Indicates the prior status of the work order before the update was performed.
WO_SYSTEM_STATUS_CODE VARCHAR2 30 Yes Indicates the system status code derived using WIE_WO_STATUSES_VL.
PRIOR_WO_SYSTEM_STATUS_CODE VARCHAR2 30 Indicates the prior system status code derived using WIE_WO_STATUSES_VL.
INVENTORY_ITEM_ID NUMBER 18 Yes Surrogate ID identifying the primary item associated to the work order.
POSTED_FLAG VARCHAR2 5 Indicates the posted flag of the transaction.
PREPROCESSING_STATUS VARCHAR2 30 Yes Indicates the preprocessing status for the transaction. SUCCESS - ERROR.
ERROR_CODE VARCHAR2 30 FND error code identifying the error message in case the transaction is in error.