GENERAL INFORMATION SECTION ------------------------------------------------------------------------------- Tuning Task Name : staName83025 Tuning Task Owner : CBS_VIEW Tuning Task ID : 29277 Workload Type : Single SQL Statement Execution Count : 1 Current Execution : EXEC_30551 Execution Type : TUNE SQL Scope : COMPREHENSIVE Time Limit(seconds): 1800 Completion Status : COMPLETED Started at : 01/24/2019 10:09:47 Completed at : 01/24/2019 10:10:52 ------------------------------------------------------------------------------- Schema Name: CBS_VIEW SQL ID : 5vamh71ak5gxv SQL Text : select distinct 'Workflow' Category, tt.docket_number_n ticket_no, wm.wrkflw_desc_v Workflow_desc, wm.estimated_resoln_tm_n sla_time,tt.ticket_regn_dt_d ticket_reg_date, round((cast((FROM_TZ(CAST(tt.ticket_regn_dt_d as timestamp), sessiontimezone) at time zone 'GMT') as date) - TO_DATE('01-01-1970','MM-DD-YYYY')) * 86400) tk_reg_date_sec, x.start_dt_d ticket_start_date, round((cast((FROM_TZ(CAST(x.start_dt_d as timestamp), sessiontimezone) at time zone 'GMT') as date) - TO_DATE('01-01-1970','MM-DD-YYYY')) * 86400) tk_start_date_sec, x.end_dt_d ticket_end_date, round((cast((FROM_TZ(CAST(x.end_dt_d as timestamp), sessiontimezone) at time zone 'GMT') as date) - TO_DATE('01-01-1970','MM-DD-YYYY')) * 86400) tk_end_date_sec, tt.ticket_resp_dt_d ticket_resp_date, round((cast((FROM_TZ(CAST(tt.ticket_resp_dt_d as timestamp), sessiontimezone) at time zone 'GMT') as date) - TO_DATE('01-01-1970','MM-DD-YYYY')) * 86400) tk_resp_date_sec, round((cast((FROM_TZ(CAST(sysdate as timestamp), sessiontimezone) at time zone 'GMT') as date) - TO_DATE('01-01-1970','MM-DD-YYYY')) * 86400) sys_date, decode(tt.status_v,'P','Pending','A','Task completed','C','Closed','R','Resolved') StatusTicket, --decode(tas.status_v,'R','Resolved','W','Wrong Assignemnt') Assignment_status, decode(tt.ticket_type_v,'Q','Query','C','Complaint Type','R','Service Request') Ticket_type, (select A3.CATEGORY_DESCRIPTION_V from TT_CATEGORY_MASTER A3 where A3.category_code_v = (select A2.parent_category_code_v from TT_CATEGORY_MASTER A2 where A2.category_code_v = (select t1.subcategory_id_v from TT_TICKETINFO t1 where t1.docket_number_n = tt.docket_number_n)) and A3.parent_category_code_v <> '0') Complaint_type, (SELECT distinct A1.CATEGORY_DESCRIPTION_V FROM TT_CATEGORY_MASTER A1 WHERE A1.CATEGORY_CODE_V = tt.SUBCATEGORY_ID_V ) SubComplaint_type, (select d.mobl_num_voice_v from gsm_service_mast d, TT_TICKETINFO tti where tti.entity_id_n = d.mobl_num_voice_v and tti.docket_number_n = tt.docket_number_n) MSISDN, (select d.sub_service_code_v from gsm_service_mast d , TT_TICKETINFO tti where tti.entity_id_n = d.mobl_num_voice_v and tti.docket_number_n = tt.docket_number_n) Service_code, (select d.subscriber_category_v from gsm_service_mast d, TT_TICKETINFO tti where tti.entity_id_n = d.mobl_num_voice_v and tti.docket_number_n = tt.docket_number_n ) Segments, (select g.SUBS_SUB_CATEGORY_DESC_V from gsm_service_mast d,cb_subscriber_sub_category g , TT_TICKETINFO tti where tti.entity_id_n = d.mobl_num_voice_v and tti.docket_number_n = tt.docket_number_n and d.subscriber_category_v = g.subs_category_code_v and d.subscriber_sub_category_v = g.subs_sub_category_code_v) sub_segments, (select d.status_code_v from gsm_service_mast d , TT_TICKETINFO tti where tti.entity_id_n = d.mobl_num_voice_v and tti.docket_number_n = tt.docket_number_n) mob_status, (select d.account_code_n from gsm_service_mast d, TT_TICKETINFO tti where tti.entity_id_n = d.mobl_num_voice_v and tti.docket_number_n = tt.docket_number_n) Account_no, --a.expiry_time_d bin_expiry_date, --round((cast((FROM_TZ(CAST(a.expiry_time_d as timestamp), sessiontimezone) at time zone 'GMT') as date) - TO_DATE('01-01-1970','MM-DD-YYYY')) * 86400) bin_expiry_date_sec, --a.assignment_dt_d bin_assign_date, --round((cast((FROM_TZ(CAST(a.assignment_dt_d as timestamp), sessiontimezone) at time zone 'GMT') as date) - TO_DATE('01-01-1970','MM-DD-YYYY')) * 86400) bin_assign_date_sec, --a.work_completion_dt_d bin_comp_date, --round((cast((FROM_TZ(CAST(a.work_completion_dt_d as timestamp), sessiontimezone) at time zone 'GMT') as date) - TO_DATE('01-01-1970','MM-DD-YYYY')) * 86400) bin_compl_date_sec, x.status_v wf_status,tt.tt_source_v Source_v, (select distinct cm.CATEGORY_DESCRIPTION_V from TT_CATEGORY_MASTER cm where cm.category_code_v = tt.category_id_v and cm.category_type_v = tt.ticket_type_v and cm.parent_category_code_v = '0') Category_desc, (select f.user_name_v from cb_users f where f.user_code_n = tt.LOGGED_BY_N) Created_by, cu.user_name_v Assign_to, e.GROUP_NAME_V activity_name_v, tt.question_v,tt.answer_v, null Notes, --a.notes_v, (SELECT CFT.fault_name_v FROM TT_TICKET_ADDNL_INFO TAI, cb_fault_types CFT where TAI.FAULT_CODE_V = CFT.FAULT_CODE_V and tt.docket_number_n = TAI.docket_number_n) ROOT_CAUSE, cu.user_name_v user_name from --WF_TODOITEM a, WF_WORKFLOW x , --WF_WORKASSIGNMENT c, TT_TICKETINFO tt,WF_WRKFLWMGR wm,cb_users cu , cb_user_group e where --a.event_refno_v = x.event_refno_v tt.docket_number_n = x.event_refno_v and x.wrkflw_id_n = wm.wrkflw_id_n --and tas.docket_number_n = tt.docket_number_n --and a.work_id_n = c.work_id_n --and tt.docket_number_n = '35022' and tt.LOGGED_BY_N = cu.user_code_n AND cu.GROUP_CODE_N = e.GROUP_CODE_N union all select distinct 'FLR' Category, tt.docket_number_n ticket_no,null Workflow_desc, null sla_time, tt.ticket_regn_dt_d registration_date,null wf_reg_date_sec,null start_date, null wf_start_date_sec,null wf_end_date,null wf_end_date_sec,tt.ticket_resp_dt_d workflw_resp_date, null wf_resp_date_sec, round((cast((FROM_TZ(CAST(sysdate as timestamp), sessiontimezone) at time zone 'GMT') as date) - TO_DATE('01-01-1970','MM-DD-YYYY')) * 86400) sys_date, decode(tt.status_v,'P','Pending','A','Task completed','C','Closed','R','Resolved') StatusTicket, --decode(tas.status_v,'R','Resolved','W','Wrong Assignemnt') Assignment_status, decode(tt.ticket_type_v,'Q','Query','C','Complaint Type','R','Service Request') Ticket_type, (select A3.CATEGORY_DESCRIPTION_V from TT_CATEGORY_MASTER A3 where A3.category_code_v = (select A2.parent_category_code_v from TT_CATEGORY_MASTER A2 where A2.category_code_v = (select t1.subcategory_id_v from TT_TICKETINFO t1 where t1.docket_number_n = tt.docket_number_n)) and A3.parent_category_code_v <> '0') Complaint_type, (SELECT distinct A1.CATEGORY_DESCRIPTION_V FROM TT_CATEGORY_MASTER A1 WHERE A1.CATEGORY_CODE_V = tt.SUBCATEGORY_ID_V ) SubComplaint_type, (select d.mobl_num_voice_v from gsm_service_mast d, TT_TICKETINFO tti where tti.entity_id_n = d.mobl_num_voice_v and tti.docket_number_n = tt.docket_number_n) MSISDN, (select d.sub_service_code_v from gsm_service_mast d , TT_TICKETINFO tti where tti.entity_id_n = d.mobl_num_voice_v and tti.docket_number_n = tt.docket_number_n) Service_code, (select d.subscriber_category_v from gsm_service_mast d, TT_TICKETINFO tti where tti.entity_id_n = d.mobl_num_voice_v and tti.docket_number_n = tt.docket_number_n) Segments, (select g.SUBS_SUB_CATEGORY_DESC_V from gsm_service_mast d,cb_subscriber_sub_category g , TT_TICKETINFO tti where tti.entity_id_n = d.mobl_num_voice_v and tti.docket_number_n = tt.docket_number_n and d.subscriber_category_v = g.subs_category_code_v and d.subscriber_sub_category_v = g.subs_sub_category_code_v) sub_segments, (select d.status_code_v from gsm_service_mast d , TT_TICKETINFO tti where tti.entity_id_n = d.mobl_num_voice_v and tti.docket_number_n = tt.docket_number_n) mob_status, (select d.account_code_n from gsm_service_mast d, TT_TICKETINFO tti where tti.entity_id_n = d.mobl_num_voice_v and tti.docket_number_n = tt.docket_number_n) Account_no, null wf_status,tt.tt_source_v Source_v, (select distinct cm.CATEGORY_DESCRIPTION_V from TT_CATEGORY_MASTER cm where cm.category_code_v = tt.category_id_v and cm.category_type_v = tt.ticket_type_v and cm.parent_category_code_v = '0') Category_desc, (select f.user_name_v from cb_users f where f.user_code_n = tt.LOGGED_BY_N) Created_by, null Assign_to, C.GROUP_NAME_V activity_name, tt.question_v,tt.answer_v, TTI.NOTES_V Notes, (SELECT CFT.fault_name_v FROM TT_TICKET_ADDNL_INFO TAI, cb_fault_types CFT--, TT_TICKETINFO c where TAI.FAULT_CODE_V = CFT.FAULT_CODE_V and tt.docket_number_n = TAI.docket_number_n) ROOT_CAUSE, B.USER_NAME_V user_name from TT_TICKETINFO tt, CB_USERS B, CB_USER_GROUP C, TT_TICKETINCIDENT TTI where tt.docket_number_n not in(select event_refno_v from WF_WORKFLOW) AND TTI.INCIDENT_NUMBER_N = tt.docket_number_n AND tt.LOGGED_BY_N = B.USER_CODE_N AND C.GROUP_CODE_N = B.GROUP_CODE_N ------------------------------------------------------------------------------- FINDINGS SECTION (1 finding) ------------------------------------------------------------------------------- 1- SQL Profile Finding (see explain plans section below) -------------------------------------------------------- A potentially better execution plan was found for this statement. Recommendation (estimated benefit: 87.9%) ----------------------------------------- - Consider accepting the recommended SQL profile. execute dbms_sqltune.accept_sql_profile(task_name => 'staName83025', task_owner => 'CBS_VIEW', replace => TRUE); ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4234275777 ------------------------------------------------------------------------------------------------------------------------------------------------ | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | Pstart| Pstop | ------------------------------------------------------------------------------------------------------------------------------------------------ | 0 | SELECT STATEMENT | | 665K| 168M| | 23M (1)| 00:31:09 | | | | 1 | UNION-ALL | | | | | | | | | |* 2 | TABLE ACCESS BY INDEX ROWID | TT_CATEGORY_MASTER | 1 | 37 | | 2 (0)| 00:00:01 | | | |* 3 | INDEX UNIQUE SCAN | TT_CATEGORY_CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 4 | TABLE ACCESS BY INDEX ROWID | TT_CATEGORY_MASTER | 1 | 18 | | 2 (0)| 00:00:01 | | | |* 5 | INDEX UNIQUE SCAN | TT_CATEGORY_CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 6 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 14 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 7 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 8 | TABLE ACCESS BY INDEX ROWID | TT_CATEGORY_MASTER | 1 | 28 | | 2 (0)| 00:00:01 | | | |* 9 | INDEX UNIQUE SCAN | TT_CATEGORY_CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 10 | NESTED LOOPS | | 1 | 21 | | 5 (0)| 00:00:01 | | | | 11 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 12 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 13 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 10 | | 3 (0)| 00:00:01 | | | |* 14 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | | 15 | NESTED LOOPS | | 1 | 24 | | 5 (0)| 00:00:01 | | | | 16 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 17 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 18 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 13 | | 3 (0)| 00:00:01 | | | |* 19 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | | 20 | NESTED LOOPS | | 1 | 20 | | 5 (0)| 00:00:01 | | | | 21 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 22 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 23 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 9 | | 3 (0)| 00:00:01 | | | |* 24 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | | 25 | NESTED LOOPS | | 1 | 55 | | 6 (0)| 00:00:01 | | | | 26 | NESTED LOOPS | | 1 | 55 | | 6 (0)| 00:00:01 | | | | 27 | NESTED LOOPS | | 1 | 25 | | 5 (0)| 00:00:01 | | | | 28 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 29 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 30 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 14 | | 3 (0)| 00:00:01 | | | |* 31 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | |* 32 | INDEX UNIQUE SCAN | SUBS_SUB_CATEGORY#CODE$PK | 1 | | | 0 (0)| 00:00:01 | | | | 33 | TABLE ACCESS BY INDEX ROWID | CB_SUBSCRIBER_SUB_CATEGORY | 1 | 30 | | 1 (0)| 00:00:01 | | | | 34 | NESTED LOOPS | | 1 | 18 | | 5 (0)| 00:00:01 | | | | 35 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 36 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 37 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 7 | | 3 (0)| 00:00:01 | | | |* 38 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | | 39 | NESTED LOOPS | | 1 | 20 | | 5 (0)| 00:00:01 | | | | 40 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 41 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 42 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 9 | | 3 (0)| 00:00:01 | | | |* 43 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | |* 44 | TABLE ACCESS BY INDEX ROWID | TT_CATEGORY_MASTER | 1 | 39 | | 2 (0)| 00:00:01 | | | |* 45 | INDEX UNIQUE SCAN | TT_CATEGORY_CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 46 | TABLE ACCESS BY INDEX ROWID | CB_USERS | 1 | 18 | | 2 (0)| 00:00:01 | | | |* 47 | INDEX UNIQUE SCAN | CB_USERS#CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 48 | NESTED LOOPS | | 1 | 31 | | 3 (0)| 00:00:01 | | | |* 49 | TABLE ACCESS BY INDEX ROWID | TT_TICKET_ADDNL_INFO | 1 | 7 | | 2 (0)| 00:00:01 | | | |* 50 | INDEX UNIQUE SCAN | TT_TICKET_ADDNL_INFO_PK | 1 | | | 1 (0)| 00:00:01 | | | | 51 | TABLE ACCESS BY INDEX ROWID | CB_FAULT_TYPES | 1 | 24 | | 1 (0)| 00:00:01 | | | |* 52 | INDEX UNIQUE SCAN | CB_FAULT_TYPES#U$1 | 1 | | | 0 (0)| 00:00:01 | | | | 53 | HASH UNIQUE | | 43761 | 10M| 11M| 1521K (1)| 00:01:59 | | | |* 54 | HASH JOIN | | 43761 | 10M| | 130K (1)| 00:00:11 | | | | 55 | TABLE ACCESS FULL | WF_WRKFLWMGR | 95 | 3135 | | 6 (0)| 00:00:01 | | | |* 56 | HASH JOIN | | 43761 | 9188K| | 130K (1)| 00:00:11 | | | | 57 | TABLE ACCESS FULL | CB_USER_GROUP | 92 | 1840 | | 4 (0)| 00:00:01 | | | |* 58 | HASH JOIN | | 43761 | 8333K| | 130K (1)| 00:00:11 | | | | 59 | TABLE ACCESS FULL | CB_USERS | 1511 | 33242 | | 19 (0)| 00:00:01 | | | | 60 | NESTED LOOPS | | 43773 | 7395K| | 130K (1)| 00:00:11 | | | | 61 | NESTED LOOPS | | 43773 | 7395K| | 130K (1)| 00:00:11 | | | | 62 | PARTITION RANGE ALL | | 43773 | 1453K| | 86981 (1)| 00:00:07 | 1 |1048575| | 63 | TABLE ACCESS FULL | WF_WORKFLOW | 43773 | 1453K| | 86981 (1)| 00:00:07 | 1 |1048575| |* 64 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 0 (0)| 00:00:01 | | | | 65 | TABLE ACCESS BY GLOBAL INDEX ROWID| TT_TICKETINFO | 1 | 139 | | 1 (0)| 00:00:01 | ROWID | ROWID | |* 66 | TABLE ACCESS BY INDEX ROWID | TT_CATEGORY_MASTER | 1 | 37 | | 2 (0)| 00:00:01 | | | |* 67 | INDEX UNIQUE SCAN | TT_CATEGORY_CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 68 | TABLE ACCESS BY INDEX ROWID | TT_CATEGORY_MASTER | 1 | 18 | | 2 (0)| 00:00:01 | | | |* 69 | INDEX UNIQUE SCAN | TT_CATEGORY_CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 70 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 14 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 71 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 72 | TABLE ACCESS BY INDEX ROWID | TT_CATEGORY_MASTER | 1 | 28 | | 2 (0)| 00:00:01 | | | |* 73 | INDEX UNIQUE SCAN | TT_CATEGORY_CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 74 | NESTED LOOPS | | 1 | 21 | | 5 (0)| 00:00:01 | | | | 75 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 76 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 77 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 10 | | 3 (0)| 00:00:01 | | | |* 78 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | | 79 | NESTED LOOPS | | 1 | 24 | | 5 (0)| 00:00:01 | | | | 80 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 81 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 82 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 13 | | 3 (0)| 00:00:01 | | | |* 83 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | | 84 | NESTED LOOPS | | 1 | 20 | | 5 (0)| 00:00:01 | | | | 85 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 86 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 87 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 9 | | 3 (0)| 00:00:01 | | | |* 88 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | | 89 | NESTED LOOPS | | 1 | 55 | | 6 (0)| 00:00:01 | | | | 90 | NESTED LOOPS | | 1 | 55 | | 6 (0)| 00:00:01 | | | | 91 | NESTED LOOPS | | 1 | 25 | | 5 (0)| 00:00:01 | | | | 92 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 93 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 94 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 14 | | 3 (0)| 00:00:01 | | | |* 95 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | |* 96 | INDEX UNIQUE SCAN | SUBS_SUB_CATEGORY#CODE$PK | 1 | | | 0 (0)| 00:00:01 | | | | 97 | TABLE ACCESS BY INDEX ROWID | CB_SUBSCRIBER_SUB_CATEGORY | 1 | 30 | | 1 (0)| 00:00:01 | | | | 98 | NESTED LOOPS | | 1 | 18 | | 5 (0)| 00:00:01 | | | | 99 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |*100 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 101 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 7 | | 3 (0)| 00:00:01 | | | |*102 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | | 103 | NESTED LOOPS | | 1 | 20 | | 5 (0)| 00:00:01 | | | | 104 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |*105 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 106 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 9 | | 3 (0)| 00:00:01 | | | |*107 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | |*108 | TABLE ACCESS BY INDEX ROWID | TT_CATEGORY_MASTER | 1 | 39 | | 2 (0)| 00:00:01 | | | |*109 | INDEX UNIQUE SCAN | TT_CATEGORY_CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 110 | TABLE ACCESS BY INDEX ROWID | CB_USERS | 1 | 18 | | 2 (0)| 00:00:01 | | | |*111 | INDEX UNIQUE SCAN | CB_USERS#CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 112 | NESTED LOOPS | | 1 | 31 | | 3 (0)| 00:00:01 | | | |*113 | TABLE ACCESS BY INDEX ROWID | TT_TICKET_ADDNL_INFO | 1 | 7 | | 2 (0)| 00:00:01 | | | |*114 | INDEX UNIQUE SCAN | TT_TICKET_ADDNL_INFO_PK | 1 | | | 1 (0)| 00:00:01 | | | | 115 | TABLE ACCESS BY INDEX ROWID | CB_FAULT_TYPES | 1 | 24 | | 1 (0)| 00:00:01 | | | |*116 | INDEX UNIQUE SCAN | CB_FAULT_TYPES#U$1 | 1 | | | 0 (0)| 00:00:01 | | | | 117 | HASH UNIQUE | | 621K| 140M| 149M| 22M (1)| 00:29:10 | | | |*118 | HASH JOIN | | 621K| 140M| | 182K (1)| 00:00:15 | | | | 119 | TABLE ACCESS FULL | CB_USER_GROUP | 92 | 1840 | | 4 (0)| 00:00:01 | | | |*120 | HASH JOIN RIGHT ANTI NA | | 621K| 128M| | 182K (1)| 00:00:15 | | | | 121 | PARTITION RANGE ALL | | 43773 | 299K| | 86981 (1)| 00:00:07 | 1 |1048575| | 122 | TABLE ACCESS FULL | WF_WORKFLOW | 43773 | 299K| | 86981 (1)| 00:00:07 | 1 |1048575| |*123 | HASH JOIN | | 621K| 124M| | 95738 (1)| 00:00:08 | | | | 124 | TABLE ACCESS FULL | CB_USERS | 1511 | 33242 | | 19 (0)| 00:00:01 | | | |*125 | HASH JOIN | | 621K| 111M| 77M| 95717 (1)| 00:00:08 | | | | 126 | TABLE ACCESS FULL | TT_TICKETINCIDENT | 1327K| 62M| | 2673 (1)| 00:00:01 | | | | 127 | PARTITION RANGE ALL | | 621K| 82M| | 85914 (1)| 00:00:07 | 1 |1048575| | 128 | TABLE ACCESS FULL | TT_TICKETINFO | 621K| 82M| | 85914 (1)| 00:00:07 | 1 |1048575| ------------------------------------------------------------------------------------------------------------------------------------------------ Query Block Name / Object Alias (identified by operation id): ------------------------------------------------------------- 1 - SET$1 2 - SEL$2 / A3@SEL$2 3 - SEL$2 / A3@SEL$2 4 - SEL$3 / A2@SEL$3 5 - SEL$3 / A2@SEL$3 6 - SEL$4 / T1@SEL$4 7 - SEL$4 / T1@SEL$4 8 - SEL$5 / A1@SEL$5 9 - SEL$5 / A1@SEL$5 10 - SEL$6 11 - SEL$6 / TTI@SEL$6 12 - SEL$6 / TTI@SEL$6 13 - SEL$6 / D@SEL$6 14 - SEL$6 / D@SEL$6 15 - SEL$7 16 - SEL$7 / TTI@SEL$7 17 - SEL$7 / TTI@SEL$7 18 - SEL$7 / D@SEL$7 19 - SEL$7 / D@SEL$7 20 - SEL$8 21 - SEL$8 / TTI@SEL$8 22 - SEL$8 / TTI@SEL$8 23 - SEL$8 / D@SEL$8 24 - SEL$8 / D@SEL$8 25 - SEL$9 28 - SEL$9 / TTI@SEL$9 29 - SEL$9 / TTI@SEL$9 30 - SEL$9 / D@SEL$9 31 - SEL$9 / D@SEL$9 32 - SEL$9 / G@SEL$9 33 - SEL$9 / G@SEL$9 34 - SEL$10 35 - SEL$10 / TTI@SEL$10 36 - SEL$10 / TTI@SEL$10 37 - SEL$10 / D@SEL$10 38 - SEL$10 / D@SEL$10 39 - SEL$11 40 - SEL$11 / TTI@SEL$11 41 - SEL$11 / TTI@SEL$11 42 - SEL$11 / D@SEL$11 43 - SEL$11 / D@SEL$11 44 - SEL$12 / CM@SEL$12 45 - SEL$12 / CM@SEL$12 46 - SEL$13 / F@SEL$13 47 - SEL$13 / F@SEL$13 48 - SEL$14 49 - SEL$14 / TAI@SEL$14 50 - SEL$14 / TAI@SEL$14 51 - SEL$14 / CFT@SEL$14 52 - SEL$14 / CFT@SEL$14 53 - SEL$1 55 - SEL$1 / WM@SEL$1 57 - SEL$1 / E@SEL$1 59 - SEL$1 / CU@SEL$1 63 - SEL$1 / X@SEL$1 64 - SEL$1 / TT@SEL$1 65 - SEL$1 / TT@SEL$1 66 - SEL$16 / A3@SEL$16 67 - SEL$16 / A3@SEL$16 68 - SEL$17 / A2@SEL$17 69 - SEL$17 / A2@SEL$17 70 - SEL$18 / T1@SEL$18 71 - SEL$18 / T1@SEL$18 72 - SEL$19 / A1@SEL$19 73 - SEL$19 / A1@SEL$19 74 - SEL$20 75 - SEL$20 / TTI@SEL$20 76 - SEL$20 / TTI@SEL$20 77 - SEL$20 / D@SEL$20 78 - SEL$20 / D@SEL$20 79 - SEL$21 80 - SEL$21 / TTI@SEL$21 81 - SEL$21 / TTI@SEL$21 82 - SEL$21 / D@SEL$21 83 - SEL$21 / D@SEL$21 84 - SEL$22 85 - SEL$22 / TTI@SEL$22 86 - SEL$22 / TTI@SEL$22 87 - SEL$22 / D@SEL$22 88 - SEL$22 / D@SEL$22 89 - SEL$23 92 - SEL$23 / TTI@SEL$23 93 - SEL$23 / TTI@SEL$23 94 - SEL$23 / D@SEL$23 95 - SEL$23 / D@SEL$23 96 - SEL$23 / G@SEL$23 97 - SEL$23 / G@SEL$23 98 - SEL$24 99 - SEL$24 / TTI@SEL$24 100 - SEL$24 / TTI@SEL$24 101 - SEL$24 / D@SEL$24 102 - SEL$24 / D@SEL$24 103 - SEL$25 104 - SEL$25 / TTI@SEL$25 105 - SEL$25 / TTI@SEL$25 106 - SEL$25 / D@SEL$25 107 - SEL$25 / D@SEL$25 108 - SEL$26 / CM@SEL$26 109 - SEL$26 / CM@SEL$26 110 - SEL$27 / F@SEL$27 111 - SEL$27 / F@SEL$27 112 - SEL$28 113 - SEL$28 / TAI@SEL$28 114 - SEL$28 / TAI@SEL$28 115 - SEL$28 / CFT@SEL$28 116 - SEL$28 / CFT@SEL$28 117 - SEL$653BBCD7 119 - SEL$653BBCD7 / C@SEL$15 122 - SEL$653BBCD7 / WF_WORKFLOW@SEL$29 124 - SEL$653BBCD7 / B@SEL$15 126 - SEL$653BBCD7 / TTI@SEL$15 128 - SEL$653BBCD7 / TT@SEL$15 Predicate Information (identified by operation id): --------------------------------------------------- 2 - filter("A3"."PARENT_CATEGORY_CODE_V"<>'0') 3 - access("A3"."CATEGORY_CODE_V"= (SELECT "A2"."PARENT_CATEGORY_CODE_V" FROM "CLM_TT"."TT_CATEGORY_MASTER" "A2" WHERE "A2"."CATEGORY_CODE_V"= (SELECT "T1"."SUBCATEGORY_ID_V" FROM "CLM_TT"."TT_TICKETINFO" "T1" WHERE "T1"."DOCKET_NUMBER_N"=:B1))) 5 - access("A2"."CATEGORY_CODE_V"= (SELECT "T1"."SUBCATEGORY_ID_V" FROM "CLM_TT"."TT_TICKETINFO" "T1" WHERE "T1"."DOCKET_NUMBER_N"=:B1)) 7 - access("T1"."DOCKET_NUMBER_N"=:B1) 9 - access("A1"."CATEGORY_CODE_V"=:B1) 12 - access("TTI"."DOCKET_NUMBER_N"=:B1) 14 - access("TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V")) filter(TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL) 17 - access("TTI"."DOCKET_NUMBER_N"=:B1) 19 - access("TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V")) filter(TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL) 22 - access("TTI"."DOCKET_NUMBER_N"=:B1) 24 - access("TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V")) filter(TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL) 29 - access("TTI"."DOCKET_NUMBER_N"=:B1) 31 - access("TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V")) filter(TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL) 32 - access("D"."SUBSCRIBER_CATEGORY_V"="G"."SUBS_CATEGORY_CODE_V" AND "D"."SUBSCRIBER_SUB_CATEGORY_V"="G"."SUBS_SUB_CATEGORY_CODE_V") 36 - access("TTI"."DOCKET_NUMBER_N"=:B1) 38 - access("TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V")) filter(TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL) 41 - access("TTI"."DOCKET_NUMBER_N"=:B1) 43 - access("TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V")) filter(TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL) 44 - filter("CM"."PARENT_CATEGORY_CODE_V"='0' AND "CM"."CATEGORY_TYPE_V"=:B1) 45 - access("CM"."CATEGORY_CODE_V"=:B1) 47 - access("F"."USER_CODE_N"=:B1) 49 - filter("TAI"."FAULT_CODE_V" IS NOT NULL) 50 - access("TAI"."DOCKET_NUMBER_N"=:B1) 52 - access("TAI"."FAULT_CODE_V"="CFT"."FAULT_CODE_V") 54 - access("X"."WRKFLW_ID_N"="WM"."WRKFLW_ID_N") 56 - access("CU"."GROUP_CODE_N"="E"."GROUP_CODE_N") 58 - access("TT"."LOGGED_BY_N"="CU"."USER_CODE_N") 64 - access("TT"."DOCKET_NUMBER_N"=TO_NUMBER("X"."EVENT_REFNO_V")) 66 - filter("A3"."PARENT_CATEGORY_CODE_V"<>'0') 67 - access("A3"."CATEGORY_CODE_V"= (SELECT "A2"."PARENT_CATEGORY_CODE_V" FROM "CLM_TT"."TT_CATEGORY_MASTER" "A2" WHERE "A2"."CATEGORY_CODE_V"= (SELECT "T1"."SUBCATEGORY_ID_V" FROM "CLM_TT"."TT_TICKETINFO" "T1" WHERE "T1"."DOCKET_NUMBER_N"=:B1))) 69 - access("A2"."CATEGORY_CODE_V"= (SELECT "T1"."SUBCATEGORY_ID_V" FROM "CLM_TT"."TT_TICKETINFO" "T1" WHERE "T1"."DOCKET_NUMBER_N"=:B1)) 71 - access("T1"."DOCKET_NUMBER_N"=:B1) 73 - access("A1"."CATEGORY_CODE_V"=:B1) 76 - access("TTI"."DOCKET_NUMBER_N"=:B1) 78 - access("TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V")) filter(TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL) 81 - access("TTI"."DOCKET_NUMBER_N"=:B1) 83 - access("TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V")) filter(TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL) 86 - access("TTI"."DOCKET_NUMBER_N"=:B1) 88 - access("TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V")) filter(TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL) 93 - access("TTI"."DOCKET_NUMBER_N"=:B1) 95 - access("TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V")) filter(TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL) 96 - access("D"."SUBSCRIBER_CATEGORY_V"="G"."SUBS_CATEGORY_CODE_V" AND "D"."SUBSCRIBER_SUB_CATEGORY_V"="G"."SUBS_SUB_CATEGORY_CODE_V") 100 - access("TTI"."DOCKET_NUMBER_N"=:B1) 102 - access("TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V")) filter(TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL) 105 - access("TTI"."DOCKET_NUMBER_N"=:B1) 107 - access("TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V")) filter(TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL) 108 - filter("CM"."PARENT_CATEGORY_CODE_V"='0' AND "CM"."CATEGORY_TYPE_V"=:B1) 109 - access("CM"."CATEGORY_CODE_V"=:B1) 111 - access("F"."USER_CODE_N"=:B1) 113 - filter("TAI"."FAULT_CODE_V" IS NOT NULL) 114 - access("TAI"."DOCKET_NUMBER_N"=:B1) 116 - access("TAI"."FAULT_CODE_V"="CFT"."FAULT_CODE_V") 118 - access("C"."GROUP_CODE_N"="B"."GROUP_CODE_N") 120 - access("TT"."DOCKET_NUMBER_N"=TO_NUMBER("EVENT_REFNO_V")) 123 - access("TT"."LOGGED_BY_N"="B"."USER_CODE_N") 125 - access("TTI"."INCIDENT_NUMBER_N"="TT"."DOCKET_NUMBER_N") Column Projection Information (identified by operation id): ----------------------------------------------------------- 1 - STRDEF[8], STRDEF[22], STRDEF[50], STRDEF[22], STRDEF[11], STRDEF[22], STRDEF[11], STRDEF[22], STRDEF[11], STRDEF[22], STRDEF[11], STRDEF[22], STRDEF[22], STRDEF[14], STRDEF[15], STRDEF[200], STRDEF[200], STRDEF[16], STRDEF[10], STRDEF[8], STRDEF[30], STRDEF[2], STRDEF[22], STRDEF[1], STRDEF[5], STRDEF[200], STRDEF[120], STRDEF[120], STRDEF[30], STRDEF[4000], STRDEF[4000], STRDEF[1000], STRDEF[50], STRDEF[120] 2 - "A3".ROWID[ROWID,10], "A3"."CATEGORY_DESCRIPTION_V"[VARCHAR2,200], "A3"."PARENT_CATEGORY_CODE_V"[VARCHAR2,8] 3 - "A3".ROWID[ROWID,10] 4 - "A2".ROWID[ROWID,10], "A2"."PARENT_CATEGORY_CODE_V"[VARCHAR2,8] 5 - "A2".ROWID[ROWID,10] 6 - "T1".ROWID[ROWID,10], "T1"."SUBCATEGORY_ID_V"[VARCHAR2,8] 7 - "T1".ROWID[ROWID,10] 8 - "A1".ROWID[ROWID,10], "A1"."CATEGORY_DESCRIPTION_V"[VARCHAR2,200] 9 - "A1".ROWID[ROWID,10] 10 - (#keys=0) "D"."MOBL_NUM_VOICE_V"[VARCHAR2,16] 11 - "TTI"."ENTITY_ID_N"[NUMBER,22] 12 - "TTI".ROWID[ROWID,10] 13 - "D"."MOBL_NUM_VOICE_V"[VARCHAR2,16] 14 - "D".ROWID[ROWID,10], TO_NUMBER("MOBL_NUM_VOICE_V")[NUMBER,22] 15 - (#keys=0) "D"."SUB_SERVICE_CODE_V"[VARCHAR2,10] 16 - "TTI"."ENTITY_ID_N"[NUMBER,22] 17 - "TTI".ROWID[ROWID,10] 18 - "D"."SUB_SERVICE_CODE_V"[VARCHAR2,10] 19 - "D".ROWID[ROWID,10], TO_NUMBER("MOBL_NUM_VOICE_V")[NUMBER,22] 20 - (#keys=0) "D"."SUBSCRIBER_CATEGORY_V"[VARCHAR2,8] 21 - "TTI"."ENTITY_ID_N"[NUMBER,22] 22 - "TTI".ROWID[ROWID,10] 23 - "D"."SUBSCRIBER_CATEGORY_V"[VARCHAR2,8] 24 - "D".ROWID[ROWID,10], TO_NUMBER("MOBL_NUM_VOICE_V")[NUMBER,22] 25 - (#keys=0) "G"."SUBS_SUB_CATEGORY_DESC_V"[VARCHAR2,30] 26 - (#keys=0) "G".ROWID[ROWID,10] 27 - (#keys=0) "D"."SUBSCRIBER_CATEGORY_V"[VARCHAR2,8], "D"."SUBSCRIBER_SUB_CATEGORY_V"[VARCHAR2,8] 28 - "TTI"."ENTITY_ID_N"[NUMBER,22] 29 - "TTI".ROWID[ROWID,10] 30 - "D"."SUBSCRIBER_CATEGORY_V"[VARCHAR2,8], "D"."SUBSCRIBER_SUB_CATEGORY_V"[VARCHAR2,8] 31 - "D".ROWID[ROWID,10], TO_NUMBER("MOBL_NUM_VOICE_V")[NUMBER,22] 32 - "G".ROWID[ROWID,10] 33 - "G"."SUBS_SUB_CATEGORY_DESC_V"[VARCHAR2,30] 34 - (#keys=0) "D"."STATUS_CODE_V"[VARCHAR2,2] 35 - "TTI"."ENTITY_ID_N"[NUMBER,22] 36 - "TTI".ROWID[ROWID,10] 37 - "D"."STATUS_CODE_V"[VARCHAR2,2] 38 - "D".ROWID[ROWID,10], TO_NUMBER("MOBL_NUM_VOICE_V")[NUMBER,22] 39 - (#keys=0) "D"."ACCOUNT_CODE_N"[NUMBER,22] 40 - "TTI"."ENTITY_ID_N"[NUMBER,22] 41 - "TTI".ROWID[ROWID,10] 42 - "D"."ACCOUNT_CODE_N"[NUMBER,22] 43 - "D".ROWID[ROWID,10], TO_NUMBER("MOBL_NUM_VOICE_V")[NUMBER,22] 44 - "CM".ROWID[ROWID,10], "CM"."CATEGORY_TYPE_V"[VARCHAR2,1], "CM"."CATEGORY_DESCRIPTION_V"[VARCHAR2,200], "CM"."PARENT_CATEGORY_CODE_V"[VARCHAR2,8] 45 - "CM".ROWID[ROWID,10] 46 - "F".ROWID[ROWID,10], "F"."USER_NAME_V"[VARCHAR2,120] 47 - "F".ROWID[ROWID,10] 48 - (#keys=0) "CFT"."FAULT_NAME_V"[VARCHAR2,50] 49 - "TAI"."FAULT_CODE_V"[VARCHAR2,8] 50 - "TAI".ROWID[ROWID,10] 51 - "CFT"."FAULT_NAME_V"[VARCHAR2,50] 52 - "CFT".ROWID[ROWID,10] 53 - (#keys=34) 'Workflow'[8], "TT"."DOCKET_NUMBER_N"[NUMBER,22], "WM"."WRKFLW_DESC_V"[VARCHAR2,50], "WM"."ESTIMATED_RESOLN_TM_N"[NUMBER,22], "TT"."TICKET_REGN_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], ROUND((CAST(FROM_TZ(CAST(INTERNAL_FUNCTION("TT"."TICKET_REGN_DT_D") AS timestamp),SESSIONTIMEZONE) AT TIME ZONE 'GMT' AS date)-TO_DATE(' 1970-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))*86400)[22], "X"."START_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], ROUND((CAST(FROM_TZ(CAST(INTERNAL_FUNCTION("X"."START_DT_D") AS timestamp),SESSIONTIMEZONE) AT TIME ZONE 'GMT' AS date)-TO_DATE(' 1970-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))*86400)[22], "X"."END_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], ROUND((CAST(FROM_TZ(CAST(INTERNAL_FUNCTION("X"."END_DT_D") AS timestamp),SESSIONTIMEZONE) AT TIME ZONE 'GMT' AS date)-TO_DATE(' 1970-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))*86400)[22], "TT"."TICKET_RESP_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], ROUND((CAST(FROM_TZ(CAST(INTERNAL_FUNCTION("TT"."TICKET_RESP_DT_D") AS timestamp),SESSIONTIMEZONE) AT TIME ZONE 'GMT' AS date)-TO_DATE(' 1970-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))*86400)[22], ROUND((CAST(FROM_TZ(CAST(SYSDATE@! AS timestamp),SESSIONTIMEZONE) AT TIME ZONE 'GMT' AS date)-TO_DATE(' 1970-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))*86400)[22], DECODE("TT"."STATUS_V",'P','Pending','A','Task completed','C','Closed','R','Resolved')[14], DECODE("TT"."TICKET_TYPE_V",'Q','Query','C','Complaint Type','R','Service Request')[15], (SELECT "A3"."CATEGORY_DESCRIPTION_V" FROM "CLM_TT"."TT_CATEGORY_MASTER" "A3" WHERE "A3"."CATEGORY_CODE_V"= (SELECT "A2"."PARENT_CATEGORY_CODE_V" FROM "CLM_TT"."TT_CATEGORY_MASTER" "A2" WHERE "A2"."CATEGORY_CODE_V"= (SELECT "T1"."SUBCATEGORY_ID_V" FROM "CLM_TT"."TT_TICKETINFO" "T1" WHERE "T1"."DOCKET_NUMBER_N"=:B1)) AND "A3"."PARENT_CATEGORY_CODE_V"<>'0')[200], (SELECT DISTINCT "A1"."CATEGORY_DESCRIPTION_V" FROM "CLM_TT"."TT_CATEGORY_MASTER" "A1" WHERE "A1"."CATEGORY_CODE_V"=:B2)[200], (SELECT "D"."MOBL_NUM_VOICE_V" FROM "CLM_TT"."TT_TICKETINFO" "TTI","CBS_CORE"."GSM_SERVICE_MAST" "D" WHERE "TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V") AND TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL AND "TTI"."DOCKET_NUMBER_N"=:B3)[16], (SELECT "D"."SUB_SERVICE_CODE_V" FROM "CLM_TT"."TT_TICKETINFO" "TTI","CBS_CORE"."GSM_SERVICE_MAST" "D" WHERE "TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V") AND TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL AND "TTI"."DOCKET_NUMBER_N"=:B4)[10], (SELECT "D"."SUBSCRIBER_CATEGORY_V" FROM "CLM_TT"."TT_TICKETINFO" "TTI","CBS_CORE"."GSM_SERVICE_MAST" "D" WHERE "TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V") AND TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL AND "TTI"."DOCKET_NUMBER_N"=:B5)[8], (SELECT "G"."SUBS_SUB_CATEGORY_DESC_V" FROM "CLM_TT"."TT_TICKETINFO" "TTI","CBS_CORE"."CB_SUBSCRIBER_SUB_CATEGORY" "G","CBS_CORE"."GSM_SERVICE_MAST" "D" WHERE "TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V") AND TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL AND "D"."SUBSCRIBER_SUB_CATEGORY_V"="G"."SUBS_SUB_CATEGORY_CODE_V" AND "D"."SUBSCRIBER_CATEGORY_V"="G"."SUBS_CATEGORY_CODE_V" AND "TTI"."DOCKET_NUMBER_N"=:B6)[30], (SELECT "D"."STATUS_CODE_V" FROM "CLM_TT"."TT_TICKETINFO" "TTI","CBS_CORE"."GSM_SERVICE_MAST" "D" WHERE "TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V") AND TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL AND "TTI"."DOCKET_NUMBER_N"=:B7)[2], (SELECT "D"."ACCOUNT_CODE_N" FROM "CLM_TT"."TT_TICKETINFO" "TTI","CBS_CORE"."GSM_SERVICE_MAST" "D" WHERE "TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V") AND TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL AND "TTI"."DOCKET_NUMBER_N"=:B8)[22], "X"."STATUS_V"[VARCHAR2,1], "TT"."TT_SOURCE_V"[VARCHAR2,5], (SELECT DISTINCT "CM"."CATEGORY_DESCRIPTION_V" FROM "CLM_TT"."TT_CATEGORY_MASTER" "CM" WHERE "CM"."CATEGORY_CODE_V"=:B9 AND "CM"."PARENT_CATEGORY_CODE_V"='0' AND "CM"."CATEGORY_TYPE_V"=:B10)[200], (SELECT "F"."USER_NAME_V" FROM "CBS_CORE"."CB_USERS" "F" WHERE "F"."USER_CODE_N"=:B11) 54 - (#keys=1) "WM"."ESTIMATED_RESOLN_TM_N"[NUMBER,22], "WM"."WRKFLW_DESC_V"[VARCHAR2,50], "E"."GROUP_NAME_V"[VARCHAR2,30], "TT"."LOGGED_BY_N"[NUMBER,22], "TT"."QUESTION_V"[VARCHAR2,4000], "CU"."USER_NAME_V"[VARCHAR2,120], "TT"."TICKET_RESP_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."START_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."END_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."STATUS_V"[VARCHAR2,1], "TT"."DOCKET_NUMBER_N"[NUMBER,22], "TT"."TICKET_REGN_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."STATUS_V"[VARCHAR2,1], "TT"."CATEGORY_ID_V"[VARCHAR2,8], "TT"."SUBCATEGORY_ID_V"[VARCHAR2,8], "TT"."TICKET_TYPE_V"[VARCHAR2,1], "TT"."ANSWER_V"[VARCHAR2,4000], "TT"."TT_SOURCE_V"[VARCHAR2,5] 55 - "WM"."WRKFLW_ID_N"[NUMBER,22], "WM"."WRKFLW_DESC_V"[VARCHAR2,50], "WM"."ESTIMATED_RESOLN_TM_N"[NUMBER,22] 56 - (#keys=1) "E"."GROUP_NAME_V"[VARCHAR2,30], "TT"."LOGGED_BY_N"[NUMBER,22], "TT"."QUESTION_V"[VARCHAR2,4000], "CU"."USER_NAME_V"[VARCHAR2,120], "X"."WRKFLW_ID_N"[NUMBER,22], "X"."START_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."END_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."STATUS_V"[VARCHAR2,1], "TT"."DOCKET_NUMBER_N"[NUMBER,22], "TT"."TICKET_REGN_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."STATUS_V"[VARCHAR2,1], "TT"."CATEGORY_ID_V"[VARCHAR2,8], "TT"."SUBCATEGORY_ID_V"[VARCHAR2,8], "TT"."TICKET_TYPE_V"[VARCHAR2,1], "TT"."ANSWER_V"[VARCHAR2,4000], "TT"."TT_SOURCE_V"[VARCHAR2,5], "TT"."TICKET_RESP_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11] 57 - "E"."GROUP_CODE_N"[NUMBER,22], "E"."GROUP_NAME_V"[VARCHAR2,30] 58 - (#keys=1) "TT"."LOGGED_BY_N"[NUMBER,22], "CU"."GROUP_CODE_N"[NUMBER,22], "CU"."USER_NAME_V"[VARCHAR2,120], "X"."WRKFLW_ID_N"[NUMBER,22], "X"."START_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."END_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."STATUS_V"[VARCHAR2,1], "TT"."DOCKET_NUMBER_N"[NUMBER,22], "TT"."TICKET_REGN_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."STATUS_V"[VARCHAR2,1], "TT"."CATEGORY_ID_V"[VARCHAR2,8], "TT"."SUBCATEGORY_ID_V"[VARCHAR2,8], "TT"."TICKET_TYPE_V"[VARCHAR2,1], "TT"."ANSWER_V"[VARCHAR2,4000], "TT"."TT_SOURCE_V"[VARCHAR2,5], "TT"."TICKET_RESP_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."QUESTION_V"[VARCHAR2,4000] 59 - "CU"."USER_CODE_N"[NUMBER,22], "CU"."USER_NAME_V"[VARCHAR2,120], "CU"."GROUP_CODE_N"[NUMBER,22] 60 - (#keys=0) "X"."WRKFLW_ID_N"[NUMBER,22], "X"."START_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."END_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."STATUS_V"[VARCHAR2,1], "TT"."DOCKET_NUMBER_N"[NUMBER,22], "TT"."TICKET_REGN_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."STATUS_V"[VARCHAR2,1], "TT"."CATEGORY_ID_V"[VARCHAR2,8], "TT"."SUBCATEGORY_ID_V"[VARCHAR2,8], "TT"."TICKET_TYPE_V"[VARCHAR2,1], "TT"."LOGGED_BY_N"[NUMBER,22], "TT"."TT_SOURCE_V"[VARCHAR2,5], "TT"."TICKET_RESP_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."QUESTION_V"[VARCHAR2,4000], "TT"."ANSWER_V"[VARCHAR2,4000] 61 - (#keys=0) "X"."WRKFLW_ID_N"[NUMBER,22], "X"."START_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."END_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."STATUS_V"[VARCHAR2,1], "TT".ROWID[ROWID,10], "TT"."DOCKET_NUMBER_N"[NUMBER,22] 62 - "X"."EVENT_REFNO_V"[VARCHAR2,20], "X"."WRKFLW_ID_N"[NUMBER,22], "X"."START_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."END_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."STATUS_V"[VARCHAR2,1] 63 - "X"."EVENT_REFNO_V"[VARCHAR2,20], "X"."WRKFLW_ID_N"[NUMBER,22], "X"."START_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."END_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."STATUS_V"[VARCHAR2,1] 64 - "TT".ROWID[ROWID,10], "TT"."DOCKET_NUMBER_N"[NUMBER,22] 65 - "TT"."TICKET_REGN_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."STATUS_V"[VARCHAR2,1], "TT"."CATEGORY_ID_V"[VARCHAR2,8], "TT"."SUBCATEGORY_ID_V"[VARCHAR2,8], "TT"."TICKET_TYPE_V"[VARCHAR2,1], "TT"."LOGGED_BY_N"[NUMBER,22], "TT"."TT_SOURCE_V"[VARCHAR2,5], "TT"."TICKET_RESP_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."QUESTION_V"[VARCHAR2,4000], "TT"."ANSWER_V"[VARCHAR2,4000] 66 - "A3".ROWID[ROWID,10], "A3"."CATEGORY_DESCRIPTION_V"[VARCHAR2,200], "A3"."PARENT_CATEGORY_CODE_V"[VARCHAR2,8] 67 - "A3".ROWID[ROWID,10] 68 - "A2".ROWID[ROWID,10], "A2"."PARENT_CATEGORY_CODE_V"[VARCHAR2,8] 69 - "A2".ROWID[ROWID,10] 70 - "T1".ROWID[ROWID,10], "T1"."SUBCATEGORY_ID_V"[VARCHAR2,8] 71 - "T1".ROWID[ROWID,10] 72 - "A1".ROWID[ROWID,10], "A1"."CATEGORY_DESCRIPTION_V"[VARCHAR2,200] 73 - "A1".ROWID[ROWID,10] 74 - (#keys=0) "D"."MOBL_NUM_VOICE_V"[VARCHAR2,16] 75 - "TTI"."ENTITY_ID_N"[NUMBER,22] 76 - "TTI".ROWID[ROWID,10] 77 - "D"."MOBL_NUM_VOICE_V"[VARCHAR2,16] 78 - "D".ROWID[ROWID,10], TO_NUMBER("MOBL_NUM_VOICE_V")[NUMBER,22] 79 - (#keys=0) "D"."SUB_SERVICE_CODE_V"[VARCHAR2,10] 80 - "TTI"."ENTITY_ID_N"[NUMBER,22] 81 - "TTI".ROWID[ROWID,10] 82 - "D"."SUB_SERVICE_CODE_V"[VARCHAR2,10] 83 - "D".ROWID[ROWID,10], TO_NUMBER("MOBL_NUM_VOICE_V")[NUMBER,22] 84 - (#keys=0) "D"."SUBSCRIBER_CATEGORY_V"[VARCHAR2,8] 85 - "TTI"."ENTITY_ID_N"[NUMBER,22] 86 - "TTI".ROWID[ROWID,10] 87 - "D"."SUBSCRIBER_CATEGORY_V"[VARCHAR2,8] 88 - "D".ROWID[ROWID,10], TO_NUMBER("MOBL_NUM_VOICE_V")[NUMBER,22] 89 - (#keys=0) "G"."SUBS_SUB_CATEGORY_DESC_V"[VARCHAR2,30] 90 - (#keys=0) "G".ROWID[ROWID,10] 91 - (#keys=0) "D"."SUBSCRIBER_CATEGORY_V"[VARCHAR2,8], "D"."SUBSCRIBER_SUB_CATEGORY_V"[VARCHAR2,8] 92 - "TTI"."ENTITY_ID_N"[NUMBER,22] 93 - "TTI".ROWID[ROWID,10] 94 - "D"."SUBSCRIBER_CATEGORY_V"[VARCHAR2,8], "D"."SUBSCRIBER_SUB_CATEGORY_V"[VARCHAR2,8] 95 - "D".ROWID[ROWID,10], TO_NUMBER("MOBL_NUM_VOICE_V")[NUMBER,22] 96 - "G".ROWID[ROWID,10] 97 - "G"."SUBS_SUB_CATEGORY_DESC_V"[VARCHAR2,30] 98 - (#keys=0) "D"."STATUS_CODE_V"[VARCHAR2,2] 99 - "TTI"."ENTITY_ID_N"[NUMBER,22] 100 - "TTI".ROWID[ROWID,10] 101 - "D"."STATUS_CODE_V"[VARCHAR2,2] 102 - "D".ROWID[ROWID,10], TO_NUMBER("MOBL_NUM_VOICE_V")[NUMBER,22] 103 - (#keys=0) "D"."ACCOUNT_CODE_N"[NUMBER,22] 104 - "TTI"."ENTITY_ID_N"[NUMBER,22] 105 - "TTI".ROWID[ROWID,10] 106 - "D"."ACCOUNT_CODE_N"[NUMBER,22] 107 - "D".ROWID[ROWID,10], TO_NUMBER("MOBL_NUM_VOICE_V")[NUMBER,22] 108 - "CM".ROWID[ROWID,10], "CM"."CATEGORY_TYPE_V"[VARCHAR2,1], "CM"."CATEGORY_DESCRIPTION_V"[VARCHAR2,200], "CM"."PARENT_CATEGORY_CODE_V"[VARCHAR2,8] 109 - "CM".ROWID[ROWID,10] 110 - "F".ROWID[ROWID,10], "F"."USER_NAME_V"[VARCHAR2,120] 111 - "F".ROWID[ROWID,10] 112 - (#keys=0) "CFT"."FAULT_NAME_V"[VARCHAR2,50] 113 - "TAI"."FAULT_CODE_V"[VARCHAR2,8] 114 - "TAI".ROWID[ROWID,10] 115 - "CFT"."FAULT_NAME_V"[VARCHAR2,50] 116 - "CFT".ROWID[ROWID,10] 117 - (#keys=34) 'FLR'[3], "TT"."DOCKET_NUMBER_N"[NUMBER,22], NULL[0], NULL[0], "TT"."TICKET_REGN_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], NULL[0], NULL[0], NULL[0], NULL[0], NULL[0], "TT"."TICKET_RESP_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], NULL[0], ROUND((CAST(FROM_TZ(CAST(SYSDATE@! AS timestamp),SESSIONTIMEZONE) AT TIME ZONE 'GMT' AS date)-TO_DATE(' 1970-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))*86400)[22], DECODE("TT"."STATUS_V",'P','Pending','A','Task completed','C','Closed','R','Resolved')[14], DECODE("TT"."TICKET_TYPE_V",'Q','Query','C','Complaint Type','R','Service Request')[15], (SELECT "A3"."CATEGORY_DESCRIPTION_V" FROM "CLM_TT"."TT_CATEGORY_MASTER" "A3" WHERE "A3"."CATEGORY_CODE_V"= (SELECT "A2"."PARENT_CATEGORY_CODE_V" FROM "CLM_TT"."TT_CATEGORY_MASTER" "A2" WHERE "A2"."CATEGORY_CODE_V"= (SELECT "T1"."SUBCATEGORY_ID_V" FROM "CLM_TT"."TT_TICKETINFO" "T1" WHERE "T1"."DOCKET_NUMBER_N"=:B1)) AND "A3"."PARENT_CATEGORY_CODE_V"<>'0')[200], (SELECT DISTINCT "A1"."CATEGORY_DESCRIPTION_V" FROM "CLM_TT"."TT_CATEGORY_MASTER" "A1" WHERE "A1"."CATEGORY_CODE_V"=:B2)[200], (SELECT "D"."MOBL_NUM_VOICE_V" FROM "CLM_TT"."TT_TICKETINFO" "TTI","CBS_CORE"."GSM_SERVICE_MAST" "D" WHERE "TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V") AND TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL AND "TTI"."DOCKET_NUMBER_N"=:B3)[16], (SELECT "D"."SUB_SERVICE_CODE_V" FROM "CLM_TT"."TT_TICKETINFO" "TTI","CBS_CORE"."GSM_SERVICE_MAST" "D" WHERE "TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V") AND TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL AND "TTI"."DOCKET_NUMBER_N"=:B4)[10], (SELECT "D"."SUBSCRIBER_CATEGORY_V" FROM "CLM_TT"."TT_TICKETINFO" "TTI","CBS_CORE"."GSM_SERVICE_MAST" "D" WHERE "TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V") AND TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL AND "TTI"."DOCKET_NUMBER_N"=:B5)[8], (SELECT "G"."SUBS_SUB_CATEGORY_DESC_V" FROM "CLM_TT"."TT_TICKETINFO" "TTI","CBS_CORE"."CB_SUBSCRIBER_SUB_CATEGORY" "G","CBS_CORE"."GSM_SERVICE_MAST" "D" WHERE "TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V") AND TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL AND "D"."SUBSCRIBER_SUB_CATEGORY_V"="G"."SUBS_SUB_CATEGORY_CODE_V" AND "D"."SUBSCRIBER_CATEGORY_V"="G"."SUBS_CATEGORY_CODE_V" AND "TTI"."DOCKET_NUMBER_N"=:B6)[30], (SELECT "D"."STATUS_CODE_V" FROM "CLM_TT"."TT_TICKETINFO" "TTI","CBS_CORE"."GSM_SERVICE_MAST" "D" WHERE "TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V") AND TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL AND "TTI"."DOCKET_NUMBER_N"=:B7)[2], (SELECT "D"."ACCOUNT_CODE_N" FROM "CLM_TT"."TT_TICKETINFO" "TTI","CBS_CORE"."GSM_SERVICE_MAST" "D" WHERE "TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V") AND TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL AND "TTI"."DOCKET_NUMBER_N"=:B8)[22], NULL[0], "TT"."TT_SOURCE_V"[VARCHAR2,5], (SELECT DISTINCT "CM"."CATEGORY_DESCRIPTION_V" FROM "CLM_TT"."TT_CATEGORY_MASTER" "CM" WHERE "CM"."CATEGORY_CODE_V"=:B9 AND "CM"."PARENT_CATEGORY_CODE_V"='0' AND "CM"."CATEGORY_TYPE_V"=:B10)[200], (SELECT "F"."USER_NAME_V" FROM "CBS_CORE"."CB_USERS" "F" WHERE "F"."USER_CODE_N"=:B11)[120], NULL[0], "C"."GROUP_NAME_V"[VARCHAR2,30], "TT"."QUESTION_V"[VARCHAR2,4000], "TT"."ANSWER_V"[VARCHAR2,4000], "TTI"."NOTES_V"[VARCHAR2,1000], (SELECT "CFT"."FAULT_NAME_V" FROM "CLM_TT"."CB_FAULT_TYPES" "CFT","CLM_TT"."TT_TICKET_ADDNL_INFO" "TAI" WHERE "TAI"."DOCKET_NUMBER_N"=:B12 AND "TAI"."FAULT_CODE_V" IS NOT NULL AND "TAI"."FAULT_CODE_V"="CFT"."FAULT_CODE_V")[50], "B"."USER_NAME_V"[VARCHAR2,120] 118 - (#keys=1) "C"."GROUP_NAME_V"[VARCHAR2,30], "TT"."DOCKET_NUMBER_N"[NUMBER,22], "TT"."LOGGED_BY_N"[NUMBER,22], "TT"."TT_SOURCE_V"[VARCHAR2,5], "B"."USER_NAME_V"[VARCHAR2,120], "TT"."TICKET_RESP_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TTI"."NOTES_V"[VARCHAR2,1000], "TT"."ANSWER_V"[VARCHAR2,4000], "TT"."TICKET_REGN_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."STATUS_V"[VARCHAR2,1], "TT"."CATEGORY_ID_V"[VARCHAR2,8], "TT"."SUBCATEGORY_ID_V"[VARCHAR2,8], "TT"."TICKET_TYPE_V"[VARCHAR2,1], "TT"."QUESTION_V"[VARCHAR2,4000] 119 - "C"."GROUP_CODE_N"[NUMBER,22], "C"."GROUP_NAME_V"[VARCHAR2,30] 120 - (#keys=1) "TT"."DOCKET_NUMBER_N"[NUMBER,22], "TT"."LOGGED_BY_N"[NUMBER,22], "B"."GROUP_CODE_N"[NUMBER,22], "B"."USER_NAME_V"[VARCHAR2,120], "TT"."TICKET_RESP_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TTI"."NOTES_V"[VARCHAR2,1000], "TT"."ANSWER_V"[VARCHAR2,4000], "TT"."TICKET_REGN_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."STATUS_V"[VARCHAR2,1], "TT"."CATEGORY_ID_V"[VARCHAR2,8], "TT"."SUBCATEGORY_ID_V"[VARCHAR2,8], "TT"."TICKET_TYPE_V"[VARCHAR2,1], "TT"."QUESTION_V"[VARCHAR2,4000], "TT"."TT_SOURCE_V"[VARCHAR2,5] 121 - "EVENT_REFNO_V"[VARCHAR2,20] 122 - "EVENT_REFNO_V"[VARCHAR2,20] 123 - (#keys=1) "TT"."LOGGED_BY_N"[NUMBER,22], "B"."GROUP_CODE_N"[NUMBER,22], "B"."USER_NAME_V"[VARCHAR2,120], "TT"."DOCKET_NUMBER_N"[NUMBER,22], "TTI"."NOTES_V"[VARCHAR2,1000], "TT"."ANSWER_V"[VARCHAR2,4000], "TT"."TICKET_REGN_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."STATUS_V"[VARCHAR2,1], "TT"."CATEGORY_ID_V"[VARCHAR2,8], "TT"."SUBCATEGORY_ID_V"[VARCHAR2,8], "TT"."TICKET_TYPE_V"[VARCHAR2,1], "TT"."QUESTION_V"[VARCHAR2,4000], "TT"."TT_SOURCE_V"[VARCHAR2,5], "TT"."TICKET_RESP_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11] 124 - "B"."USER_CODE_N"[NUMBER,22], "B"."USER_NAME_V"[VARCHAR2,120], "B"."GROUP_CODE_N"[NUMBER,22] 125 - (#keys=1) "TT"."DOCKET_NUMBER_N"[NUMBER,22], "TTI"."NOTES_V"[VARCHAR2,1000], "TT"."ANSWER_V"[VARCHAR2,4000], "TT"."TICKET_REGN_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."STATUS_V"[VARCHAR2,1], "TT"."CATEGORY_ID_V"[VARCHAR2,8], "TT"."SUBCATEGORY_ID_V"[VARCHAR2,8], "TT"."TICKET_TYPE_V"[VARCHAR2,1], "TT"."LOGGED_BY_N"[NUMBER,22], "TT"."TT_SOURCE_V"[VARCHAR2,5], "TT"."TICKET_RESP_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."QUESTION_V"[VARCHAR2,4000] 126 - "TTI"."INCIDENT_NUMBER_N"[NUMBER,22], "TTI"."NOTES_V"[VARCHAR2,1000] 127 - "TT"."DOCKET_NUMBER_N"[NUMBER,22], "TT"."TICKET_REGN_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."STATUS_V"[VARCHAR2,1], "TT"."CATEGORY_ID_V"[VARCHAR2,8], "TT"."SUBCATEGORY_ID_V"[VARCHAR2,8], "TT"."TICKET_TYPE_V"[VARCHAR2,1], "TT"."LOGGED_BY_N"[NUMBER,22], "TT"."TT_SOURCE_V"[VARCHAR2,5], "TT"."TICKET_RESP_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."QUESTION_V"[VARCHAR2,4000], "TT"."ANSWER_V"[VARCHAR2,4000] 128 - "TT"."DOCKET_NUMBER_N"[NUMBER,22], "TT"."TICKET_REGN_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."STATUS_V"[VARCHAR2,1], "TT"."CATEGORY_ID_V"[VARCHAR2,8], "TT"."SUBCATEGORY_ID_V"[VARCHAR2,8], "TT"."TICKET_TYPE_V"[VARCHAR2,1], "TT"."LOGGED_BY_N"[NUMBER,22], "TT"."TT_SOURCE_V"[VARCHAR2,5], "TT"."TICKET_RESP_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."QUESTION_V"[VARCHAR2,4000], "TT"."ANSWER_V"[VARCHAR2,4000] 2- Original With Adjusted Cost ------------------------------ Plan hash value: 4234275777 ------------------------------------------------------------------------------------------------------------------------------------------------ | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | Pstart| Pstop | ------------------------------------------------------------------------------------------------------------------------------------------------ | 0 | SELECT STATEMENT | | 665K| 168M| | 23M (1)| 00:31:09 | | | | 1 | UNION-ALL | | | | | | | | | |* 2 | TABLE ACCESS BY INDEX ROWID | TT_CATEGORY_MASTER | 1 | 37 | | 2 (0)| 00:00:01 | | | |* 3 | INDEX UNIQUE SCAN | TT_CATEGORY_CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 4 | TABLE ACCESS BY INDEX ROWID | TT_CATEGORY_MASTER | 1 | 18 | | 2 (0)| 00:00:01 | | | |* 5 | INDEX UNIQUE SCAN | TT_CATEGORY_CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 6 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 14 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 7 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 8 | TABLE ACCESS BY INDEX ROWID | TT_CATEGORY_MASTER | 1 | 28 | | 2 (0)| 00:00:01 | | | |* 9 | INDEX UNIQUE SCAN | TT_CATEGORY_CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 10 | NESTED LOOPS | | 1 | 21 | | 5 (0)| 00:00:01 | | | | 11 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 12 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 13 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 10 | | 3 (0)| 00:00:01 | | | |* 14 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | | 15 | NESTED LOOPS | | 1 | 24 | | 5 (0)| 00:00:01 | | | | 16 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 17 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 18 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 13 | | 3 (0)| 00:00:01 | | | |* 19 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | | 20 | NESTED LOOPS | | 1 | 20 | | 5 (0)| 00:00:01 | | | | 21 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 22 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 23 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 9 | | 3 (0)| 00:00:01 | | | |* 24 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | | 25 | NESTED LOOPS | | 1 | 55 | | 6 (0)| 00:00:01 | | | | 26 | NESTED LOOPS | | 1 | 55 | | 6 (0)| 00:00:01 | | | | 27 | NESTED LOOPS | | 1 | 25 | | 5 (0)| 00:00:01 | | | | 28 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 29 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 30 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 14 | | 3 (0)| 00:00:01 | | | |* 31 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | |* 32 | INDEX UNIQUE SCAN | SUBS_SUB_CATEGORY#CODE$PK | 1 | | | 0 (0)| 00:00:01 | | | | 33 | TABLE ACCESS BY INDEX ROWID | CB_SUBSCRIBER_SUB_CATEGORY | 1 | 30 | | 1 (0)| 00:00:01 | | | | 34 | NESTED LOOPS | | 1 | 18 | | 5 (0)| 00:00:01 | | | | 35 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 36 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 37 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 7 | | 3 (0)| 00:00:01 | | | |* 38 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | | 39 | NESTED LOOPS | | 1 | 20 | | 5 (0)| 00:00:01 | | | | 40 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 41 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 42 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 9 | | 3 (0)| 00:00:01 | | | |* 43 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | |* 44 | TABLE ACCESS BY INDEX ROWID | TT_CATEGORY_MASTER | 1 | 39 | | 2 (0)| 00:00:01 | | | |* 45 | INDEX UNIQUE SCAN | TT_CATEGORY_CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 46 | TABLE ACCESS BY INDEX ROWID | CB_USERS | 1 | 18 | | 2 (0)| 00:00:01 | | | |* 47 | INDEX UNIQUE SCAN | CB_USERS#CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 48 | NESTED LOOPS | | 1 | 31 | | 3 (0)| 00:00:01 | | | |* 49 | TABLE ACCESS BY INDEX ROWID | TT_TICKET_ADDNL_INFO | 1 | 7 | | 2 (0)| 00:00:01 | | | |* 50 | INDEX UNIQUE SCAN | TT_TICKET_ADDNL_INFO_PK | 1 | | | 1 (0)| 00:00:01 | | | | 51 | TABLE ACCESS BY INDEX ROWID | CB_FAULT_TYPES | 1 | 24 | | 1 (0)| 00:00:01 | | | |* 52 | INDEX UNIQUE SCAN | CB_FAULT_TYPES#U$1 | 1 | | | 0 (0)| 00:00:01 | | | | 53 | HASH UNIQUE | | 43761 | 10M| 11M| 1521K (1)| 00:01:59 | | | |* 54 | HASH JOIN | | 43761 | 10M| | 130K (1)| 00:00:11 | | | | 55 | TABLE ACCESS FULL | WF_WRKFLWMGR | 95 | 3135 | | 6 (0)| 00:00:01 | | | |* 56 | HASH JOIN | | 43761 | 9188K| | 130K (1)| 00:00:11 | | | | 57 | TABLE ACCESS FULL | CB_USER_GROUP | 92 | 1840 | | 4 (0)| 00:00:01 | | | |* 58 | HASH JOIN | | 43761 | 8333K| | 130K (1)| 00:00:11 | | | | 59 | TABLE ACCESS FULL | CB_USERS | 1511 | 33242 | | 19 (0)| 00:00:01 | | | | 60 | NESTED LOOPS | | 43773 | 7395K| | 130K (1)| 00:00:11 | | | | 61 | NESTED LOOPS | | 43773 | 7395K| | 130K (1)| 00:00:11 | | | | 62 | PARTITION RANGE ALL | | 43773 | 1453K| | 86981 (1)| 00:00:07 | 1 |1048575| | 63 | TABLE ACCESS FULL | WF_WORKFLOW | 43773 | 1453K| | 86981 (1)| 00:00:07 | 1 |1048575| |* 64 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 0 (0)| 00:00:01 | | | | 65 | TABLE ACCESS BY GLOBAL INDEX ROWID| TT_TICKETINFO | 1 | 139 | | 1 (0)| 00:00:01 | ROWID | ROWID | |* 66 | TABLE ACCESS BY INDEX ROWID | TT_CATEGORY_MASTER | 1 | 37 | | 2 (0)| 00:00:01 | | | |* 67 | INDEX UNIQUE SCAN | TT_CATEGORY_CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 68 | TABLE ACCESS BY INDEX ROWID | TT_CATEGORY_MASTER | 1 | 18 | | 2 (0)| 00:00:01 | | | |* 69 | INDEX UNIQUE SCAN | TT_CATEGORY_CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 70 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 14 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 71 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 72 | TABLE ACCESS BY INDEX ROWID | TT_CATEGORY_MASTER | 1 | 28 | | 2 (0)| 00:00:01 | | | |* 73 | INDEX UNIQUE SCAN | TT_CATEGORY_CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 74 | NESTED LOOPS | | 1 | 21 | | 5 (0)| 00:00:01 | | | | 75 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 76 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 77 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 10 | | 3 (0)| 00:00:01 | | | |* 78 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | | 79 | NESTED LOOPS | | 1 | 24 | | 5 (0)| 00:00:01 | | | | 80 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 81 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 82 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 13 | | 3 (0)| 00:00:01 | | | |* 83 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | | 84 | NESTED LOOPS | | 1 | 20 | | 5 (0)| 00:00:01 | | | | 85 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 86 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 87 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 9 | | 3 (0)| 00:00:01 | | | |* 88 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | | 89 | NESTED LOOPS | | 1 | 55 | | 6 (0)| 00:00:01 | | | | 90 | NESTED LOOPS | | 1 | 55 | | 6 (0)| 00:00:01 | | | | 91 | NESTED LOOPS | | 1 | 25 | | 5 (0)| 00:00:01 | | | | 92 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 93 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 94 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 14 | | 3 (0)| 00:00:01 | | | |* 95 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | |* 96 | INDEX UNIQUE SCAN | SUBS_SUB_CATEGORY#CODE$PK | 1 | | | 0 (0)| 00:00:01 | | | | 97 | TABLE ACCESS BY INDEX ROWID | CB_SUBSCRIBER_SUB_CATEGORY | 1 | 30 | | 1 (0)| 00:00:01 | | | | 98 | NESTED LOOPS | | 1 | 18 | | 5 (0)| 00:00:01 | | | | 99 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |*100 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 101 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 7 | | 3 (0)| 00:00:01 | | | |*102 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | | 103 | NESTED LOOPS | | 1 | 20 | | 5 (0)| 00:00:01 | | | | 104 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |*105 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 106 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 9 | | 3 (0)| 00:00:01 | | | |*107 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | |*108 | TABLE ACCESS BY INDEX ROWID | TT_CATEGORY_MASTER | 1 | 39 | | 2 (0)| 00:00:01 | | | |*109 | INDEX UNIQUE SCAN | TT_CATEGORY_CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 110 | TABLE ACCESS BY INDEX ROWID | CB_USERS | 1 | 18 | | 2 (0)| 00:00:01 | | | |*111 | INDEX UNIQUE SCAN | CB_USERS#CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 112 | NESTED LOOPS | | 1 | 31 | | 3 (0)| 00:00:01 | | | |*113 | TABLE ACCESS BY INDEX ROWID | TT_TICKET_ADDNL_INFO | 1 | 7 | | 2 (0)| 00:00:01 | | | |*114 | INDEX UNIQUE SCAN | TT_TICKET_ADDNL_INFO_PK | 1 | | | 1 (0)| 00:00:01 | | | | 115 | TABLE ACCESS BY INDEX ROWID | CB_FAULT_TYPES | 1 | 24 | | 1 (0)| 00:00:01 | | | |*116 | INDEX UNIQUE SCAN | CB_FAULT_TYPES#U$1 | 1 | | | 0 (0)| 00:00:01 | | | | 117 | HASH UNIQUE | | 621K| 140M| 149M| 22M (1)| 00:29:10 | | | |*118 | HASH JOIN | | 621K| 140M| | 182K (1)| 00:00:15 | | | | 119 | TABLE ACCESS FULL | CB_USER_GROUP | 92 | 1840 | | 4 (0)| 00:00:01 | | | |*120 | HASH JOIN RIGHT ANTI NA | | 621K| 128M| | 182K (1)| 00:00:15 | | | | 121 | PARTITION RANGE ALL | | 43773 | 299K| | 86981 (1)| 00:00:07 | 1 |1048575| | 122 | TABLE ACCESS FULL | WF_WORKFLOW | 43773 | 299K| | 86981 (1)| 00:00:07 | 1 |1048575| |*123 | HASH JOIN | | 621K| 124M| | 95738 (1)| 00:00:08 | | | | 124 | TABLE ACCESS FULL | CB_USERS | 1511 | 33242 | | 19 (0)| 00:00:01 | | | |*125 | HASH JOIN | | 621K| 111M| 77M| 95717 (1)| 00:00:08 | | | | 126 | TABLE ACCESS FULL | TT_TICKETINCIDENT | 1327K| 62M| | 2673 (1)| 00:00:01 | | | | 127 | PARTITION RANGE ALL | | 621K| 82M| | 85914 (1)| 00:00:07 | 1 |1048575| | 128 | TABLE ACCESS FULL | TT_TICKETINFO | 621K| 82M| | 85914 (1)| 00:00:07 | 1 |1048575| ------------------------------------------------------------------------------------------------------------------------------------------------ Query Block Name / Object Alias (identified by operation id): ------------------------------------------------------------- 1 - SET$1 2 - SEL$2 / A3@SEL$2 3 - SEL$2 / A3@SEL$2 4 - SEL$3 / A2@SEL$3 5 - SEL$3 / A2@SEL$3 6 - SEL$4 / T1@SEL$4 7 - SEL$4 / T1@SEL$4 8 - SEL$5 / A1@SEL$5 9 - SEL$5 / A1@SEL$5 10 - SEL$6 11 - SEL$6 / TTI@SEL$6 12 - SEL$6 / TTI@SEL$6 13 - SEL$6 / D@SEL$6 14 - SEL$6 / D@SEL$6 15 - SEL$7 16 - SEL$7 / TTI@SEL$7 17 - SEL$7 / TTI@SEL$7 18 - SEL$7 / D@SEL$7 19 - SEL$7 / D@SEL$7 20 - SEL$8 21 - SEL$8 / TTI@SEL$8 22 - SEL$8 / TTI@SEL$8 23 - SEL$8 / D@SEL$8 24 - SEL$8 / D@SEL$8 25 - SEL$9 28 - SEL$9 / TTI@SEL$9 29 - SEL$9 / TTI@SEL$9 30 - SEL$9 / D@SEL$9 31 - SEL$9 / D@SEL$9 32 - SEL$9 / G@SEL$9 33 - SEL$9 / G@SEL$9 34 - SEL$10 35 - SEL$10 / TTI@SEL$10 36 - SEL$10 / TTI@SEL$10 37 - SEL$10 / D@SEL$10 38 - SEL$10 / D@SEL$10 39 - SEL$11 40 - SEL$11 / TTI@SEL$11 41 - SEL$11 / TTI@SEL$11 42 - SEL$11 / D@SEL$11 43 - SEL$11 / D@SEL$11 44 - SEL$12 / CM@SEL$12 45 - SEL$12 / CM@SEL$12 46 - SEL$13 / F@SEL$13 47 - SEL$13 / F@SEL$13 48 - SEL$14 49 - SEL$14 / TAI@SEL$14 50 - SEL$14 / TAI@SEL$14 51 - SEL$14 / CFT@SEL$14 52 - SEL$14 / CFT@SEL$14 53 - SEL$1 55 - SEL$1 / WM@SEL$1 57 - SEL$1 / E@SEL$1 59 - SEL$1 / CU@SEL$1 63 - SEL$1 / X@SEL$1 64 - SEL$1 / TT@SEL$1 65 - SEL$1 / TT@SEL$1 66 - SEL$16 / A3@SEL$16 67 - SEL$16 / A3@SEL$16 68 - SEL$17 / A2@SEL$17 69 - SEL$17 / A2@SEL$17 70 - SEL$18 / T1@SEL$18 71 - SEL$18 / T1@SEL$18 72 - SEL$19 / A1@SEL$19 73 - SEL$19 / A1@SEL$19 74 - SEL$20 75 - SEL$20 / TTI@SEL$20 76 - SEL$20 / TTI@SEL$20 77 - SEL$20 / D@SEL$20 78 - SEL$20 / D@SEL$20 79 - SEL$21 80 - SEL$21 / TTI@SEL$21 81 - SEL$21 / TTI@SEL$21 82 - SEL$21 / D@SEL$21 83 - SEL$21 / D@SEL$21 84 - SEL$22 85 - SEL$22 / TTI@SEL$22 86 - SEL$22 / TTI@SEL$22 87 - SEL$22 / D@SEL$22 88 - SEL$22 / D@SEL$22 89 - SEL$23 92 - SEL$23 / TTI@SEL$23 93 - SEL$23 / TTI@SEL$23 94 - SEL$23 / D@SEL$23 95 - SEL$23 / D@SEL$23 96 - SEL$23 / G@SEL$23 97 - SEL$23 / G@SEL$23 98 - SEL$24 99 - SEL$24 / TTI@SEL$24 100 - SEL$24 / TTI@SEL$24 101 - SEL$24 / D@SEL$24 102 - SEL$24 / D@SEL$24 103 - SEL$25 104 - SEL$25 / TTI@SEL$25 105 - SEL$25 / TTI@SEL$25 106 - SEL$25 / D@SEL$25 107 - SEL$25 / D@SEL$25 108 - SEL$26 / CM@SEL$26 109 - SEL$26 / CM@SEL$26 110 - SEL$27 / F@SEL$27 111 - SEL$27 / F@SEL$27 112 - SEL$28 113 - SEL$28 / TAI@SEL$28 114 - SEL$28 / TAI@SEL$28 115 - SEL$28 / CFT@SEL$28 116 - SEL$28 / CFT@SEL$28 117 - SEL$653BBCD7 119 - SEL$653BBCD7 / C@SEL$15 122 - SEL$653BBCD7 / WF_WORKFLOW@SEL$29 124 - SEL$653BBCD7 / B@SEL$15 126 - SEL$653BBCD7 / TTI@SEL$15 128 - SEL$653BBCD7 / TT@SEL$15 Predicate Information (identified by operation id): --------------------------------------------------- 2 - filter("A3"."PARENT_CATEGORY_CODE_V"<>'0') 3 - access("A3"."CATEGORY_CODE_V"= (SELECT /*+ PUSH_SUBQ INDEX_RS_ASC ("A2" "TT_CATEGORY_CODE$PK") */ "A2"."PARENT_CATEGORY_CODE_V" FROM "CLM_TT"."TT_CATEGORY_MASTER" "A2" WHERE "A2"."CATEGORY_CODE_V"= (SELECT /*+ PUSH_SUBQ INDEX_RS_ASC ("T1" "TTINFO_DKTNUM_PK") */ "T1"."SUBCATEGORY_ID_V" FROM "CLM_TT"."TT_TICKETINFO" "T1" WHERE "T1"."DOCKET_NUMBER_N"=:B1))) 5 - access("A2"."CATEGORY_CODE_V"= (SELECT /*+ PUSH_SUBQ INDEX_RS_ASC ("T1" "TTINFO_DKTNUM_PK") */ "T1"."SUBCATEGORY_ID_V" FROM "CLM_TT"."TT_TICKETINFO" "T1" WHERE "T1"."DOCKET_NUMBER_N"=:B1)) 7 - access("T1"."DOCKET_NUMBER_N"=:B1) 9 - access("A1"."CATEGORY_CODE_V"=:B1) 12 - access("TTI"."DOCKET_NUMBER_N"=:B1) 14 - access("TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V")) filter(TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL) 17 - access("TTI"."DOCKET_NUMBER_N"=:B1) 19 - access("TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V")) filter(TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL) 22 - access("TTI"."DOCKET_NUMBER_N"=:B1) 24 - access("TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V")) filter(TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL) 29 - access("TTI"."DOCKET_NUMBER_N"=:B1) 31 - access("TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V")) filter(TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL) 32 - access("D"."SUBSCRIBER_CATEGORY_V"="G"."SUBS_CATEGORY_CODE_V" AND "D"."SUBSCRIBER_SUB_CATEGORY_V"="G"."SUBS_SUB_CATEGORY_CODE_V") 36 - access("TTI"."DOCKET_NUMBER_N"=:B1) 38 - access("TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V")) filter(TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL) 41 - access("TTI"."DOCKET_NUMBER_N"=:B1) 43 - access("TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V")) filter(TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL) 44 - filter("CM"."PARENT_CATEGORY_CODE_V"='0' AND "CM"."CATEGORY_TYPE_V"=:B1) 45 - access("CM"."CATEGORY_CODE_V"=:B1) 47 - access("F"."USER_CODE_N"=:B1) 49 - filter("TAI"."FAULT_CODE_V" IS NOT NULL) 50 - access("TAI"."DOCKET_NUMBER_N"=:B1) 52 - access("TAI"."FAULT_CODE_V"="CFT"."FAULT_CODE_V") 54 - access("X"."WRKFLW_ID_N"="WM"."WRKFLW_ID_N") 56 - access("CU"."GROUP_CODE_N"="E"."GROUP_CODE_N") 58 - access("TT"."LOGGED_BY_N"="CU"."USER_CODE_N") 64 - access("TT"."DOCKET_NUMBER_N"=TO_NUMBER("X"."EVENT_REFNO_V")) 66 - filter("A3"."PARENT_CATEGORY_CODE_V"<>'0') 67 - access("A3"."CATEGORY_CODE_V"= (SELECT /*+ PUSH_SUBQ INDEX_RS_ASC ("A2" "TT_CATEGORY_CODE$PK") */ "A2"."PARENT_CATEGORY_CODE_V" FROM "CLM_TT"."TT_CATEGORY_MASTER" "A2" WHERE "A2"."CATEGORY_CODE_V"= (SELECT /*+ PUSH_SUBQ INDEX_RS_ASC ("T1" "TTINFO_DKTNUM_PK") */ "T1"."SUBCATEGORY_ID_V" FROM "CLM_TT"."TT_TICKETINFO" "T1" WHERE "T1"."DOCKET_NUMBER_N"=:B1))) 69 - access("A2"."CATEGORY_CODE_V"= (SELECT /*+ PUSH_SUBQ INDEX_RS_ASC ("T1" "TTINFO_DKTNUM_PK") */ "T1"."SUBCATEGORY_ID_V" FROM "CLM_TT"."TT_TICKETINFO" "T1" WHERE "T1"."DOCKET_NUMBER_N"=:B1)) 71 - access("T1"."DOCKET_NUMBER_N"=:B1) 73 - access("A1"."CATEGORY_CODE_V"=:B1) 76 - access("TTI"."DOCKET_NUMBER_N"=:B1) 78 - access("TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V")) filter(TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL) 81 - access("TTI"."DOCKET_NUMBER_N"=:B1) 83 - access("TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V")) filter(TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL) 86 - access("TTI"."DOCKET_NUMBER_N"=:B1) 88 - access("TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V")) filter(TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL) 93 - access("TTI"."DOCKET_NUMBER_N"=:B1) 95 - access("TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V")) filter(TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL) 96 - access("D"."SUBSCRIBER_CATEGORY_V"="G"."SUBS_CATEGORY_CODE_V" AND "D"."SUBSCRIBER_SUB_CATEGORY_V"="G"."SUBS_SUB_CATEGORY_CODE_V") 100 - access("TTI"."DOCKET_NUMBER_N"=:B1) 102 - access("TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V")) filter(TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL) 105 - access("TTI"."DOCKET_NUMBER_N"=:B1) 107 - access("TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V")) filter(TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL) 108 - filter("CM"."PARENT_CATEGORY_CODE_V"='0' AND "CM"."CATEGORY_TYPE_V"=:B1) 109 - access("CM"."CATEGORY_CODE_V"=:B1) 111 - access("F"."USER_CODE_N"=:B1) 113 - filter("TAI"."FAULT_CODE_V" IS NOT NULL) 114 - access("TAI"."DOCKET_NUMBER_N"=:B1) 116 - access("TAI"."FAULT_CODE_V"="CFT"."FAULT_CODE_V") 118 - access("C"."GROUP_CODE_N"="B"."GROUP_CODE_N") 120 - access("TT"."DOCKET_NUMBER_N"=TO_NUMBER("EVENT_REFNO_V")) 123 - access("TT"."LOGGED_BY_N"="B"."USER_CODE_N") 125 - access("TTI"."INCIDENT_NUMBER_N"="TT"."DOCKET_NUMBER_N") Column Projection Information (identified by operation id): ----------------------------------------------------------- 1 - STRDEF[8], STRDEF[22], STRDEF[50], STRDEF[22], STRDEF[11], STRDEF[22], STRDEF[11], STRDEF[22], STRDEF[11], STRDEF[22], STRDEF[11], STRDEF[22], STRDEF[22], STRDEF[14], STRDEF[15], STRDEF[200], STRDEF[200], STRDEF[16], STRDEF[10], STRDEF[8], STRDEF[30], STRDEF[2], STRDEF[22], STRDEF[1], STRDEF[5], STRDEF[200], STRDEF[120], STRDEF[120], STRDEF[30], STRDEF[4000], STRDEF[4000], STRDEF[1000], STRDEF[50], STRDEF[120] 2 - "A3".ROWID[ROWID,10], "A3"."CATEGORY_DESCRIPTION_V"[VARCHAR2,200], "A3"."PARENT_CATEGORY_CODE_V"[VARCHAR2,8] 3 - "A3".ROWID[ROWID,10] 4 - "A2".ROWID[ROWID,10], "A2"."PARENT_CATEGORY_CODE_V"[VARCHAR2,8] 5 - "A2".ROWID[ROWID,10] 6 - "T1".ROWID[ROWID,10], "T1"."SUBCATEGORY_ID_V"[VARCHAR2,8] 7 - "T1".ROWID[ROWID,10] 8 - "A1".ROWID[ROWID,10], "A1"."CATEGORY_DESCRIPTION_V"[VARCHAR2,200] 9 - "A1".ROWID[ROWID,10] 10 - (#keys=0) "D"."MOBL_NUM_VOICE_V"[VARCHAR2,16] 11 - "TTI"."ENTITY_ID_N"[NUMBER,22] 12 - "TTI".ROWID[ROWID,10] 13 - "D"."MOBL_NUM_VOICE_V"[VARCHAR2,16] 14 - "D".ROWID[ROWID,10], TO_NUMBER("MOBL_NUM_VOICE_V")[NUMBER,22] 15 - (#keys=0) "D"."SUB_SERVICE_CODE_V"[VARCHAR2,10] 16 - "TTI"."ENTITY_ID_N"[NUMBER,22] 17 - "TTI".ROWID[ROWID,10] 18 - "D"."SUB_SERVICE_CODE_V"[VARCHAR2,10] 19 - "D".ROWID[ROWID,10], TO_NUMBER("MOBL_NUM_VOICE_V")[NUMBER,22] 20 - (#keys=0) "D"."SUBSCRIBER_CATEGORY_V"[VARCHAR2,8] 21 - "TTI"."ENTITY_ID_N"[NUMBER,22] 22 - "TTI".ROWID[ROWID,10] 23 - "D"."SUBSCRIBER_CATEGORY_V"[VARCHAR2,8] 24 - "D".ROWID[ROWID,10], TO_NUMBER("MOBL_NUM_VOICE_V")[NUMBER,22] 25 - (#keys=0) "G"."SUBS_SUB_CATEGORY_DESC_V"[VARCHAR2,30] 26 - (#keys=0) "G".ROWID[ROWID,10] 27 - (#keys=0) "D"."SUBSCRIBER_CATEGORY_V"[VARCHAR2,8], "D"."SUBSCRIBER_SUB_CATEGORY_V"[VARCHAR2,8] 28 - "TTI"."ENTITY_ID_N"[NUMBER,22] 29 - "TTI".ROWID[ROWID,10] 30 - "D"."SUBSCRIBER_CATEGORY_V"[VARCHAR2,8], "D"."SUBSCRIBER_SUB_CATEGORY_V"[VARCHAR2,8] 31 - "D".ROWID[ROWID,10], TO_NUMBER("MOBL_NUM_VOICE_V")[NUMBER,22] 32 - "G".ROWID[ROWID,10] 33 - "G"."SUBS_SUB_CATEGORY_DESC_V"[VARCHAR2,30] 34 - (#keys=0) "D"."STATUS_CODE_V"[VARCHAR2,2] 35 - "TTI"."ENTITY_ID_N"[NUMBER,22] 36 - "TTI".ROWID[ROWID,10] 37 - "D"."STATUS_CODE_V"[VARCHAR2,2] 38 - "D".ROWID[ROWID,10], TO_NUMBER("MOBL_NUM_VOICE_V")[NUMBER,22] 39 - (#keys=0) "D"."ACCOUNT_CODE_N"[NUMBER,22] 40 - "TTI"."ENTITY_ID_N"[NUMBER,22] 41 - "TTI".ROWID[ROWID,10] 42 - "D"."ACCOUNT_CODE_N"[NUMBER,22] 43 - "D".ROWID[ROWID,10], TO_NUMBER("MOBL_NUM_VOICE_V")[NUMBER,22] 44 - "CM".ROWID[ROWID,10], "CM"."CATEGORY_TYPE_V"[VARCHAR2,1], "CM"."CATEGORY_DESCRIPTION_V"[VARCHAR2,200], "CM"."PARENT_CATEGORY_CODE_V"[VARCHAR2,8] 45 - "CM".ROWID[ROWID,10] 46 - "F".ROWID[ROWID,10], "F"."USER_NAME_V"[VARCHAR2,120] 47 - "F".ROWID[ROWID,10] 48 - (#keys=0) "CFT"."FAULT_NAME_V"[VARCHAR2,50] 49 - "TAI"."FAULT_CODE_V"[VARCHAR2,8] 50 - "TAI".ROWID[ROWID,10] 51 - "CFT"."FAULT_NAME_V"[VARCHAR2,50] 52 - "CFT".ROWID[ROWID,10] 53 - (#keys=34) 'Workflow'[8], "TT"."DOCKET_NUMBER_N"[NUMBER,22], "WM"."WRKFLW_DESC_V"[VARCHAR2,50], "WM"."ESTIMATED_RESOLN_TM_N"[NUMBER,22], "TT"."TICKET_REGN_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], ROUND((CAST(FROM_TZ(CAST(INTERNAL_FUNCTION("TT"."TICKET_REGN_DT_D") AS timestamp),SESSIONTIMEZONE) AT TIME ZONE 'GMT' AS date)-TO_DATE(' 1970-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))*86400)[22], "X"."START_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], ROUND((CAST(FROM_TZ(CAST(INTERNAL_FUNCTION("X"."START_DT_D") AS timestamp),SESSIONTIMEZONE) AT TIME ZONE 'GMT' AS date)-TO_DATE(' 1970-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))*86400)[22], "X"."END_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], ROUND((CAST(FROM_TZ(CAST(INTERNAL_FUNCTION("X"."END_DT_D") AS timestamp),SESSIONTIMEZONE) AT TIME ZONE 'GMT' AS date)-TO_DATE(' 1970-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))*86400)[22], "TT"."TICKET_RESP_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], ROUND((CAST(FROM_TZ(CAST(INTERNAL_FUNCTION("TT"."TICKET_RESP_DT_D") AS timestamp),SESSIONTIMEZONE) AT TIME ZONE 'GMT' AS date)-TO_DATE(' 1970-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))*86400)[22], ROUND((CAST(FROM_TZ(CAST(SYSDATE@! AS timestamp),SESSIONTIMEZONE) AT TIME ZONE 'GMT' AS date)-TO_DATE(' 1970-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))*86400)[22], DECODE("TT"."STATUS_V",'P','Pending','A','Task completed','C','Closed','R','Resolved')[14], DECODE("TT"."TICKET_TYPE_V",'Q','Query','C','Complaint Type','R','Service Request')[15], (SELECT /*+ INDEX_RS_ASC ("A3" "TT_CATEGORY_CODE$PK") */ "A3"."CATEGORY_DESCRIPTION_V" FROM "CLM_TT"."TT_CATEGORY_MASTER" "A3" WHERE "A3"."CATEGORY_CODE_V"= (SELECT /*+ PUSH_SUBQ INDEX_RS_ASC ("A2" "TT_CATEGORY_CODE$PK") */ "A2"."PARENT_CATEGORY_CODE_V" FROM "CLM_TT"."TT_CATEGORY_MASTER" "A2" WHERE "A2"."CATEGORY_CODE_V"= (SELECT /*+ PUSH_SUBQ INDEX_RS_ASC ("T1" "TTINFO_DKTNUM_PK") */ "T1"."SUBCATEGORY_ID_V" FROM "CLM_TT"."TT_TICKETINFO" "T1" WHERE "T1"."DOCKET_NUMBER_N"=:B1)) AND "A3"."PARENT_CATEGORY_CODE_V"<>'0')[200], (SELECT /*+ INDEX_RS_ASC ("A1" "TT_CATEGORY_CODE$PK") */ DISTINCT "A1"."CATEGORY_DESCRIPTION_V" FROM "CLM_TT"."TT_CATEGORY_MASTER" "A1" WHERE "A1"."CATEGORY_CODE_V"=:B2)[200], (SELECT /*+ LEADING ("TTI" "D") INDEX_RS_ASC ("TTI" "TTINFO_DKTNUM_PK") USE_NL ("D") BATCH_TABLE_ACCESS_BY_ROWID ("D") INDEX_RS_ASC ("D" "GSM_SERV_MAST#TMP#TO_MOBL_V") */ "D"."MOBL_NUM_VOICE_V" FROM "CLM_TT"."TT_TICKETINFO" "TTI","CBS_CORE"."GSM_SERVICE_MAST" "D" WHERE "TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V") AND TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL AND "TTI"."DOCKET_NUMBER_N"=:B3)[16], (SELECT /*+ LEADING ("TTI" "D") INDEX_RS_ASC ("TTI" "TTINFO_DKTNUM_PK") USE_NL ("D") BATCH_TABLE_ACCESS_BY_ROWID ("D") INDEX_RS_ASC ("D" "GSM_SERV_MAST#TMP#TO_MOBL_V") */ "D"."SUB_SERVICE_CODE_V" FROM "CLM_TT"."TT_TICKETINFO" "TTI","CBS_CORE"."GSM_SERVICE_MAST" "D" WHERE "TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V") AND TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL AND "TTI"."DOCKET_NUMBER_N"=:B4)[10], (SELECT /*+ LEADING ("TTI" "D") INDEX_RS_ASC ("TTI" "TTINFO_DKTNUM_PK") USE_NL ("D") BATCH_TABLE_ACCESS_BY_ROWID ("D") INDEX_RS_ASC ("D" "GSM_SERV_MAST#TMP#TO_MOBL_V") */ "D"."SUBSCRIBER_CATEGORY_V" FROM "CLM_TT"."TT_TICKETINFO" "TTI","CBS_CORE"."GSM_SERVICE_MAST" "D" WHERE "TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V") AND TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL AND "TTI"."DOCKET_NUMBER_N"=:B5)[8], (SELECT /*+ LEADING ("TTI" "D" "G") INDEX_RS_ASC ("TTI" "TTINFO_DKTNUM_PK") USE_NL ("G") INDEX ("G" "SUBS_SUB_CATEGORY#CODE$PK") USE_NL ("D") BATCH_TABLE_ACCESS_BY_ROWID ("D") INDEX_RS_ASC ("D" "GSM_SERV_MAST#TMP#TO_MOBL_V") */ "G"."SUBS_SUB_CATEGORY_DESC_V" FROM "CLM_TT"."TT_TICKETINFO" "TTI","CBS_CORE"."CB_SUBSCRIBER_SUB_CATEGORY" "G","CBS_CORE"."GSM_SERVICE_MAST" "D" WHERE "TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V") AND TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL AND "D"."SUBSCRIBER_SUB_CATEGORY_V"="G"."SUBS_SUB_CATEGORY_CODE_V" AND "D"."SUBSCRIBER_CATEGORY_V"="G"."SUBS_CATE 54 - (#keys=1) "WM"."ESTIMATED_RESOLN_TM_N"[NUMBER,22], "WM"."WRKFLW_DESC_V"[VARCHAR2,50], "E"."GROUP_NAME_V"[VARCHAR2,30], "TT"."LOGGED_BY_N"[NUMBER,22], "TT"."QUESTION_V"[VARCHAR2,4000], "CU"."USER_NAME_V"[VARCHAR2,120], "TT"."TICKET_RESP_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."START_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."END_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."STATUS_V"[VARCHAR2,1], "TT"."DOCKET_NUMBER_N"[NUMBER,22], "TT"."TICKET_REGN_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."STATUS_V"[VARCHAR2,1], "TT"."CATEGORY_ID_V"[VARCHAR2,8], "TT"."SUBCATEGORY_ID_V"[VARCHAR2,8], "TT"."TICKET_TYPE_V"[VARCHAR2,1], "TT"."ANSWER_V"[VARCHAR2,4000], "TT"."TT_SOURCE_V"[VARCHAR2,5] 55 - "WM"."WRKFLW_ID_N"[NUMBER,22], "WM"."WRKFLW_DESC_V"[VARCHAR2,50], "WM"."ESTIMATED_RESOLN_TM_N"[NUMBER,22] 56 - (#keys=1) "E"."GROUP_NAME_V"[VARCHAR2,30], "TT"."LOGGED_BY_N"[NUMBER,22], "TT"."QUESTION_V"[VARCHAR2,4000], "CU"."USER_NAME_V"[VARCHAR2,120], "X"."WRKFLW_ID_N"[NUMBER,22], "X"."START_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."END_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."STATUS_V"[VARCHAR2,1], "TT"."DOCKET_NUMBER_N"[NUMBER,22], "TT"."TICKET_REGN_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."STATUS_V"[VARCHAR2,1], "TT"."CATEGORY_ID_V"[VARCHAR2,8], "TT"."SUBCATEGORY_ID_V"[VARCHAR2,8], "TT"."TICKET_TYPE_V"[VARCHAR2,1], "TT"."ANSWER_V"[VARCHAR2,4000], "TT"."TT_SOURCE_V"[VARCHAR2,5], "TT"."TICKET_RESP_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11] 57 - "E"."GROUP_CODE_N"[NUMBER,22], "E"."GROUP_NAME_V"[VARCHAR2,30] 58 - (#keys=1) "TT"."LOGGED_BY_N"[NUMBER,22], "CU"."GROUP_CODE_N"[NUMBER,22], "CU"."USER_NAME_V"[VARCHAR2,120], "X"."WRKFLW_ID_N"[NUMBER,22], "X"."START_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."END_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."STATUS_V"[VARCHAR2,1], "TT"."DOCKET_NUMBER_N"[NUMBER,22], "TT"."TICKET_REGN_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."STATUS_V"[VARCHAR2,1], "TT"."CATEGORY_ID_V"[VARCHAR2,8], "TT"."SUBCATEGORY_ID_V"[VARCHAR2,8], "TT"."TICKET_TYPE_V"[VARCHAR2,1], "TT"."ANSWER_V"[VARCHAR2,4000], "TT"."TT_SOURCE_V"[VARCHAR2,5], "TT"."TICKET_RESP_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."QUESTION_V"[VARCHAR2,4000] 59 - "CU"."USER_CODE_N"[NUMBER,22], "CU"."USER_NAME_V"[VARCHAR2,120], "CU"."GROUP_CODE_N"[NUMBER,22] 60 - (#keys=0) "X"."WRKFLW_ID_N"[NUMBER,22], "X"."START_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."END_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."STATUS_V"[VARCHAR2,1], "TT"."DOCKET_NUMBER_N"[NUMBER,22], "TT"."TICKET_REGN_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."STATUS_V"[VARCHAR2,1], "TT"."CATEGORY_ID_V"[VARCHAR2,8], "TT"."SUBCATEGORY_ID_V"[VARCHAR2,8], "TT"."TICKET_TYPE_V"[VARCHAR2,1], "TT"."LOGGED_BY_N"[NUMBER,22], "TT"."TT_SOURCE_V"[VARCHAR2,5], "TT"."TICKET_RESP_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."QUESTION_V"[VARCHAR2,4000], "TT"."ANSWER_V"[VARCHAR2,4000] 61 - (#keys=0) "X"."WRKFLW_ID_N"[NUMBER,22], "X"."START_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."END_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."STATUS_V"[VARCHAR2,1], "TT".ROWID[ROWID,10], "TT"."DOCKET_NUMBER_N"[NUMBER,22] 62 - "X"."EVENT_REFNO_V"[VARCHAR2,20], "X"."WRKFLW_ID_N"[NUMBER,22], "X"."START_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."END_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."STATUS_V"[VARCHAR2,1] 63 - "X"."EVENT_REFNO_V"[VARCHAR2,20], "X"."WRKFLW_ID_N"[NUMBER,22], "X"."START_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."END_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "X"."STATUS_V"[VARCHAR2,1] 64 - "TT".ROWID[ROWID,10], "TT"."DOCKET_NUMBER_N"[NUMBER,22] 65 - "TT"."TICKET_REGN_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."STATUS_V"[VARCHAR2,1], "TT"."CATEGORY_ID_V"[VARCHAR2,8], "TT"."SUBCATEGORY_ID_V"[VARCHAR2,8], "TT"."TICKET_TYPE_V"[VARCHAR2,1], "TT"."LOGGED_BY_N"[NUMBER,22], "TT"."TT_SOURCE_V"[VARCHAR2,5], "TT"."TICKET_RESP_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."QUESTION_V"[VARCHAR2,4000], "TT"."ANSWER_V"[VARCHAR2,4000] 66 - "A3".ROWID[ROWID,10], "A3"."CATEGORY_DESCRIPTION_V"[VARCHAR2,200], "A3"."PARENT_CATEGORY_CODE_V"[VARCHAR2,8] 67 - "A3".ROWID[ROWID,10] 68 - "A2".ROWID[ROWID,10], "A2"."PARENT_CATEGORY_CODE_V"[VARCHAR2,8] 69 - "A2".ROWID[ROWID,10] 70 - "T1".ROWID[ROWID,10], "T1"."SUBCATEGORY_ID_V"[VARCHAR2,8] 71 - "T1".ROWID[ROWID,10] 72 - "A1".ROWID[ROWID,10], "A1"."CATEGORY_DESCRIPTION_V"[VARCHAR2,200] 73 - "A1".ROWID[ROWID,10] 74 - (#keys=0) "D"."MOBL_NUM_VOICE_V"[VARCHAR2,16] 75 - "TTI"."ENTITY_ID_N"[NUMBER,22] 76 - "TTI".ROWID[ROWID,10] 77 - "D"."MOBL_NUM_VOICE_V"[VARCHAR2,16] 78 - "D".ROWID[ROWID,10], TO_NUMBER("MOBL_NUM_VOICE_V")[NUMBER,22] 79 - (#keys=0) "D"."SUB_SERVICE_CODE_V"[VARCHAR2,10] 80 - "TTI"."ENTITY_ID_N"[NUMBER,22] 81 - "TTI".ROWID[ROWID,10] 82 - "D"."SUB_SERVICE_CODE_V"[VARCHAR2,10] 83 - "D".ROWID[ROWID,10], TO_NUMBER("MOBL_NUM_VOICE_V")[NUMBER,22] 84 - (#keys=0) "D"."SUBSCRIBER_CATEGORY_V"[VARCHAR2,8] 85 - "TTI"."ENTITY_ID_N"[NUMBER,22] 86 - "TTI".ROWID[ROWID,10] 87 - "D"."SUBSCRIBER_CATEGORY_V"[VARCHAR2,8] 88 - "D".ROWID[ROWID,10], TO_NUMBER("MOBL_NUM_VOICE_V")[NUMBER,22] 89 - (#keys=0) "G"."SUBS_SUB_CATEGORY_DESC_V"[VARCHAR2,30] 90 - (#keys=0) "G".ROWID[ROWID,10] 91 - (#keys=0) "D"."SUBSCRIBER_CATEGORY_V"[VARCHAR2,8], "D"."SUBSCRIBER_SUB_CATEGORY_V"[VARCHAR2,8] 92 - "TTI"."ENTITY_ID_N"[NUMBER,22] 93 - "TTI".ROWID[ROWID,10] 94 - "D"."SUBSCRIBER_CATEGORY_V"[VARCHAR2,8], "D"."SUBSCRIBER_SUB_CATEGORY_V"[VARCHAR2,8] 95 - "D".ROWID[ROWID,10], TO_NUMBER("MOBL_NUM_VOICE_V")[NUMBER,22] 96 - "G".ROWID[ROWID,10] 97 - "G"."SUBS_SUB_CATEGORY_DESC_V"[VARCHAR2,30] 98 - (#keys=0) "D"."STATUS_CODE_V"[VARCHAR2,2] 99 - "TTI"."ENTITY_ID_N"[NUMBER,22] 100 - "TTI".ROWID[ROWID,10] 101 - "D"."STATUS_CODE_V"[VARCHAR2,2] 102 - "D".ROWID[ROWID,10], TO_NUMBER("MOBL_NUM_VOICE_V")[NUMBER,22] 103 - (#keys=0) "D"."ACCOUNT_CODE_N"[NUMBER,22] 104 - "TTI"."ENTITY_ID_N"[NUMBER,22] 105 - "TTI".ROWID[ROWID,10] 106 - "D"."ACCOUNT_CODE_N"[NUMBER,22] 107 - "D".ROWID[ROWID,10], TO_NUMBER("MOBL_NUM_VOICE_V")[NUMBER,22] 108 - "CM".ROWID[ROWID,10], "CM"."CATEGORY_TYPE_V"[VARCHAR2,1], "CM"."CATEGORY_DESCRIPTION_V"[VARCHAR2,200], "CM"."PARENT_CATEGORY_CODE_V"[VARCHAR2,8] 109 - "CM".ROWID[ROWID,10] 110 - "F".ROWID[ROWID,10], "F"."USER_NAME_V"[VARCHAR2,120] 111 - "F".ROWID[ROWID,10] 112 - (#keys=0) "CFT"."FAULT_NAME_V"[VARCHAR2,50] 113 - "TAI"."FAULT_CODE_V"[VARCHAR2,8] 114 - "TAI".ROWID[ROWID,10] 115 - "CFT"."FAULT_NAME_V"[VARCHAR2,50] 116 - "CFT".ROWID[ROWID,10] 117 - (#keys=34) 'FLR'[3], "TT"."DOCKET_NUMBER_N"[NUMBER,22], NULL[0], NULL[0], "TT"."TICKET_REGN_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], NULL[0], NULL[0], NULL[0], NULL[0], NULL[0], "TT"."TICKET_RESP_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], NULL[0], ROUND((CAST(FROM_TZ(CAST(SYSDATE@! AS timestamp),SESSIONTIMEZONE) AT TIME ZONE 'GMT' AS date)-TO_DATE(' 1970-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))*86400)[22], DECODE("TT"."STATUS_V",'P','Pending','A','Task completed','C','Closed','R','Resolved')[14], DECODE("TT"."TICKET_TYPE_V",'Q','Query','C','Complaint Type','R','Service Request')[15], (SELECT /*+ INDEX_RS_ASC ("A3" "TT_CATEGORY_CODE$PK") */ "A3"."CATEGORY_DESCRIPTION_V" FROM "CLM_TT"."TT_CATEGORY_MASTER" "A3" WHERE "A3"."CATEGORY_CODE_V"= (SELECT /*+ PUSH_SUBQ INDEX_RS_ASC ("A2" "TT_CATEGORY_CODE$PK") */ "A2"."PARENT_CATEGORY_CODE_V" FROM "CLM_TT"."TT_CATEGORY_MASTER" "A2" WHERE "A2"."CATEGORY_CODE_V"= (SELECT /*+ PUSH_SUBQ INDEX_RS_ASC ("T1" "TTINFO_DKTNUM_PK") */ "T1"."SUBCATEGORY_ID_V" FROM "CLM_TT"."TT_TICKETINFO" "T1" WHERE "T1"."DOCKET_NUMBER_N"=:B1)) AND "A3"."PARENT_CATEGORY_CODE_V"<>'0')[200], (SELECT /*+ INDEX_RS_ASC ("A1" "TT_CATEGORY_CODE$PK") */ DISTINCT "A1"."CATEGORY_DESCRIPTION_V" FROM "CLM_TT"."TT_CATEGORY_MASTER" "A1" WHERE "A1"."CATEGORY_CODE_V"=:B2)[200], (SELECT /*+ LEADING ("TTI" "D") INDEX_RS_ASC ("TTI" "TTINFO_DKTNUM_PK") USE_NL ("D") BATCH_TABLE_ACCESS_BY_ROWID ("D") INDEX_RS_ASC ("D" "GSM_SERV_MAST#TMP#TO_MOBL_V") */ "D"."MOBL_NUM_VOICE_V" FROM "CLM_TT"."TT_TICKETINFO" "TTI","CBS_CORE"."GSM_SERVICE_MAST" "D" WHERE "TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V") AND TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL AND "TTI"."DOCKET_NUMBER_N"=:B3)[16], (SELECT /*+ LEADING ("TTI" "D") INDEX_RS_ASC ("TTI" "TTINFO_DKTNUM_PK") USE_NL ("D") BATCH_TABLE_ACCESS_BY_ROWID ("D") INDEX_RS_ASC ("D" "GSM_SERV_MAST#TMP#TO_MOBL_V") */ "D"."SUB_SERVICE_CODE_V" FROM "CLM_TT"."TT_TICKETINFO" "TTI","CBS_CORE"."GSM_SERVICE_MAST" "D" WHERE "TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V") AND TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL AND "TTI"."DOCKET_NUMBER_N"=:B4)[10], (SELECT /*+ LEADING ("TTI" "D") INDEX_RS_ASC ("TTI" "TTINFO_DKTNUM_PK") USE_NL ("D") BATCH_TABLE_ACCESS_BY_ROWID ("D") INDEX_RS_ASC ("D" "GSM_SERV_MAST#TMP#TO_MOBL_V") */ "D"."SUBSCRIBER_CATEGORY_V" FROM "CLM_TT"."TT_TICKETINFO" "TTI","CBS_CORE"."GSM_SERVICE_MAST" "D" WHERE "TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V") AND TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL AND "TTI"."DOCKET_NUMBER_N"=:B5)[8], (SELECT /*+ LEADING ("TTI" "D" "G") INDEX_RS_ASC ("TTI" "TTINFO_DKTNUM_PK") USE_NL ("G") INDEX ("G" "SUBS_SUB_CATEGORY#CODE$PK") USE_NL ("D") BATCH_TABLE_ACCESS_BY_ROWID ("D") INDEX_RS_ASC ("D" "GSM_SERV_MAST#TMP#TO_MOBL_V") */ "G"."SUBS_SUB_CATEGORY_DESC_V" FROM "CLM_TT"."TT_TICKETINFO" "TTI","CBS_CORE"."CB_SUBSCRIBER_SUB_CATEGORY" "G","CBS_CORE"."GSM_SERVICE_MAST" "D" WHERE "TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V") AND TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL AND "D"."SUBSCRIBER_SUB_CATEGORY_V"="G"."SUBS_SUB_CATEGORY_CODE_V" AND "D"."SUBSCRIBER_CATEGORY_V"="G"."SUBS_CATEGORY_CODE_V" AND "TTI"."DOCKET_NUMBER_N"=:B6)[30], (SELECT /*+ LEADING ("TTI" "D") INDEX_RS_ASC ("TTI" "TTINFO_DKTNUM_PK") USE_NL ("D") BATCH_TABLE_ACCESS_BY_ROWID ("D") INDEX_RS_ASC ("D" "GSM_SERV_MAST#TMP#TO_MOBL_V") */ "D"."STATUS_CODE_V" FROM "CLM_TT"."TT_TICKETINFO" "TTI","CBS_CORE"."GSM_SERVICE_MAST" "D" WHERE "TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V") AND TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL AND "TTI"."DOCKET_NUMBER_N"=:B7)[2], (SELECT /*+ LEADING ("TTI" "D") INDEX_RS_ASC ("TTI" "TTINFO_DKTNUM_PK") USE_NL ("D") BATCH_TABLE_ACCESS_BY_ROWID ("D") INDEX_RS_ASC ("D" "GSM_SERV_MAST#TMP#TO_MOBL_V") */ "D"."ACCOUNT_CODE_N" FROM "CLM_TT"."TT_TICKETINFO" "TTI","CBS_CORE"."GSM_SERVICE_MAST" "D" WHERE "TTI"."ENTITY_ID_N"=TO_NUMBER("MOBL_NUM_VOICE_V") AND TO_NUMBER("MOBL_NUM_VOICE_V") IS NOT NULL AND "TTI"."DOCKET_NUMBER_N"=:B8) 118 - (#keys=1) "C"."GROUP_NAME_V"[VARCHAR2,30], "TT"."DOCKET_NUMBER_N"[NUMBER,22], "TT"."LOGGED_BY_N"[NUMBER,22], "TT"."TT_SOURCE_V"[VARCHAR2,5], "B"."USER_NAME_V"[VARCHAR2,120], "TT"."TICKET_RESP_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TTI"."NOTES_V"[VARCHAR2,1000], "TT"."ANSWER_V"[VARCHAR2,4000], "TT"."TICKET_REGN_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."STATUS_V"[VARCHAR2,1], "TT"."CATEGORY_ID_V"[VARCHAR2,8], "TT"."SUBCATEGORY_ID_V"[VARCHAR2,8], "TT"."TICKET_TYPE_V"[VARCHAR2,1], "TT"."QUESTION_V"[VARCHAR2,4000] 119 - "C"."GROUP_CODE_N"[NUMBER,22], "C"."GROUP_NAME_V"[VARCHAR2,30] 120 - (#keys=1) "TT"."DOCKET_NUMBER_N"[NUMBER,22], "TT"."LOGGED_BY_N"[NUMBER,22], "B"."GROUP_CODE_N"[NUMBER,22], "B"."USER_NAME_V"[VARCHAR2,120], "TT"."TICKET_RESP_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TTI"."NOTES_V"[VARCHAR2,1000], "TT"."ANSWER_V"[VARCHAR2,4000], "TT"."TICKET_REGN_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."STATUS_V"[VARCHAR2,1], "TT"."CATEGORY_ID_V"[VARCHAR2,8], "TT"."SUBCATEGORY_ID_V"[VARCHAR2,8], "TT"."TICKET_TYPE_V"[VARCHAR2,1], "TT"."QUESTION_V"[VARCHAR2,4000], "TT"."TT_SOURCE_V"[VARCHAR2,5] 121 - "EVENT_REFNO_V"[VARCHAR2,20] 122 - "EVENT_REFNO_V"[VARCHAR2,20] 123 - (#keys=1) "TT"."LOGGED_BY_N"[NUMBER,22], "B"."GROUP_CODE_N"[NUMBER,22], "B"."USER_NAME_V"[VARCHAR2,120], "TT"."DOCKET_NUMBER_N"[NUMBER,22], "TTI"."NOTES_V"[VARCHAR2,1000], "TT"."ANSWER_V"[VARCHAR2,4000], "TT"."TICKET_REGN_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."STATUS_V"[VARCHAR2,1], "TT"."CATEGORY_ID_V"[VARCHAR2,8], "TT"."SUBCATEGORY_ID_V"[VARCHAR2,8], "TT"."TICKET_TYPE_V"[VARCHAR2,1], "TT"."QUESTION_V"[VARCHAR2,4000], "TT"."TT_SOURCE_V"[VARCHAR2,5], "TT"."TICKET_RESP_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11] 124 - "B"."USER_CODE_N"[NUMBER,22], "B"."USER_NAME_V"[VARCHAR2,120], "B"."GROUP_CODE_N"[NUMBER,22] 125 - (#keys=1) "TT"."DOCKET_NUMBER_N"[NUMBER,22], "TTI"."NOTES_V"[VARCHAR2,1000], "TT"."ANSWER_V"[VARCHAR2,4000], "TT"."TICKET_REGN_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."STATUS_V"[VARCHAR2,1], "TT"."CATEGORY_ID_V"[VARCHAR2,8], "TT"."SUBCATEGORY_ID_V"[VARCHAR2,8], "TT"."TICKET_TYPE_V"[VARCHAR2,1], "TT"."LOGGED_BY_N"[NUMBER,22], "TT"."TT_SOURCE_V"[VARCHAR2,5], "TT"."TICKET_RESP_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."QUESTION_V"[VARCHAR2,4000] 126 - "TTI"."INCIDENT_NUMBER_N"[NUMBER,22], "TTI"."NOTES_V"[VARCHAR2,1000] 127 - "TT"."DOCKET_NUMBER_N"[NUMBER,22], "TT"."TICKET_REGN_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."STATUS_V"[VARCHAR2,1], "TT"."CATEGORY_ID_V"[VARCHAR2,8], "TT"."SUBCATEGORY_ID_V"[VARCHAR2,8], "TT"."TICKET_TYPE_V"[VARCHAR2,1], "TT"."LOGGED_BY_N"[NUMBER,22], "TT"."TT_SOURCE_V"[VARCHAR2,5], "TT"."TICKET_RESP_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."QUESTION_V"[VARCHAR2,4000], "TT"."ANSWER_V"[VARCHAR2,4000] 128 - "TT"."DOCKET_NUMBER_N"[NUMBER,22], "TT"."TICKET_REGN_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."STATUS_V"[VARCHAR2,1], "TT"."CATEGORY_ID_V"[VARCHAR2,8], "TT"."SUBCATEGORY_ID_V"[VARCHAR2,8], "TT"."TICKET_TYPE_V"[VARCHAR2,1], "TT"."LOGGED_BY_N"[NUMBER,22], "TT"."TT_SOURCE_V"[VARCHAR2,5], "TT"."TICKET_RESP_DT_D"[TIMESTAMP WITH LOCAL TIME ZONE,11], "TT"."QUESTION_V"[VARCHAR2,4000], "TT"."ANSWER_V"[VARCHAR2,4000] 3- Using SQL Profile -------------------- Plan hash value: 1051475532 ------------------------------------------------------------------------------------------------------------------------------------------------ | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | Pstart| Pstop | ------------------------------------------------------------------------------------------------------------------------------------------------ | 0 | SELECT STATEMENT | | 82026 | 36M| | 2893K (1)| 00:03:47 | | | | 1 | UNION-ALL | | | | | | | | | |* 2 | TABLE ACCESS BY INDEX ROWID | TT_CATEGORY_MASTER | 1 | 37 | | 2 (0)| 00:00:01 | | | |* 3 | INDEX UNIQUE SCAN | TT_CATEGORY_CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 4 | TABLE ACCESS BY INDEX ROWID | TT_CATEGORY_MASTER | 1 | 18 | | 2 (0)| 00:00:01 | | | |* 5 | INDEX UNIQUE SCAN | TT_CATEGORY_CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 6 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 14 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 7 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 8 | TABLE ACCESS BY INDEX ROWID | TT_CATEGORY_MASTER | 1 | 28 | | 2 (0)| 00:00:01 | | | |* 9 | INDEX UNIQUE SCAN | TT_CATEGORY_CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 10 | NESTED LOOPS | | 1 | 21 | | 5 (0)| 00:00:01 | | | | 11 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 12 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 13 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 10 | | 3 (0)| 00:00:01 | | | |* 14 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | | 15 | NESTED LOOPS | | 1 | 24 | | 5 (0)| 00:00:01 | | | | 16 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 17 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 18 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 13 | | 3 (0)| 00:00:01 | | | |* 19 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | | 20 | NESTED LOOPS | | 1 | 20 | | 5 (0)| 00:00:01 | | | | 21 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 22 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 23 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 9 | | 3 (0)| 00:00:01 | | | |* 24 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | | 25 | NESTED LOOPS | | 1 | 55 | | 6 (0)| 00:00:01 | | | | 26 | NESTED LOOPS | | 1 | 55 | | 6 (0)| 00:00:01 | | | | 27 | NESTED LOOPS | | 1 | 25 | | 5 (0)| 00:00:01 | | | | 28 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 29 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 30 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 14 | | 3 (0)| 00:00:01 | | | |* 31 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | |* 32 | INDEX UNIQUE SCAN | SUBS_SUB_CATEGORY#CODE$PK | 1 | | | 0 (0)| 00:00:01 | | | | 33 | TABLE ACCESS BY INDEX ROWID | CB_SUBSCRIBER_SUB_CATEGORY | 1 | 30 | | 1 (0)| 00:00:01 | | | | 34 | NESTED LOOPS | | 1 | 18 | | 5 (0)| 00:00:01 | | | | 35 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 36 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 37 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 7 | | 3 (0)| 00:00:01 | | | |* 38 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | | 39 | NESTED LOOPS | | 1 | 20 | | 5 (0)| 00:00:01 | | | | 40 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 41 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 42 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 9 | | 3 (0)| 00:00:01 | | | |* 43 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | |* 44 | TABLE ACCESS BY INDEX ROWID | TT_CATEGORY_MASTER | 1 | 39 | | 2 (0)| 00:00:01 | | | |* 45 | INDEX UNIQUE SCAN | TT_CATEGORY_CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 46 | TABLE ACCESS BY INDEX ROWID | CB_USERS | 1 | 18 | | 2 (0)| 00:00:01 | | | |* 47 | INDEX UNIQUE SCAN | CB_USERS#CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 48 | NESTED LOOPS | | 1 | 31 | | 3 (0)| 00:00:01 | | | |* 49 | TABLE ACCESS BY INDEX ROWID | TT_TICKET_ADDNL_INFO | 1 | 7 | | 2 (0)| 00:00:01 | | | |* 50 | INDEX UNIQUE SCAN | TT_TICKET_ADDNL_INFO_PK | 1 | | | 1 (0)| 00:00:01 | | | | 51 | TABLE ACCESS BY INDEX ROWID | CB_FAULT_TYPES | 1 | 24 | | 1 (0)| 00:00:01 | | | |* 52 | INDEX UNIQUE SCAN | CB_FAULT_TYPES#U$1 | 1 | | | 0 (0)| 00:00:01 | | | | 53 | HASH UNIQUE | | 43761 | 10M| 11M| 1521K (1)| 00:01:59 | | | |* 54 | HASH JOIN | | 43761 | 10M| | 130K (1)| 00:00:11 | | | | 55 | TABLE ACCESS FULL | WF_WRKFLWMGR | 95 | 3135 | | 6 (0)| 00:00:01 | | | |* 56 | HASH JOIN | | 43761 | 9188K| | 130K (1)| 00:00:11 | | | | 57 | TABLE ACCESS FULL | CB_USER_GROUP | 92 | 1840 | | 4 (0)| 00:00:01 | | | |* 58 | HASH JOIN | | 43761 | 8333K| | 130K (1)| 00:00:11 | | | | 59 | TABLE ACCESS FULL | CB_USERS | 1511 | 33242 | | 19 (0)| 00:00:01 | | | | 60 | NESTED LOOPS | | 43773 | 7395K| | 130K (1)| 00:00:11 | | | | 61 | NESTED LOOPS | | 43773 | 7395K| | 130K (1)| 00:00:11 | | | | 62 | PARTITION RANGE ALL | | 43773 | 1453K| | 86981 (1)| 00:00:07 | 1 |1048575| | 63 | TABLE ACCESS FULL | WF_WORKFLOW | 43773 | 1453K| | 86981 (1)| 00:00:07 | 1 |1048575| |* 64 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 0 (0)| 00:00:01 | | | | 65 | TABLE ACCESS BY GLOBAL INDEX ROWID| TT_TICKETINFO | 1 | 139 | | 1 (0)| 00:00:01 | ROWID | ROWID | |* 66 | TABLE ACCESS BY INDEX ROWID | TT_CATEGORY_MASTER | 1 | 37 | | 2 (0)| 00:00:01 | | | |* 67 | INDEX UNIQUE SCAN | TT_CATEGORY_CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 68 | TABLE ACCESS BY INDEX ROWID | TT_CATEGORY_MASTER | 1 | 18 | | 2 (0)| 00:00:01 | | | |* 69 | INDEX UNIQUE SCAN | TT_CATEGORY_CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 70 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 14 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 71 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 72 | TABLE ACCESS BY INDEX ROWID | TT_CATEGORY_MASTER | 1 | 28 | | 2 (0)| 00:00:01 | | | |* 73 | INDEX UNIQUE SCAN | TT_CATEGORY_CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 74 | NESTED LOOPS | | 1 | 21 | | 5 (0)| 00:00:01 | | | | 75 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 76 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 77 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 10 | | 3 (0)| 00:00:01 | | | |* 78 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | | 79 | NESTED LOOPS | | 1 | 24 | | 5 (0)| 00:00:01 | | | | 80 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 81 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 82 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 13 | | 3 (0)| 00:00:01 | | | |* 83 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | | 84 | NESTED LOOPS | | 1 | 20 | | 5 (0)| 00:00:01 | | | | 85 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 86 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 87 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 9 | | 3 (0)| 00:00:01 | | | |* 88 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | | 89 | NESTED LOOPS | | 1 | 55 | | 6 (0)| 00:00:01 | | | | 90 | NESTED LOOPS | | 1 | 55 | | 6 (0)| 00:00:01 | | | | 91 | NESTED LOOPS | | 1 | 25 | | 5 (0)| 00:00:01 | | | | 92 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |* 93 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 94 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 14 | | 3 (0)| 00:00:01 | | | |* 95 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | |* 96 | INDEX UNIQUE SCAN | SUBS_SUB_CATEGORY#CODE$PK | 1 | | | 0 (0)| 00:00:01 | | | | 97 | TABLE ACCESS BY INDEX ROWID | CB_SUBSCRIBER_SUB_CATEGORY | 1 | 30 | | 1 (0)| 00:00:01 | | | | 98 | NESTED LOOPS | | 1 | 18 | | 5 (0)| 00:00:01 | | | | 99 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |*100 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 101 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 7 | | 3 (0)| 00:00:01 | | | |*102 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | | 103 | NESTED LOOPS | | 1 | 20 | | 5 (0)| 00:00:01 | | | | 104 | TABLE ACCESS BY GLOBAL INDEX ROWID | TT_TICKETINFO | 1 | 11 | | 2 (0)| 00:00:01 | ROWID | ROWID | |*105 | INDEX UNIQUE SCAN | TTINFO_DKTNUM_PK | 1 | | | 1 (0)| 00:00:01 | | | | 106 | TABLE ACCESS BY INDEX ROWID BATCHED | GSM_SERVICE_MAST | 1 | 9 | | 3 (0)| 00:00:01 | | | |*107 | INDEX RANGE SCAN | GSM_SERV_MAST#TMP#TO_MOBL_V | 1 | | | 2 (0)| 00:00:01 | | | |*108 | TABLE ACCESS BY INDEX ROWID | TT_CATEGORY_MASTER | 1 | 39 | | 2 (0)| 00:00:01 | | | |*109 | INDEX UNIQUE SCAN | TT_CATEGORY_CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 110 | TABLE ACCESS BY INDEX ROWID | CB_USERS | 1 | 18 | | 2 (0)| 00:00:01 | | | |*111 | INDEX UNIQUE SCAN | CB_USERS#CODE$PK | 1 | | | 1 (0)| 00:00:01 | | | | 112 | NESTED LOOPS | | 1 | 31 | | 3 (0)| 00:00:01 | | | |*113 | TABLE ACCESS BY INDEX ROWID | TT_TICKET_ADDNL_INFO | 1 | 7 | | 2 (0)| 00:00:01 | | | |*114 | INDEX UNIQUE SCAN | TT_TICKET_ADDNL_INFO_PK | 1 | | | 1 (0)| 00:00:01 | | | | 115 | TABLE ACCESS BY INDEX ROWID | CB_FAULT_TYPES | 1 | 24 | | 1 (0)| 00:00:01 | | | |*116 | INDEX UNIQUE SCAN | CB_FAULT_TYPES#U$1 | 1 | | | 0 (0)| 00:00:01 | | | | 117 | HASH UNIQUE | | 38265 | 8856K| 9440K| 1371K (1)| 00:01:48 | | | |*118 | HASH JOIN | | 38265 | 8856K| | 179K (1)| 00:00:14 | | | | 119 | TABLE ACCESS FULL | CB_USER_GROUP | 92 | 1840 | | 4 (0)| 00:00:01 | | | |*120 | HASH JOIN | | 38265 | 8108K| 6736K| 179K (1)| 00:00:14 | | | |*121 | HASH JOIN RIGHT ANTI NA | | 38265 | 6277K| | 172K (1)| 00:00:14 | | | | 122 | PARTITION RANGE ALL | | 43773 | 299K| | 86981 (1)| 00:00:07 | 1 |1048575| | 123 | TABLE ACCESS FULL | WF_WORKFLOW | 43773 | 299K| | 86981 (1)| 00:00:07 | 1 |1048575| |*124 | HASH JOIN | | 621K| 95M| | 85935 (1)| 00:00:07 | | | | 125 | TABLE ACCESS FULL | CB_USERS | 1511 | 33242 | | 19 (0)| 00:00:01 | | | | 126 | PARTITION RANGE ALL | | 621K| 82M| | 85914 (1)| 00:00:07 | 1 |1048575| | 127 | TABLE ACCESS FULL | TT_TICKETINFO | 621K| 82M| | 85914 (1)| 00:00:07 | 1 |1048575| | 128 | TABLE ACCESS FULL | TT_TICKETINCIDENT | 1327K| 62M| | 2673 (1)| 00:00:01 | | | ------------------------------------------------------------------------------------------------------------------------------------------------ Query Block Name / Object Alias (identified by operation id): ------------------------------------------------------------- 1 - SET$1 2 - SEL$2 / A3@SEL$2 3 - SEL$2 / A3@SEL$2 4 - SEL$3 / A2@SEL$3 5 - SEL$3 / A2@SEL$3 6 - SEL$4 / T1@SEL$4 7 - SEL$4 / T1@SEL$4 8 - SEL$5 / A1@SEL$5 9 - SEL$5 / A1@SEL$5 10 - SEL$6 11 - SEL$6 / TTI@SEL$6 12 - SEL$6 / TTI@SEL$6 13 - SEL$6 / D@SEL$6 14 - SEL$6 / D@SEL$6 15 - SEL$7 16 - SEL$7 / TTI@SEL$7 17 - SEL$7 / TTI@SEL$7 18 - SEL$7 / D@SEL$7 19 - SEL$7 / D@SEL$7 20 - SEL$8 21 - SEL$8 / TTI@SEL$8 22 - SEL$8 / TTI@SEL$8 23 - SEL$8 / D@SEL$8 24 - SEL$8 / D@SEL$8 25 - SEL$9 28 - SEL$9 / TTI@SEL$9 29 - SEL$9 / TTI@SEL$9 30 - SEL$9 / D@SEL$9 31 - SEL$9 / D@SEL$9 32 - SEL$9 / G@SEL$9 33 - SEL$9 / G@SEL$9 34 - SEL$10 35 - SEL$10 / TTI@SEL$10 36 - SEL$10 / TTI@SEL$10 37 - SEL$10 / D@SEL$10 38 - SEL$10 / D@SEL$10 39 - SEL$11 40 - SEL$11 / TTI@SEL$11 41 - SEL$11 / TTI@SEL$11 42 - SEL$11 / D@SEL$11 43 - SEL$11 / D@SEL$11 44 - SEL$12 / CM@SEL$12 45 - SEL$12 / CM@SEL$12 46 - SEL$13 / F@SEL$13 47 - SEL$13 / F@SEL$13 48 - SEL$14 49 - SEL$14 / TAI@SEL$14 50 - SEL$14 / TAI@SEL$14 51 - SEL$14 / CFT@SEL$14 52 - SEL$14 / CFT@SEL$14 53 - SEL$1 55 - SEL$1 / WM@SEL$1 57 - SEL$1 / E@SEL$1 59 - SEL$1 / CU@SEL$1 63 - SEL$1 / X@SEL$1 64 - SEL$1 / TT@SEL$1 65 - SEL$1 / TT@SEL$1 66 - SEL$16 / A3@SEL$16 67 - SEL$16 / A3@SEL$16 68 - SEL$17 / A2@SEL$17 69 - SEL$17 / A2@SEL$17 70 - SEL$18 / T1@SEL$18 71 - SEL$18 / T1@SEL$18 72 - SEL$19 / A1@SEL$19 73 - SEL$19 / A1@SEL$19 74 - SEL$20 75 - SEL$20 / TTI@SEL$20 76 - SEL$20 / TTI@SEL$20 77 - SEL$20 / D@SEL$20 78 - SEL$20 / D@SEL$20 79 - SEL$21 80 - SEL$21 / TTI@SEL$21 81 - SEL$21 / TTI@SEL$21 82 - SEL$21 / D@SEL$21 83 - SEL$21 / D@SEL$21 84 - SEL$22 85 - SEL$22 / TTI@SEL$22 86 - SEL$22 / TTI@SEL$22 87 - SEL$22 / D@SEL$22 88 - SEL$22 / D@SEL$22 89 - SEL$23 92 - SEL$23 / TTI@SEL$23 93 - SEL$23 / TTI@SEL$23 94 - SEL$23 / D@SEL$23 95 - SEL$23 / D@SEL$23 96 - SEL$23 / G@SEL$23 97 - SEL$23 / G@SEL$23 98 - SEL$24 99 - SEL$24 / TTI@SEL$24 100 - SEL$24 / TTI@SEL$24 101 - SEL$24 / D@SEL$24 102 - SEL$24 / D@SEL$24 103 - SEL$25 104 - SEL$25 / TTI@SEL$25 105 - SEL$25 / TTI@SEL$25 106 - SEL$25 / D@SEL$25 107 - SEL$25 / D@SEL$25 108 - SEL$26 / CM@SEL$26 109 - SEL$26 / CM@SEL$26 110 - SEL$27 / F@SEL$27 111 - SEL$27 / F@SEL$27 112 - SEL$28 113 - SEL$28 / TAI@SEL$28 114 - SEL$28 / TAI@SEL$28 115 - SEL$28 / CFT@SEL$28 116 - SEL$28 / CFT@SEL$28 117 - SEL$653BBCD7 119 - SEL$653BBCD7 / C@SEL$15 123 - SEL$653BBCD7 / WF_WORKFLOW@SEL$29 125 - SEL$653BBCD7 / B@SEL$15 127 - SEL$653BBCD7 / TT@SEL$15 128 - SEL$653BBCD7 / TTI@SEL$15 Predicate Information (identified by operation id): --------------------------------------------------- 2 - filter("A3"."PARENT_CATEGORY_CODE_V"<>'0') 3 - access("A3"."CATEGORY_CODE_V"= (SELECT "A2"."PARENT_CATEGORY_CODE_V" FROM "CLM_TT"."TT_CATEGORY_MASTER" "A2" WHERE "A2"."CATEGORY_CODE_V"= (SELECT "T1"."SUBCATEGORY_ID_V" FROM "CLM_TT"."TT_TICKETINFO" "T1" WHERE "T1"."DOCKET_NUMBER_N"=:B1))) 5 - access("A2"."CATEGORY_CODE_V"= (SELECT "T1"."SUBCATEGORY_ID_V" FROM "CLM_TT"."TT_TICKETINFO" "T1" WHERE