+- Input[@CanonicalImage = null, @ExcludedLinesCount = 0, @ExcludedRangesCount = 0]
   +- Global[@CanonicalImage = null]
      +- Block[@CanonicalImage = null]
         +- DeclarativeSection[@CanonicalImage = null]
         |  +- DeclarativeUnit[@CanonicalImage = null]
         |  |  +- SubTypeDefinition[@CanonicalImage = "T_CMER_IDS", @Image = "t_cmer_ids"]
         |  |     +- QualifiedID[@CanonicalImage = "T_CMER_IDS", @Image = "t_cmer_ids"]
         |  |     +- Datatype[@CanonicalImage = "COMP_MPRC_EMP_ROLE.ID%TYPE", @Image = "comp_mprc_emp_role.id%TYPE", @TypeImage = "comp_mprc_emp_role.id%TYPE"]
         |  |        +- QualifiedName[@CanonicalImage = "COMP_MPRC_EMP_ROLE.ID", @Image = "comp_mprc_emp_role.id"]
         |  |           +- UnqualifiedID[@CanonicalImage = "COMP_MPRC_EMP_ROLE", @Image = "comp_mprc_emp_role"]
         |  |           +- QualifiedID[@CanonicalImage = "ID", @Image = "id"]
         |  +- DeclarativeUnit[@CanonicalImage = null]
         |  |  +- SubTypeDefinition[@CanonicalImage = "T_VERSIONS", @Image = "t_versions"]
         |  |     +- QualifiedID[@CanonicalImage = "T_VERSIONS", @Image = "t_versions"]
         |  |     +- Datatype[@CanonicalImage = "COMP_MPRC_EMP_ROLE.VERSION%TYPE", @Image = "comp_mprc_emp_role.version%TYPE", @TypeImage = "comp_mprc_emp_role.version%TYPE"]
         |  |        +- QualifiedName[@CanonicalImage = "COMP_MPRC_EMP_ROLE.VERSION", @Image = "comp_mprc_emp_role.version"]
         |  |           +- UnqualifiedID[@CanonicalImage = "COMP_MPRC_EMP_ROLE", @Image = "comp_mprc_emp_role"]
         |  |           +- QualifiedID[@CanonicalImage = "VERSION", @Image = "version"]
         |  +- DeclarativeUnit[@CanonicalImage = null]
         |  |  +- SubTypeDefinition[@CanonicalImage = "T_CMP_IDS", @Image = "t_cmp_ids"]
         |  |     +- QualifiedID[@CanonicalImage = "T_CMP_IDS", @Image = "t_cmp_ids"]
         |  |     +- Datatype[@CanonicalImage = "COMP_MPRC_EMP_ROLE.CMP_ID%TYPE", @Image = "comp_mprc_emp_role.cmp_id%TYPE", @TypeImage = "comp_mprc_emp_role.cmp_id%TYPE"]
         |  |        +- QualifiedName[@CanonicalImage = "COMP_MPRC_EMP_ROLE.CMP_ID", @Image = "comp_mprc_emp_role.cmp_id"]
         |  |           +- UnqualifiedID[@CanonicalImage = "COMP_MPRC_EMP_ROLE", @Image = "comp_mprc_emp_role"]
         |  |           +- QualifiedID[@CanonicalImage = "CMP_ID", @Image = "cmp_id"]
         |  +- DeclarativeUnit[@CanonicalImage = null]
         |  |  +- SubTypeDefinition[@CanonicalImage = "T_MPRC_CODES", @Image = "t_mprc_codes"]
         |  |     +- QualifiedID[@CanonicalImage = "T_MPRC_CODES", @Image = "t_mprc_codes"]
         |  |     +- Datatype[@CanonicalImage = "COMP_MPRC_EMP_ROLE.MPRC_CODE%TYPE", @Image = "comp_mprc_emp_role.mprc_code%TYPE", @TypeImage = "comp_mprc_emp_role.mprc_code%TYPE"]
         |  |        +- QualifiedName[@CanonicalImage = "COMP_MPRC_EMP_ROLE.MPRC_CODE", @Image = "comp_mprc_emp_role.mprc_code"]
         |  |           +- UnqualifiedID[@CanonicalImage = "COMP_MPRC_EMP_ROLE", @Image = "comp_mprc_emp_role"]
         |  |           +- QualifiedID[@CanonicalImage = "MPRC_CODE", @Image = "mprc_code"]
         |  +- DeclarativeUnit[@CanonicalImage = null]
         |  |  +- SubTypeDefinition[@CanonicalImage = "T_EMP_IDS", @Image = "t_emp_ids"]
         |  |     +- QualifiedID[@CanonicalImage = "T_EMP_IDS", @Image = "t_emp_ids"]
         |  |     +- Datatype[@CanonicalImage = "COMP_MPRC_EMP_ROLE.EMP_ID%TYPE", @Image = "comp_mprc_emp_role.emp_id%TYPE", @TypeImage = "comp_mprc_emp_role.emp_id%TYPE"]
         |  |        +- QualifiedName[@CanonicalImage = "COMP_MPRC_EMP_ROLE.EMP_ID", @Image = "comp_mprc_emp_role.emp_id"]
         |  |           +- UnqualifiedID[@CanonicalImage = "COMP_MPRC_EMP_ROLE", @Image = "comp_mprc_emp_role"]
         |  |           +- QualifiedID[@CanonicalImage = "EMP_ID", @Image = "emp_id"]
         |  +- DeclarativeUnit[@CanonicalImage = null]
         |  |  +- SubTypeDefinition[@CanonicalImage = "T_EMP_ROLE_CODES", @Image = "t_emp_role_codes"]
         |  |     +- QualifiedID[@CanonicalImage = "T_EMP_ROLE_CODES", @Image = "t_emp_role_codes"]
         |  |     +- Datatype[@CanonicalImage = "COMP_MPRC_EMP_ROLE.EMP_ROLE_CODE%TYPE", @Image = "comp_mprc_emp_role.emp_role_code%TYPE", @TypeImage = "comp_mprc_emp_role.emp_role_code%TYPE"]
         |  |        +- QualifiedName[@CanonicalImage = "COMP_MPRC_EMP_ROLE.EMP_ROLE_CODE", @Image = "comp_mprc_emp_role.emp_role_code"]
         |  |           +- UnqualifiedID[@CanonicalImage = "COMP_MPRC_EMP_ROLE", @Image = "comp_mprc_emp_role"]
         |  |           +- QualifiedID[@CanonicalImage = "EMP_ROLE_CODE", @Image = "emp_role_code"]
         |  +- DeclarativeUnit[@CanonicalImage = null]
         |  |  +- SubTypeDefinition[@CanonicalImage = "T_GSN_IDS", @Image = "t_gsn_ids"]
         |  |     +- QualifiedID[@CanonicalImage = "T_GSN_IDS", @Image = "t_gsn_ids"]
         |  |     +- Datatype[@CanonicalImage = "COMP_MPRC_EMP_ROLE.GSN_ID%TYPE", @Image = "comp_mprc_emp_role.gsn_id%TYPE", @TypeImage = "comp_mprc_emp_role.gsn_id%TYPE"]
         |  |        +- QualifiedName[@CanonicalImage = "COMP_MPRC_EMP_ROLE.GSN_ID", @Image = "comp_mprc_emp_role.gsn_id"]
         |  |           +- UnqualifiedID[@CanonicalImage = "COMP_MPRC_EMP_ROLE", @Image = "comp_mprc_emp_role"]
         |  |           +- QualifiedID[@CanonicalImage = "GSN_ID", @Image = "gsn_id"]
         |  +- DeclarativeUnit[@CanonicalImage = null]
         |  |  +- SubTypeDefinition[@CanonicalImage = "T_DEP_CODES", @Image = "t_dep_codes"]
         |  |     +- QualifiedID[@CanonicalImage = "T_DEP_CODES", @Image = "t_dep_codes"]
         |  |     +- Datatype[@CanonicalImage = "COMP_MPRC_EMP_ROLE.DEP_CODE%TYPE", @Image = "comp_mprc_emp_role.dep_code%TYPE", @TypeImage = "comp_mprc_emp_role.dep_code%TYPE"]
         |  |        +- QualifiedName[@CanonicalImage = "COMP_MPRC_EMP_ROLE.DEP_CODE", @Image = "comp_mprc_emp_role.dep_code"]
         |  |           +- UnqualifiedID[@CanonicalImage = "COMP_MPRC_EMP_ROLE", @Image = "comp_mprc_emp_role"]
         |  |           +- QualifiedID[@CanonicalImage = "DEP_CODE", @Image = "dep_code"]
         |  +- DeclarativeUnit[@CanonicalImage = null]
         |  |  +- SubTypeDefinition[@CanonicalImage = "T_VALIDFROMS", @Image = "t_validfroms"]
         |  |     +- QualifiedID[@CanonicalImage = "T_VALIDFROMS", @Image = "t_validfroms"]
         |  |     +- Datatype[@CanonicalImage = "DATE", @Image = "DATE", @TypeImage = "DATE"]
         |  |        +- ScalarDataTypeName[@CanonicalImage = "DATE", @Image = "DATE"]
         |  +- DeclarativeUnit[@CanonicalImage = null]
         |  |  +- SubTypeDefinition[@CanonicalImage = "T_VALIDTOS", @Image = "t_validtos"]
         |  |     +- QualifiedID[@CanonicalImage = "T_VALIDTOS", @Image = "t_validtos"]
         |  |     +- Datatype[@CanonicalImage = "DATE", @Image = "DATE", @TypeImage = "DATE"]
         |  |        +- ScalarDataTypeName[@CanonicalImage = "DATE", @Image = "DATE"]
         |  +- DeclarativeUnit[@CanonicalImage = null]
         |  |  +- SubTypeDefinition[@CanonicalImage = "T_FL_ACTIVES", @Image = "t_fl_actives"]
         |  |     +- QualifiedID[@CanonicalImage = "T_FL_ACTIVES", @Image = "t_fl_actives"]
         |  |     +- Datatype[@CanonicalImage = "VARCHAR2(1)", @Image = "VARCHAR2(1)", @TypeImage = "VARCHAR2(1)"]
         |  |        +- ScalarDataTypeName[@CanonicalImage = "VARCHAR2(1)", @Image = "VARCHAR2(1)"]
         |  |           +- NumericLiteral[@CanonicalImage = "1", @Image = "1"]
         |  +- DeclarativeUnit[@CanonicalImage = null]
         |  |  +- SubTypeDefinition[@CanonicalImage = "T_REPORTING_LISTS", @Image = "t_reporting_lists"]
         |  |     +- QualifiedID[@CanonicalImage = "T_REPORTING_LISTS", @Image = "t_reporting_lists"]
         |  |     +- Datatype[@CanonicalImage = "V_SFM_EMP_ROLE_CNY_REPG.REPORTING_GROUPS%TYPE", @Image = "v_sfm_emp_role_cny_repg.reporting_groups%TYPE", @TypeImage = "v_sfm_emp_role_cny_repg.reporting_groups%TYPE"]
         |  |        +- QualifiedName[@CanonicalImage = "V_SFM_EMP_ROLE_CNY_REPG.REPORTING_GROUPS", @Image = "v_sfm_emp_role_cny_repg.reporting_groups"]
         |  |           +- UnqualifiedID[@CanonicalImage = "V_SFM_EMP_ROLE_CNY_REPG", @Image = "v_sfm_emp_role_cny_repg"]
         |  |           +- QualifiedID[@CanonicalImage = "REPORTING_GROUPS", @Image = "reporting_groups"]
         |  +- DeclarativeUnit[@CanonicalImage = null]
         |  |  +- VariableOrConstantDeclaration[@CanonicalImage = null]
         |  |     +- VariableOrConstantDeclarator[@CanonicalImage = "V_CMER_IDS T_CMER_IDS", @Image = "v_cmer_ids t_cmer_ids"]
         |  |        +- VariableOrConstantDeclaratorId[@Array = false, @ArrayDepth = 0, @CanonicalImage = "V_CMER_IDS", @Image = "v_cmer_ids"]
         |  |        |  +- ID[@CanonicalImage = "V_CMER_IDS", @Image = "v_cmer_ids"]
         |  |        +- Datatype[@CanonicalImage = "T_CMER_IDS", @Image = "t_cmer_ids", @TypeImage = "t_cmer_ids"]
         |  |           +- QualifiedName[@CanonicalImage = "T_CMER_IDS", @Image = "t_cmer_ids"]
         |  |              +- UnqualifiedID[@CanonicalImage = "T_CMER_IDS", @Image = "t_cmer_ids"]
         |  +- DeclarativeUnit[@CanonicalImage = null]
         |  |  +- VariableOrConstantDeclaration[@CanonicalImage = null]
         |  |     +- VariableOrConstantDeclarator[@CanonicalImage = "V_VERSIONS T_VERSIONS", @Image = "v_versions t_versions"]
         |  |        +- VariableOrConstantDeclaratorId[@Array = false, @ArrayDepth = 0, @CanonicalImage = "V_VERSIONS", @Image = "v_versions"]
         |  |        |  +- ID[@CanonicalImage = "V_VERSIONS", @Image = "v_versions"]
         |  |        +- Datatype[@CanonicalImage = "T_VERSIONS", @Image = "t_versions", @TypeImage = "t_versions"]
         |  |           +- QualifiedName[@CanonicalImage = "T_VERSIONS", @Image = "t_versions"]
         |  |              +- UnqualifiedID[@CanonicalImage = "T_VERSIONS", @Image = "t_versions"]
         |  +- DeclarativeUnit[@CanonicalImage = null]
         |  |  +- VariableOrConstantDeclaration[@CanonicalImage = null]
         |  |     +- VariableOrConstantDeclarator[@CanonicalImage = "V_CMP_IDS T_CMP_IDS", @Image = "v_cmp_ids t_cmp_ids"]
         |  |        +- VariableOrConstantDeclaratorId[@Array = false, @ArrayDepth = 0, @CanonicalImage = "V_CMP_IDS", @Image = "v_cmp_ids"]
         |  |        |  +- ID[@CanonicalImage = "V_CMP_IDS", @Image = "v_cmp_ids"]
         |  |        +- Datatype[@CanonicalImage = "T_CMP_IDS", @Image = "t_cmp_ids", @TypeImage = "t_cmp_ids"]
         |  |           +- QualifiedName[@CanonicalImage = "T_CMP_IDS", @Image = "t_cmp_ids"]
         |  |              +- UnqualifiedID[@CanonicalImage = "T_CMP_IDS", @Image = "t_cmp_ids"]
         |  +- DeclarativeUnit[@CanonicalImage = null]
         |  |  +- VariableOrConstantDeclaration[@CanonicalImage = null]
         |  |     +- VariableOrConstantDeclarator[@CanonicalImage = "V_MPRC_CODES T_MPRC_CODES", @Image = "v_mprc_codes t_mprc_codes"]
         |  |        +- VariableOrConstantDeclaratorId[@Array = false, @ArrayDepth = 0, @CanonicalImage = "V_MPRC_CODES", @Image = "v_mprc_codes"]
         |  |        |  +- ID[@CanonicalImage = "V_MPRC_CODES", @Image = "v_mprc_codes"]
         |  |        +- Datatype[@CanonicalImage = "T_MPRC_CODES", @Image = "t_mprc_codes", @TypeImage = "t_mprc_codes"]
         |  |           +- QualifiedName[@CanonicalImage = "T_MPRC_CODES", @Image = "t_mprc_codes"]
         |  |              +- UnqualifiedID[@CanonicalImage = "T_MPRC_CODES", @Image = "t_mprc_codes"]
         |  +- DeclarativeUnit[@CanonicalImage = null]
         |  |  +- VariableOrConstantDeclaration[@CanonicalImage = null]
         |  |     +- VariableOrConstantDeclarator[@CanonicalImage = "V_EMP_IDS T_EMP_IDS", @Image = "v_emp_ids t_emp_ids"]
         |  |        +- VariableOrConstantDeclaratorId[@Array = false, @ArrayDepth = 0, @CanonicalImage = "V_EMP_IDS", @Image = "v_emp_ids"]
         |  |        |  +- ID[@CanonicalImage = "V_EMP_IDS", @Image = "v_emp_ids"]
         |  |        +- Datatype[@CanonicalImage = "T_EMP_IDS", @Image = "t_emp_ids", @TypeImage = "t_emp_ids"]
         |  |           +- QualifiedName[@CanonicalImage = "T_EMP_IDS", @Image = "t_emp_ids"]
         |  |              +- UnqualifiedID[@CanonicalImage = "T_EMP_IDS", @Image = "t_emp_ids"]
         |  +- DeclarativeUnit[@CanonicalImage = null]
         |  |  +- VariableOrConstantDeclaration[@CanonicalImage = null]
         |  |     +- VariableOrConstantDeclarator[@CanonicalImage = "V_EMP_ROLE_CODES T_EMP_ROLE_CODES", @Image = "v_emp_role_codes t_emp_role_codes"]
         |  |        +- VariableOrConstantDeclaratorId[@Array = false, @ArrayDepth = 0, @CanonicalImage = "V_EMP_ROLE_CODES", @Image = "v_emp_role_codes"]
         |  |        |  +- ID[@CanonicalImage = "V_EMP_ROLE_CODES", @Image = "v_emp_role_codes"]
         |  |        +- Datatype[@CanonicalImage = "T_EMP_ROLE_CODES", @Image = "t_emp_role_codes", @TypeImage = "t_emp_role_codes"]
         |  |           +- QualifiedName[@CanonicalImage = "T_EMP_ROLE_CODES", @Image = "t_emp_role_codes"]
         |  |              +- UnqualifiedID[@CanonicalImage = "T_EMP_ROLE_CODES", @Image = "t_emp_role_codes"]
         |  +- DeclarativeUnit[@CanonicalImage = null]
         |  |  +- VariableOrConstantDeclaration[@CanonicalImage = null]
         |  |     +- VariableOrConstantDeclarator[@CanonicalImage = "V_GSN_IDS T_GSN_IDS", @Image = "v_gsn_ids t_gsn_ids"]
         |  |        +- VariableOrConstantDeclaratorId[@Array = false, @ArrayDepth = 0, @CanonicalImage = "V_GSN_IDS", @Image = "v_gsn_ids"]
         |  |        |  +- ID[@CanonicalImage = "V_GSN_IDS", @Image = "v_gsn_ids"]
         |  |        +- Datatype[@CanonicalImage = "T_GSN_IDS", @Image = "t_gsn_ids", @TypeImage = "t_gsn_ids"]
         |  |           +- QualifiedName[@CanonicalImage = "T_GSN_IDS", @Image = "t_gsn_ids"]
         |  |              +- UnqualifiedID[@CanonicalImage = "T_GSN_IDS", @Image = "t_gsn_ids"]
         |  +- DeclarativeUnit[@CanonicalImage = null]
         |  |  +- VariableOrConstantDeclaration[@CanonicalImage = null]
         |  |     +- VariableOrConstantDeclarator[@CanonicalImage = "V_DEP_CODES T_DEP_CODES", @Image = "v_dep_codes t_dep_codes"]
         |  |        +- VariableOrConstantDeclaratorId[@Array = false, @ArrayDepth = 0, @CanonicalImage = "V_DEP_CODES", @Image = "v_dep_codes"]
         |  |        |  +- ID[@CanonicalImage = "V_DEP_CODES", @Image = "v_dep_codes"]
         |  |        +- Datatype[@CanonicalImage = "T_DEP_CODES", @Image = "t_dep_codes", @TypeImage = "t_dep_codes"]
         |  |           +- QualifiedName[@CanonicalImage = "T_DEP_CODES", @Image = "t_dep_codes"]
         |  |              +- UnqualifiedID[@CanonicalImage = "T_DEP_CODES", @Image = "t_dep_codes"]
         |  +- DeclarativeUnit[@CanonicalImage = null]
         |  |  +- VariableOrConstantDeclaration[@CanonicalImage = null]
         |  |     +- VariableOrConstantDeclarator[@CanonicalImage = "V_VALIDFROMS T_VALIDFROMS", @Image = "v_validfroms t_validfroms"]
         |  |        +- VariableOrConstantDeclaratorId[@Array = false, @ArrayDepth = 0, @CanonicalImage = "V_VALIDFROMS", @Image = "v_validfroms"]
         |  |        |  +- ID[@CanonicalImage = "V_VALIDFROMS", @Image = "v_validfroms"]
         |  |        +- Datatype[@CanonicalImage = "T_VALIDFROMS", @Image = "t_validfroms", @TypeImage = "t_validfroms"]
         |  |           +- QualifiedName[@CanonicalImage = "T_VALIDFROMS", @Image = "t_validfroms"]
         |  |              +- UnqualifiedID[@CanonicalImage = "T_VALIDFROMS", @Image = "t_validfroms"]
         |  +- DeclarativeUnit[@CanonicalImage = null]
         |  |  +- VariableOrConstantDeclaration[@CanonicalImage = null]
         |  |     +- VariableOrConstantDeclarator[@CanonicalImage = "V_VALIDTOS T_VALIDTOS", @Image = "v_validtos t_validtos"]
         |  |        +- VariableOrConstantDeclaratorId[@Array = false, @ArrayDepth = 0, @CanonicalImage = "V_VALIDTOS", @Image = "v_validtos"]
         |  |        |  +- ID[@CanonicalImage = "V_VALIDTOS", @Image = "v_validtos"]
         |  |        +- Datatype[@CanonicalImage = "T_VALIDTOS", @Image = "t_validtos", @TypeImage = "t_validtos"]
         |  |           +- QualifiedName[@CanonicalImage = "T_VALIDTOS", @Image = "t_validtos"]
         |  |              +- UnqualifiedID[@CanonicalImage = "T_VALIDTOS", @Image = "t_validtos"]
         |  +- DeclarativeUnit[@CanonicalImage = null]
         |  |  +- VariableOrConstantDeclaration[@CanonicalImage = null]
         |  |     +- VariableOrConstantDeclarator[@CanonicalImage = "V_FL_ACTIVES T_FL_ACTIVES", @Image = "v_fl_actives t_fl_actives"]
         |  |        +- VariableOrConstantDeclaratorId[@Array = false, @ArrayDepth = 0, @CanonicalImage = "V_FL_ACTIVES", @Image = "v_fl_actives"]
         |  |        |  +- ID[@CanonicalImage = "V_FL_ACTIVES", @Image = "v_fl_actives"]
         |  |        +- Datatype[@CanonicalImage = "T_FL_ACTIVES", @Image = "t_fl_actives", @TypeImage = "t_fl_actives"]
         |  |           +- QualifiedName[@CanonicalImage = "T_FL_ACTIVES", @Image = "t_fl_actives"]
         |  |              +- UnqualifiedID[@CanonicalImage = "T_FL_ACTIVES", @Image = "t_fl_actives"]
         |  +- DeclarativeUnit[@CanonicalImage = null]
         |     +- VariableOrConstantDeclaration[@CanonicalImage = null]
         |        +- VariableOrConstantDeclarator[@CanonicalImage = "V_REPORTING_LISTS T_REPORTING_LISTS", @Image = "v_reporting_lists t_reporting_lists"]
         |           +- VariableOrConstantDeclaratorId[@Array = false, @ArrayDepth = 0, @CanonicalImage = "V_REPORTING_LISTS", @Image = "v_reporting_lists"]
         |           |  +- ID[@CanonicalImage = "V_REPORTING_LISTS", @Image = "v_reporting_lists"]
         |           +- Datatype[@CanonicalImage = "T_REPORTING_LISTS", @Image = "t_reporting_lists", @TypeImage = "t_reporting_lists"]
         |              +- QualifiedName[@CanonicalImage = "T_REPORTING_LISTS", @Image = "t_reporting_lists"]
         |                 +- UnqualifiedID[@CanonicalImage = "T_REPORTING_LISTS", @Image = "t_reporting_lists"]
         +- Statement[@CanonicalImage = null]
            +- UnlabelledStatement[@CanonicalImage = null]
               +- SelectIntoStatement[@All = false, @CanonicalImage = null, @Distinct = false, @Unique = false]
                  +- SelectList[@CanonicalImage = null]
                  |  +- SqlExpression[@CanonicalImage = "CMER_ID", @Image = "cmer_id"]
                  |  |  +- PrimaryPrefix[@CanonicalImage = "CMER_ID", @Image = "cmer_id", @SelfModifier = false]
                  |  |     +- SimpleExpression[@CanonicalImage = "CMER_ID", @Image = "cmer_id"]
                  |  |        +- Column[@CanonicalImage = "CMER_ID", @Image = "cmer_id"]
                  |  |           +- ID[@CanonicalImage = "CMER_ID", @Image = "cmer_id"]
                  |  +- SqlExpression[@CanonicalImage = "VERSION", @Image = "version"]
                  |  |  +- PrimaryPrefix[@CanonicalImage = "VERSION", @Image = "version", @SelfModifier = false]
                  |  |     +- SimpleExpression[@CanonicalImage = "VERSION", @Image = "version"]
                  |  |        +- Column[@CanonicalImage = "VERSION", @Image = "version"]
                  |  |           +- ID[@CanonicalImage = "VERSION", @Image = "version"]
                  |  +- SqlExpression[@CanonicalImage = "CMP_ID", @Image = "cmp_id"]
                  |  |  +- PrimaryPrefix[@CanonicalImage = "CMP_ID", @Image = "cmp_id", @SelfModifier = false]
                  |  |     +- SimpleExpression[@CanonicalImage = "CMP_ID", @Image = "cmp_id"]
                  |  |        +- Column[@CanonicalImage = "CMP_ID", @Image = "cmp_id"]
                  |  |           +- ID[@CanonicalImage = "CMP_ID", @Image = "cmp_id"]
                  |  +- SqlExpression[@CanonicalImage = "MPRC_CODE", @Image = "mprc_code"]
                  |  |  +- PrimaryPrefix[@CanonicalImage = "MPRC_CODE", @Image = "mprc_code", @SelfModifier = false]
                  |  |     +- SimpleExpression[@CanonicalImage = "MPRC_CODE", @Image = "mprc_code"]
                  |  |        +- Column[@CanonicalImage = "MPRC_CODE", @Image = "mprc_code"]
                  |  |           +- ID[@CanonicalImage = "MPRC_CODE", @Image = "mprc_code"]
                  |  +- SqlExpression[@CanonicalImage = "EMP_ID", @Image = "emp_id"]
                  |  |  +- PrimaryPrefix[@CanonicalImage = "EMP_ID", @Image = "emp_id", @SelfModifier = false]
                  |  |     +- SimpleExpression[@CanonicalImage = "EMP_ID", @Image = "emp_id"]
                  |  |        +- Column[@CanonicalImage = "EMP_ID", @Image = "emp_id"]
                  |  |           +- ID[@CanonicalImage = "EMP_ID", @Image = "emp_id"]
                  |  +- SqlExpression[@CanonicalImage = "EMP_ROLE_CODE", @Image = "emp_role_code"]
                  |  |  +- PrimaryPrefix[@CanonicalImage = "EMP_ROLE_CODE", @Image = "emp_role_code", @SelfModifier = false]
                  |  |     +- SimpleExpression[@CanonicalImage = "EMP_ROLE_CODE", @Image = "emp_role_code"]
                  |  |        +- Column[@CanonicalImage = "EMP_ROLE_CODE", @Image = "emp_role_code"]
                  |  |           +- ID[@CanonicalImage = "EMP_ROLE_CODE", @Image = "emp_role_code"]
                  |  +- SqlExpression[@CanonicalImage = "GSN_ID", @Image = "gsn_id"]
                  |  |  +- PrimaryPrefix[@CanonicalImage = "GSN_ID", @Image = "gsn_id", @SelfModifier = false]
                  |  |     +- SimpleExpression[@CanonicalImage = "GSN_ID", @Image = "gsn_id"]
                  |  |        +- Column[@CanonicalImage = "GSN_ID", @Image = "gsn_id"]
                  |  |           +- ID[@CanonicalImage = "GSN_ID", @Image = "gsn_id"]
                  |  +- SqlExpression[@CanonicalImage = "DEP_CODE", @Image = "dep_code"]
                  |  |  +- PrimaryPrefix[@CanonicalImage = "DEP_CODE", @Image = "dep_code", @SelfModifier = false]
                  |  |     +- SimpleExpression[@CanonicalImage = "DEP_CODE", @Image = "dep_code"]
                  |  |        +- Column[@CanonicalImage = "DEP_CODE", @Image = "dep_code"]
                  |  |           +- ID[@CanonicalImage = "DEP_CODE", @Image = "dep_code"]
                  |  +- SqlExpression[@CanonicalImage = "VALIDFROM", @Image = "validfrom"]
                  |  |  +- PrimaryPrefix[@CanonicalImage = "VALIDFROM", @Image = "validfrom", @SelfModifier = false]
                  |  |     +- SimpleExpression[@CanonicalImage = "VALIDFROM", @Image = "validfrom"]
                  |  |        +- Column[@CanonicalImage = "VALIDFROM", @Image = "validfrom"]
                  |  |           +- ID[@CanonicalImage = "VALIDFROM", @Image = "validfrom"]
                  |  +- SqlExpression[@CanonicalImage = "VALIDTO", @Image = "validto"]
                  |  |  +- PrimaryPrefix[@CanonicalImage = "VALIDTO", @Image = "validto", @SelfModifier = false]
                  |  |     +- SimpleExpression[@CanonicalImage = "VALIDTO", @Image = "validto"]
                  |  |        +- Column[@CanonicalImage = "VALIDTO", @Image = "validto"]
                  |  |           +- ID[@CanonicalImage = "VALIDTO", @Image = "validto"]
                  |  +- SqlExpression[@CanonicalImage = "FL_ACTIVE", @Image = "fl_active"]
                  |  |  +- PrimaryPrefix[@CanonicalImage = "FL_ACTIVE", @Image = "fl_active", @SelfModifier = false]
                  |  |     +- SimpleExpression[@CanonicalImage = "FL_ACTIVE", @Image = "fl_active"]
                  |  |        +- Column[@CanonicalImage = "FL_ACTIVE", @Image = "fl_active"]
                  |  |           +- ID[@CanonicalImage = "FL_ACTIVE", @Image = "fl_active"]
                  |  +- SqlExpression[@CanonicalImage = "REPORTING_LIST", @Image = "reporting_list"]
                  |     +- PrimaryPrefix[@CanonicalImage = "REPORTING_LIST", @Image = "reporting_list", @SelfModifier = false]
                  |        +- SimpleExpression[@CanonicalImage = "REPORTING_LIST", @Image = "reporting_list"]
                  |           +- Column[@CanonicalImage = "REPORTING_LIST", @Image = "reporting_list"]
                  |              +- ID[@CanonicalImage = "REPORTING_LIST", @Image = "reporting_list"]
                  +- BulkCollectIntoClause[@CanonicalImage = null]
                  |  +- CollectionName[@CanonicalImage = "V_CMER_IDS", @Image = "v_cmer_ids"]
                  |  |  +- ID[@CanonicalImage = "V_CMER_IDS", @Image = "v_cmer_ids"]
                  |  +- CollectionName[@CanonicalImage = "V_VERSIONS", @Image = "v_versions"]
                  |  |  +- ID[@CanonicalImage = "V_VERSIONS", @Image = "v_versions"]
                  |  +- CollectionName[@CanonicalImage = "V_CMP_IDS", @Image = "v_cmp_ids"]
                  |  |  +- ID[@CanonicalImage = "V_CMP_IDS", @Image = "v_cmp_ids"]
                  |  +- CollectionName[@CanonicalImage = "V_MPRC_CODES", @Image = "v_mprc_codes"]
                  |  |  +- ID[@CanonicalImage = "V_MPRC_CODES", @Image = "v_mprc_codes"]
                  |  +- CollectionName[@CanonicalImage = "V_EMP_IDS", @Image = "v_emp_ids"]
                  |  |  +- ID[@CanonicalImage = "V_EMP_IDS", @Image = "v_emp_ids"]
                  |  +- CollectionName[@CanonicalImage = "V_EMP_ROLE_CODES", @Image = "v_emp_role_codes"]
                  |  |  +- ID[@CanonicalImage = "V_EMP_ROLE_CODES", @Image = "v_emp_role_codes"]
                  |  +- CollectionName[@CanonicalImage = "V_GSN_IDS", @Image = "v_gsn_ids"]
                  |  |  +- ID[@CanonicalImage = "V_GSN_IDS", @Image = "v_gsn_ids"]
                  |  +- CollectionName[@CanonicalImage = "V_DEP_CODES", @Image = "v_dep_codes"]
                  |  |  +- ID[@CanonicalImage = "V_DEP_CODES", @Image = "v_dep_codes"]
                  |  +- CollectionName[@CanonicalImage = "V_VALIDFROMS", @Image = "v_validfroms"]
                  |  |  +- ID[@CanonicalImage = "V_VALIDFROMS", @Image = "v_validfroms"]
                  |  +- CollectionName[@CanonicalImage = "V_VALIDTOS", @Image = "v_validtos"]
                  |  |  +- ID[@CanonicalImage = "V_VALIDTOS", @Image = "v_validtos"]
                  |  +- CollectionName[@CanonicalImage = "V_FL_ACTIVES", @Image = "v_fl_actives"]
                  |  |  +- ID[@CanonicalImage = "V_FL_ACTIVES", @Image = "v_fl_actives"]
                  |  +- CollectionName[@CanonicalImage = "V_REPORTING_LISTS", @Image = "v_reporting_lists"]
                  |     +- ID[@CanonicalImage = "V_REPORTING_LISTS", @Image = "v_reporting_lists"]
                  +- FromClause[@CanonicalImage = null]
                     +- TableReference[@CanonicalImage = null]
                        +- QueryBlock[@All = false, @CanonicalImage = null, @Distinct = false, @Unique = false]
                        |  +- SelectList[@CanonicalImage = null]
                        |  |  +- SqlExpression[@CanonicalImage = "CMER.CMER_ID", @Image = "cmer.cmer_id"]
                        |  |  |  +- PrimaryPrefix[@CanonicalImage = "CMER.CMER_ID", @Image = "cmer.cmer_id", @SelfModifier = false]
                        |  |  |     +- SimpleExpression[@CanonicalImage = "CMER.CMER_ID", @Image = "cmer.cmer_id"]
                        |  |  |        +- TableName[@CanonicalImage = "CMER", @Image = "cmer"]
                        |  |  |        |  +- ID[@CanonicalImage = "CMER", @Image = "cmer"]
                        |  |  |        +- Column[@CanonicalImage = "CMER_ID", @Image = "cmer_id"]
                        |  |  |           +- ID[@CanonicalImage = "CMER_ID", @Image = "cmer_id"]
                        |  |  +- SqlExpression[@CanonicalImage = "CMER.VERSION", @Image = "cmer.version"]
                        |  |  |  +- PrimaryPrefix[@CanonicalImage = "CMER.VERSION", @Image = "cmer.version", @SelfModifier = false]
                        |  |  |     +- SimpleExpression[@CanonicalImage = "CMER.VERSION", @Image = "cmer.version"]
                        |  |  |        +- TableName[@CanonicalImage = "CMER", @Image = "cmer"]
                        |  |  |        |  +- ID[@CanonicalImage = "CMER", @Image = "cmer"]
                        |  |  |        +- Column[@CanonicalImage = "VERSION", @Image = "version"]
                        |  |  |           +- ID[@CanonicalImage = "VERSION", @Image = "version"]
                        |  |  +- SqlExpression[@CanonicalImage = "CMER.CMP_ID", @Image = "cmer.cmp_id"]
                        |  |  |  +- PrimaryPrefix[@CanonicalImage = "CMER.CMP_ID", @Image = "cmer.cmp_id", @SelfModifier = false]
                        |  |  |     +- SimpleExpression[@CanonicalImage = "CMER.CMP_ID", @Image = "cmer.cmp_id"]
                        |  |  |        +- TableName[@CanonicalImage = "CMER", @Image = "cmer"]
                        |  |  |        |  +- ID[@CanonicalImage = "CMER", @Image = "cmer"]
                        |  |  |        +- Column[@CanonicalImage = "CMP_ID", @Image = "cmp_id"]
                        |  |  |           +- ID[@CanonicalImage = "CMP_ID", @Image = "cmp_id"]
                        |  |  +- SqlExpression[@CanonicalImage = "CMER.MPRC_CODE", @Image = "cmer.mprc_code"]
                        |  |  |  +- PrimaryPrefix[@CanonicalImage = "CMER.MPRC_CODE", @Image = "cmer.mprc_code", @SelfModifier = false]
                        |  |  |     +- SimpleExpression[@CanonicalImage = "CMER.MPRC_CODE", @Image = "cmer.mprc_code"]
                        |  |  |        +- TableName[@CanonicalImage = "CMER", @Image = "cmer"]
                        |  |  |        |  +- ID[@CanonicalImage = "CMER", @Image = "cmer"]
                        |  |  |        +- Column[@CanonicalImage = "MPRC_CODE", @Image = "mprc_code"]
                        |  |  |           +- ID[@CanonicalImage = "MPRC_CODE", @Image = "mprc_code"]
                        |  |  +- SqlExpression[@CanonicalImage = "CMER.EMP_ID", @Image = "cmer.emp_id"]
                        |  |  |  +- PrimaryPrefix[@CanonicalImage = "CMER.EMP_ID", @Image = "cmer.emp_id", @SelfModifier = false]
                        |  |  |     +- SimpleExpression[@CanonicalImage = "CMER.EMP_ID", @Image = "cmer.emp_id"]
                        |  |  |        +- TableName[@CanonicalImage = "CMER", @Image = "cmer"]
                        |  |  |        |  +- ID[@CanonicalImage = "CMER", @Image = "cmer"]
                        |  |  |        +- Column[@CanonicalImage = "EMP_ID", @Image = "emp_id"]
                        |  |  |           +- ID[@CanonicalImage = "EMP_ID", @Image = "emp_id"]
                        |  |  +- SqlExpression[@CanonicalImage = "CMER.EMP_ROLE_CODE", @Image = "cmer.emp_role_code"]
                        |  |  |  +- PrimaryPrefix[@CanonicalImage = "CMER.EMP_ROLE_CODE", @Image = "cmer.emp_role_code", @SelfModifier = false]
                        |  |  |     +- SimpleExpression[@CanonicalImage = "CMER.EMP_ROLE_CODE", @Image = "cmer.emp_role_code"]
                        |  |  |        +- TableName[@CanonicalImage = "CMER", @Image = "cmer"]
                        |  |  |        |  +- ID[@CanonicalImage = "CMER", @Image = "cmer"]
                        |  |  |        +- Column[@CanonicalImage = "EMP_ROLE_CODE", @Image = "emp_role_code"]
                        |  |  |           +- ID[@CanonicalImage = "EMP_ROLE_CODE", @Image = "emp_role_code"]
                        |  |  +- SqlExpression[@CanonicalImage = "CMER.GSN_ID", @Image = "cmer.gsn_id"]
                        |  |  |  +- PrimaryPrefix[@CanonicalImage = "CMER.GSN_ID", @Image = "cmer.gsn_id", @SelfModifier = false]
                        |  |  |     +- SimpleExpression[@CanonicalImage = "CMER.GSN_ID", @Image = "cmer.gsn_id"]
                        |  |  |        +- TableName[@CanonicalImage = "CMER", @Image = "cmer"]
                        |  |  |        |  +- ID[@CanonicalImage = "CMER", @Image = "cmer"]
                        |  |  |        +- Column[@CanonicalImage = "GSN_ID", @Image = "gsn_id"]
                        |  |  |           +- ID[@CanonicalImage = "GSN_ID", @Image = "gsn_id"]
                        |  |  +- SqlExpression[@CanonicalImage = "CMER.DEP_CODE", @Image = "cmer.dep_code"]
                        |  |  |  +- PrimaryPrefix[@CanonicalImage = "CMER.DEP_CODE", @Image = "cmer.dep_code", @SelfModifier = false]
                        |  |  |     +- SimpleExpression[@CanonicalImage = "CMER.DEP_CODE", @Image = "cmer.dep_code"]
                        |  |  |        +- TableName[@CanonicalImage = "CMER", @Image = "cmer"]
                        |  |  |        |  +- ID[@CanonicalImage = "CMER", @Image = "cmer"]
                        |  |  |        +- Column[@CanonicalImage = "DEP_CODE", @Image = "dep_code"]
                        |  |  |           +- ID[@CanonicalImage = "DEP_CODE", @Image = "dep_code"]
                        |  |  +- SqlExpression[@CanonicalImage = "TRUNC", @Image = "TRUNC"]
                        |  |  |  +- PrimaryPrefix[@CanonicalImage = "TRUNC", @Image = "TRUNC", @SelfModifier = false]
                        |  |  |     +- FunctionCall[@CanonicalImage = "TRUNC", @Image = "TRUNC"]
                        |  |  |        +- FunctionName[@CanonicalImage = "TRUNC", @Image = "TRUNC"]
                        |  |  |        |  +- ID[@CanonicalImage = "TRUNC", @Image = "TRUNC"]
                        |  |  |        +- Arguments[@ArgumentCount = 1, @CanonicalImage = null]
                        |  |  |           +- ArgumentList[@CanonicalImage = null]
                        |  |  |              +- Argument[@CanonicalImage = null]
                        |  |  |                 +- Expression[@CanonicalImage = "INSERT_ENTRY.DMLTIME", @Image = "insert_entry.dmltime"]
                        |  |  |                    +- PrimaryPrefix[@CanonicalImage = "INSERT_ENTRY.DMLTIME", @Image = "insert_entry.dmltime", @SelfModifier = false]
                        |  |  |                       +- SimpleExpression[@CanonicalImage = "INSERT_ENTRY.DMLTIME", @Image = "insert_entry.dmltime"]
                        |  |  |                          +- TableName[@CanonicalImage = "INSERT_ENTRY", @Image = "insert_entry"]
                        |  |  |                          |  +- ID[@CanonicalImage = "INSERT_ENTRY", @Image = "insert_entry"]
                        |  |  |                          +- Column[@CanonicalImage = "DMLTIME", @Image = "dmltime"]
                        |  |  |                             +- ID[@CanonicalImage = "DMLTIME", @Image = "dmltime"]
                        |  |  +- ColumnAlias[@CanonicalImage = "VALIDFROM", @Image = "validfrom"]
                        |  |  |  +- ID[@CanonicalImage = "VALIDFROM", @Image = "validfrom"]
                        |  |  +- SqlExpression[@CanonicalImage = "NULL", @Image = "NULL"]
                        |  |  |  +- PrimaryPrefix[@CanonicalImage = "NULL", @Image = "NULL", @SelfModifier = false]
                        |  |  |     +- Literal[@CanonicalImage = "NULL", @Image = "NULL"]
                        |  |  |        +- NullLiteral[@CanonicalImage = "NULL", @Image = "NULL"]
                        |  |  +- ColumnAlias[@CanonicalImage = "VALIDTO", @Image = "validto"]
                        |  |  |  +- ID[@CanonicalImage = "VALIDTO", @Image = "validto"]
                        |  |  +- SqlExpression[@CanonicalImage = "\'Y\'", @Image = "\'Y\'"]
                        |  |  |  +- PrimaryPrefix[@CanonicalImage = "\'Y\'", @Image = "\'Y\'", @SelfModifier = false]
                        |  |  |     +- Literal[@CanonicalImage = "\'Y\'", @Image = "\'Y\'"]
                        |  |  +- ColumnAlias[@CanonicalImage = "FL_ACTIVE", @Image = "fl_active"]
                        |  |  |  +- ID[@CanonicalImage = "FL_ACTIVE", @Image = "fl_active"]
                        |  |  +- SqlExpression[@CanonicalImage = "SFM.REPORTING_GROUPS", @Image = "sfm.reporting_groups"]
                        |  |  |  +- PrimaryPrefix[@CanonicalImage = "SFM.REPORTING_GROUPS", @Image = "sfm.reporting_groups", @SelfModifier = false]
                        |  |  |     +- SimpleExpression[@CanonicalImage = "SFM.REPORTING_GROUPS", @Image = "sfm.reporting_groups"]
                        |  |  |        +- TableName[@CanonicalImage = "SFM", @Image = "sfm"]
                        |  |  |        |  +- ID[@CanonicalImage = "SFM", @Image = "sfm"]
                        |  |  |        +- Column[@CanonicalImage = "REPORTING_GROUPS", @Image = "reporting_groups"]
                        |  |  |           +- ID[@CanonicalImage = "REPORTING_GROUPS", @Image = "reporting_groups"]
                        |  |  +- ColumnAlias[@CanonicalImage = "REPORTING_LIST", @Image = "reporting_list"]
                        |  |     +- ID[@CanonicalImage = "REPORTING_LIST", @Image = "reporting_list"]
                        |  +- FromClause[@CanonicalImage = null]
                        |     +- JoinClause[@CanonicalImage = null]
                        |        +- TableReference[@CanonicalImage = null]
                        |        |  +- SchemaName[@CanonicalImage = "WEBCRM", @Image = "webcrm"]
                        |        |  |  +- ID[@CanonicalImage = "WEBCRM", @Image = "webcrm"]
                        |        |  +- TableName[@CanonicalImage = "COMP_MPRC_EMP_ROLE", @Image = "comp_mprc_emp_role"]
                        |        |  |  +- ID[@CanonicalImage = "COMP_MPRC_EMP_ROLE", @Image = "comp_mprc_emp_role"]
                        |        |  +- TableAlias[@CanonicalImage = "CMER", @Image = "cmer"]
                        |        |     +- ID[@CanonicalImage = "CMER", @Image = "cmer"]
                        |        +- InnerCrossJoinClause[@CanonicalImage = null, @Cross = false, @Natural = false]
                        |        |  +- TableReference[@CanonicalImage = null]
                        |        |  |  +- SchemaName[@CanonicalImage = "WEBCRM", @Image = "webcrm"]
                        |        |  |  |  +- ID[@CanonicalImage = "WEBCRM", @Image = "webcrm"]
                        |        |  |  +- TableName[@CanonicalImage = "JCOMP_MPRC_EMP_ROLE", @Image = "jcomp_mprc_emp_role"]
                        |        |  |  |  +- ID[@CanonicalImage = "JCOMP_MPRC_EMP_ROLE", @Image = "jcomp_mprc_emp_role"]
                        |        |  |  +- TableAlias[@CanonicalImage = "INSERT_ENTRY", @Image = "insert_entry"]
                        |        |  |     +- ID[@CanonicalImage = "INSERT_ENTRY", @Image = "insert_entry"]
                        |        |  +- PrimaryPrefix[@CanonicalImage = "(INSERT_ENTRY.CMER_ID = CMER.CMER_ID AND INSERT_ENTRY.OPERATION = \'I\')", @Image = "(insert_entry.cmer_id = cmer.cmer_id AND insert_entry.operation = \'I\')", @SelfModifier = false]
                        |        |     +- Expression[@CanonicalImage = "INSERT_ENTRY.CMER_ID = CMER.CMER_ID AND INSERT_ENTRY.OPERATION = \'I\'", @Image = "insert_entry.cmer_id = cmer.cmer_id AND insert_entry.operation = \'I\'"]
                        |        |        +- ConditionalAndExpression[@CanonicalImage = "INSERT_ENTRY.CMER_ID = CMER.CMER_ID AND INSERT_ENTRY.OPERATION = \'I\'", @Image = "insert_entry.cmer_id = cmer.cmer_id AND insert_entry.operation = \'I\'"]
                        |        |           +- EqualityExpression[@CanonicalImage = "INSERT_ENTRY.CMER_ID = CMER.CMER_ID", @Image = "insert_entry.cmer_id = cmer.cmer_id"]
                        |        |           |  +- PrimaryPrefix[@CanonicalImage = "INSERT_ENTRY.CMER_ID", @Image = "insert_entry.cmer_id", @SelfModifier = false]
                        |        |           |  |  +- SimpleExpression[@CanonicalImage = "INSERT_ENTRY.CMER_ID", @Image = "insert_entry.cmer_id"]
                        |        |           |  |     +- TableName[@CanonicalImage = "INSERT_ENTRY", @Image = "insert_entry"]
                        |        |           |  |     |  +- ID[@CanonicalImage = "INSERT_ENTRY", @Image = "insert_entry"]
                        |        |           |  |     +- Column[@CanonicalImage = "CMER_ID", @Image = "cmer_id"]
                        |        |           |  |        +- ID[@CanonicalImage = "CMER_ID", @Image = "cmer_id"]
                        |        |           |  +- PrimaryPrefix[@CanonicalImage = "CMER.CMER_ID", @Image = "cmer.cmer_id", @SelfModifier = false]
                        |        |           |     +- SimpleExpression[@CanonicalImage = "CMER.CMER_ID", @Image = "cmer.cmer_id"]
                        |        |           |        +- TableName[@CanonicalImage = "CMER", @Image = "cmer"]
                        |        |           |        |  +- ID[@CanonicalImage = "CMER", @Image = "cmer"]
                        |        |           |        +- Column[@CanonicalImage = "CMER_ID", @Image = "cmer_id"]
                        |        |           |           +- ID[@CanonicalImage = "CMER_ID", @Image = "cmer_id"]
                        |        |           +- EqualityExpression[@CanonicalImage = "INSERT_ENTRY.OPERATION = \'I\'", @Image = "insert_entry.operation = \'I\'"]
                        |        |              +- PrimaryPrefix[@CanonicalImage = "INSERT_ENTRY.OPERATION", @Image = "insert_entry.operation", @SelfModifier = false]
                        |        |              |  +- SimpleExpression[@CanonicalImage = "INSERT_ENTRY.OPERATION", @Image = "insert_entry.operation"]
                        |        |              |     +- TableName[@CanonicalImage = "INSERT_ENTRY", @Image = "insert_entry"]
                        |        |              |     |  +- ID[@CanonicalImage = "INSERT_ENTRY", @Image = "insert_entry"]
                        |        |              |     +- Column[@CanonicalImage = "OPERATION", @Image = "operation"]
                        |        |              |        +- ID[@CanonicalImage = "OPERATION", @Image = "operation"]
                        |        |              +- PrimaryPrefix[@CanonicalImage = "\'I\'", @Image = "\'I\'", @SelfModifier = false]
                        |        |                 +- Literal[@CanonicalImage = "\'I\'", @Image = "\'I\'"]
                        |        +- OuterJoinClause[@CanonicalImage = null, @Natural = false]
                        |        |  +- OuterJoinType[@CanonicalImage = "LEFT", @Full = false, @Image = "LEFT", @Left = true, @Right = false, @Type = Type.LEFT]
                        |        |  +- TableReference[@CanonicalImage = null]
                        |        |  |  +- SchemaName[@CanonicalImage = "WEBCRM", @Image = "webcrm"]
                        |        |  |  |  +- ID[@CanonicalImage = "WEBCRM", @Image = "webcrm"]
                        |        |  |  +- TableName[@CanonicalImage = "V_COMPANY_ADDRESS", @Image = "v_company_address"]
                        |        |  |  |  +- ID[@CanonicalImage = "V_COMPANY_ADDRESS", @Image = "v_company_address"]
                        |        |  |  +- TableAlias[@CanonicalImage = "CADDR", @Image = "caddr"]
                        |        |  |     +- ID[@CanonicalImage = "CADDR", @Image = "caddr"]
                        |        |  +- PrimaryPrefix[@CanonicalImage = "(CADDR.CMP_ID = CMER.CMP_ID)", @Image = "(caddr.cmp_id = cmer.cmp_id)", @SelfModifier = false]
                        |        |     +- Expression[@CanonicalImage = "CADDR.CMP_ID = CMER.CMP_ID", @Image = "caddr.cmp_id = cmer.cmp_id"]
                        |        |        +- EqualityExpression[@CanonicalImage = "CADDR.CMP_ID = CMER.CMP_ID", @Image = "caddr.cmp_id = cmer.cmp_id"]
                        |        |           +- PrimaryPrefix[@CanonicalImage = "CADDR.CMP_ID", @Image = "caddr.cmp_id", @SelfModifier = false]
                        |        |           |  +- SimpleExpression[@CanonicalImage = "CADDR.CMP_ID", @Image = "caddr.cmp_id"]
                        |        |           |     +- TableName[@CanonicalImage = "CADDR", @Image = "caddr"]
                        |        |           |     |  +- ID[@CanonicalImage = "CADDR", @Image = "caddr"]
                        |        |           |     +- Column[@CanonicalImage = "CMP_ID", @Image = "cmp_id"]
                        |        |           |        +- ID[@CanonicalImage = "CMP_ID", @Image = "cmp_id"]
                        |        |           +- PrimaryPrefix[@CanonicalImage = "CMER.CMP_ID", @Image = "cmer.cmp_id", @SelfModifier = false]
                        |        |              +- SimpleExpression[@CanonicalImage = "CMER.CMP_ID", @Image = "cmer.cmp_id"]
                        |        |                 +- TableName[@CanonicalImage = "CMER", @Image = "cmer"]
                        |        |                 |  +- ID[@CanonicalImage = "CMER", @Image = "cmer"]
                        |        |                 +- Column[@CanonicalImage = "CMP_ID", @Image = "cmp_id"]
                        |        |                    +- ID[@CanonicalImage = "CMP_ID", @Image = "cmp_id"]
                        |        +- OuterJoinClause[@CanonicalImage = null, @Natural = false]
                        |           +- OuterJoinType[@CanonicalImage = "LEFT", @Full = false, @Image = "LEFT", @Left = true, @Right = false, @Type = Type.LEFT]
                        |           +- TableReference[@CanonicalImage = null]
                        |           |  +- SchemaName[@CanonicalImage = "WEBCRM", @Image = "webcrm"]
                        |           |  |  +- ID[@CanonicalImage = "WEBCRM", @Image = "webcrm"]
                        |           |  +- TableName[@CanonicalImage = "V_SFM_EMP_ROLE_CNY_REPG", @Image = "v_sfm_emp_role_cny_repg"]
                        |           |  |  +- ID[@CanonicalImage = "V_SFM_EMP_ROLE_CNY_REPG", @Image = "v_sfm_emp_role_cny_repg"]
                        |           |  +- TableAlias[@CanonicalImage = "SFM", @Image = "sfm"]
                        |           |     +- ID[@CanonicalImage = "SFM", @Image = "sfm"]
                        |           +- PrimaryPrefix[@CanonicalImage = "(SFM.EMP_ID = CMER.EMP_ID AND SFM.EMP_ROLE_CODE = CMER.EMP_ROLE_CODE AND SFM.CNY_CODE = NVL)", @Image = "(sfm.emp_id = cmer.emp_id AND sfm.emp_role_code = cmer.emp_role_code AND sfm.cny_code = NVL)", @SelfModifier = false]
                        |              +- Expression[@CanonicalImage = "SFM.EMP_ID = CMER.EMP_ID AND SFM.EMP_ROLE_CODE = CMER.EMP_ROLE_CODE AND SFM.CNY_CODE = NVL", @Image = "sfm.emp_id = cmer.emp_id AND sfm.emp_role_code = cmer.emp_role_code AND sfm.cny_code = NVL"]
                        |                 +- ConditionalAndExpression[@CanonicalImage = "SFM.EMP_ID = CMER.EMP_ID AND SFM.EMP_ROLE_CODE = CMER.EMP_ROLE_CODE AND SFM.CNY_CODE = NVL", @Image = "sfm.emp_id = cmer.emp_id AND sfm.emp_role_code = cmer.emp_role_code AND sfm.cny_code = NVL"]
                        |                    +- EqualityExpression[@CanonicalImage = "SFM.EMP_ID = CMER.EMP_ID", @Image = "sfm.emp_id = cmer.emp_id"]
                        |                    |  +- PrimaryPrefix[@CanonicalImage = "SFM.EMP_ID", @Image = "sfm.emp_id", @SelfModifier = false]
                        |                    |  |  +- SimpleExpression[@CanonicalImage = "SFM.EMP_ID", @Image = "sfm.emp_id"]
                        |                    |  |     +- TableName[@CanonicalImage = "SFM", @Image = "sfm"]
                        |                    |  |     |  +- ID[@CanonicalImage = "SFM", @Image = "sfm"]
                        |                    |  |     +- Column[@CanonicalImage = "EMP_ID", @Image = "emp_id"]
                        |                    |  |        +- ID[@CanonicalImage = "EMP_ID", @Image = "emp_id"]
                        |                    |  +- PrimaryPrefix[@CanonicalImage = "CMER.EMP_ID", @Image = "cmer.emp_id", @SelfModifier = false]
                        |                    |     +- SimpleExpression[@CanonicalImage = "CMER.EMP_ID", @Image = "cmer.emp_id"]
                        |                    |        +- TableName[@CanonicalImage = "CMER", @Image = "cmer"]
                        |                    |        |  +- ID[@CanonicalImage = "CMER", @Image = "cmer"]
                        |                    |        +- Column[@CanonicalImage = "EMP_ID", @Image = "emp_id"]
                        |                    |           +- ID[@CanonicalImage = "EMP_ID", @Image = "emp_id"]
                        |                    +- EqualityExpression[@CanonicalImage = "SFM.EMP_ROLE_CODE = CMER.EMP_ROLE_CODE", @Image = "sfm.emp_role_code = cmer.emp_role_code"]
                        |                    |  +- PrimaryPrefix[@CanonicalImage = "SFM.EMP_ROLE_CODE", @Image = "sfm.emp_role_code", @SelfModifier = false]
                        |                    |  |  +- SimpleExpression[@CanonicalImage = "SFM.EMP_ROLE_CODE", @Image = "sfm.emp_role_code"]
                        |                    |  |     +- TableName[@CanonicalImage = "SFM", @Image = "sfm"]
                        |                    |  |     |  +- ID[@CanonicalImage = "SFM", @Image = "sfm"]
                        |                    |  |     +- Column[@CanonicalImage = "EMP_ROLE_CODE", @Image = "emp_role_code"]
                        |                    |  |        +- ID[@CanonicalImage = "EMP_ROLE_CODE", @Image = "emp_role_code"]
                        |                    |  +- PrimaryPrefix[@CanonicalImage = "CMER.EMP_ROLE_CODE", @Image = "cmer.emp_role_code", @SelfModifier = false]
                        |                    |     +- SimpleExpression[@CanonicalImage = "CMER.EMP_ROLE_CODE", @Image = "cmer.emp_role_code"]
                        |                    |        +- TableName[@CanonicalImage = "CMER", @Image = "cmer"]
                        |                    |        |  +- ID[@CanonicalImage = "CMER", @Image = "cmer"]
                        |                    |        +- Column[@CanonicalImage = "EMP_ROLE_CODE", @Image = "emp_role_code"]
                        |                    |           +- ID[@CanonicalImage = "EMP_ROLE_CODE", @Image = "emp_role_code"]
                        |                    +- EqualityExpression[@CanonicalImage = "SFM.CNY_CODE = NVL", @Image = "sfm.cny_code = NVL"]
                        |                       +- PrimaryPrefix[@CanonicalImage = "SFM.CNY_CODE", @Image = "sfm.cny_code", @SelfModifier = false]
                        |                       |  +- SimpleExpression[@CanonicalImage = "SFM.CNY_CODE", @Image = "sfm.cny_code"]
                        |                       |     +- TableName[@CanonicalImage = "SFM", @Image = "sfm"]
                        |                       |     |  +- ID[@CanonicalImage = "SFM", @Image = "sfm"]
                        |                       |     +- Column[@CanonicalImage = "CNY_CODE", @Image = "cny_code"]
                        |                       |        +- ID[@CanonicalImage = "CNY_CODE", @Image = "cny_code"]
                        |                       +- 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 = "CADDR.S_CNY_CODE", @Image = "caddr.s_cny_code"]
                        |                                   |     +- PrimaryPrefix[@CanonicalImage = "CADDR.S_CNY_CODE", @Image = "caddr.s_cny_code", @SelfModifier = false]
                        |                                   |        +- SimpleExpression[@CanonicalImage = "CADDR.S_CNY_CODE", @Image = "caddr.s_cny_code"]
                        |                                   |           +- TableName[@CanonicalImage = "CADDR", @Image = "caddr"]
                        |                                   |           |  +- ID[@CanonicalImage = "CADDR", @Image = "caddr"]
                        |                                   |           +- Column[@CanonicalImage = "S_CNY_CODE", @Image = "s_cny_code"]
                        |                                   |              +- ID[@CanonicalImage = "S_CNY_CODE", @Image = "s_cny_code"]
                        |                                   +- Argument[@CanonicalImage = null]
                        |                                      +- Expression[@CanonicalImage = "CADDR.M_CNY_CODE", @Image = "caddr.m_cny_code"]
                        |                                         +- PrimaryPrefix[@CanonicalImage = "CADDR.M_CNY_CODE", @Image = "caddr.m_cny_code", @SelfModifier = false]
                        |                                            +- SimpleExpression[@CanonicalImage = "CADDR.M_CNY_CODE", @Image = "caddr.m_cny_code"]
                        |                                               +- TableName[@CanonicalImage = "CADDR", @Image = "caddr"]
                        |                                               |  +- ID[@CanonicalImage = "CADDR", @Image = "caddr"]
                        |                                               +- Column[@CanonicalImage = "M_CNY_CODE", @Image = "m_cny_code"]
                        |                                                  +- ID[@CanonicalImage = "M_CNY_CODE", @Image = "m_cny_code"]
                        +- SubqueryOperation[@All = false, @CanonicalImage = "UNION", @Image = "UNION", @Intersect = false, @Minus = false, @Union = true]
                        +- QueryBlock[@All = false, @CanonicalImage = null, @Distinct = false, @Unique = false]
                           +- SelectList[@CanonicalImage = null]
                           |  +- SqlExpression[@CanonicalImage = "JCMER.CMER_ID", @Image = "jcmer.cmer_id"]
                           |  |  +- PrimaryPrefix[@CanonicalImage = "JCMER.CMER_ID", @Image = "jcmer.cmer_id", @SelfModifier = false]
                           |  |     +- SimpleExpression[@CanonicalImage = "JCMER.CMER_ID", @Image = "jcmer.cmer_id"]
                           |  |        +- TableName[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |  |        |  +- ID[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |  |        +- Column[@CanonicalImage = "CMER_ID", @Image = "cmer_id"]
                           |  |           +- ID[@CanonicalImage = "CMER_ID", @Image = "cmer_id"]
                           |  +- SqlExpression[@CanonicalImage = "JCMER.VERSION", @Image = "jcmer.version"]
                           |  |  +- PrimaryPrefix[@CanonicalImage = "JCMER.VERSION", @Image = "jcmer.version", @SelfModifier = false]
                           |  |     +- SimpleExpression[@CanonicalImage = "JCMER.VERSION", @Image = "jcmer.version"]
                           |  |        +- TableName[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |  |        |  +- ID[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |  |        +- Column[@CanonicalImage = "VERSION", @Image = "version"]
                           |  |           +- ID[@CanonicalImage = "VERSION", @Image = "version"]
                           |  +- SqlExpression[@CanonicalImage = "JCMER.CMP_ID", @Image = "jcmer.cmp_id"]
                           |  |  +- PrimaryPrefix[@CanonicalImage = "JCMER.CMP_ID", @Image = "jcmer.cmp_id", @SelfModifier = false]
                           |  |     +- SimpleExpression[@CanonicalImage = "JCMER.CMP_ID", @Image = "jcmer.cmp_id"]
                           |  |        +- TableName[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |  |        |  +- ID[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |  |        +- Column[@CanonicalImage = "CMP_ID", @Image = "cmp_id"]
                           |  |           +- ID[@CanonicalImage = "CMP_ID", @Image = "cmp_id"]
                           |  +- SqlExpression[@CanonicalImage = "JCMER.MPRC_CODE", @Image = "jcmer.mprc_code"]
                           |  |  +- PrimaryPrefix[@CanonicalImage = "JCMER.MPRC_CODE", @Image = "jcmer.mprc_code", @SelfModifier = false]
                           |  |     +- SimpleExpression[@CanonicalImage = "JCMER.MPRC_CODE", @Image = "jcmer.mprc_code"]
                           |  |        +- TableName[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |  |        |  +- ID[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |  |        +- Column[@CanonicalImage = "MPRC_CODE", @Image = "mprc_code"]
                           |  |           +- ID[@CanonicalImage = "MPRC_CODE", @Image = "mprc_code"]
                           |  +- SqlExpression[@CanonicalImage = "JCMER.EMP_ID", @Image = "jcmer.emp_id"]
                           |  |  +- PrimaryPrefix[@CanonicalImage = "JCMER.EMP_ID", @Image = "jcmer.emp_id", @SelfModifier = false]
                           |  |     +- SimpleExpression[@CanonicalImage = "JCMER.EMP_ID", @Image = "jcmer.emp_id"]
                           |  |        +- TableName[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |  |        |  +- ID[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |  |        +- Column[@CanonicalImage = "EMP_ID", @Image = "emp_id"]
                           |  |           +- ID[@CanonicalImage = "EMP_ID", @Image = "emp_id"]
                           |  +- SqlExpression[@CanonicalImage = "JCMER.EMP_ROLE_CODE", @Image = "jcmer.emp_role_code"]
                           |  |  +- PrimaryPrefix[@CanonicalImage = "JCMER.EMP_ROLE_CODE", @Image = "jcmer.emp_role_code", @SelfModifier = false]
                           |  |     +- SimpleExpression[@CanonicalImage = "JCMER.EMP_ROLE_CODE", @Image = "jcmer.emp_role_code"]
                           |  |        +- TableName[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |  |        |  +- ID[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |  |        +- Column[@CanonicalImage = "EMP_ROLE_CODE", @Image = "emp_role_code"]
                           |  |           +- ID[@CanonicalImage = "EMP_ROLE_CODE", @Image = "emp_role_code"]
                           |  +- SqlExpression[@CanonicalImage = "JCMER.GSN_ID", @Image = "jcmer.gsn_id"]
                           |  |  +- PrimaryPrefix[@CanonicalImage = "JCMER.GSN_ID", @Image = "jcmer.gsn_id", @SelfModifier = false]
                           |  |     +- SimpleExpression[@CanonicalImage = "JCMER.GSN_ID", @Image = "jcmer.gsn_id"]
                           |  |        +- TableName[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |  |        |  +- ID[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |  |        +- Column[@CanonicalImage = "GSN_ID", @Image = "gsn_id"]
                           |  |           +- ID[@CanonicalImage = "GSN_ID", @Image = "gsn_id"]
                           |  +- SqlExpression[@CanonicalImage = "JCMER.DEP_CODE", @Image = "jcmer.dep_code"]
                           |  |  +- PrimaryPrefix[@CanonicalImage = "JCMER.DEP_CODE", @Image = "jcmer.dep_code", @SelfModifier = false]
                           |  |     +- SimpleExpression[@CanonicalImage = "JCMER.DEP_CODE", @Image = "jcmer.dep_code"]
                           |  |        +- TableName[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |  |        |  +- ID[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |  |        +- Column[@CanonicalImage = "DEP_CODE", @Image = "dep_code"]
                           |  |           +- ID[@CanonicalImage = "DEP_CODE", @Image = "dep_code"]
                           |  +- SqlExpression[@CanonicalImage = "TRUNC", @Image = "TRUNC"]
                           |  |  +- PrimaryPrefix[@CanonicalImage = "TRUNC", @Image = "TRUNC", @SelfModifier = false]
                           |  |     +- FunctionCall[@CanonicalImage = "TRUNC", @Image = "TRUNC"]
                           |  |        +- FunctionName[@CanonicalImage = "TRUNC", @Image = "TRUNC"]
                           |  |        |  +- ID[@CanonicalImage = "TRUNC", @Image = "TRUNC"]
                           |  |        +- Arguments[@ArgumentCount = 1, @CanonicalImage = null]
                           |  |           +- ArgumentList[@CanonicalImage = null]
                           |  |              +- Argument[@CanonicalImage = null]
                           |  |                 +- Expression[@CanonicalImage = "INSERT_ENTRY.DMLTIME", @Image = "insert_entry.dmltime"]
                           |  |                    +- PrimaryPrefix[@CanonicalImage = "INSERT_ENTRY.DMLTIME", @Image = "insert_entry.dmltime", @SelfModifier = false]
                           |  |                       +- SimpleExpression[@CanonicalImage = "INSERT_ENTRY.DMLTIME", @Image = "insert_entry.dmltime"]
                           |  |                          +- TableName[@CanonicalImage = "INSERT_ENTRY", @Image = "insert_entry"]
                           |  |                          |  +- ID[@CanonicalImage = "INSERT_ENTRY", @Image = "insert_entry"]
                           |  |                          +- Column[@CanonicalImage = "DMLTIME", @Image = "dmltime"]
                           |  |                             +- ID[@CanonicalImage = "DMLTIME", @Image = "dmltime"]
                           |  +- ColumnAlias[@CanonicalImage = "VALIDFROM", @Image = "validfrom"]
                           |  |  +- ID[@CanonicalImage = "VALIDFROM", @Image = "validfrom"]
                           |  +- SqlExpression[@CanonicalImage = "TRUNC", @Image = "TRUNC"]
                           |  |  +- PrimaryPrefix[@CanonicalImage = "TRUNC", @Image = "TRUNC", @SelfModifier = false]
                           |  |     +- FunctionCall[@CanonicalImage = "TRUNC", @Image = "TRUNC"]
                           |  |        +- FunctionName[@CanonicalImage = "TRUNC", @Image = "TRUNC"]
                           |  |        |  +- ID[@CanonicalImage = "TRUNC", @Image = "TRUNC"]
                           |  |        +- Arguments[@ArgumentCount = 1, @CanonicalImage = null]
                           |  |           +- ArgumentList[@CanonicalImage = null]
                           |  |              +- Argument[@CanonicalImage = null]
                           |  |                 +- Expression[@CanonicalImage = "JCMER.DMLTIME", @Image = "jcmer.dmltime"]
                           |  |                    +- PrimaryPrefix[@CanonicalImage = "JCMER.DMLTIME", @Image = "jcmer.dmltime", @SelfModifier = false]
                           |  |                       +- SimpleExpression[@CanonicalImage = "JCMER.DMLTIME", @Image = "jcmer.dmltime"]
                           |  |                          +- TableName[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |  |                          |  +- ID[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |  |                          +- Column[@CanonicalImage = "DMLTIME", @Image = "dmltime"]
                           |  |                             +- ID[@CanonicalImage = "DMLTIME", @Image = "dmltime"]
                           |  +- ColumnAlias[@CanonicalImage = "VALIDFROM", @Image = "validfrom"]
                           |  |  +- ID[@CanonicalImage = "VALIDFROM", @Image = "validfrom"]
                           |  +- SqlExpression[@CanonicalImage = "\'N\'", @Image = "\'N\'"]
                           |  |  +- PrimaryPrefix[@CanonicalImage = "\'N\'", @Image = "\'N\'", @SelfModifier = false]
                           |  |     +- Literal[@CanonicalImage = "\'N\'", @Image = "\'N\'"]
                           |  +- ColumnAlias[@CanonicalImage = "FL_ACTIVE", @Image = "fl_active"]
                           |  |  +- ID[@CanonicalImage = "FL_ACTIVE", @Image = "fl_active"]
                           |  +- SqlExpression[@CanonicalImage = "SFM.REPORTING_GROUPS", @Image = "sfm.reporting_groups"]
                           |  |  +- PrimaryPrefix[@CanonicalImage = "SFM.REPORTING_GROUPS", @Image = "sfm.reporting_groups", @SelfModifier = false]
                           |  |     +- SimpleExpression[@CanonicalImage = "SFM.REPORTING_GROUPS", @Image = "sfm.reporting_groups"]
                           |  |        +- TableName[@CanonicalImage = "SFM", @Image = "sfm"]
                           |  |        |  +- ID[@CanonicalImage = "SFM", @Image = "sfm"]
                           |  |        +- Column[@CanonicalImage = "REPORTING_GROUPS", @Image = "reporting_groups"]
                           |  |           +- ID[@CanonicalImage = "REPORTING_GROUPS", @Image = "reporting_groups"]
                           |  +- ColumnAlias[@CanonicalImage = "REPORTING_LIST", @Image = "reporting_list"]
                           |     +- ID[@CanonicalImage = "REPORTING_LIST", @Image = "reporting_list"]
                           +- FromClause[@CanonicalImage = null]
                           |  +- JoinClause[@CanonicalImage = null]
                           |     +- TableReference[@CanonicalImage = null]
                           |     |  +- SchemaName[@CanonicalImage = "WEBCRM", @Image = "webcrm"]
                           |     |  |  +- ID[@CanonicalImage = "WEBCRM", @Image = "webcrm"]
                           |     |  +- TableName[@CanonicalImage = "JCOMP_MPRC_EMP_ROLE", @Image = "jcomp_mprc_emp_role"]
                           |     |  |  +- ID[@CanonicalImage = "JCOMP_MPRC_EMP_ROLE", @Image = "jcomp_mprc_emp_role"]
                           |     |  +- TableAlias[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |     |     +- ID[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |     +- InnerCrossJoinClause[@CanonicalImage = null, @Cross = false, @Natural = false]
                           |     |  +- TableReference[@CanonicalImage = null]
                           |     |  |  +- SchemaName[@CanonicalImage = "WEBCRM", @Image = "webcrm"]
                           |     |  |  |  +- ID[@CanonicalImage = "WEBCRM", @Image = "webcrm"]
                           |     |  |  +- TableName[@CanonicalImage = "JCOMP_MPRC_EMP_ROLE", @Image = "jcomp_mprc_emp_role"]
                           |     |  |  |  +- ID[@CanonicalImage = "JCOMP_MPRC_EMP_ROLE", @Image = "jcomp_mprc_emp_role"]
                           |     |  |  +- TableAlias[@CanonicalImage = "INSERT_ENTRY", @Image = "insert_entry"]
                           |     |  |     +- ID[@CanonicalImage = "INSERT_ENTRY", @Image = "insert_entry"]
                           |     |  +- PrimaryPrefix[@CanonicalImage = "(INSERT_ENTRY.CMER_ID = JCMER.CMER_ID AND INSERT_ENTRY.OPERATION = \'I\')", @Image = "(insert_entry.cmer_id = jcmer.cmer_id AND insert_entry.operation = \'I\')", @SelfModifier = false]
                           |     |     +- Expression[@CanonicalImage = "INSERT_ENTRY.CMER_ID = JCMER.CMER_ID AND INSERT_ENTRY.OPERATION = \'I\'", @Image = "insert_entry.cmer_id = jcmer.cmer_id AND insert_entry.operation = \'I\'"]
                           |     |        +- ConditionalAndExpression[@CanonicalImage = "INSERT_ENTRY.CMER_ID = JCMER.CMER_ID AND INSERT_ENTRY.OPERATION = \'I\'", @Image = "insert_entry.cmer_id = jcmer.cmer_id AND insert_entry.operation = \'I\'"]
                           |     |           +- EqualityExpression[@CanonicalImage = "INSERT_ENTRY.CMER_ID = JCMER.CMER_ID", @Image = "insert_entry.cmer_id = jcmer.cmer_id"]
                           |     |           |  +- PrimaryPrefix[@CanonicalImage = "INSERT_ENTRY.CMER_ID", @Image = "insert_entry.cmer_id", @SelfModifier = false]
                           |     |           |  |  +- SimpleExpression[@CanonicalImage = "INSERT_ENTRY.CMER_ID", @Image = "insert_entry.cmer_id"]
                           |     |           |  |     +- TableName[@CanonicalImage = "INSERT_ENTRY", @Image = "insert_entry"]
                           |     |           |  |     |  +- ID[@CanonicalImage = "INSERT_ENTRY", @Image = "insert_entry"]
                           |     |           |  |     +- Column[@CanonicalImage = "CMER_ID", @Image = "cmer_id"]
                           |     |           |  |        +- ID[@CanonicalImage = "CMER_ID", @Image = "cmer_id"]
                           |     |           |  +- PrimaryPrefix[@CanonicalImage = "JCMER.CMER_ID", @Image = "jcmer.cmer_id", @SelfModifier = false]
                           |     |           |     +- SimpleExpression[@CanonicalImage = "JCMER.CMER_ID", @Image = "jcmer.cmer_id"]
                           |     |           |        +- TableName[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |     |           |        |  +- ID[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |     |           |        +- Column[@CanonicalImage = "CMER_ID", @Image = "cmer_id"]
                           |     |           |           +- ID[@CanonicalImage = "CMER_ID", @Image = "cmer_id"]
                           |     |           +- EqualityExpression[@CanonicalImage = "INSERT_ENTRY.OPERATION = \'I\'", @Image = "insert_entry.operation = \'I\'"]
                           |     |              +- PrimaryPrefix[@CanonicalImage = "INSERT_ENTRY.OPERATION", @Image = "insert_entry.operation", @SelfModifier = false]
                           |     |              |  +- SimpleExpression[@CanonicalImage = "INSERT_ENTRY.OPERATION", @Image = "insert_entry.operation"]
                           |     |              |     +- TableName[@CanonicalImage = "INSERT_ENTRY", @Image = "insert_entry"]
                           |     |              |     |  +- ID[@CanonicalImage = "INSERT_ENTRY", @Image = "insert_entry"]
                           |     |              |     +- Column[@CanonicalImage = "OPERATION", @Image = "operation"]
                           |     |              |        +- ID[@CanonicalImage = "OPERATION", @Image = "operation"]
                           |     |              +- PrimaryPrefix[@CanonicalImage = "\'I\'", @Image = "\'I\'", @SelfModifier = false]
                           |     |                 +- Literal[@CanonicalImage = "\'I\'", @Image = "\'I\'"]
                           |     +- OuterJoinClause[@CanonicalImage = null, @Natural = false]
                           |     |  +- OuterJoinType[@CanonicalImage = "LEFT", @Full = false, @Image = "LEFT", @Left = true, @Right = false, @Type = Type.LEFT]
                           |     |  +- TableReference[@CanonicalImage = null]
                           |     |  |  +- SchemaName[@CanonicalImage = "WEBCRM", @Image = "webcrm"]
                           |     |  |  |  +- ID[@CanonicalImage = "WEBCRM", @Image = "webcrm"]
                           |     |  |  +- TableName[@CanonicalImage = "V_COMPANY_ADDRESS", @Image = "v_company_address"]
                           |     |  |  |  +- ID[@CanonicalImage = "V_COMPANY_ADDRESS", @Image = "v_company_address"]
                           |     |  |  +- TableAlias[@CanonicalImage = "CADDR", @Image = "caddr"]
                           |     |  |     +- ID[@CanonicalImage = "CADDR", @Image = "caddr"]
                           |     |  +- PrimaryPrefix[@CanonicalImage = "(CADDR.CMP_ID = JCMER.CMP_ID)", @Image = "(caddr.cmp_id = jcmer.cmp_id)", @SelfModifier = false]
                           |     |     +- Expression[@CanonicalImage = "CADDR.CMP_ID = JCMER.CMP_ID", @Image = "caddr.cmp_id = jcmer.cmp_id"]
                           |     |        +- EqualityExpression[@CanonicalImage = "CADDR.CMP_ID = JCMER.CMP_ID", @Image = "caddr.cmp_id = jcmer.cmp_id"]
                           |     |           +- PrimaryPrefix[@CanonicalImage = "CADDR.CMP_ID", @Image = "caddr.cmp_id", @SelfModifier = false]
                           |     |           |  +- SimpleExpression[@CanonicalImage = "CADDR.CMP_ID", @Image = "caddr.cmp_id"]
                           |     |           |     +- TableName[@CanonicalImage = "CADDR", @Image = "caddr"]
                           |     |           |     |  +- ID[@CanonicalImage = "CADDR", @Image = "caddr"]
                           |     |           |     +- Column[@CanonicalImage = "CMP_ID", @Image = "cmp_id"]
                           |     |           |        +- ID[@CanonicalImage = "CMP_ID", @Image = "cmp_id"]
                           |     |           +- PrimaryPrefix[@CanonicalImage = "JCMER.CMP_ID", @Image = "jcmer.cmp_id", @SelfModifier = false]
                           |     |              +- SimpleExpression[@CanonicalImage = "JCMER.CMP_ID", @Image = "jcmer.cmp_id"]
                           |     |                 +- TableName[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |     |                 |  +- ID[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |     |                 +- Column[@CanonicalImage = "CMP_ID", @Image = "cmp_id"]
                           |     |                    +- ID[@CanonicalImage = "CMP_ID", @Image = "cmp_id"]
                           |     +- OuterJoinClause[@CanonicalImage = null, @Natural = false]
                           |        +- OuterJoinType[@CanonicalImage = "LEFT", @Full = false, @Image = "LEFT", @Left = true, @Right = false, @Type = Type.LEFT]
                           |        +- TableReference[@CanonicalImage = null]
                           |        |  +- TableName[@CanonicalImage = "V_SFM_EMP_ROLE_CNY_REPG", @Image = "v_sfm_emp_role_cny_repg"]
                           |        |  |  +- ID[@CanonicalImage = "V_SFM_EMP_ROLE_CNY_REPG", @Image = "v_sfm_emp_role_cny_repg"]
                           |        |  +- TableAlias[@CanonicalImage = "SFM", @Image = "sfm"]
                           |        |     +- ID[@CanonicalImage = "SFM", @Image = "sfm"]
                           |        +- PrimaryPrefix[@CanonicalImage = "(SFM.EMP_ID = JCMER.EMP_ID AND SFM.EMP_ROLE_CODE = JCMER.EMP_ROLE_CODE AND SFM.CNY_CODE = NVL)", @Image = "(sfm.emp_id = jcmer.emp_id AND sfm.emp_role_code = jcmer.emp_role_code AND sfm.cny_code = NVL)", @SelfModifier = false]
                           |           +- Expression[@CanonicalImage = "SFM.EMP_ID = JCMER.EMP_ID AND SFM.EMP_ROLE_CODE = JCMER.EMP_ROLE_CODE AND SFM.CNY_CODE = NVL", @Image = "sfm.emp_id = jcmer.emp_id AND sfm.emp_role_code = jcmer.emp_role_code AND sfm.cny_code = NVL"]
                           |              +- ConditionalAndExpression[@CanonicalImage = "SFM.EMP_ID = JCMER.EMP_ID AND SFM.EMP_ROLE_CODE = JCMER.EMP_ROLE_CODE AND SFM.CNY_CODE = NVL", @Image = "sfm.emp_id = jcmer.emp_id AND sfm.emp_role_code = jcmer.emp_role_code AND sfm.cny_code = NVL"]
                           |                 +- EqualityExpression[@CanonicalImage = "SFM.EMP_ID = JCMER.EMP_ID", @Image = "sfm.emp_id = jcmer.emp_id"]
                           |                 |  +- PrimaryPrefix[@CanonicalImage = "SFM.EMP_ID", @Image = "sfm.emp_id", @SelfModifier = false]
                           |                 |  |  +- SimpleExpression[@CanonicalImage = "SFM.EMP_ID", @Image = "sfm.emp_id"]
                           |                 |  |     +- TableName[@CanonicalImage = "SFM", @Image = "sfm"]
                           |                 |  |     |  +- ID[@CanonicalImage = "SFM", @Image = "sfm"]
                           |                 |  |     +- Column[@CanonicalImage = "EMP_ID", @Image = "emp_id"]
                           |                 |  |        +- ID[@CanonicalImage = "EMP_ID", @Image = "emp_id"]
                           |                 |  +- PrimaryPrefix[@CanonicalImage = "JCMER.EMP_ID", @Image = "jcmer.emp_id", @SelfModifier = false]
                           |                 |     +- SimpleExpression[@CanonicalImage = "JCMER.EMP_ID", @Image = "jcmer.emp_id"]
                           |                 |        +- TableName[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |                 |        |  +- ID[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |                 |        +- Column[@CanonicalImage = "EMP_ID", @Image = "emp_id"]
                           |                 |           +- ID[@CanonicalImage = "EMP_ID", @Image = "emp_id"]
                           |                 +- EqualityExpression[@CanonicalImage = "SFM.EMP_ROLE_CODE = JCMER.EMP_ROLE_CODE", @Image = "sfm.emp_role_code = jcmer.emp_role_code"]
                           |                 |  +- PrimaryPrefix[@CanonicalImage = "SFM.EMP_ROLE_CODE", @Image = "sfm.emp_role_code", @SelfModifier = false]
                           |                 |  |  +- SimpleExpression[@CanonicalImage = "SFM.EMP_ROLE_CODE", @Image = "sfm.emp_role_code"]
                           |                 |  |     +- TableName[@CanonicalImage = "SFM", @Image = "sfm"]
                           |                 |  |     |  +- ID[@CanonicalImage = "SFM", @Image = "sfm"]
                           |                 |  |     +- Column[@CanonicalImage = "EMP_ROLE_CODE", @Image = "emp_role_code"]
                           |                 |  |        +- ID[@CanonicalImage = "EMP_ROLE_CODE", @Image = "emp_role_code"]
                           |                 |  +- PrimaryPrefix[@CanonicalImage = "JCMER.EMP_ROLE_CODE", @Image = "jcmer.emp_role_code", @SelfModifier = false]
                           |                 |     +- SimpleExpression[@CanonicalImage = "JCMER.EMP_ROLE_CODE", @Image = "jcmer.emp_role_code"]
                           |                 |        +- TableName[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |                 |        |  +- ID[@CanonicalImage = "JCMER", @Image = "jcmer"]
                           |                 |        +- Column[@CanonicalImage = "EMP_ROLE_CODE", @Image = "emp_role_code"]
                           |                 |           +- ID[@CanonicalImage = "EMP_ROLE_CODE", @Image = "emp_role_code"]
                           |                 +- EqualityExpression[@CanonicalImage = "SFM.CNY_CODE = NVL", @Image = "sfm.cny_code = NVL"]
                           |                    +- PrimaryPrefix[@CanonicalImage = "SFM.CNY_CODE", @Image = "sfm.cny_code", @SelfModifier = false]
                           |                    |  +- SimpleExpression[@CanonicalImage = "SFM.CNY_CODE", @Image = "sfm.cny_code"]
                           |                    |     +- TableName[@CanonicalImage = "SFM", @Image = "sfm"]
                           |                    |     |  +- ID[@CanonicalImage = "SFM", @Image = "sfm"]
                           |                    |     +- Column[@CanonicalImage = "CNY_CODE", @Image = "cny_code"]
                           |                    |        +- ID[@CanonicalImage = "CNY_CODE", @Image = "cny_code"]
                           |                    +- 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 = "CADDR.S_CNY_CODE", @Image = "caddr.s_cny_code"]
                           |                                |     +- PrimaryPrefix[@CanonicalImage = "CADDR.S_CNY_CODE", @Image = "caddr.s_cny_code", @SelfModifier = false]
                           |                                |        +- SimpleExpression[@CanonicalImage = "CADDR.S_CNY_CODE", @Image = "caddr.s_cny_code"]
                           |                                |           +- TableName[@CanonicalImage = "CADDR", @Image = "caddr"]
                           |                                |           |  +- ID[@CanonicalImage = "CADDR", @Image = "caddr"]
                           |                                |           +- Column[@CanonicalImage = "S_CNY_CODE", @Image = "s_cny_code"]
                           |                                |              +- ID[@CanonicalImage = "S_CNY_CODE", @Image = "s_cny_code"]
                           |                                +- Argument[@CanonicalImage = null]
                           |                                   +- Expression[@CanonicalImage = "CADDR.M_CNY_CODE", @Image = "caddr.m_cny_code"]
                           |                                      +- PrimaryPrefix[@CanonicalImage = "CADDR.M_CNY_CODE", @Image = "caddr.m_cny_code", @SelfModifier = false]
                           |                                         +- SimpleExpression[@CanonicalImage = "CADDR.M_CNY_CODE", @Image = "caddr.m_cny_code"]
                           |                                            +- TableName[@CanonicalImage = "CADDR", @Image = "caddr"]
                           |                                            |  +- ID[@CanonicalImage = "CADDR", @Image = "caddr"]
                           |                                            +- Column[@CanonicalImage = "M_CNY_CODE", @Image = "m_cny_code"]
                           |                                               +- ID[@CanonicalImage = "M_CNY_CODE", @Image = "m_cny_code"]
                           +- WhereClause[@CanonicalImage = null]
                              +- Condition[@CanonicalImage = null]
                                 +- CompoundCondition[@CanonicalImage = null, @Type = "AND"]
                                    +- InCondition[@CanonicalImage = null]
                                    |  +- SqlExpression[@CanonicalImage = "JCMER.CMER_ID", @Image = "jcmer.cmer_id"]
                                    |  |  +- PrimaryPrefix[@CanonicalImage = "JCMER.CMER_ID", @Image = "jcmer.cmer_id", @SelfModifier = false]
                                    |  |     +- SimpleExpression[@CanonicalImage = "JCMER.CMER_ID", @Image = "jcmer.cmer_id"]
                                    |  |        +- TableName[@CanonicalImage = "JCMER", @Image = "jcmer"]
                                    |  |        |  +- ID[@CanonicalImage = "JCMER", @Image = "jcmer"]
                                    |  |        +- Column[@CanonicalImage = "CMER_ID", @Image = "cmer_id"]
                                    |  |           +- ID[@CanonicalImage = "CMER_ID", @Image = "cmer_id"]
                                    |  +- QueryBlock[@All = false, @CanonicalImage = null, @Distinct = false, @Unique = false]
                                    |     +- SelectList[@CanonicalImage = null]
                                    |     |  +- SqlExpression[@CanonicalImage = "CMER.CMER_ID", @Image = "cmer.cmer_id"]
                                    |     |     +- PrimaryPrefix[@CanonicalImage = "CMER.CMER_ID", @Image = "cmer.cmer_id", @SelfModifier = false]
                                    |     |        +- SimpleExpression[@CanonicalImage = "CMER.CMER_ID", @Image = "cmer.cmer_id"]
                                    |     |           +- TableName[@CanonicalImage = "CMER", @Image = "cmer"]
                                    |     |           |  +- ID[@CanonicalImage = "CMER", @Image = "cmer"]
                                    |     |           +- Column[@CanonicalImage = "CMER_ID", @Image = "cmer_id"]
                                    |     |              +- ID[@CanonicalImage = "CMER_ID", @Image = "cmer_id"]
                                    |     +- FromClause[@CanonicalImage = null]
                                    |        +- TableReference[@CanonicalImage = null]
                                    |           +- SchemaName[@CanonicalImage = "WEBCRM", @Image = "webcrm"]
                                    |           |  +- ID[@CanonicalImage = "WEBCRM", @Image = "webcrm"]
                                    |           +- TableName[@CanonicalImage = "COMP_MPRC_EMP_ROLE", @Image = "comp_mprc_emp_role"]
                                    |           |  +- ID[@CanonicalImage = "COMP_MPRC_EMP_ROLE", @Image = "comp_mprc_emp_role"]
                                    |           +- TableAlias[@CanonicalImage = "CMER", @Image = "cmer"]
                                    |              +- ID[@CanonicalImage = "CMER", @Image = "cmer"]
                                    +- Condition[@CanonicalImage = null]
                                       +- CompoundCondition[@CanonicalImage = null, @Type = null]
                                          +- ComparisonCondition[@CanonicalImage = null, @Operator = "="]
                                             +- SqlExpression[@CanonicalImage = "JCMER.OPERATION", @Image = "jcmer.operation"]
                                             |  +- PrimaryPrefix[@CanonicalImage = "JCMER.OPERATION", @Image = "jcmer.operation", @SelfModifier = false]
                                             |     +- SimpleExpression[@CanonicalImage = "JCMER.OPERATION", @Image = "jcmer.operation"]
                                             |        +- TableName[@CanonicalImage = "JCMER", @Image = "jcmer"]
                                             |        |  +- ID[@CanonicalImage = "JCMER", @Image = "jcmer"]
                                             |        +- Column[@CanonicalImage = "OPERATION", @Image = "operation"]
                                             |           +- ID[@CanonicalImage = "OPERATION", @Image = "operation"]
                                             +- SqlExpression[@CanonicalImage = "\'D\'", @Image = "\'D\'"]
                                                +- PrimaryPrefix[@CanonicalImage = "\'D\'", @Image = "\'D\'", @SelfModifier = false]
                                                   +- Literal[@CanonicalImage = "\'D\'", @Image = "\'D\'"]
