SELECT statement with ID: C763368 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.SYS_PREF_CD, T1.VAL FROM SIEBEL.S_SYS_PREF T1 ORDER BY T1.SYS_PREF_CD ***** SQL Statement Execute Time: 0.002 seconds ***** 244 row(s) retrieved by ID: C762918 SELECT statement with ID: C8CC430 SELECT T3.CONFLICT_ID, T3.LAST_UPD, T3.CREATED, T3.LAST_UPD_BY, T3.CREATED_BY, T3.MODIFICATION_NUM, T3.ROW_ID, T3.CUSTOM_SCHEMA_VER, T3.DB_MAINT_VER, T3.DB_SCHEMA_VER, T3.DB_MINOR_VER, T3.CUSTOM_DOCK_VER, T1.ROW_ID, T3.NODE_NAME, T1.ROUTE_ID, T3.CUSTOM_EIM_VER, T2.ROW_ID, T2.NAME, T3.REPOS_BRANCH, T3.ZD_UPG_MODE FROM SIEBEL.S_NODE T1, SIEBEL.S_INT_INSTANCE T2, SIEBEL.S_APP_VER T3 WHERE T3.NODE_NAME = T1.NAME (+) AND T1.NODE_TYPE_CD (+) = 'REMOTE' AND T3.INST_MAJ_NUM = T2.INST_MAJ_NUM (+) AND T3.INST_MIN_NUM = T2.INST_MIN_NU M (+) ***** SQL Statement Execute Time: 0.002 seconds ***** SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED,

T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: ZERO_DTIME_MODE ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: C7E0F30 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: ZERO_DTIME_MODE ***** SQL Statement Execute Time: 0.001 seconds ***** 3 row(s) retrieved by ID: C7E0F30 1 row(s) retrieved by ID: 131DC4F8 SELECT statement with ID: C8AF110 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID,

T1.VERSION_NUM FROM SIEBEL.S_AUDIT_VERSION T1 ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: C7DC7D0 SELECT statement with ID: 131D8008 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.DB_LAST_UPD_SRC, T1.DB_LAST_UPD, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.ASSOC_FLG, T1.BUSCOMP_NAME, T1.COPY_FLG, T1.DELETE_FLG, T1.END_DT, T1.NEW_FLG, T1.RESTRICTION_CD, T1.START_DT, T1.UPDATE_FLG, T1.BASE_TBL_NAME, T1.DESC_TEXT, T1.EXPORT_FLG, T1.SYS_AUDIT_FLG FROM SIEBEL.S_AUDIT_BUSCOMP T1 ***** SQL Statement Execute Time: 0.002 seconds ***** SELECT statement with ID: C833B40 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T2.DST_ABBREV, T2.NAME, T2.STD_ABBREV, T1.DST_ABBREV, T1.NAME, T1.STD_ABBREV FROM SIEBEL.S_TIMEZONE_LANG T1, SIEBEL.S_TIMEZONE T2 WHERE T2.ROW_ID = T1.PAR_ROW_ID (+) AND T1.LANG_ID (+) = :1 AND (T2.ACTIVE_FLG = 'Y')

ORDER BY T2.NAME Bind variable 1: ENU ***** SQL Statement Execute Time: 0.003 seconds ***** 76 row(s) retrieved by ID: 133555F8 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: TIME_ZONE_DST_ORDINAL ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 133555F8 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: TIME_ZONE_DST_ORDINAL ***** SQL Statement Execute Time: 0.000 seconds *****

5 row(s) retrieved by ID: 133555F8 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: DAY_NAME ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 133555F8 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: DAY_NAME ***** SQL Statement Execute Time: 0.001 seconds ***** 8 row(s) retrieved by ID: 133555F8 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID,

T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: MONTH_NAME ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 133555F8 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: MONTH_NAME ***** SQL Statement Execute Time: 0.000 seconds ***** 12 row(s) retrieved by ID: 133555F8 SELECT statement with ID: 16D2D638 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID,

T2.DST_BIAS, T2.DST_END_DAY_CD, T2.DST_END_MONTH_CD, T2.DST_END_ORD_CD, T2.DST_END_TM, T2.DST_START_DAY_CD, T2.UTC_OFFSET, T2.DST_START_MONTH_CD, T2.DST_START_ORD_CD, T2.DST_START_TM, T2.EFF_START_DT, T1.NAME FROM SIEBEL.S_TIMEZONE T1, SIEBEL.S_TIMEZONE_DTL T2 WHERE T2.TIMEZONE_ID = T1.ROW_ID AND (T1.ACTIVE_FLG = :1 AND T1.NAME IS NOT NULL) ORDER BY T2.TIMEZONE_ID, T2.EFF_START_DT DESC Bind variable 1: Y ***** SQL Statement Execute Time: 0.002 seconds ***** 84 row(s) retrieved by ID: 133555F8 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: AUDIT_RESTRICTION_TYPE ***** SQL Statement Execute Time: 0.000 seconds ***** 1 row(s) retrieved by ID: 133555F8 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY,

T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: AUDIT_RESTRICTION_TYPE ***** SQL Statement Execute Time: 0.000 seconds ***** 5 row(s) retrieved by ID: 133555F8 82 row(s) retrieved by ID: C7DC7D0 SELECT statement with ID: 13155170 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.DB_LAST_UPD_SRC, T2.DB_LAST_UPD, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T2.TBL_NAME, T2.READ_FV_FLG, T1.SYS_AUDIT_FLG, T2.AUDIT_BC_ID, T1.BUSCOMP_NAME, T2.FIELD_NAME, T2.COL_NAME, T2.SPECIAL_JOINED_FLG, T2.JOIN_NAME, T2.READ_FLG, T1.ROW_ID, T1.ROW_ID, T1.MODIFICATION_NUM, T1.DB_LAST_UPD FROM SIEBEL.S_AUDIT_BUSCOMP T1, SIEBEL.S_AUDIT_FIELD T2 WHERE T2.AUDIT_BC_ID = T1.ROW_ID ***** SQL Statement Execute Time: 0.003 seconds ***** 263 row(s) retrieved by ID: C7DC7D0 SELECT statement with ID: 16DF0D18

SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.DB_LAST_UPD_SRC, T2.DB_LAST_UPD, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T2.AUDIT_BC_ID, T2.JOIN_NAME, T2.JOIN_SPEC_NAME, T2.SRC_COL_NAME, T2.SRC_TBL_NAME, T1.SYS_AUDIT_FLG, T1.ROW_ID, T1.ROW_ID, T1.MODIFICATION_NUM, T1.DB_LAST_UPD FROM SIEBEL.S_AUDIT_BUSCOMP T1, SIEBEL.S_AUDIT_JOIN T2 WHERE T2.AUDIT_BC_ID = T1.ROW_ID ***** SQL Statement Execute Time: 0.001 seconds ***** 63 row(s) retrieved by ID: C7DC7D0 SELECT statement with ID: 16D31DF0 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.DB_LAST_UPD_SRC, T2.DB_LAST_UPD, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T2.AUDIT_BC_ID, T2.CHILD_BC_NAME, T1.BUSCOMP_NAME, T2.CHILD_COL_NAME, T2.LINK_NAME, T2.MM_FLG, T2.PAR_COL_NAME, T1.SYS_AUDIT_FLG, T2.TBL_NAME, T1.ROW_ID, T1.ROW_ID, T1.MODIFICATION_NUM, T1.DB_LAST_UPD FROM SIEBEL.S_AUDIT_BUSCOMP T1, SIEBEL.S_AUDIT_LINK T2 WHERE T2.AUDIT_BC_ID = T1.ROW_ID

***** SQL Statement Execute Time: 0.001 seconds ***** 24 row(s) retrieved by ID: C7DC7D0 SELECT statement with ID: 13299008 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.AUDIT_BC_ID, T1.USER_ID FROM SIEBEL.S_AUDIT_USER T1 ***** SQL Statement Execute Time: 0.001 seconds ***** 0 row(s) retrieved by ID: C7DC7D0 SELECT statement with ID: 16D49D98 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T2.AUDIT_BC_ID, T1.NAME, T2.RESP_ID FROM SIEBEL.S_RESP T1, SIEBEL.S_AUDIT_RESP T2 WHERE T2.RESP_ID = T1.ROW_ID ***** SQL Statement Execute Time: 0.001 seconds ***** 0 row(s) retrieved by ID: C7DC7D0 SELECT statement with ID: 1332DC40 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.AUDIT_BC_ID, T1.POSITION_ID FROM

