APPS.BIX_SESSION_LOAD_PKG dependencies on JTF_IH_MEDIA_ITM_LC_SEG_TYS

Line 936: jtf_ih_media_itm_lc_seg_tys segs

932: select /*+ parallel(msegs) */ 2 type, resource_id,
933: start_date_time begin_date_time, null end_date_time,
934: null session_id, null application_id
935: from jtf_ih_media_item_lc_segs msegs,
936: jtf_ih_media_itm_lc_seg_tys segs
937: where msegs.milcs_type_id = segs.milcs_type_id
938: and segs.milcs_code in ('EMAIL_FETCH', 'EMAIL_REPLY',
939: 'EMAIL_DELETED', 'EMAIL_OPEN', 'EMAIL_REQUEUED',
940: 'EMAIL_REROUTED_DIFF_CLASS', 'EMAIL_REROUTED_DIFF_ACCT',

Line 957: ,jtf_ih_media_itm_lc_seg_tys segs

953: application_id
954: FROM
955: ( SELECT + full(msegs)
956: resource_id, start_date_time FROM jtf_ih_media_item_lc_segs msegs
957: ,jtf_ih_media_itm_lc_seg_tys segs
958: WHERE msegs.milcs_type_id = segs.milcs_type_id
959: AND segs.milcs_code IN
960: ('EMAIL_FETCH'
961: ,'EMAIL_REPLY'