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.

[Home] [Help]

APPS.BIX_CALL_LOAD_PKG dependencies on JTF_IH_MEDIA_ITM_LC_SEG_TYS

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

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

Line 535: JTF_IH_MEDIA_ITM_LC_SEG_TYS TYPES

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

Line 1121: --JTF_IH_MEDIA_ITM_LC_SEG_TYS SEGTYPES

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
1122: --ON SEGS.MILCS_TYPE_ID = SEGTYPES.MILCS_TYPE_ID
1123: FROM
1124: bix_medias_for_worker MED,
1125: (select *

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