SIEBEL.S_AUDIT_POSTN T1 ***** SQL Statement Execute Time: 0.001 seconds ***** 0 row(s) retrieved by ID: C7DC7D0 SELECT statement with ID: 134F3298 SELECT /*+ ALL_ROWS */ T6.CONFLICT_ID, T6.LAST_UPD, T6.CREATED, T6.LAST_UPD_BY, T6.CREATED_BY, T6.MODIFICATION_NUM, T6.ROW_ID, T1.PAR_ROW_ID, T1.NAME, T7.FST_NAME, T7.JOB_TITLE, T7.LAST_NAME, T3.LOGIN, T7.NEW_USER_RESP_NAME, T5.LOGIN, T2.NAME, T7.TIMEZONE_ID, T7.BU_ID, T3.STATUS_CD, T7.ROW_ID, T7.PAR_ROW_ID, T7.MODIFICATION_NUM, T7.CREATED_BY, T7.LAST_UPD_BY, T7.CREATED, T7.LAST_UPD, T7.CONFLICT_ID, T7.PAR_ROW_ID, T3.ROW_ID, T3.PAR_ROW_ID, T3.MODIFICATION_NUM, T3.CREATED_BY, T3.LAST_UPD_BY, T3.CREATED, T3.LAST_UPD, T3.CONFLICT_ID, T3.PAR_ROW_ID FROM SIEBEL.S_ORG_EXT T1, SIEBEL.S_TIMEZONE T2, SIEBEL.S_USER T3, SIEBEL.S_PARTY_PER T4, SIEBEL.S_USER T5, SIEBEL.S_PARTY T6, SIEBEL.S_CONTACT T7 WHERE T7.PR_DEPT_OU_ID = T4.PARTY_ID (+) AND T7.PAR_ROW_ID = T4.PERSON_ID (+) AN D T4.PARTY_ID = T1.PAR_ROW_ID (+) AND T7.EMP_ID = T5.PAR_ROW_ID (+) AND T7.TIMEZONE_ID = T2.ROW_ID (+) AND

T6.ROW_ID = T7.PAR_ROW_ID AND T6.ROW_ID = T3.PAR_ROW_ID AND (T3.LOGIN = :1) Bind variable 1: SADMIN ***** SQL Statement Execute Time: 0.002 seconds ***** SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: USER_STATUS ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 16E11008 SELECT statement with ID: C7AE5F0 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.TYPE = :1 AND T1.LANG_ID = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: USER_STATUS Bind variable 2: ENU ***** SQL Statement Execute Time: 0.001 seconds ***** 2 row(s) retrieved by ID: 16E11008

SELECT statement with ID: C802758 SELECT /*+ ALL_ROWS */ T8.CONFLICT_ID, T8.LAST_UPD, T8.CREATED, T8.LAST_UPD_BY, T8.CREATED_BY, T8.MODIFICATION_NUM, T8.ROW_ID, T5.NAME, T8.PARTY_ID, T6.PR_HELD_POSTN_ID, T3.UPG_COMP_ID, T4.BASE_CURCY_CD, T4.NAME, T5.OU_ID, T7.NAME, T4.PAR_BU_ID, T1.ROW_ID FROM SIEBEL.S_POSTN T1, SIEBEL.S_USER T2, SIEBEL.S_EMP_PER T3, SIEBEL.S_ORG_EXT T4, SIEBEL.S_POSTN T5, SIEBEL.S_CONTACT T6, SIEBEL.S_ORG_EXT T7, SIEBEL.S_PARTY_PER T8 WHERE T4.PAR_BU_ID = T7.PAR_ROW_ID (+) AND T6.PR_HELD_POSTN_ID = T1.PAR_ROW_ID (+) AND T8.PERSON_ID = T3.PAR_ROW_ID AND T8.PARTY_ID = T5.PAR_ROW_ID AND T8.PERSON_ID = T6.PAR_ROW_ID AND T5.OU_ID = T4.PAR_ROW_ID AND T8.PERSON_ID = T2.PAR_ROW_ID AND (T2.LOGIN = :1) Bind variable 1: SADMIN ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 13320A18 1 row(s) retrieved by ID: 1375B008 SELECT statement with ID: C8CC430 SELECT T3.CONFLICT_ID, T3.LAST_UPD, T3.CREATED, T3.LAST_UPD_BY, T3.CREATED_BY, T3.MODIFICATION_NUM, T3.ROW_ID, T3.CUSTOM_SCHEMA_VER, T3.DB_MAINT_VER, T3.DB_SCHEMA_VER, T3.DB_MINOR_VER,

T3.CUSTOM_DOCK_VER, T1.ROW_ID, T3.NODE_NAME, T1.ROUTE_ID, T3.CUSTOM_EIM_VER, T2.ROW_ID, T2.NAME, T3.REPOS_BRANCH, T3.ZD_UPG_MODE FROM SIEBEL.S_NODE T1, SIEBEL.S_INT_INSTANCE T2, SIEBEL.S_APP_VER T3 WHERE T3.NODE_NAME = T1.NAME (+) AND T1.NODE_TYPE_CD (+) = 'REMOTE' AND T3.INST_MAJ_NUM = T2.INST_MAJ_NUM (+) AND T3.INST_MIN_NUM = T2.INST_MIN_NU M (+) ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 1375B008 SELECT statement with ID: C763368 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.EFF_END_DT, T1.NAME, T1.EFF_START_DT FROM SIEBEL.S_CT_ACTION_SET T1 WHERE (T1.ACTIVE_FLG = :1) ORDER BY T1.NAME Bind variable 1: Y ***** SQL Statement Execute Time: 0.002 seconds ***** 846 row(s) retrieved by ID: 1313CCC8 SELECT statement with ID: C8AF110 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.EFF_END_DT, T1.METHOD_NAME, T1.METHOD_CONTEXT,

T1.NAME, T1.SET_ATTR, T1.SET_RHS_EXPR, T1.SET_MAX_VAL, T1.SET_MIN_VAL, T1.SET_OPER_CD, T1.CT_ACTN_SET_ID, T1.ACTN_TYPE_CD, T1.SVC_CONTEXT, T1.SVC_METHOD_NAME, T1.SVC_NAME, T1.COND_EXPR, T1.EFF_START_DT FROM SIEBEL.S_CT_ACTION T1 WHERE (T1.ACTIVE_FLG = :1) ORDER BY T1.SEQ_NUM Bind variable 1: Y ***** SQL Statement Execute Time: 0.003 seconds ***** SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: CT_ACTION_TYPE ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 13154470 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID,

T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: CT_ACTION_TYPE ***** SQL Statement Execute Time: 0.001 seconds ***** 3 row(s) retrieved by ID: 13154470 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: CT_ACTION_SET_OP ***** SQL Statement Execute Time: 0.000 seconds ***** 1 row(s) retrieved by ID: 13154470 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE

