DBA Data[Home] [Help]

APPS.BIX_SESSION_LOAD_PKG dependencies on JTF_IH_MEDIA_ITEM_LC_SEGS

Line 935: from jtf_ih_media_item_lc_segs msegs,

931: union all
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',

Line 956: resource_id, start_date_time FROM jtf_ih_media_item_lc_segs msegs

952: ,decode(inv1.application_id, 696, 696, 680, 680, 0)
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'