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.IBE_MINISITERUNTIME_PVT dependencies on IBE_MSITE_RESPS_B

Line 292: From ibe_msite_resps_b respb ,

288: respb.application_id,
289: respt.language,
290: respt.display_name,
291: respb.start_date_active, respb.end_date_active -- added by YAXU on 08/06/02
292: From ibe_msite_resps_b respb ,
293: ibe_msite_resps_tl respt ,
294: ibe_msite_languages lang
295: Where respb.msite_id = l_msite_id
296: And respb.msite_resp_id = respt.msite_resp_id

Line 803: -- Mini-site and responsibility association (from ibe_msite_resps_b, _tl)

799: AND MM.msite_id = v.msite_id
800: AND MM.site_type = 'I'
801: ORDER BY MM.msite_id;
802:
803: -- Mini-site and responsibility association (from ibe_msite_resps_b, _tl)
804: OPEN x_msite_resps_cur FOR SELECT /*+ ORDERED USE_NL (V MM MRB MRTL) INDEX (MM,IBE_MSITES_B_U1)*/
805: MM.msite_id, MRB.msite_resp_id, MRB.responsibility_id, MRB.application_id, MRTL.language,
806: MRTL.display_name, MRB.start_date_active, MRB.end_date_active
807: FROM (select distinct to_number(t.column_value) as msite_id

Line 810: ibe_msites_b MM, ibe_msite_resps_b MRB, ibe_msite_resps_tl MRTL

806: MRTL.display_name, MRB.start_date_active, MRB.end_date_active
807: FROM (select distinct to_number(t.column_value) as msite_id
808: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
809: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
810: ibe_msites_b MM, ibe_msite_resps_b MRB, ibe_msite_resps_tl MRTL
811: WHERE MM.msite_id = MRB.msite_id
812: AND MRB.msite_resp_id = MRTL.msite_resp_id
813: AND MM.msite_id = v.msite_id
814: AND MM.site_type = 'I'