(T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: CT_ACTION_SET_OP ***** SQL Statement Execute Time: 0.000 seconds ***** 5 row(s) retrieved by ID: 13154470 886 row(s) retrieved by ID: 1317B4B8 SELECT statement with ID: C833B40 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.CT_ACTN_SET_ID, T1.ACTN_COND_EXPR, T1.EVT_NAME, T1.EVT_SUB_NAME, T1.OBJ_NAME, T1.OBJ_TYPE_CD FROM SIEBEL.S_CT_EVENT T1 ORDER BY T1.EVT_SEQ_NUM ***** SQL Statement Execute Time: 0.002 seconds ***** SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: CT_EVENT_OBJ_TYPE

***** SQL Statement Execute Time: 0.000 seconds ***** 1 row(s) retrieved by ID: 13663008 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: CT_EVENT_OBJ_TYPE ***** SQL Statement Execute Time: 0.000 seconds ***** 3 row(s) retrieved by ID: 13663008 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: CT_BUSCOMP_EVENT ***** SQL Statement Execute Time: 0.000 seconds ***** 1 row(s) retrieved by ID: 13663008 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */

T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: CT_BUSCOMP_EVENT ***** SQL Statement Execute Time: 0.001 seconds ***** 20 row(s) retrieved by ID: 13663008 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: CT_APPLET_EVENT ***** SQL Statement Execute Time: 0.000 seconds ***** 1 row(s) retrieved by ID: 13663008 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM,

T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: CT_APPLET_EVENT ***** SQL Statement Execute Time: 0.000 seconds ***** 4 row(s) retrieved by ID: 13663008 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: CT_APPLICATION_EVENT ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 13663008 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1

WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: CT_APPLICATION_EVENT ***** SQL Statement Execute Time: 0.001 seconds ***** 13 row(s) retrieved by ID: 13663008 878 row(s) retrieved by ID: 1337C008 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: QUOTE_STATUS ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 1240E2C8 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY

T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: QUOTE_STATUS ***** SQL Statement Execute Time: 0.001 seconds ***** 16 row(s) retrieved by ID: 1240E2C8 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: TNT_SHM_INV_STATUS ***** SQL Statement Execute Time: 0.000 seconds ***** 1 row(s) retrieved by ID: 1240E2C8 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: TNT_SHM_INV_STATUS ***** SQL Statement Execute Time: 0.001 seconds *****

9 row(s) retrieved by ID: 1240E2C8 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: AUCTION_TYPE_CD ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 124E2750 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: AUCTION_TYPE_CD ***** SQL Statement Execute Time: 0.001 seconds ***** 7 row(s) retrieved by ID: 124E2750 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID,

T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: PROD_CD ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 1253D4A0 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: PROD_CD ***** SQL Statement Execute Time: 0.001 seconds ***** 27 row(s) retrieved by ID: 1253D4A0 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID,

T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: PROD_TYPE_CD ***** SQL Statement Execute Time: 0.000 seconds ***** 1 row(s) retrieved by ID: 1253D4A0 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: PROD_TYPE_CD ***** SQL Statement Execute Time: 0.000 seconds ***** 3 row(s) retrieved by ID: 1253D4A0 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE

T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: TRAINING_COURSE_FORMAT ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 1259A0F8 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: TRAINING_COURSE_FORMAT ***** SQL Statement Execute Time: 0.001 seconds ***** 11 row(s) retrieved by ID: 1259A0F8 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE

Bind variable 2: TRAINING_CLASS_STATUS ***** SQL Statement Execute Time: 0.000 seconds ***** 1 row(s) retrieved by ID: 1259A0F8 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: TRAINING_CLASS_STATUS ***** SQL Statement Execute Time: 0.001 seconds ***** 8 row(s) retrieved by ID: 1259A0F8 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: TODO_TYPE ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 12B4ACB0

SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: TODO_TYPE ***** SQL Statement Execute Time: 0.001 seconds ***** 613 row(s) retrieved by ID: 12B4ACB0 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: TNT_SHM_CALENDAR_DISPLAY ***** SQL Statement Execute Time: 0.000 seconds ***** 1 row(s) retrieved by ID: 12B4AC60 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY,

T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: TNT_SHM_CALENDAR_DISPLAY ***** SQL Statement Execute Time: 0.001 seconds ***** 13 row(s) retrieved by ID: 12B4AC60 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: PARTNER_TYPE ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 12E0D560 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME

FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: PARTNER_TYPE ***** SQL Statement Execute Time: 0.001 seconds ***** 33 row(s) retrieved by ID: 12E0D560 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: FS_ORDER_TYPE ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 12E6C458 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY

T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: FS_ORDER_TYPE ***** SQL Statement Execute Time: 0.001 seconds ***** 20 row(s) retrieved by ID: 12E6C458 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: HTIM_STATUS_CD ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 12EEB1F0 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: HTIM_STATUS_CD ***** SQL Statement Execute Time: 0.001 seconds *****

21 row(s) retrieved by ID: 12EEB1F0 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: OPTY_STATUS ***** SQL Statement Execute Time: 0.000 seconds ***** 1 row(s) retrieved by ID: 12EEE398 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: OPTY_STATUS ***** SQL Statement Execute Time: 0.001 seconds ***** 15 row(s) retrieved by ID: 12EEE398 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID,

T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: LS_MED_CODE_TYPE ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 139A9A58 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: LS_MED_CODE_TYPE ***** SQL Statement Execute Time: 0.001 seconds ***** 14 row(s) retrieved by ID: 139A9A58 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID,

T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: LS_MED_CA_STATUS_TYPE ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 13A56C10 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: LS_MED_CA_STATUS_TYPE ***** SQL Statement Execute Time: 0.001 seconds ***** 16 row(s) retrieved by ID: 13A56C10 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE

T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: LS_MED_PI_STATUS_TYPE ***** SQL Statement Execute Time: 0.001 seconds ***** 0 row(s) retrieved by ID: 13AA99D0 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: LS_MED_PI_STATUS_TYPE ***** SQL Statement Execute Time: 0.001 seconds ***** 12 row(s) retrieved by ID: 13AA99D0 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE

Bind variable 2: LS_MED_RR_STATUS_CD ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 13AAA560 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: LS_MED_RR_STATUS_CD ***** SQL Statement Execute Time: 0.001 seconds ***** 13 row(s) retrieved by ID: 13AAA560 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: SR_TYPE ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 13B8BA40

SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: SR_TYPE ***** SQL Statement Execute Time: 0.001 seconds ***** 12 row(s) retrieved by ID: 13B8BA40 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: DELTA_ACTION_CODE ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 13DFB868 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY,

T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: DELTA_ACTION_CODE ***** SQL Statement Execute Time: 0.001 seconds ***** 6 row(s) retrieved by ID: 13DFB868 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: ATP_STATUS ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 13DFE3B8 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME

FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: ATP_STATUS ***** SQL Statement Execute Time: 0.001 seconds ***** 13 row(s) retrieved by ID: 13DFE3B8 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: NET_ELEM_TYPE_CD ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 13DFE3B8 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY

T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: NET_ELEM_TYPE_CD ***** SQL Statement Execute Time: 0.001 seconds ***** 3 row(s) retrieved by ID: 13DFE3B8 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: SALES_TOOL_TYPE ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 13EB59A0 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: SALES_TOOL_TYPE ***** SQL Statement Execute Time: 0.001 seconds *****

43 row(s) retrieved by ID: 13EB59A0 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: PRODUCT_TYPE ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 142604B8 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: PRODUCT_TYPE ***** SQL Statement Execute Time: 0.001 seconds ***** 90 row(s) retrieved by ID: 142604B8 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID,

T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: SHM_CRITICAL_CD ***** SQL Statement Execute Time: 0.000 seconds ***** 1 row(s) retrieved by ID: 142604B8 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: SHM_CRITICAL_CD ***** SQL Statement Execute Time: 0.001 seconds ***** 3 row(s) retrieved by ID: 142604B8 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID,

T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: CG_HH_INVOICE_PRN_COPY ***** SQL Statement Execute Time: 0.000 seconds ***** 1 row(s) retrieved by ID: 1430F220 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: CG_HH_INVOICE_PRN_COPY ***** SQL Statement Execute Time: 0.000 seconds ***** 3 row(s) retrieved by ID: 1430F220 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE

T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: TNT_FUNC_STATUS ***** SQL Statement Execute Time: 0.000 seconds ***** 1 row(s) retrieved by ID: 143E06B0 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: TNT_FUNC_STATUS ***** SQL Statement Execute Time: 0.000 seconds ***** 10 row(s) retrieved by ID: 143E06B0 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE

Bind variable 2: CONTACT_USER_TYPE ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 14586D78 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: CONTACT_USER_TYPE ***** SQL Statement Execute Time: 0.000 seconds ***** 5 row(s) retrieved by ID: 14586D78 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: FS_ORDER_STATUS ***** SQL Statement Execute Time: 0.000 seconds ***** 1 row(s) retrieved by ID: 145898B0

SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: FS_ORDER_STATUS ***** SQL Statement Execute Time: 0.001 seconds ***** 5 row(s) retrieved by ID: 145898B0 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: EVENT_STATUS ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 146A85B0 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY,

T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: EVENT_STATUS ***** SQL Statement Execute Time: 0.001 seconds ***** 7 row(s) retrieved by ID: 146A85B0 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: PROJECT_STATUS ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 14994F00 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME

FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: PROJECT_STATUS ***** SQL Statement Execute Time: 0.001 seconds ***** 8 row(s) retrieved by ID: 14994F00 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: PROJECT_TYPE ***** SQL Statement Execute Time: 0.000 seconds ***** 1 row(s) retrieved by ID: 14994F00 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY

T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: PROJECT_TYPE ***** SQL Statement Execute Time: 0.001 seconds ***** 18 row(s) retrieved by ID: 14994F00 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: LOY_TXN_SUB_TYPE_CD ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 14B19548 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: LOY_TXN_SUB_TYPE_CD ***** SQL Statement Execute Time: 0.001 seconds *****

26 row(s) retrieved by ID: 14B19548 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: LOY_TXN_TYPE_CD ***** SQL Statement Execute Time: 0.000 seconds ***** 1 row(s) retrieved by ID: 14B19548 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: LOY_TXN_TYPE_CD ***** SQL Statement Execute Time: 0.000 seconds ***** 4 row(s) retrieved by ID: 14B19548 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID,

T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: LOY_CARD_STATUS ***** SQL Statement Execute Time: 0.000 seconds ***** 1 row(s) retrieved by ID: 14B52838 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: LOY_CARD_STATUS ***** SQL Statement Execute Time: 0.000 seconds ***** 6 row(s) retrieved by ID: 14B52838 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID,

T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: PARTY_RELATIONSHIP_TYPE ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 14E70890 SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: PARTY_RELATIONSHIP_TYPE ***** SQL Statement Execute Time: 0.001 seconds ***** 42 row(s) retrieved by ID: 14E70890 SELECT statement with ID: 151F6930 SELECT T4.CONFLICT_ID, T4.LAST_UPD, T4.CREATED, T4.LAST_UPD_BY, T4.CREATED_BY, T4.MODIFICATION_NUM, T4.ROW_ID, T6.DYN_HRCHY_ID, T2.NAME, T5.LOC, T5.NAME, T3.NAME, T6.BU_FLG,

T5.PAR_BU_ID, T5.BASE_CURCY_CD, T5.PR_ADDR_ID, T1.NAME, T5.PR_MGR_POSTN_ID, T5.ROW_ID, T5.PAR_ROW_ID, T5.MODIFICATION_NUM, T5.CREATED_BY, T5.LAST_UPD_BY, T5.CREATED, T5.LAST_UPD, T5.CONFLICT_ID, T5.PAR_ROW_ID, T6.ROW_ID, T6.PAR_ROW_ID, T6.MODIFICATION_NUM, T6.CREATED_BY, T6.LAST_UPD_BY, T6.CREATED, T6.LAST_UPD, T6.CONFLICT_ID, T6.PAR_ROW_ID FROM SIEBEL.S_POSTN T1, SIEBEL.S_DYN_HRCHY T2, SIEBEL.S_ORG_EXT T3, SIEBEL.S_PARTY T4, SIEBEL.S_ORG_EXT T5, SIEBEL.S_BU T6 WHERE T6.DYN_HRCHY_ID = T2.ROW_ID (+) AND T5.PAR_BU_ID = T3.PAR_ROW_ID (+) AND T5.PR_MGR_POSTN_ID = T1.PAR_ROW_ID (+) AND T4.ROW_ID = T5.PAR_ROW_ID AND T4.ROW_ID = T6.PAR_ROW_ID AND (T5.INT_ORG_FLG = 'Y' AND T6.BU_FLG = 'Y') AND (T4.ROW_ID = :1) ORDER BY T5.INT_ORG_FLG, T5.NAME Bind variable 1: 0-R9NH ***** SQL Statement Execute Time: 0.002 seconds ***** 1 row(s) retrieved by ID: 151F2AF0 SELECT statement with ID: 131D8008 SELECT T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.DEFAULT_FLG, T1.NAME FROM SIEBEL.S_DYN_HRCHY T1

WHERE (T1.DEFAULT_FLG = :1) Bind variable 1: Y ***** SQL Statement Execute Time: 0.001 seconds ***** 0 row(s) retrieved by ID: 13870008 SELECT statement with ID: 13155170 SELECT /*+ ALL_ROWS */ T3.CONFLICT_ID, T3.LAST_UPD, T3.CREATED, T3.LAST_UPD_BY, T3.CREATED_BY, T3.MODIFICATION_NUM, T3.ROW_ID, T2.LOGIN, T1.ROW_ID, T3.NAME, T3.COMPILED_INFO FROM SIEBEL.S_EMP_PER T1, SIEBEL.S_USER T2, SIEBEL.S_UPG_COMP T3 WHERE T3.ROW_ID = T1.UPG_COMP_ID (+) AND T1.ROW_ID = T2.PAR_ROW_ID (+) AND (T3.NAME = :1) Bind variable 1: Siebel Public Sector ***** SQL Statement Execute Time: 0.001 seconds ***** 0 row(s) retrieved by ID: C832D30 SELECT statement with ID: 16DF0D18 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.APP_KEY FROM SIEBEL.S_APP_KEY T1 ***** SQL Statement Execute Time: 0.001 seconds ***** 19 row(s) retrieved by ID: 15269E80 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED,

T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: ACCESS_RESOURCE_TYPE ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 152771E0 SELECT statement with ID: C7AE5F0 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.TYPE = :1 AND T1.LANG_ID = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: ACCESS_RESOURCE_TYPE Bind variable 2: ENU ***** SQL Statement Execute Time: 0.001 seconds ***** 4 row(s) retrieved by ID: 152771E0 SELECT statement with ID: 16D31DF0 SELECT /*+ ALL_ROWS */ T2.ROW_ID, T2.NAME, T2.TYPE_CD FROM SIEBEL.S_LST_OF_VAL T1, SIEBEL.S_AC_RSRC T2 WHERE T2.TYPE_CD = T1.NAME (+) AND T1.TYPE (+) = 'ACCESS_RESOURCE_TYPE' AND T1.L ANG_ID (+) = :1 AND (T2.TYPE_CD IN (:2,:3))

ORDER BY T1.VAL, T2.NAME Bind variable 1: ENU Bind variable 2: BUS_SVC Bind variable 3: BUS_PROC ***** SQL Statement Execute Time: 0.001 seconds ***** 0 row(s) retrieved by ID: 15276790 SELECT statement with ID: 13299008 SELECT /*+ ALL_ROWS */ T2.ROW_ID, T2.NAME, T2.PAR_NAME, T2.PAR_TYPE_CD, T2.TYPE_CD FROM SIEBEL.S_LST_OF_VAL T1, SIEBEL.S_AC_RSRC T2 WHERE T2.TYPE_CD = T1.NAME (+) AND T1.TYPE (+) = 'ACCESS_RESOURCE_TYPE' AND T1.L ANG_ID (+) = :1 AND (T2.TYPE_CD IN ( :2 )) ORDER BY T1.VAL, T2.NAME Bind variable 1: ENU Bind variable 2: BUS_SVC_MTHD ***** SQL Statement Execute Time: 0.001 seconds ***** 0 row(s) retrieved by ID: 15276790 SELECT statement with ID: 16D49D98 SELECT /*+ ALL_ROWS */ T4.ROW_ID, T4.NAME, T1.PER_ID, T4.TYPE_CD FROM SIEBEL.S_PER_RESP T1, SIEBEL.S_AC_RSRC_RESP T2, SIEBEL.S_LST_OF_VAL T3, SIEBEL.S_AC_RSRC T4 WHERE T2.RESP_ID = T1.RESP_ID AND T4.ROW_ID = T2.RSRC_ID AND T4.TYPE_CD = T3.NAME (+) AND T3.TYPE (+) = 'ACCESS_RESOURCE_TYPE' AND T3.L ANG_ID (+) = :1 AND (T1.PER_ID = :2 AND T4.TYPE_CD IN (:3,:4)) ORDER BY T3.VAL, T4.NAME Bind Bind Bind Bind variable variable variable variable 1: 2: 3: 4: ENU 0-1 BUS_SVC BUS_PROC

***** SQL Statement Execute Time: 0.004 seconds ***** 0 row(s) retrieved by ID: 15276790 SELECT statement with ID: 1332DC40 SELECT /*+ ALL_ROWS */ T4.ROW_ID, T4.NAME, T4.PAR_NAME, T1.PER_ID, T2.BROADEST_VIS_CD, T4.TYPE_CD FROM SIEBEL.S_PER_RESP T1, SIEBEL.S_AC_RSRC_RESP T2, SIEBEL.S_LST_OF_VAL T3, SIEBEL.S_AC_RSRC T4 WHERE T2.RESP_ID = T1.RESP_ID AND T4.ROW_ID = T2.RSRC_ID AND T4.TYPE_CD = T3.NAME (+) AND T3.TYPE (+) = 'ACCESS_RESOURCE_TYPE' AND T3.L ANG_ID (+) = :1 AND (T1.PER_ID = :2 AND T4.TYPE_CD IN ( :3 )) ORDER BY T3.VAL, T4.NAME Bind variable 1: ENU Bind variable 2: 0-1 Bind variable 3: BUS_SVC_MTHD ***** SQL Statement Execute Time: 0.002 seconds ***** 0 row(s) retrieved by ID: 15276790 SELECT statement with ID: C802758 SELECT /*+ ALL_ROWS */ T3.CONFLICT_ID, T3.LAST_UPD, T3.CREATED, T3.LAST_UPD_BY, T3.CREATED_BY, T3.MODIFICATION_NUM, T3.ROW_ID, T2.NAME, T1.NAME, T3.CPBLTY_VALUE FROM SIEBEL.S_BRWSR_FEATURE T1, SIEBEL.S_BRWSR T2, SIEBEL.S_BRWSR_CPBLTY T3 WHERE T3.BRWSR_ID = T2.ROW_ID AND T3.BRWSR_FTR_ID = T1.ROW_ID AND (T2.TYPE_CD = 'Agent') ORDER BY T2.NAME ***** SQL Statement Execute Time: 0.006 seconds *****

381 row(s) retrieved by ID: 15DD46A8 SELECT statement with ID: 1333D390 SELECT T1.CONFLICT_ID, T1.DB_LAST_UPD_SRC, T1.DB_LAST_UPD, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.BUILD_NUMBER, T1.CURR_WEBFILE_VER, T1.ENTERPRISE_NAME, T1.PREV_WEBFILE_VER, T1.RECORD_INFO_TEXT, T1.REC_IDENTIFIER FROM SIEBEL.S_UIF_WEB_FILE T1 WHERE (T1.REC_IDENTIFIER = :1) Bind variable 1: 0: ***** SQL Statement Execute Time: 0.001 seconds ***** 0 row(s) retrieved by ID: 15587008 SELECT statement with ID: 1319D238 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.TYPE, T1.VAL, T1.CODE, T1.NAME, T1.ORDER_BY, T1.RPLCTN_LVL_CD, T1.SUB_TYPE FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.CODE != 'CLASS' OR T1.CODE IS NULL) AND (T1.TYPE = :1) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: PHONE_FORMAT ***** SQL Statement Execute Time: 0.003 seconds ***** 29 row(s) retrieved by ID: 15587008

