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