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_UPDATE_PKG dependencies on JTF_IH_MEDIA_ITEM_LC_SEGS

Line 472: FROM JTF_IH_MEDIA_ITEM_LC_SEGS SEGS, JTF_IH_MEDIA_ITM_LC_SEG_TYS TYPES

468: BEGIN
469:
470: SELECT max(milcs_id), max(end_date_time)
471: INTO l_max_milcs_id, p_max_talk_end_date_time
472: FROM JTF_IH_MEDIA_ITEM_LC_SEGS SEGS, JTF_IH_MEDIA_ITM_LC_SEG_TYS TYPES
473: WHERE media_id = p_media_id
474: AND resource_id = p_resource_id
475: AND SEGS.milcs_type_id = TYPES.milcs_type_id
476: AND milcs_code = 'WITH_AGENT';

Line 506: FROM JTF_IH_MEDIA_ITEM_LC_SEGS SEGS, JTF_IH_MEDIA_ITM_LC_SEG_TYS TYPES

502: BEGIN
503:
504: SELECT min(resource_id)
505: INTO p_earliest_agent
506: FROM JTF_IH_MEDIA_ITEM_LC_SEGS SEGS, JTF_IH_MEDIA_ITM_LC_SEG_TYS TYPES
507: WHERE SEGS.media_id = p_media_id
508: AND SEGS.milcs_type_id = TYPES.milcs_type_id
509: AND TYPES.milcs_code = 'WITH_AGENT'
510: AND SEGS.start_date_time = (select min(start_date_time)

Line 511: FROM JTF_IH_MEDIA_ITEM_LC_SEGS SEGS,

507: WHERE SEGS.media_id = p_media_id
508: AND SEGS.milcs_type_id = TYPES.milcs_type_id
509: AND TYPES.milcs_code = 'WITH_AGENT'
510: AND SEGS.start_date_time = (select min(start_date_time)
511: FROM JTF_IH_MEDIA_ITEM_LC_SEGS SEGS,
512: JTF_IH_MEDIA_ITM_LC_SEG_TYS TYPES
513: WHERE SEGS.media_id = p_media_id
514: AND SEGS.milcs_type_id = TYPES.milcs_type_id
515: AND TYPES.milcs_code = 'WITH_AGENT'

Line 527: FROM JTF_IH_MEDIA_ITEM_LC_SEGS SEGS,

523: END IF;
524:
525: SELECT min(start_date_time), max(end_date_time)
526: INTO p_min_talk_start, p_max_talk_end
527: FROM JTF_IH_MEDIA_ITEM_LC_SEGS SEGS,
528: JTF_IH_MEDIA_ITM_LC_SEG_TYS TYPES
529: WHERE SEGS.media_id = p_media_id
530: AND SEGS.milcs_type_id = TYPES.milcs_type_id
531: AND TYPES.milcs_code = 'WITH_AGENT';

Line 1109: --JTF_IH_MEDIA_ITEM_LC_SEGS AGENT_SEGS

1105: ORDER BY decode(AGENT_SEGS.MILCS_TYPE_ID,5,1000,AGENT_SEGS.MILCS_TYPE_ID) DESC NULLS LAST,
1106: AGENT_SEGS.END_DATE_TIME DESC NULLS LAST
1107: ) MAX_AGENT_TALK_END
1108: --FROM (JTF_IH_MEDIA_ITEMS MED LEFT OUTER JOIN
1109: --JTF_IH_MEDIA_ITEM_LC_SEGS AGENT_SEGS
1110: --ON MED.media_id = AGENT_SEGS.media_id
1111: --)
1112: --LEFT OUTER JOIN
1113: --JTF_IH_MEDIA_ITM_LC_SEG_TYS SEGTYPES

Line 1118: from jtf_ih_media_item_lc_segs

1114: --ON SEGS.MILCS_TYPE_ID = SEGTYPES.MILCS_TYPE_ID
1115: FROM
1116: bix_medias_for_worker MED,
1117: (select *
1118: from jtf_ih_media_item_lc_segs
1119: where milcs_type_id = 1) IVR_SEGS,
1120: (select *
1121: from jtf_ih_media_item_lc_segs
1122: where milcs_type_id = 4) ROUTE_SEGS,

Line 1121: from jtf_ih_media_item_lc_segs

1117: (select *
1118: from jtf_ih_media_item_lc_segs
1119: where milcs_type_id = 1) IVR_SEGS,
1120: (select *
1121: from jtf_ih_media_item_lc_segs
1122: where milcs_type_id = 4) ROUTE_SEGS,
1123: (select *
1124: from jtf_ih_media_item_lc_segs
1125: where milcs_type_id = 3) QUEUE_SEGS,

Line 1124: from jtf_ih_media_item_lc_segs

1120: (select *
1121: from jtf_ih_media_item_lc_segs
1122: where milcs_type_id = 4) ROUTE_SEGS,
1123: (select *
1124: from jtf_ih_media_item_lc_segs
1125: where milcs_type_id = 3) QUEUE_SEGS,
1126: (select *
1127: from jtf_ih_media_item_lc_segs
1128: where milcs_type_id = 5) AGENT_SEGS

Line 1127: from jtf_ih_media_item_lc_segs

1123: (select *
1124: from jtf_ih_media_item_lc_segs
1125: where milcs_type_id = 3) QUEUE_SEGS,
1126: (select *
1127: from jtf_ih_media_item_lc_segs
1128: where milcs_type_id = 5) AGENT_SEGS
1129: WHERE MED.worker_number = p_worker_no
1130: AND MED.status = 'IN PROCESS'
1131: --WHERE MED.last_update_date BETWEEN g_collect_start_date

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

1336: TYPE L_MEDIA_END_TIME_t IS TABLE OF jtf_ih_media_items.END_DATE_TIME%TYPE INDEX BY BINARY_INTEGER;
1337: TYPE L_ABANDON_FLAG_t IS TABLE OF jtf_ih_media_items.MEDIA_ABANDON_FLAG%TYPE INDEX BY BINARY_INTEGER;
1338: TYPE L_TRANSFER_FLAG_t IS TABLE OF jtf_ih_media_items.MEDIA_TRANSFERRED_FLAG%TYPE INDEX BY BINARY_INTEGER;
1339: TYPE L_SOURCE_ITEM_ID_t IS TABLE OF jtf_ih_media_items.SOURCE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
1340: TYPE L_MILCS_ID_t IS TABLE OF jtf_ih_media_item_lc_segs.MILCS_ID%TYPE INDEX BY BINARY_INTEGER;
1341: TYPE L_RESOURCE_ID_t IS TABLE OF jtf_ih_media_item_lc_segs.RESOURCE_ID%TYPE INDEX BY BINARY_INTEGER;
1342: TYPE L_SEGMENT_TYPE_t IS TABLE OF jtf_ih_media_itm_lc_seg_tys.MILCS_CODE%TYPE INDEX BY BINARY_INTEGER;
1343: TYPE L_SEGMENT_START_TIME_t IS TABLE OF jtf_ih_media_item_lc_segs.START_DATE_TIME%TYPE INDEX BY BINARY_INTEGER;
1344: TYPE L_SEGMENT_END_TIME_t IS TABLE OF jtf_ih_media_item_lc_segs.END_DATE_TIME%TYPE INDEX BY BINARY_INTEGER;

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

1337: TYPE L_ABANDON_FLAG_t IS TABLE OF jtf_ih_media_items.MEDIA_ABANDON_FLAG%TYPE INDEX BY BINARY_INTEGER;
1338: TYPE L_TRANSFER_FLAG_t IS TABLE OF jtf_ih_media_items.MEDIA_TRANSFERRED_FLAG%TYPE INDEX BY BINARY_INTEGER;
1339: TYPE L_SOURCE_ITEM_ID_t IS TABLE OF jtf_ih_media_items.SOURCE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
1340: TYPE L_MILCS_ID_t IS TABLE OF jtf_ih_media_item_lc_segs.MILCS_ID%TYPE INDEX BY BINARY_INTEGER;
1341: TYPE L_RESOURCE_ID_t IS TABLE OF jtf_ih_media_item_lc_segs.RESOURCE_ID%TYPE INDEX BY BINARY_INTEGER;
1342: TYPE L_SEGMENT_TYPE_t IS TABLE OF jtf_ih_media_itm_lc_seg_tys.MILCS_CODE%TYPE INDEX BY BINARY_INTEGER;
1343: TYPE L_SEGMENT_START_TIME_t IS TABLE OF jtf_ih_media_item_lc_segs.START_DATE_TIME%TYPE INDEX BY BINARY_INTEGER;
1344: TYPE L_SEGMENT_END_TIME_t IS TABLE OF jtf_ih_media_item_lc_segs.END_DATE_TIME%TYPE INDEX BY BINARY_INTEGER;
1345: --

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

1339: TYPE L_SOURCE_ITEM_ID_t IS TABLE OF jtf_ih_media_items.SOURCE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
1340: TYPE L_MILCS_ID_t IS TABLE OF jtf_ih_media_item_lc_segs.MILCS_ID%TYPE INDEX BY BINARY_INTEGER;
1341: TYPE L_RESOURCE_ID_t IS TABLE OF jtf_ih_media_item_lc_segs.RESOURCE_ID%TYPE INDEX BY BINARY_INTEGER;
1342: TYPE L_SEGMENT_TYPE_t IS TABLE OF jtf_ih_media_itm_lc_seg_tys.MILCS_CODE%TYPE INDEX BY BINARY_INTEGER;
1343: TYPE L_SEGMENT_START_TIME_t IS TABLE OF jtf_ih_media_item_lc_segs.START_DATE_TIME%TYPE INDEX BY BINARY_INTEGER;
1344: TYPE L_SEGMENT_END_TIME_t IS TABLE OF jtf_ih_media_item_lc_segs.END_DATE_TIME%TYPE INDEX BY BINARY_INTEGER;
1345: --
1346: --Target Table Datatype Declarations
1347: --

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

1340: TYPE L_MILCS_ID_t IS TABLE OF jtf_ih_media_item_lc_segs.MILCS_ID%TYPE INDEX BY BINARY_INTEGER;
1341: TYPE L_RESOURCE_ID_t IS TABLE OF jtf_ih_media_item_lc_segs.RESOURCE_ID%TYPE INDEX BY BINARY_INTEGER;
1342: TYPE L_SEGMENT_TYPE_t IS TABLE OF jtf_ih_media_itm_lc_seg_tys.MILCS_CODE%TYPE INDEX BY BINARY_INTEGER;
1343: TYPE L_SEGMENT_START_TIME_t IS TABLE OF jtf_ih_media_item_lc_segs.START_DATE_TIME%TYPE INDEX BY BINARY_INTEGER;
1344: TYPE L_SEGMENT_END_TIME_t IS TABLE OF jtf_ih_media_item_lc_segs.END_DATE_TIME%TYPE INDEX BY BINARY_INTEGER;
1345: --
1346: --Target Table Datatype Declarations
1347: --
1348: TYPE L_TIME_ID_T IS TABLE OF BIX_CALL_DETAILS_F.TIME_ID%TYPE INDEX BY BINARY_INTEGER;