SELECT statement with ID: C763368 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.CURCY_CD, T1.CURCY_SYMBOL, T1.EURO_FLG, T1.EXTEND_PRECISION, T1.ISSUING_COUNTRY, T1.MIN_ACCT_UNIT, T1.DEGREE_OF_PREC FROM SIEBEL.S_CURCY T1 ORDER BY T1.CURCY_CD ***** SQL Statement Execute Time: 0.001 seconds ***** 61 row(s) retrieved by ID: 15587008 SELECT statement with ID: C8AF110 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T2.ACTIVE_FLG, T2.NAME, T1.NAME FROM SIEBEL.S_TIMEZONE_LANG T1, SIEBEL.S_TIMEZONE T2 WHERE T2.ROW_ID = T1.PAR_ROW_ID (+) AND T1.LANG_ID (+) = :1 AND (T2.ACTIVE_FLG = 'Y') AND (T2.ACTIVE_FLG = :2) ORDER BY T2.NAME Bind variable 1: ENU Bind variable 2: Y ***** SQL Statement Execute Time: 0.003 seconds ***** 76 row(s) retrieved by ID: 15587008 SELECT statement with ID: C833B40 SELECT T15.CONFLICT_ID, T15.LAST_UPD, T15.CREATED,

T15.LAST_UPD_BY, T15.CREATED_BY, T15.MODIFICATION_NUM, T15.ROW_ID, T9.ATTRIB_15, T13.INT_NEWS_APPR_FLG, T2.AUC_USR_ROLE_CD, T11.BIRTH_DT, T9.ATTRIB_26, T11.CALL_FLG, T11.CELL_PH_NUM, T11.CREATOR_LOGIN, T9.ATTRIB_07, T12.EBP_ENRL_FLG, T12.EBPP_ENRL_FLG, T5.EDUCATION, T9.ATTRIB_04, T11.EMAIL_ADDR, T11.EMP_ID, T11.EMP_NUM, T11.FAX_PH_NUM, T11.PREF_LOCALE_ID, T5.PREV_JOBS, T11.PR_DEPT_OU_ID, T11.DFLT_ORDER_PROC_CD, T9.ATTRIB_14, T14.LOCALE_CODE, T11.ACTIVE_FLG, T9.ATTRIB_06, T11.HOME_PH_NUM, T11.ANNL_INCM_AMT, T11.ANNL_INCM_CURCY_CD, T11.ANNL_INCM_EXCH_DT, T9.ATTRIB_48, T8.TRNG_DL_ADMIN_FLG, T11.EMP_FLG, T11.JOB_TITLE, T8.LAST_LOGIN_TS, T11.PREF_COMM_MEDIA_CD, T11.PREF_LANG_ID, T4.ROW_ID, T11.PR_OU_ADDR_ID, T6.OU_ID, T1.ROW_ID, T11.PR_PER_ADDR_ID, T11.PR_HELD_POSTN_ID, T6.POSTN_TYPE_CD, T11.PR_RESP_ID, T5.SPOUSE_NAME, T11.TMZONE_CD, T11.ALIAS_NAME, T5.POLIT_ALIGN, T11.ALT_PH_NUM, T11.FST_NAME, T11.LAST_NAME, T8.LOGIN, T11.SEX_MF, T11.PER_TITLE, T9.ATTRIB_08, T11.MID_NAME,

