+- Input[@CanonicalImage = null, @ExcludedLinesCount = 0, @ExcludedRangesCount = 0]
   +- Global[@CanonicalImage = null]
      +- Block[@CanonicalImage = null]
         +- Statement[@CanonicalImage = null]
         |  +- UnlabelledStatement[@CanonicalImage = null]
         |     +- SelectIntoStatement[@All = false, @CanonicalImage = null, @Distinct = false, @Unique = false]
         |        +- SelectList[@CanonicalImage = null]
         |        |  +- SqlExpression[@CanonicalImage = "ADT.ADT_ID", @Image = "adt.adt_id"]
         |        |     +- PrimaryPrefix[@CanonicalImage = "ADT.ADT_ID", @Image = "adt.adt_id", @SelfModifier = false]
         |        |        +- SimpleExpression[@CanonicalImage = "ADT.ADT_ID", @Image = "adt.adt_id"]
         |        |           +- TableName[@CanonicalImage = "ADT", @Image = "adt"]
         |        |           |  +- ID[@CanonicalImage = "ADT", @Image = "adt"]
         |        |           +- Column[@CanonicalImage = "ADT_ID", @Image = "adt_id"]
         |        |              +- ID[@CanonicalImage = "ADT_ID", @Image = "adt_id"]
         |        +- IntoClause[@CanonicalImage = null]
         |        |  +- VariableName[@CanonicalImage = "V_ADT_ID", @Image = "v_adt_id"]
         |        |     +- ID[@CanonicalImage = "V_ADT_ID", @Image = "v_adt_id"]
         |        +- FromClause[@CanonicalImage = null]
         |        |  +- TableReference[@CanonicalImage = null]
         |        |     +- TableName[@CanonicalImage = "ACADEMIC_TITLES", @Image = "academic_titles"]
         |        |     |  +- ID[@CanonicalImage = "ACADEMIC_TITLES", @Image = "academic_titles"]
         |        |     +- TableAlias[@CanonicalImage = "ADT", @Image = "adt"]
         |        |        +- ID[@CanonicalImage = "ADT", @Image = "adt"]
         |        +- WhereClause[@CanonicalImage = null]
         |           +- Condition[@CanonicalImage = null]
         |              +- CompoundCondition[@CanonicalImage = null, @Type = null]
         |                 +- ComparisonCondition[@CanonicalImage = null, @Operator = "="]
         |                    +- SqlExpression[@CanonicalImage = "UPPER", @Image = "UPPER"]
         |                    |  +- PrimaryPrefix[@CanonicalImage = "UPPER", @Image = "UPPER", @SelfModifier = false]
         |                    |     +- FunctionCall[@CanonicalImage = "UPPER", @Image = "UPPER"]
         |                    |        +- FunctionName[@CanonicalImage = "UPPER", @Image = "UPPER"]
         |                    |        |  +- ID[@CanonicalImage = "UPPER", @Image = "UPPER"]
         |                    |        +- Arguments[@ArgumentCount = 1, @CanonicalImage = null]
         |                    |           +- ArgumentList[@CanonicalImage = null]
         |                    |              +- Argument[@CanonicalImage = null]
         |                    |                 +- Expression[@CanonicalImage = "ADT.SHORT_DESCRIPTION", @Image = "adt.short_description"]
         |                    |                    +- PrimaryPrefix[@CanonicalImage = "ADT.SHORT_DESCRIPTION", @Image = "adt.short_description", @SelfModifier = false]
         |                    |                       +- SimpleExpression[@CanonicalImage = "ADT.SHORT_DESCRIPTION", @Image = "adt.short_description"]
         |                    |                          +- TableName[@CanonicalImage = "ADT", @Image = "adt"]
         |                    |                          |  +- ID[@CanonicalImage = "ADT", @Image = "adt"]
         |                    |                          +- Column[@CanonicalImage = "SHORT_DESCRIPTION", @Image = "short_description"]
         |                    |                             +- ID[@CanonicalImage = "SHORT_DESCRIPTION", @Image = "short_description"]
         |                    +- SqlExpression[@CanonicalImage = "UPPER", @Image = "UPPER"]
         |                       +- PrimaryPrefix[@CanonicalImage = "UPPER", @Image = "UPPER", @SelfModifier = false]
         |                          +- FunctionCall[@CanonicalImage = "UPPER", @Image = "UPPER"]
         |                             +- FunctionName[@CanonicalImage = "UPPER", @Image = "UPPER"]
         |                             |  +- ID[@CanonicalImage = "UPPER", @Image = "UPPER"]
         |                             +- Arguments[@ArgumentCount = 1, @CanonicalImage = null]
         |                                +- ArgumentList[@CanonicalImage = null]
         |                                   +- Argument[@CanonicalImage = null]
         |                                      +- Expression[@CanonicalImage = "TITLE_IN", @Image = "title_in"]
         |                                         +- PrimaryPrefix[@CanonicalImage = "TITLE_IN", @Image = "title_in", @SelfModifier = false]
         |                                            +- SimpleExpression[@CanonicalImage = "TITLE_IN", @Image = "title_in"]
         |                                               +- Column[@CanonicalImage = "TITLE_IN", @Image = "title_in"]
         |                                                  +- ID[@CanonicalImage = "TITLE_IN", @Image = "title_in"]
         +- Statement[@CanonicalImage = null]
         |  +- UnlabelledStatement[@CanonicalImage = null]
         |     +- SelectIntoStatement[@All = false, @CanonicalImage = null, @Distinct = false, @Unique = false]
         |        +- SelectList[@CanonicalImage = null]
         |        |  +- SqlExpression[@CanonicalImage = "RGN.RGN_ID", @Image = "rgn.rgn_id"]
         |        |     +- PrimaryPrefix[@CanonicalImage = "RGN.RGN_ID", @Image = "rgn.rgn_id", @SelfModifier = false]
         |        |        +- SimpleExpression[@CanonicalImage = "RGN.RGN_ID", @Image = "rgn.rgn_id"]
         |        |           +- TableName[@CanonicalImage = "RGN", @Image = "rgn"]
         |        |           |  +- ID[@CanonicalImage = "RGN", @Image = "rgn"]
         |        |           +- Column[@CanonicalImage = "RGN_ID", @Image = "rgn_id"]
         |        |              +- ID[@CanonicalImage = "RGN_ID", @Image = "rgn_id"]
         |        +- IntoClause[@CanonicalImage = null]
         |        |  +- VariableName[@CanonicalImage = "V_REGION_ID", @Image = "v_region_id"]
         |        |     +- ID[@CanonicalImage = "V_REGION_ID", @Image = "v_region_id"]
         |        +- FromClause[@CanonicalImage = null]
         |        |  +- TableReference[@CanonicalImage = null]
         |        |     +- TableName[@CanonicalImage = "REGIONS", @Image = "regions"]
         |        |     |  +- ID[@CanonicalImage = "REGIONS", @Image = "regions"]
         |        |     +- TableAlias[@CanonicalImage = "RGN", @Image = "rgn"]
         |        |        +- ID[@CanonicalImage = "RGN", @Image = "rgn"]
         |        +- WhereClause[@CanonicalImage = null]
         |           +- Condition[@CanonicalImage = null]
         |              +- CompoundCondition[@CanonicalImage = null, @Type = "AND"]
         |                 +- Condition[@CanonicalImage = null]
         |                 |  +- CompoundCondition[@CanonicalImage = null, @Type = "OR"]
         |                 |     +- IsNullCondition[@CanonicalImage = "STREET_CNY_CODE_IN IS NULL", @Image = "street_cny_code_in IS NULL"]
         |                 |     |  +- PrimaryPrefix[@CanonicalImage = "STREET_CNY_CODE_IN", @Image = "street_cny_code_in", @SelfModifier = false]
         |                 |     |     +- SimpleExpression[@CanonicalImage = "STREET_CNY_CODE_IN", @Image = "street_cny_code_in"]
         |                 |     |        +- Column[@CanonicalImage = "STREET_CNY_CODE_IN", @Image = "street_cny_code_in"]
         |                 |     |           +- ID[@CanonicalImage = "STREET_CNY_CODE_IN", @Image = "street_cny_code_in"]
         |                 |     +- Condition[@CanonicalImage = null]
         |                 |        +- CompoundCondition[@CanonicalImage = null, @Type = null]
         |                 |           +- ComparisonCondition[@CanonicalImage = null, @Operator = "="]
         |                 |              +- SqlExpression[@CanonicalImage = "RGN.CNY_CODE", @Image = "rgn.cny_code"]
         |                 |              |  +- PrimaryPrefix[@CanonicalImage = "RGN.CNY_CODE", @Image = "rgn.cny_code", @SelfModifier = false]
         |                 |              |     +- SimpleExpression[@CanonicalImage = "RGN.CNY_CODE", @Image = "rgn.cny_code"]
         |                 |              |        +- TableName[@CanonicalImage = "RGN", @Image = "rgn"]
         |                 |              |        |  +- ID[@CanonicalImage = "RGN", @Image = "rgn"]
         |                 |              |        +- Column[@CanonicalImage = "CNY_CODE", @Image = "cny_code"]
         |                 |              |           +- ID[@CanonicalImage = "CNY_CODE", @Image = "cny_code"]
         |                 |              +- SqlExpression[@CanonicalImage = "STREET_CNY_CODE_IN", @Image = "street_cny_code_in"]
         |                 |                 +- PrimaryPrefix[@CanonicalImage = "STREET_CNY_CODE_IN", @Image = "street_cny_code_in", @SelfModifier = false]
         |                 |                    +- SimpleExpression[@CanonicalImage = "STREET_CNY_CODE_IN", @Image = "street_cny_code_in"]
         |                 |                       +- Column[@CanonicalImage = "STREET_CNY_CODE_IN", @Image = "street_cny_code_in"]
         |                 |                          +- ID[@CanonicalImage = "STREET_CNY_CODE_IN", @Image = "street_cny_code_in"]
         |                 +- Condition[@CanonicalImage = null]
         |                    +- CompoundCondition[@CanonicalImage = null, @Type = null]
         |                       +- ComparisonCondition[@CanonicalImage = null, @Operator = "="]
         |                          +- SqlExpression[@CanonicalImage = "UPPER", @Image = "UPPER"]
         |                          |  +- PrimaryPrefix[@CanonicalImage = "UPPER", @Image = "UPPER", @SelfModifier = false]
         |                          |     +- FunctionCall[@CanonicalImage = "UPPER", @Image = "UPPER"]
         |                          |        +- FunctionName[@CanonicalImage = "UPPER", @Image = "UPPER"]
         |                          |        |  +- ID[@CanonicalImage = "UPPER", @Image = "UPPER"]
         |                          |        +- Arguments[@ArgumentCount = 1, @CanonicalImage = null]
         |                          |           +- ArgumentList[@CanonicalImage = null]
         |                          |              +- Argument[@CanonicalImage = null]
         |                          |                 +- Expression[@CanonicalImage = "RGN.NAME", @Image = "rgn.name"]
         |                          |                    +- PrimaryPrefix[@CanonicalImage = "RGN.NAME", @Image = "rgn.name", @SelfModifier = false]
         |                          |                       +- SimpleExpression[@CanonicalImage = "RGN.NAME", @Image = "rgn.name"]
         |                          |                          +- TableName[@CanonicalImage = "RGN", @Image = "rgn"]
         |                          |                          |  +- ID[@CanonicalImage = "RGN", @Image = "rgn"]
         |                          |                          +- Column[@CanonicalImage = "NAME", @Image = "name"]
         |                          |                             +- ID[@CanonicalImage = "NAME", @Image = "name"]
         |                          +- SqlExpression[@CanonicalImage = "UPPER", @Image = "UPPER"]
         |                             +- PrimaryPrefix[@CanonicalImage = "UPPER", @Image = "UPPER", @SelfModifier = false]
         |                                +- FunctionCall[@CanonicalImage = "UPPER", @Image = "UPPER"]
         |                                   +- FunctionName[@CanonicalImage = "UPPER", @Image = "UPPER"]
         |                                   |  +- ID[@CanonicalImage = "UPPER", @Image = "UPPER"]
         |                                   +- Arguments[@ArgumentCount = 1, @CanonicalImage = null]
         |                                      +- ArgumentList[@CanonicalImage = null]
         |                                         +- Argument[@CanonicalImage = null]
         |                                            +- Expression[@CanonicalImage = "STREET_RGN_IN", @Image = "street_rgn_in"]
         |                                               +- PrimaryPrefix[@CanonicalImage = "STREET_RGN_IN", @Image = "street_rgn_in", @SelfModifier = false]
         |                                                  +- SimpleExpression[@CanonicalImage = "STREET_RGN_IN", @Image = "street_rgn_in"]
         |                                                     +- Column[@CanonicalImage = "STREET_RGN_IN", @Image = "street_rgn_in"]
         |                                                        +- ID[@CanonicalImage = "STREET_RGN_IN", @Image = "street_rgn_in"]
         +- Statement[@CanonicalImage = null]
         |  +- UnlabelledStatement[@CanonicalImage = null]
         |     +- SelectIntoStatement[@All = false, @CanonicalImage = null, @Distinct = false, @Unique = false]
         |        +- SelectList[@CanonicalImage = null]
         |        |  +- SqlExpression[@CanonicalImage = "VALUE", @Image = "value"]
         |        |     +- PrimaryPrefix[@CanonicalImage = "VALUE", @Image = "value", @SelfModifier = false]
         |        |        +- SimpleExpression[@CanonicalImage = "VALUE", @Image = "value"]
         |        |           +- Column[@CanonicalImage = "VALUE", @Image = "value"]
         |        |              +- ID[@CanonicalImage = "VALUE", @Image = "value"]
         |        +- IntoClause[@CanonicalImage = null]
         |        |  +- VariableName[@CanonicalImage = "V_VALUE", @Image = "v_value"]
         |        |     +- ID[@CanonicalImage = "V_VALUE", @Image = "v_value"]
         |        +- FromClause[@CanonicalImage = null]
         |        |  +- TableReference[@CanonicalImage = null]
         |        |     +- TableName[@CanonicalImage = "MYTABLE", @Image = "mytable"]
         |        |        +- ID[@CanonicalImage = "MYTABLE", @Image = "mytable"]
         |        +- WhereClause[@CanonicalImage = null]
         |           +- Condition[@CanonicalImage = null]
         |              +- CompoundCondition[@CanonicalImage = null, @Type = null]
         |                 +- ComparisonCondition[@CanonicalImage = null, @Operator = "="]
         |                    +- SqlExpression[@CanonicalImage = "COLNAME", @Image = "colname"]
         |                    |  +- PrimaryPrefix[@CanonicalImage = "COLNAME", @Image = "colname", @SelfModifier = false]
         |                    |     +- SimpleExpression[@CanonicalImage = "COLNAME", @Image = "colname"]
         |                    |        +- Column[@CanonicalImage = "COLNAME", @Image = "colname"]
         |                    |           +- ID[@CanonicalImage = "COLNAME", @Image = "colname"]
         |                    +- SqlExpression[@CanonicalImage = "UTILS.GET_COLNAME", @Image = "utils.get_colname"]
         |                       +- PrimaryPrefix[@CanonicalImage = "UTILS.GET_COLNAME", @Image = "utils.get_colname", @SelfModifier = false]
         |                          +- FunctionCall[@CanonicalImage = "UTILS.GET_COLNAME", @Image = "utils.get_colname"]
         |                             +- FunctionName[@CanonicalImage = "UTILS.GET_COLNAME", @Image = "utils.get_colname"]
         |                             |  +- ID[@CanonicalImage = "UTILS", @Image = "utils"]
         |                             |  +- ID[@CanonicalImage = "GET_COLNAME", @Image = "get_colname"]
         |                             +- Arguments[@ArgumentCount = 1, @CanonicalImage = null]
         |                                +- ArgumentList[@CanonicalImage = null]
         |                                   +- Argument[@CanonicalImage = null]
         |                                      +- Expression[@CanonicalImage = "\'COLUMN_ID\'", @Image = "\'COLUMN_ID\'"]
         |                                         +- PrimaryPrefix[@CanonicalImage = "\'COLUMN_ID\'", @Image = "\'COLUMN_ID\'", @SelfModifier = false]
         |                                            +- Literal[@CanonicalImage = "\'COLUMN_ID\'", @Image = "\'COLUMN_ID\'"]
         |                                               +- StringLiteral[@CanonicalImage = "\'COLUMN_ID\'", @Image = "\'COLUMN_ID\'", @String = "COLUMN_ID"]
         +- Statement[@CanonicalImage = null]
            +- UnlabelledStatement[@CanonicalImage = null]
               +- SelectIntoStatement[@All = false, @CanonicalImage = null, @Distinct = false, @Unique = false]
                  +- SelectList[@CanonicalImage = null]
                  |  +- SqlExpression[@CanonicalImage = "FOO", @Image = "foo"]
                  |     +- PrimaryPrefix[@CanonicalImage = "FOO", @Image = "foo", @SelfModifier = false]
                  |        +- SimpleExpression[@CanonicalImage = "FOO", @Image = "foo"]
                  |           +- Column[@CanonicalImage = "FOO", @Image = "foo"]
                  |              +- ID[@CanonicalImage = "FOO", @Image = "foo"]
                  +- IntoClause[@CanonicalImage = null]
                  |  +- VariableName[@CanonicalImage = "BAR", @Image = "bar"]
                  |     +- ID[@CanonicalImage = "BAR", @Image = "bar"]
                  +- FromClause[@CanonicalImage = null]
                  |  +- TableReference[@CanonicalImage = null]
                  |     +- TableName[@CanonicalImage = "DUAL", @Image = "DUAL"]
                  |        +- ID[@CanonicalImage = "DUAL", @Image = "DUAL"]
                  +- WhereClause[@CanonicalImage = null]
                  |  +- Condition[@CanonicalImage = null]
                  |     +- CompoundCondition[@CanonicalImage = null, @Type = "AND"]
                  |        +- ComparisonCondition[@CanonicalImage = null, @Operator = "="]
                  |        |  +- SqlExpression[@CanonicalImage = "A", @Image = "a"]
                  |        |  |  +- PrimaryPrefix[@CanonicalImage = "A", @Image = "a", @SelfModifier = false]
                  |        |  |     +- SimpleExpression[@CanonicalImage = "A", @Image = "a"]
                  |        |  |        +- Column[@CanonicalImage = "A", @Image = "a"]
                  |        |  |           +- ID[@CanonicalImage = "A", @Image = "a"]
                  |        |  +- SqlExpression[@CanonicalImage = "1", @Image = "1"]
                  |        |     +- PrimaryPrefix[@CanonicalImage = "1", @Image = "1", @SelfModifier = false]
                  |        |        +- Literal[@CanonicalImage = "1", @Image = "1"]
                  |        |           +- NumericLiteral[@CanonicalImage = "1", @Image = "1"]
                  |        +- Condition[@CanonicalImage = null]
                  |           +- CompoundCondition[@CanonicalImage = null, @Type = "AND"]
                  |              +- ComparisonCondition[@CanonicalImage = null, @Operator = "="]
                  |              |  +- SqlExpression[@CanonicalImage = "B", @Image = "b"]
                  |              |  |  +- PrimaryPrefix[@CanonicalImage = "B", @Image = "b", @SelfModifier = false]
                  |              |  |     +- SimpleExpression[@CanonicalImage = "B", @Image = "b"]
                  |              |  |        +- Column[@CanonicalImage = "B", @Image = "b"]
                  |              |  |           +- ID[@CanonicalImage = "B", @Image = "b"]
                  |              |  +- SqlExpression[@CanonicalImage = "2", @Image = "2"]
                  |              |     +- PrimaryPrefix[@CanonicalImage = "2", @Image = "2", @SelfModifier = false]
                  |              |        +- Literal[@CanonicalImage = "2", @Image = "2"]
                  |              |           +- NumericLiteral[@CanonicalImage = "2", @Image = "2"]
                  |              +- Condition[@CanonicalImage = null]
                  |                 +- CompoundCondition[@CanonicalImage = null, @Type = null]
                  |                    +- ComparisonCondition[@CanonicalImage = null, @Operator = "="]
                  |                       +- SqlExpression[@CanonicalImage = "NVL", @Image = "NVL"]
                  |                       |  +- PrimaryPrefix[@CanonicalImage = "NVL", @Image = "NVL", @SelfModifier = false]
                  |                       |     +- FunctionCall[@CanonicalImage = "NVL", @Image = "NVL"]
                  |                       |        +- FunctionName[@CanonicalImage = "NVL", @Image = "NVL"]
                  |                       |        |  +- ID[@CanonicalImage = "NVL", @Image = "NVL"]
                  |                       |        +- Arguments[@ArgumentCount = 2, @CanonicalImage = null]
                  |                       |           +- ArgumentList[@CanonicalImage = null]
                  |                       |              +- Argument[@CanonicalImage = null]
                  |                       |              |  +- Expression[@CanonicalImage = "INSTR", @Image = "INSTR"]
                  |                       |              |     +- PrimaryPrefix[@CanonicalImage = "INSTR", @Image = "INSTR", @SelfModifier = false]
                  |                       |              |        +- FunctionCall[@CanonicalImage = "INSTR", @Image = "INSTR"]
                  |                       |              |           +- FunctionName[@CanonicalImage = "INSTR", @Image = "INSTR"]
                  |                       |              |           |  +- ID[@CanonicalImage = "INSTR", @Image = "INSTR"]
                  |                       |              |           +- Arguments[@ArgumentCount = 1, @CanonicalImage = null]
                  |                       |              |              +- ArgumentList[@CanonicalImage = null]
                  |                       |              |                 +- Argument[@CanonicalImage = null]
                  |                       |              |                    +- Expression[@CanonicalImage = "C || D", @Image = "c || d"]
                  |                       |              |                       +- AdditiveExpression[@CanonicalImage = "C || D", @Image = "c || d"]
                  |                       |              |                          +- PrimaryPrefix[@CanonicalImage = "C", @Image = "c", @SelfModifier = false]
                  |                       |              |                          |  +- SimpleExpression[@CanonicalImage = "C", @Image = "c"]
                  |                       |              |                          |     +- Column[@CanonicalImage = "C", @Image = "c"]
                  |                       |              |                          |        +- ID[@CanonicalImage = "C", @Image = "c"]
                  |                       |              |                          +- PrimaryPrefix[@CanonicalImage = "D", @Image = "d", @SelfModifier = false]
                  |                       |              |                             +- SimpleExpression[@CanonicalImage = "D", @Image = "d"]
                  |                       |              |                                +- Column[@CanonicalImage = "D", @Image = "d"]
                  |                       |              |                                   +- ID[@CanonicalImage = "D", @Image = "d"]
                  |                       |              +- Argument[@CanonicalImage = null]
                  |                       |                 +- Expression[@CanonicalImage = "3", @Image = "3"]
                  |                       |                    +- PrimaryPrefix[@CanonicalImage = "3", @Image = "3", @SelfModifier = false]
                  |                       |                       +- Literal[@CanonicalImage = "3", @Image = "3"]
                  |                       |                          +- NumericLiteral[@CanonicalImage = "3", @Image = "3"]
                  |                       +- SqlExpression[@CanonicalImage = "3", @Image = "3"]
                  |                          +- PrimaryPrefix[@CanonicalImage = "3", @Image = "3", @SelfModifier = false]
                  |                             +- Literal[@CanonicalImage = "3", @Image = "3"]
                  |                                +- NumericLiteral[@CanonicalImage = "3", @Image = "3"]
                  +- OrderByClause[@CanonicalImage = null]
                     +- SqlExpression[@CanonicalImage = "1", @Image = "1"]
                        +- PrimaryPrefix[@CanonicalImage = "1", @Image = "1", @SelfModifier = false]
                           +- Literal[@CanonicalImage = "1", @Image = "1"]
                              +- NumericLiteral[@CanonicalImage = "1", @Image = "1"]
