VIEW: MSC.MSC_ST_WO_ATTRIBUTES#

Source

View Text - Preformatted

select WIP_ENTITY_CODE WIP_ENTITY_CODE, SR_INSTANCE_CODE SR_INSTANCE_CODE, SR_INSTANCE_ID SR_INSTANCE_ID, SUPPLY_ID SUPPLY_ID, PRODUCES_TO_STOCK PRODUCES_TO_STOCK, SERIAL_NUM SERIAL_NUM, ORGANIZATION_CODE ORGANIZATION_CODE, ORGANIZATION_ID ORGANIZATION_ID, VISIT_ID VISIT_ID, VISIT_NAME VISIT_NAME, PARAMETER1 PARAMETER1, PARAMETER2 PARAMETER2, PARAMETER3 PARAMETER3, PARAMETER4 PARAMETER4, PARAMETER5 PARAMETER5, PARAMETER6 PARAMETER6, PARAMETER7 PARAMETER7, PARAMETER8 PARAMETER8, PARAMETER9 PARAMETER9, MASTER_WO MASTER_WO, PREV_MILESTONE PREV_MILESTONE, NEXT_MILESTONE NEXT_MILESTONE, DELETED_FLAG DELETED_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REFRESH_ID REFRESH_ID, MESSAGE_ID MESSAGE_ID, PROCESS_FLAG PROCESS_FLAG, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, ST_TRANSACTION_ID ST_TRANSACTION_ID, BATCH_ID BATCH_ID, ERROR_TEXT ERROR_TEXT, ITEM_ALTERNATES_EXIST ITEM_ALTERNATES_EXIST, FLEET_HEADER_ID FLEET_HEADER_ID, PRODUCT_CLASSIFICATION PRODUCT_CLASSIFICATION, MAINTENANCE_REQT MAINTENANCE_REQT, WIP_ENTITY_ID WIP_ENTITY_ID from "MSC"."MSC_ST_WO_ATTRIBUTES"

View Text - HTML Formatted

SELECT WIP_ENTITY_CODE WIP_ENTITY_CODE
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, SR_INSTANCE_ID SR_INSTANCE_ID
, SUPPLY_ID SUPPLY_ID
, PRODUCES_TO_STOCK PRODUCES_TO_STOCK
, SERIAL_NUM SERIAL_NUM
, ORGANIZATION_CODE ORGANIZATION_CODE
, ORGANIZATION_ID ORGANIZATION_ID
, VISIT_ID VISIT_ID
, VISIT_NAME VISIT_NAME
, PARAMETER1 PARAMETER1
, PARAMETER2 PARAMETER2
, PARAMETER3 PARAMETER3
, PARAMETER4 PARAMETER4
, PARAMETER5 PARAMETER5
, PARAMETER6 PARAMETER6
, PARAMETER7 PARAMETER7
, PARAMETER8 PARAMETER8
, PARAMETER9 PARAMETER9
, MASTER_WO MASTER_WO
, PREV_MILESTONE PREV_MILESTONE
, NEXT_MILESTONE NEXT_MILESTONE
, DELETED_FLAG DELETED_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REFRESH_ID REFRESH_ID
, MESSAGE_ID MESSAGE_ID
, PROCESS_FLAG PROCESS_FLAG
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, BATCH_ID BATCH_ID
, ERROR_TEXT ERROR_TEXT
, ITEM_ALTERNATES_EXIST ITEM_ALTERNATES_EXIST
, FLEET_HEADER_ID FLEET_HEADER_ID
, PRODUCT_CLASSIFICATION PRODUCT_CLASSIFICATION
, MAINTENANCE_REQT MAINTENANCE_REQT
, WIP_ENTITY_ID WIP_ENTITY_ID
FROM "MSC"."MSC_ST_WO_ATTRIBUTES"