T11.BU_ID, T3.NAME, T3.NAME, T10.APPL_SRC_CD, T10.APPL_TYPE_CD, T10.APPL_STAT_CD, T10.REQ_PRTNR_TIER_CD, T10.REQ_PRTNR_TYPE_CD, T5.RESP, T11.SEND_NEWS_FLG, T11.SEND_PROMOTES_FLG, T11.SEND_FIN_FLG, T9.ATTRIB_05, T6.X_CASE_VISIBILITY, T1.NAME, T7.NAME, T12.ROW_ID, T12.PAR_ROW_ID, T12.MODIFICATION_NUM, T12.CREATED_BY, T12.LAST_UPD_BY, T12.CREATED, T12.LAST_UPD, T12.CONFLICT_ID, T12.PAR_ROW_ID, T11.ROW_ID, T11.PAR_ROW_ID, T11.MODIFICATION_NUM, T11.CREATED_BY, T11.LAST_UPD_BY, T11.CREATED, T11.LAST_UPD, T11.CONFLICT_ID, T11.PAR_ROW_ID, T9.ROW_ID, T9.PAR_ROW_ID, T9.MODIFICATION_NUM, T9.CREATED_BY, T9.LAST_UPD_BY, T9.CREATED, T9.LAST_UPD, T9.CONFLICT_ID, T9.PAR_ROW_ID, T2.ROW_ID, T2.PAR_ROW_ID, T2.MODIFICATION_NUM, T2.CREATED_BY, T2.LAST_UPD_BY, T2.CREATED, T2.LAST_UPD, T2.CONFLICT_ID, T2.PAR_ROW_ID, T13.ROW_ID, T13.PAR_ROW_ID, T13.MODIFICATION_NUM, T13.CREATED_BY, T13.LAST_UPD_BY, T13.CREATED, T13.LAST_UPD, T13.CONFLICT_ID,

T13.PAR_ROW_ID, T10.ROW_ID, T10.PAR_ROW_ID, T10.MODIFICATION_NUM, T10.CREATED_BY, T10.LAST_UPD_BY, T10.CREATED, T10.LAST_UPD, T10.CONFLICT_ID, T10.PAR_ROW_ID, T8.ROW_ID, T8.PAR_ROW_ID, T8.MODIFICATION_NUM, T8.CREATED_BY, T8.LAST_UPD_BY, T8.CREATED, T8.LAST_UPD, T8.CONFLICT_ID, T8.PAR_ROW_ID, T5.ROW_ID, T5.PAR_ROW_ID, T5.MODIFICATION_NUM, T5.CREATED_BY, T5.LAST_UPD_BY, T5.CREATED, T5.LAST_UPD, T5.CONFLICT_ID, T5.PAR_ROW_ID, T7.ROW_ID FROM SIEBEL.S_ORG_EXT T1, SIEBEL.S_USER_PROF T2, SIEBEL.S_RESP T3, SIEBEL.S_ORG_EXT T4, SIEBEL.S_CONTACT_T T5, SIEBEL.S_POSTN T6, SIEBEL.S_RESP T7, SIEBEL.S_USER T8, SIEBEL.S_CONTACT_X T9, SIEBEL.S_PER_PRTNRAPPL T10, SIEBEL.S_CONTACT T11, SIEBEL.S_CONTACT_FNX T12, SIEBEL.S_EMP_PER T13, SIEBEL.S_LOCALE T14, SIEBEL.S_PARTY T15 WHERE T11.PR_DEPT_OU_ID = T4.PAR_ROW_ID (+) AND T6.OU_ID = T1.PAR_ROW_ID (+) AND T11.PREF_LOCALE_ID = T14.ROW_ID (+) AND T11.PR_HELD_POSTN_ID = T6.PAR_ROW_ID (+) AND T11.PR_RESP_ID = T3.ROW_ID (+) AND T15.ROW_ID = T12.PAR_ROW_ID (+) AND T15.ROW_ID = T11.PAR_ROW_ID (+) AND T15.ROW_ID = T9.PAR_ROW_ID (+) AND T15.ROW_ID = T2.PAR_ROW_ID (+) AND T15.ROW_ID = T13.PAR_ROW_ID (+) AND T15.ROW_ID = T10.PAR_ROW_ID (+) AND T15.ROW_ID = T8.PAR_ROW_ID (+) AND T15.ROW_ID = T5.PAR_ROW_ID (+) AND T11.PR_RESP_ID = T7.ROW_ID (+) AND

(T15.ROW_ID = :1) Bind variable 1: 0-1 ***** SQL Statement Execute Time: 0.004 seconds ***** SELECT statement with ID: 1319D030 SELECT T6.CONFLICT_ID, T6.LAST_UPD, T6.CREATED, T6.LAST_UPD_BY, T6.CREATED_BY, T6.MODIFICATION_NUM, T6.ROW_ID, T5.PAR_ROW_ID, T4.EMP_STAT_CD, T4.EMPLOYEE_TYPE_CD, T6.SUB_PARTY_ID, T1.PAR_ROW_ID, T6.REL_TYPE_CD, T3.BU_ID, T3.PR_EMP_ID, T1.PR_EMP_ID, T2.PAR_ROW_ID, T6.PARTY_ID, T3.PAR_ROW_ID FROM SIEBEL.S_POSTN T1, SIEBEL.S_CONTACT T2, SIEBEL.S_POSTN T3, SIEBEL.S_EMP_PER T4, SIEBEL.S_CONTACT T5, SIEBEL.S_PARTY_RPT_REL T6 WHERE T3.PR_EMP_ID = T2.PAR_ROW_ID AND T3.PAR_ROW_ID = T2.PR_HELD_POSTN_ID AND T 2.EMP_FLG = 'Y' AND T6.PARTY_ID = T3.PAR_ROW_ID AND T6.SUB_PARTY_ID = T1.PAR_ROW_ID AND T5.PAR_ROW_ID = T4.PAR_ROW_ID AND T1.PR_EMP_ID = T5.PAR_ROW_ID AND T1.PAR_ROW_ID = T5.PR_HELD_POSTN_ID AND T 5.EMP_FLG = 'Y' AND (T6.REL_TYPE_CD != 'SELF') AND (T6.PARTY_ID = :1) Bind variable 1: 0-5220 ***** SQL Statement Execute Time: 0.001 seconds ***** SELECT statement with ID: 15944928 SELECT T3.CONFLICT_ID, T3.LAST_UPD, T3.CREATED, T3.LAST_UPD_BY, T3.CREATED_BY, T3.MODIFICATION_NUM, T3.ROW_ID, T3.ADDR_LINE_2, T3.ADDR,

