DBA Data[Home] [Help] [Dependency Information]

VIEW: GMO.GMO_BATCH_PROGRESSION#

Object Details
Object Name: GMO_BATCH_PROGRESSION#
Object Type: VIEW
Owner: GMO
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PROGRESSION_ID NUMBER (22) Yes
BATCH_ID NUMBER (22)
BATCHSTEP_ID NUMBER (22)
MATERIAL_LINE_ID NUMBER (22)
BATCHACTIVITY_ID NUMBER (22)
BATCHRSRC_ID NUMBER (22)
DISPENSE_ID NUMBER (22)
SAMPLE_ID NUMBER (22)
DEVIATION_ID NUMBER (22)
TRANSACTION_ID NUMBER (22)
PARENT_NODE VARCHAR2 (200)
PARENT_KEY_NODE VARCHAR2 (200)
PARENT_KEY_VAL VARCHAR2 (200)
CURR_NODE_KEY VARCHAR2 (200)
CURR_KEY_VAL VARCHAR2 (200)
USER_KEY_LABEL_PROD VARCHAR2 (10)
USER_KEY_LABEL_TOKEN VARCHAR2 (200)
USER_KEY_LABEL VARCHAR2 (2000)
USER_KEY_VALUE VARCHAR2 (2000)
EXTERNAL_EVENT VARCHAR2 (2000)
INCLUDE_IN_CBR VARCHAR2 (100)
EVENT VARCHAR2 (200)
EVENT_KEY VARCHAR2 (200)
EVENT_DATE DATE

PLANED_START_DATE DATE

ERECORD_ID NUMBER (22)
XML_EREC CLOB (4000)
STATUS VARCHAR2 (200)
INCLUDED_IN_CBR VARCHAR2 (1)
XML_MAP_CODE VARCHAR2 (40)
COMPARE_XML VARCHAR2 (1)
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

GMO.GMO_BATCH_PROGRESSION# references the following:

SchemaGMO
TableGMO_BATCH_PROGRESSION
GMO.GMO_BATCH_PROGRESSION# is referenced by following:

SchemaAPPS
SynonymGMO_BATCH_PROGRESSION