APPS.BIX_REAL_TIME_RPTS_PKG dependencies on JTF_IH_INTERACTIONS

Line 587: jtf_ih_interactions J1,

583:
584:
585: select sum(J1.end_date_time - J2.end_date_time)*24*3600 into wrap_past
586: from jtf_ih_media_item_lc_segs J2,
587: jtf_ih_interactions J1,
588: jtf_ih_media_itm_lc_seg_tys J3
589: where J1.resource_id = v_agent_id
590: and J1.resource_id = J2.resource_id
591: and J2.media_id = J1.productive_time_amount