T3.STATE, T3.COUNTRY, T3.CITY, T3.ZIPCODE, T1.ROW_ID, T3.ADDR_LINE_4, T2.BU_ID, T1.ROW_ID, T1.MODIFICATION_NUM, T1.CREATED_BY, T1.LAST_UPD_BY, T1.CREATED, T1.LAST_UPD, T1.CONFLICT_ID, T1.CONTACT_ID, T1.ADDR_PER_ID, T1.ADDR_PER_ID, T1.CONTACT_ID FROM SIEBEL.S_CON_ADDR T1, SIEBEL.S_CONTACT T2, SIEBEL.S_ADDR_PER T3 WHERE T3.PER_ID = T2.ROW_ID (+) AND T1.ADDR_PER_ID = T3.ROW_ID AND (T1.CONTACT_ID = :1) Bind variable 1: 0-1 ***** SQL Statement Execute Time: 0.001 seconds ***** SELECT statement with ID: 155A3920 SELECT T9.CONFLICT_ID, T9.LAST_UPD, T9.CREATED, T9.LAST_UPD_BY, T9.CREATED_BY, T9.MODIFICATION_NUM, T9.ROW_ID, T12.OU_ID, T12.NAME, T12.PR_EMP_ID, T12.PR_TERR_ID, T11.LAST_NAME, T11.FST_NAME, T12.PR_POSTN_ADDR_ID, T3.PR_EMP_ID, T12.BU_ID, T12.BL_PROD_ID, T1.BASE_CURCY_CD, T12.CMPNS_CURCY_CD, T12.CP_PLAN_LVL_NUM, T12.PGROUP_ID, T2.FST_NAME, T5.LOGIN, T2.LAST_NAME, T10.ADDR, T12.ROW_ID, T12.PAR_ROW_ID, T12.MODIFICATION_NUM,

T12.CREATED_BY, T12.LAST_UPD_BY, T12.CREATED, T12.LAST_UPD, T12.CONFLICT_ID, T12.PAR_ROW_ID, T4.ROW_ID, T7.ROW_ID, T8.ROW_ID, T10.ROW_ID, T6.ROW_ID, T6.MODIFICATION_NUM, T6.CREATED_BY, T6.LAST_UPD_BY, T6.CREATED, T6.LAST_UPD, T6.CONFLICT_ID, T6.PERSON_ID, T6.PARTY_ID, T6.PARTY_ID, T6.PERSON_ID FROM SIEBEL.S_ORG_EXT T1, SIEBEL.S_CONTACT T2, SIEBEL.S_POSTN T3, SIEBEL.S_PARTY_PER T4, SIEBEL.S_USER T5, SIEBEL.S_PARTY_PER T6, SIEBEL.S_PARTY T7, SIEBEL.S_CON_ADDR T8, SIEBEL.S_PARTY T9, SIEBEL.S_ADDR_PER T10, SIEBEL.S_CONTACT T11, SIEBEL.S_POSTN T12 WHERE T12.OU_ID = T1.PAR_ROW_ID AND T12.PR_EMP_ID = T11.PAR_ROW_ID (+) AND T9.PAR_PARTY_ID = T3.PAR_ROW_ID (+) AND T9.ROW_ID = T12.PAR_ROW_ID AND T12.PR_EMP_ID = T4.PERSON_ID (+) AND T12.ROW_ID = T4.PARTY_ID (+) AND T12.PR_EMP_ID = T7.ROW_ID (+) AND T12.PR_EMP_ID = T2.PAR_ROW_ID (+) AND T12.PR_EMP_ID = T5.PAR_ROW_ID (+) AND T12.PR_POSTN_ADDR_ID = T8.ADDR_PER_ID (+) AND T12.OU_ID = T8.ACCNT_ID (+) AND T12.PR_POSTN_ADDR_ID = T10.ROW_ID (+) AND T6.PARTY_ID = T9.ROW_ID AND (T6.PERSON_ID = :1) ORDER BY T12.NAME Bind variable 1: 0-1 ***** SQL Statement Execute Time: 0.002 seconds ***** 1 row(s) retrieved by ID: 15549600 0 row(s) retrieved by ID: 157F0600 0 row(s) retrieved by ID: 1588D600

1 row(s) retrieved by ID: 15587008 SELECT statement with ID: 13155170 SELECT T4.CONFLICT_ID, T4.LAST_UPD, T4.CREATED, T4.LAST_UPD_BY, T4.CREATED_BY, T4.MODIFICATION_NUM, T4.ROW_ID, T6.DYN_HRCHY_ID, T2.NAME, T5.LOC, T5.NAME, T3.NAME, T6.BU_FLG, T5.PAR_BU_ID, T5.BASE_CURCY_CD, T5.PR_ADDR_ID, T1.NAME, T5.PR_MGR_POSTN_ID, T5.ROW_ID, T5.PAR_ROW_ID, T5.MODIFICATION_NUM, T5.CREATED_BY, T5.LAST_UPD_BY, T5.CREATED, T5.LAST_UPD, T5.CONFLICT_ID, T5.PAR_ROW_ID, T6.ROW_ID, T6.PAR_ROW_ID, T6.MODIFICATION_NUM, T6.CREATED_BY, T6.LAST_UPD_BY, T6.CREATED, T6.LAST_UPD, T6.CONFLICT_ID, T6.PAR_ROW_ID FROM SIEBEL.S_POSTN T1, SIEBEL.S_DYN_HRCHY T2, SIEBEL.S_ORG_EXT T3, SIEBEL.S_PARTY T4, SIEBEL.S_ORG_EXT T5, SIEBEL.S_BU T6 WHERE T6.DYN_HRCHY_ID = T2.ROW_ID (+) AND T5.PAR_BU_ID = T3.PAR_ROW_ID (+) AND T5.PR_MGR_POSTN_ID = T1.PAR_ROW_ID (+) AND T4.ROW_ID = T5.PAR_ROW_ID AND T4.ROW_ID = T6.PAR_ROW_ID AND (T5.INT_ORG_FLG = 'Y' AND T6.BU_FLG = 'Y') AND (T4.ROW_ID = :1) ORDER BY T5.INT_ORG_FLG, T5.NAME Bind variable 1: 0-R9NH

***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 1588D600 SELECT statement with ID: 16DF0D18 SELECT T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.DEFAULT_FLG, T1.NAME FROM SIEBEL.S_DYN_HRCHY T1 WHERE (T1.DEFAULT_FLG = :1) Bind variable 1: Y ***** SQL Statement Execute Time: 0.001 seconds ***** 0 row(s) retrieved by ID: 1588D600 SELECT statement with ID: C88FC20 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.NAME, T1.BU_ID FROM SIEBEL.S_RESP T1 WHERE (T1.ROW_ID = :1) ORDER BY T1.NAME Bind variable 1: 0-30 ***** SQL Statement Execute Time: 0.001 seconds ***** SELECT statement with ID: 131D8008 SELECT T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID FROM SIEBEL.S_REPOSITORY T1 WHERE

(T1.NAME = :1) ORDER BY T1.NAME Bind variable 1: Siebel Repository ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 15537600 SELECT statement with ID: C7AE5F0 SELECT T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.FILE_AUTO_UPD_FLG, T1.FILE_DATE, T1.FILE_DEFER_FLG, T1.FILE_DOCK_REQ_FLG, T1.FILE_DOCK_STAT_FLG, T1.FILE_EXT, T1.FILE_NAME, T1.FILE_REV_NUM, T1.FILE_SIZE, T1.FILE_SRC_PATH, T1.FILE_SRC_TYPE FROM SIEBEL.S_USERLIST_ATT T1 WHERE (T1.PAR_ROW_ID = :1) Bind variable 1: 0-30 ***** SQL Statement Execute Time: 0.001 seconds ***** SELECT statement with ID: 151F6930 SELECT T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T2.FILE_REV_NUM, T2.FILE_ROW_ID, T2.FILE_TABLE_NAME, T1.NAME FROM SIEBEL.S_NODE T1, SIEBEL.S_RTS_BIG_ATT T2 WHERE T2.NODE_ID = T1.ROW_ID AND (T2.FILE_REV_NUM = :1 AND T2.FILE_ROW_ID = :2 AND T2.FILE_TABLE_NAME = :3) Bind variable 1: 05-QB3F

