DW_CXSR_WORK_ORDER_STATUS_CODE_D_TL

This table contains information about code, name, and description of work order status

Details

Module: Service Request Management

Key Columns

CODE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CODE VARCHAR2 128   True Concatenation of work order integration code and status code.    
SOURCE_RECORD_ID VARCHAR2 128     This column is for Oracle Internal use only. Source record identifier.    
CREATION_DATE TIMESTAMP       Who column: indicates the date and time of the creation of the row.    
DISPLAY_SEQUENCE NUMBER 38 0   Identifies the sequence in which the activity types are displayed in the user interface.    
ENABLED_FLAG VARCHAR2 16     Enabled flag used to identify whether the status is enabled.    
LAST_UPDATE_DATE TIMESTAMP       Who column: indicates the date and time of the last update of the row.    
LANGUAGE VARCHAR2 16     Indicates the code of the language into which the contents of the translatable columns are translated.    
DESCRIPTION VARCHAR2 256     Language dependent, translatable property used to capture the description of the status.    
SOURCE_LANGUAGE VARCHAR2 16     Indicates the code of the language in which the contents of the translatable columns were originally created.    
STATUS_NAME VARCHAR2 128     Language dependent, translatable status name.    

Copyright © 2019, 2026, Oracle and/or its affiliates.