eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIX_CALL_LOAD_PKG dependencies on JTF_IH_MEDIA_ITEM_LC_SEGS

Line 479: FROM JTF_IH_MEDIA_ITEM_LC_SEGS SEGS, JTF_IH_MEDIA_ITM_LC_SEG_TYS TYPES

475: BEGIN
476:
477: SELECT max(milcs_id), max(end_date_time)
478: INTO l_max_milcs_id, p_max_talk_end_date_time
479: FROM JTF_IH_MEDIA_ITEM_LC_SEGS SEGS, JTF_IH_MEDIA_ITM_LC_SEG_TYS TYPES
480: WHERE media_id = p_media_id
481: AND resource_id = p_resource_id
482: AND SEGS.milcs_type_id = TYPES.milcs_type_id
483: AND milcs_code = 'WITH_AGENT';

Line 513: FROM JTF_IH_MEDIA_ITEM_LC_SEGS SEGS, JTF_IH_MEDIA_ITM_LC_SEG_TYS TYPES

509: BEGIN
510:
511: SELECT min(resource_id)
512: INTO p_earliest_agent
513: FROM JTF_IH_MEDIA_ITEM_LC_SEGS SEGS, JTF_IH_MEDIA_ITM_LC_SEG_TYS TYPES
514: WHERE SEGS.media_id = p_media_id
515: AND SEGS.milcs_type_id = TYPES.milcs_type_id
516: AND TYPES.milcs_code = 'WITH_AGENT'
517: AND SEGS.start_date_time = (select min(start_date_time)

Line 518: FROM JTF_IH_MEDIA_ITEM_LC_SEGS SEGS,

514: WHERE SEGS.media_id = p_media_id
515: AND SEGS.milcs_type_id = TYPES.milcs_type_id
516: AND TYPES.milcs_code = 'WITH_AGENT'
517: AND SEGS.start_date_time = (select min(start_date_time)
518: FROM JTF_IH_MEDIA_ITEM_LC_SEGS SEGS,
519: JTF_IH_MEDIA_ITM_LC_SEG_TYS TYPES
520: WHERE SEGS.media_id = p_media_id
521: AND SEGS.milcs_type_id = TYPES.milcs_type_id
522: AND TYPES.milcs_code = 'WITH_AGENT'

Line 534: FROM JTF_IH_MEDIA_ITEM_LC_SEGS SEGS,

530: END IF;
531:
532: SELECT min(start_date_time), max(end_date_time)
533: INTO p_min_talk_start, p_max_talk_end
534: FROM JTF_IH_MEDIA_ITEM_LC_SEGS SEGS,
535: JTF_IH_MEDIA_ITM_LC_SEG_TYS TYPES
536: WHERE SEGS.media_id = p_media_id
537: AND SEGS.milcs_type_id = TYPES.milcs_type_id
538: AND TYPES.milcs_code = 'WITH_AGENT';

Line 1117: --JTF_IH_MEDIA_ITEM_LC_SEGS AGENT_SEGS

1113: ORDER BY decode(AGENT_SEGS.MILCS_TYPE_ID,5,1000,AGENT_SEGS.MILCS_TYPE_ID) DESC NULLS LAST,
1114: AGENT_SEGS.END_DATE_TIME DESC NULLS LAST
1115: ) MAX_AGENT_TALK_END
1116: --FROM (JTF_IH_MEDIA_ITEMS MED LEFT OUTER JOIN
1117: --JTF_IH_MEDIA_ITEM_LC_SEGS AGENT_SEGS
1118: --ON MED.media_id = AGENT_SEGS.media_id
1119: --)
1120: --LEFT OUTER JOIN
1121: --JTF_IH_MEDIA_ITM_LC_SEG_TYS SEGTYPES

Line 1126: from jtf_ih_media_item_lc_segs

1122: --ON SEGS.MILCS_TYPE_ID = SEGTYPES.MILCS_TYPE_ID
1123: FROM
1124: bix_medias_for_worker MED,
1125: (select *
1126: from jtf_ih_media_item_lc_segs
1127: where milcs_type_id = 1) IVR_SEGS,
1128: (select *
1129: from jtf_ih_media_item_lc_segs
1130: where milcs_type_id = 4) ROUTE_SEGS,

Line 1129: from jtf_ih_media_item_lc_segs

1125: (select *
1126: from jtf_ih_media_item_lc_segs
1127: where milcs_type_id = 1) IVR_SEGS,
1128: (select *
1129: from jtf_ih_media_item_lc_segs
1130: where milcs_type_id = 4) ROUTE_SEGS,
1131: (select *
1132: from jtf_ih_media_item_lc_segs
1133: where milcs_type_id = 3) QUEUE_SEGS,

Line 1132: from jtf_ih_media_item_lc_segs

1128: (select *
1129: from jtf_ih_media_item_lc_segs
1130: where milcs_type_id = 4) ROUTE_SEGS,
1131: (select *
1132: from jtf_ih_media_item_lc_segs
1133: where milcs_type_id = 3) QUEUE_SEGS,
1134: (select *
1135: from jtf_ih_media_item_lc_segs
1136: where milcs_type_id = 5) AGENT_SEGS

Line 1135: from jtf_ih_media_item_lc_segs

1131: (select *
1132: from jtf_ih_media_item_lc_segs
1133: where milcs_type_id = 3) QUEUE_SEGS,
1134: (select *
1135: from jtf_ih_media_item_lc_segs
1136: where milcs_type_id = 5) AGENT_SEGS
1137: WHERE MED.worker_number = p_worker_no
1138: AND MED.status = 'IN PROCESS'
1139: AND med.media_id = ROUTE_SEGS.media_id (+)

Line 1256: TYPE L_MILCS_ID_t IS TABLE OF jtf_ih_media_item_lc_segs.MILCS_ID%TYPE INDEX BY BINARY_INTEGER;

1252: TYPE L_MEDIA_END_TIME_t IS TABLE OF jtf_ih_media_items.END_DATE_TIME%TYPE INDEX BY BINARY_INTEGER;
1253: TYPE L_ABANDON_FLAG_t IS TABLE OF jtf_ih_media_items.MEDIA_ABANDON_FLAG%TYPE INDEX BY BINARY_INTEGER;
1254: TYPE L_TRANSFER_FLAG_t IS TABLE OF jtf_ih_media_items.MEDIA_TRANSFERRED_FLAG%TYPE INDEX BY BINARY_INTEGER;
1255: TYPE L_SOURCE_ITEM_ID_t IS TABLE OF jtf_ih_media_items.SOURCE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
1256: TYPE L_MILCS_ID_t IS TABLE OF jtf_ih_media_item_lc_segs.MILCS_ID%TYPE INDEX BY BINARY_INTEGER;
1257: TYPE L_RESOURCE_ID_t IS TABLE OF jtf_ih_media_item_lc_segs.RESOURCE_ID%TYPE INDEX BY BINARY_INTEGER;
1258: TYPE L_SEGMENT_TYPE_t IS TABLE OF jtf_ih_media_itm_lc_seg_tys.MILCS_CODE%TYPE INDEX BY BINARY_INTEGER;
1259: TYPE L_SEGMENT_START_TIME_t IS TABLE OF jtf_ih_media_item_lc_segs.START_DATE_TIME%TYPE INDEX BY BINARY_INTEGER;
1260: TYPE L_SEGMENT_END_TIME_t IS TABLE OF jtf_ih_media_item_lc_segs.END_DATE_TIME%TYPE INDEX BY BINARY_INTEGER;

Line 1257: TYPE L_RESOURCE_ID_t IS TABLE OF jtf_ih_media_item_lc_segs.RESOURCE_ID%TYPE INDEX BY BINARY_INTEGER;

1253: TYPE L_ABANDON_FLAG_t IS TABLE OF jtf_ih_media_items.MEDIA_ABANDON_FLAG%TYPE INDEX BY BINARY_INTEGER;
1254: TYPE L_TRANSFER_FLAG_t IS TABLE OF jtf_ih_media_items.MEDIA_TRANSFERRED_FLAG%TYPE INDEX BY BINARY_INTEGER;
1255: TYPE L_SOURCE_ITEM_ID_t IS TABLE OF jtf_ih_media_items.SOURCE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
1256: TYPE L_MILCS_ID_t IS TABLE OF jtf_ih_media_item_lc_segs.MILCS_ID%TYPE INDEX BY BINARY_INTEGER;
1257: TYPE L_RESOURCE_ID_t IS TABLE OF jtf_ih_media_item_lc_segs.RESOURCE_ID%TYPE INDEX BY BINARY_INTEGER;
1258: TYPE L_SEGMENT_TYPE_t IS TABLE OF jtf_ih_media_itm_lc_seg_tys.MILCS_CODE%TYPE INDEX BY BINARY_INTEGER;
1259: TYPE L_SEGMENT_START_TIME_t IS TABLE OF jtf_ih_media_item_lc_segs.START_DATE_TIME%TYPE INDEX BY BINARY_INTEGER;
1260: TYPE L_SEGMENT_END_TIME_t IS TABLE OF jtf_ih_media_item_lc_segs.END_DATE_TIME%TYPE INDEX BY BINARY_INTEGER;
1261: --

Line 1259: TYPE L_SEGMENT_START_TIME_t IS TABLE OF jtf_ih_media_item_lc_segs.START_DATE_TIME%TYPE INDEX BY BINARY_INTEGER;

1255: TYPE L_SOURCE_ITEM_ID_t IS TABLE OF jtf_ih_media_items.SOURCE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
1256: TYPE L_MILCS_ID_t IS TABLE OF jtf_ih_media_item_lc_segs.MILCS_ID%TYPE INDEX BY BINARY_INTEGER;
1257: TYPE L_RESOURCE_ID_t IS TABLE OF jtf_ih_media_item_lc_segs.RESOURCE_ID%TYPE INDEX BY BINARY_INTEGER;
1258: TYPE L_SEGMENT_TYPE_t IS TABLE OF jtf_ih_media_itm_lc_seg_tys.MILCS_CODE%TYPE INDEX BY BINARY_INTEGER;
1259: TYPE L_SEGMENT_START_TIME_t IS TABLE OF jtf_ih_media_item_lc_segs.START_DATE_TIME%TYPE INDEX BY BINARY_INTEGER;
1260: TYPE L_SEGMENT_END_TIME_t IS TABLE OF jtf_ih_media_item_lc_segs.END_DATE_TIME%TYPE INDEX BY BINARY_INTEGER;
1261: --
1262: --Target Table Datatype Declarations
1263: --

Line 1260: TYPE L_SEGMENT_END_TIME_t IS TABLE OF jtf_ih_media_item_lc_segs.END_DATE_TIME%TYPE INDEX BY BINARY_INTEGER;

1256: TYPE L_MILCS_ID_t IS TABLE OF jtf_ih_media_item_lc_segs.MILCS_ID%TYPE INDEX BY BINARY_INTEGER;
1257: TYPE L_RESOURCE_ID_t IS TABLE OF jtf_ih_media_item_lc_segs.RESOURCE_ID%TYPE INDEX BY BINARY_INTEGER;
1258: TYPE L_SEGMENT_TYPE_t IS TABLE OF jtf_ih_media_itm_lc_seg_tys.MILCS_CODE%TYPE INDEX BY BINARY_INTEGER;
1259: TYPE L_SEGMENT_START_TIME_t IS TABLE OF jtf_ih_media_item_lc_segs.START_DATE_TIME%TYPE INDEX BY BINARY_INTEGER;
1260: TYPE L_SEGMENT_END_TIME_t IS TABLE OF jtf_ih_media_item_lc_segs.END_DATE_TIME%TYPE INDEX BY BINARY_INTEGER;
1261: --
1262: --Target Table Datatype Declarations
1263: --
1264: TYPE L_TIME_ID_T IS TABLE OF BIX_CALL_DETAILS_F.TIME_ID%TYPE INDEX BY BINARY_INTEGER;