Bind variable 2: 05-LWDAF Bind variable 3: S_USERLIST_ATT ***** SQL Statement Execute Time: 0.001 seconds ***** 0 row(s) retrieved by ID: 133FC528 1 row(s) retrieved by ID: 1588D600 1 row(s) retrieved by ID: 15587008 SELECT statement with ID: 16D49D98 SELECT /*+ ALL_ROWS */ T3.CONFLICT_ID, T3.LAST_UPD, T3.CREATED, T3.LAST_UPD_BY, T3.CREATED_BY, T3.MODIFICATION_NUM, T3.ROW_ID, T3.CS_PATH_ID, T2.LOCAL_ACCESS_FLG, T1.PER_ID, T2.READ_ONLY_FLG, T3.NAME FROM SIEBEL.S_PER_RESP T1, SIEBEL.S_APP_VIEW_RESP T2, SIEBEL.S_APP_VIEW T3 WHERE T3.ROW_ID = T2.VIEW_ID AND T2.RESP_ID = T1.RESP_ID AND (T1.PER_ID = :1) Bind variable 1: 0-1 ***** SQL Statement Execute Time: 0.002 seconds ***** 55377 row(s) retrieved by ID: 15549600 SELECT statement with ID: 1332DC40 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VIS_COND_EXPR, T1.EFF_END_DT, T1.NAME, T1.EFF_START_DT FROM SIEBEL.S_APP_VIEW T1 WHERE (T1.VIS_COND_EXPR IS NOT NULL OR T1.EFF_START_DT IS NOT NULL OR T1.EFF_END _DT IS NOT NULL) ORDER BY T1.NAME

***** SQL Statement Execute Time: 0.005 seconds ***** 4 row(s) retrieved by ID: 15549600 SELECT statement with ID: C802758 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: SWE_ROW_COUNTER_MAP ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 15594088 SELECT statement with ID: 1333D390 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: SWE_ROW_COUNTER_MAP ***** SQL Statement Execute Time: 0.001 seconds ***** 9 row(s) retrieved by ID: 15594088

SELECT statement with ID: 1319D238 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.LOCK_FLG, T1.EFF_END_DT, T1.NAME, T1.EFF_START_DT FROM SIEBEL.S_CT_RULE_SET T1 WHERE (T1.ACTIVE_FLG = :1) ORDER BY T1.NAME Bind variable 1: Y ***** SQL Statement Execute Time: 0.004 seconds ***** 95 row(s) retrieved by ID: 15594088 SELECT statement with ID: C763368 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.INCL_RULE_EXPR, T1.METHOD_NAME, T1.METHOD_CONTEXT, T1.NAME, T1.CT_RULE_SET_ID, T1.SVC_CONTEXT, T1.SVC_METHOD_NAME, T1.SVC_NAME, T1.COND_EXPR, T1.EFF_END_DT, T1.EXCL_RULE_EXPR, T1.RULE_TYPE_CD, T1.EFF_START_DT FROM SIEBEL.S_CT_RULE T1 WHERE (T1.ACTIVE_FLG = :1) ORDER BY T1.SEQ_NUM Bind variable 1: Y ***** SQL Statement Execute Time: 0.006 seconds ***** SELECT statement with ID: C802758

SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: CT_RULE_TYPE ***** SQL Statement Execute Time: 0.017 seconds ***** 1 row(s) retrieved by ID: 1566D550 SELECT statement with ID: 1333D390 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: CT_RULE_TYPE ***** SQL Statement Execute Time: 0.012 seconds ***** 3 row(s) retrieved by ID: 1566D550 371 row(s) retrieved by ID: 15594088 SELECT statement with ID: C8AF110 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED,

T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VIS_COND_EXPR, T1.EFF_END_DT, T1.APPLET_NAME, T1.SORTSPEC, T1.EFF_START_DT FROM SIEBEL.S_CT_APPLET T1 ORDER BY T1.APPLET_NAME ***** SQL Statement Execute Time: 0.001 seconds ***** 281 row(s) retrieved by ID: 164311A8 SELECT statement with ID: 155A3920 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.LOCK_FLG, T1.CT_APPLET_ID, T1.COND_EXPR, T1.EFF_END_DT, T1.CT_RULE_SET_ID, T1.EFF_START_DT FROM SIEBEL.S_CT_APLT_RLST T1 ORDER BY T1.SEQ_NUM ***** SQL Statement Execute Time: 0.001 seconds ***** 143 row(s) retrieved by ID: 1551F008 SELECT statement with ID: 16D31DF0 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T2.ACTIVATE_DT, T2.BUSCOMP_NAME, T2.DEFAULT_STATE_ID, T2.EXPIRE_DT, T2.FIELD_NAME, T1.DESC_TEXT, T1.VALUE,

T1.ROW_ID FROM SIEBEL.S_SM_STATE T1, SIEBEL.S_STATE_MODEL T2 WHERE T2.DEFAULT_STATE_ID = T1.ROW_ID (+) AND (T2.EXPIRE_DT IS NULL OR T2.EXPIRE_DT >= TO_DATE(:1,'MM/DD/YYYY HH24:MI:SS ')) ORDER BY T2.NAME Bind variable 1: 10/05/2011 13:57:34 ***** SQL Statement Execute Time: 0.002 seconds ***** 66 row(s) retrieved by ID: 1602E2C0 SELECT statement with ID: 15944928 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VALUE, T1.DESC_TEXT, T1.RSTRCT_DEL_FLG, T1.RSTRCT_TRNS_FLG, T1.RSTRCT_UPD_FLG FROM SIEBEL.S_SM_STATE T1 WHERE (T1.STATE_MODEL_ID = :1) ORDER BY T1.STATE_MODEL_ID, T1.VALUE Bind variable 1: 1-XOM ***** SQL Statement Execute Time: 0.001 seconds ***** SELECT statement with ID: C8A8448 SELECT /*+ ALL_ROWS */ T3.CONFLICT_ID, T3.LAST_UPD, T3.CREATED, T3.LAST_UPD_BY, T3.CREATED_BY, T3.MODIFICATION_NUM, T3.ROW_ID, T3.FROM_STATE_ID, T3.RULE_FIELD_NAME, T1.VALUE, T3.PUBLIC_FLG, T3.RULE_EXPR, T3.RULE_OPERATOR, T3.RULE_VALUE, T3.STATE_MODEL_ID, T3.TO_STATE_ID,

T2.VALUE FROM SIEBEL.S_SM_STATE T1, SIEBEL.S_SM_STATE T2, SIEBEL.S_SM_TRANSITION T3 WHERE T3.FROM_STATE_ID = T1.ROW_ID (+) AND T3.TO_STATE_ID = T2.ROW_ID (+) AND (T3.STATE_MODEL_ID = :1) ORDER BY T1.VALUE, T2.VALUE Bind variable 1: 1-XOM ***** SQL Statement Execute Time: 0.001 seconds ***** SELECT statement with ID: 1667A6D8 SELECT /*+ ALL_ROWS */ T4.CONFLICT_ID, T4.LAST_UPD, T4.CREATED, T4.LAST_UPD_BY, T4.CREATED_BY, T4.MODIFICATION_NUM, T4.ROW_ID, T2.VALUE, T4.POSITION_ID, T3.VALUE FROM SIEBEL.S_SM_TRANSITION T1, SIEBEL.S_SM_STATE T2, SIEBEL.S_SM_STATE T3, SIEBEL.S_SM_TRNS_POSTN T4 WHERE T1.FROM_STATE_ID = T2.ROW_ID AND T4.STATE_TRNS_ID = T1.ROW_ID AND T1.TO_STATE_ID = T3.ROW_ID AND (T1.PUBLIC_FLG = 'N') AND (T1.STATE_MODEL_ID = :1 AND NOT (T1.PUBLIC_FLG = :2)) Bind variable 1: 1-XOM Bind variable 2: Y ***** SQL Statement Execute Time: 0.001 seconds ***** 4 row(s) retrieved by ID: 166507D8 18 row(s) retrieved by ID: 16678840 9 row(s) retrieved by ID: 1665E128 SELECT statement with ID: C802758 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID,

T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: HLS_CASE_STATUS ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 1665E128 SELECT statement with ID: 1333D390 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: HLS_CASE_STATUS ***** SQL Statement Execute Time: 0.001 seconds ***** 4 row(s) retrieved by ID: 1665E128 SELECT statement with ID: C802758 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE

T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: CAL_DATEDISPLAY_FORMAT ***** SQL Statement Execute Time: 0.001 seconds ***** 1 row(s) retrieved by ID: 1670CEF0 SELECT statement with ID: 1333D390 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: CAL_DATEDISPLAY_FORMAT ***** SQL Statement Execute Time: 0.001 seconds ***** 6 row(s) retrieved by ID: 1670CEF0 SELECT statement with ID: C802758 SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE

Bind variable 2: EMPLOYMENT_STATUS ***** SQL Statement Execute Time: 0.000 seconds ***** 1 row(s) retrieved by ID: 1671B438 SELECT statement with ID: 1333D390 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: EMPLOYMENT_STATUS ***** SQL Statement Execute Time: 0.000 seconds ***** 4 row(s) retrieved by ID: 1671B438 SELECT statement with ID: C833B40 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.CACHE_RSLT_FLG, T1.DESC_TEXT, T1.QUERY_STRING, T1.OWNER_ID FROM SIEBEL.S_APP_QUERY T1 WHERE (T1.OWNER_ID = :1 OR T1.PRIV_FLG = 'N') AND (T1.NAME = :2) ORDER BY T1.NAME, T1.DESC_TEXT Bind variable 1: 0-1 Bind variable 2: HLS Home ***** SQL Statement Execute Time: 0.001 seconds ***** SELECT statement with ID: C802758

