VIEW: GMO.GMO_BATCH_PROGRESSION#

Source

View Text - Preformatted

select PROGRESSION_ID PROGRESSION_ID, BATCH_ID BATCH_ID, BATCHSTEP_ID BATCHSTEP_ID, MATERIAL_LINE_ID MATERIAL_LINE_ID, BATCHACTIVITY_ID BATCHACTIVITY_ID, BATCHRSRC_ID BATCHRSRC_ID, DISPENSE_ID DISPENSE_ID, SAMPLE_ID SAMPLE_ID, DEVIATION_ID DEVIATION_ID, TRANSACTION_ID TRANSACTION_ID, PARENT_NODE PARENT_NODE, PARENT_KEY_NODE PARENT_KEY_NODE, PARENT_KEY_VAL PARENT_KEY_VAL, CURR_NODE_KEY CURR_NODE_KEY, CURR_KEY_VAL CURR_KEY_VAL, USER_KEY_LABEL_PROD USER_KEY_LABEL_PROD, USER_KEY_LABEL_TOKEN USER_KEY_LABEL_TOKEN, USER_KEY_LABEL USER_KEY_LABEL, USER_KEY_VALUE USER_KEY_VALUE, EXTERNAL_EVENT EXTERNAL_EVENT, INCLUDE_IN_CBR INCLUDE_IN_CBR, EVENT EVENT, EVENT_KEY EVENT_KEY, EVENT_DATE EVENT_DATE, PLANED_START_DATE PLANED_START_DATE, ERECORD_ID ERECORD_ID, XML_EREC XML_EREC, STATUS STATUS, INCLUDED_IN_CBR INCLUDED_IN_CBR, XML_MAP_CODE XML_MAP_CODE, COMPARE_XML COMPARE_XML from "GMO"."GMO_BATCH_PROGRESSION"

View Text - HTML Formatted

SELECT PROGRESSION_ID PROGRESSION_ID
, BATCH_ID BATCH_ID
, BATCHSTEP_ID BATCHSTEP_ID
, MATERIAL_LINE_ID MATERIAL_LINE_ID
, BATCHACTIVITY_ID BATCHACTIVITY_ID
, BATCHRSRC_ID BATCHRSRC_ID
, DISPENSE_ID DISPENSE_ID
, SAMPLE_ID SAMPLE_ID
, DEVIATION_ID DEVIATION_ID
, TRANSACTION_ID TRANSACTION_ID
, PARENT_NODE PARENT_NODE
, PARENT_KEY_NODE PARENT_KEY_NODE
, PARENT_KEY_VAL PARENT_KEY_VAL
, CURR_NODE_KEY CURR_NODE_KEY
, CURR_KEY_VAL CURR_KEY_VAL
, USER_KEY_LABEL_PROD USER_KEY_LABEL_PROD
, USER_KEY_LABEL_TOKEN USER_KEY_LABEL_TOKEN
, USER_KEY_LABEL USER_KEY_LABEL
, USER_KEY_VALUE USER_KEY_VALUE
, EXTERNAL_EVENT EXTERNAL_EVENT
, INCLUDE_IN_CBR INCLUDE_IN_CBR
, EVENT EVENT
, EVENT_KEY EVENT_KEY
, EVENT_DATE EVENT_DATE
, PLANED_START_DATE PLANED_START_DATE
, ERECORD_ID ERECORD_ID
, XML_EREC XML_EREC
, STATUS STATUS
, INCLUDED_IN_CBR INCLUDED_IN_CBR
, XML_MAP_CODE XML_MAP_CODE
, COMPARE_XML COMPARE_XML
FROM "GMO"."GMO_BATCH_PROGRESSION"