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_ITM_LC_SEG_TYS

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 512: JTF_IH_MEDIA_ITM_LC_SEG_TYS TYPES

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'
516: );

Line 528: JTF_IH_MEDIA_ITM_LC_SEG_TYS TYPES

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';
532:

Line 1113: --JTF_IH_MEDIA_ITM_LC_SEG_TYS SEGTYPES

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
1114: --ON SEGS.MILCS_TYPE_ID = SEGTYPES.MILCS_TYPE_ID
1115: FROM
1116: bix_medias_for_worker MED,
1117: (select *

Line 1342: TYPE L_SEGMENT_TYPE_t IS TABLE OF jtf_ih_media_itm_lc_seg_tys.MILCS_CODE%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: --
1346: --Target Table Datatype Declarations