SELECT /*+ ALL_ROWS */ T2.CONFLICT_ID, T2.LAST_UPD, T2.CREATED, T2.LAST_UPD_BY, T2.CREATED_BY, T2.MODIFICATION_NUM, T2.ROW_ID, T1.BU_ID, T2.MULTI_LINGUAL_FLG FROM SIEBEL.S_LST_OF_VAL_BU T1, SIEBEL.S_LST_OF_VAL T2 WHERE T2.ROW_ID = T1.LST_OF_VAL_ID (+) AND (T2.TYPE = :1 AND T2.NAME = :2) ORDER BY T2.TYPE, T2.ORDER_BY, T2.VAL Bind variable 1: LOV_TYPE Bind variable 2: ACTIVITY_DISPLAY_CODE ***** SQL Statement Execute Time: 0.000 seconds ***** 1 row(s) retrieved by ID: 167268A0 SELECT statement with ID: 1333D390 SELECT /*+ ALL_ROWS */ T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.VAL, T1.DFLT_LIC_FLG, T1.NAME FROM SIEBEL.S_LST_OF_VAL T1 WHERE (T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND (T1.TYPE = :2 AND T1.BU_ID IS NULL) ORDER BY T1.TYPE, T1.ORDER_BY, T1.VAL Bind variable 1: Y Bind variable 2: ACTIVITY_DISPLAY_CODE ***** SQL Statement Execute Time: 0.000 seconds ***** 4 row(s) retrieved by ID: 167268A0 SELECT statement with ID: 16729748 SELECT /*+ ALL_ROWS */ T21.CONFLICT_ID, T21.LAST_UPD, T21.CREATED, T21.LAST_UPD_BY, T21.CREATED_BY,

T21.MODIFICATION_NUM, T21.ROW_ID, T21.ROW_ID, T21.PYMNT_FLG, T6.ASSET_NUM, T9.RTE_APPR_FLG, T9.MIN_CAPABILITY_LVL, T9.MAX_CAPABILITY_LVL, T14.AMS_ACT_ID, T21.OWNER_OU_ID, T21.PR_PRDINT_ID, T21.CL_PTCL_ST_ID, T9.NAME, T21.APPT_START_TM, T21.CL_SUBJ_ID, T14.SUB_TYPE_CD, T14.AMS_ROUTE_TO_CD, T21.SUBTYPE_CD, T21.APPT_END_DT, T21.ME_EVT_ID, T21.APPT_REPT_TYPE, T21.APPT_REPT_END_DT, T21.APPT_REPT_FLG, T21.TODO_CD, T21.TODO_ACTL_START_DT, T21.EVT_STAT_CD, T21.PRIV_FLG, T7.LOC, T21.TARGET_OU_ID, T21.SRA_SR_ID, T21.CAL_DISP_FLG, T21.NAME, T21.CREATOR_LOGIN, T21.COMMENTS_LONG, T21.TODO_ACTL_END_DT, T21.ALARM_FLAG, T21.SRA_DEFECT_ID, T7.NAME, T21.APPT_DURATION_MIN, T20.NAME, T21.OPTY_ID, T21.TODO_PLAN_START_DT, T21.TARGET_PER_ID, T21.APPT_REPT_APPT_ID, T21.APPT_REPT_REPL_CD, T21.TODO_PLAN_END_DT, T21.PCT_COMPLETE, T21.DONE_FLG, T21.ASSET_ID, T21.PR_SYMPTOM_CD, T21.TARGET_OU_ADDR_ID, T21.TARGET_PER_ADDR_ID, T21.TODO_AFTER_DT, T21.ACTIVITY_UID, T4.OWN_INST_ID, T4.INTEGRATION_ID, T12.ACTL_START_DT, T12.ACTL_END_DT, T12.PLAN_START_DT, T12.PLAN_END_DT,

T11.BL_CLASS_CD, T21.PR_ORDER_ID, T21.CAL_TYPE_CD, T21.PAR_EVT_ID, T21.TEMPLATE_FLG, T21.PREV_ACT_ID, T17.SRV_REGN_ID, T21.PROJ_ID, T11.NAME, T21.APPT_START_DT, T21.APPT_ALARM_TM_MIN, T21.BILLABLE_FLG, T21.AGREEMENT_ID, T21.SRV_REGN_ID, T21.OWNER_LOGIN, T21.OWNER_PER_ID, T18.NUM_PAGE, T7.BASE_CURCY_CD, T11.BL_CURCY_CD, T20.CURCY_CD, T11.PROJ_NUM, T15.FORMAT_TYPE_CD, T21.SRC_ID, T21.COST_CURCY_CD, T21.SRC_EVT_REG_ID, T1.EMP_ID, T21.PR_PROD_CAT_ID, T3.ACTIVE_FLG, T3.STAGE_ID, T3.SRM_REQUEST_ID, T19.SEBL_APPT_FLG, T19.PIM_APPT_FLG, T19.UNSPRTD_REPT_FLG, T13.AMS_CAPABILITY_LVL, T16.LOGIN, T10.ROW_ID, T2.ROW_STATUS, T8.ROW_ID, T14.ROW_ID, T14.PAR_ROW_ID, T14.MODIFICATION_NUM, T14.CREATED_BY, T14.LAST_UPD_BY, T14.CREATED, T14.LAST_UPD, T14.CONFLICT_ID, T14.PAR_ROW_ID, T3.ROW_ID, T3.PAR_ROW_ID, T3.MODIFICATION_NUM, T3.CREATED_BY, T3.LAST_UPD_BY, T3.CREATED, T3.LAST_UPD, T3.CONFLICT_ID, T3.PAR_ROW_ID, T18.ROW_ID, T18.PAR_ROW_ID, T18.MODIFICATION_NUM, T18.CREATED_BY,

T18.LAST_UPD_BY, T18.CREATED, T18.LAST_UPD, T18.CONFLICT_ID, T18.PAR_ROW_ID, T15.ROW_ID, T15.PAR_ROW_ID, T15.MODIFICATION_NUM, T15.CREATED_BY, T15.LAST_UPD_BY, T15.CREATED, T15.LAST_UPD, T15.CONFLICT_ID, T15.PAR_ROW_ID, T4.ROW_ID, T4.PAR_ROW_ID, T4.MODIFICATION_NUM, T4.CREATED_BY, T4.LAST_UPD_BY, T4.CREATED, T4.LAST_UPD, T4.CONFLICT_ID, T4.PAR_ROW_ID, T19.ROW_ID, T19.PAR_ROW_ID, T19.MODIFICATION_NUM, T19.CREATED_BY, T19.LAST_UPD_BY, T19.CREATED, T19.LAST_UPD, T19.CONFLICT_ID, T19.PAR_ROW_ID, T2.ROW_ID, T10.ROW_ID, T8.ROW_ID FROM SIEBEL.S_ACT_EMP T1, SIEBEL.S_ACT_EMP T2, SIEBEL.S_EVT_MKTG T3, SIEBEL.S_EVT_ACT_SS T4, SIEBEL.S_OPTY_POSTN T5, SIEBEL.S_ASSET T6, SIEBEL.S_ORG_EXT T7, SIEBEL.S_PARTY T8, SIEBEL.S_FN_APPR T9, SIEBEL.S_PARTY T10, SIEBEL.S_PROJ T11, SIEBEL.S_PROJITEM T12, SIEBEL.S_CONTACT_FNX T13, SIEBEL.S_EVT_ACT_FNX T14, SIEBEL.S_EVT_MAIL T15, SIEBEL.S_USER T16, SIEBEL.S_EMP_PER T17, SIEBEL.S_EVT_ACT_LSX T18, SIEBEL.S_EVT_CAL T19, SIEBEL.S_OPTY T20, SIEBEL.S_EVT_ACT T21 WHERE T21.ROW_ID = T1.ACTIVITY_ID (+) AND T21.OWNER_PER_ID = T17.PAR_ROW_ID (+) AND

T21.OPTY_ID = T5.OPTY_ID (+) AND T5.POSITION_ID (+) = :1 AND T21.TARGET_OU_ID = T7.PAR_ROW_ID (+) AND T21.OPTY_ID = T20.ROW_ID (+) AND T21.ASSET_ID = T6.ROW_ID (+) AND T21.PROJ_ID = T11.ROW_ID (+) AND T21.PROJ_ITEM_ID = T12.ROW_ID (+) AND T14.AMS_ACT_ID = T9.ROW_ID (+) AND T21.ROW_ID = T14.PAR_ROW_ID (+) AND T21.ROW_ID = T3.PAR_ROW_ID (+) AND T21.ROW_ID = T18.PAR_ROW_ID (+) AND T21.ROW_ID = T15.PAR_ROW_ID (+) AND T21.ROW_ID = T4.PAR_ROW_ID (+) AND T21.ROW_ID = T19.PAR_ROW_ID (+) AND T2.EMP_ID = :2 AND T21.ROW_ID = T2.ACTIVITY_ID AND T2.EMP_ID = T10.ROW_ID AND T2.EMP_ID = T13.PAR_ROW_ID (+) AND T2.EMP_ID = T16.PAR_ROW_ID (+) AND T21.TARGET_PER_ID = T8.ROW_ID (+) AND (((T2.ACT_APPT_REPT_FLG =