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_PRTY_ACCSS

Line 570: From ibe_msite_prty_accss accss

566: ORDER BY respb.msite_resp_id;
567:
568: -- added to cache the minisite party access information -- ssridhar
569: Open x_party_access_cur FOR Select Party_id
570: From ibe_msite_prty_accss accss
571: Where accss.msite_id = l_msite_id
572: And sysdate Between accss.start_date_Active
573: And NVL(accss.end_date_active,sysdate);
574:

Line 1082: -- Mini-site and party association (from ibe_msite_prty_accss table)

1078: AND MM.msite_id = v.msite_id
1079: AND MM.site_type = 'I'
1080: ORDER BY MM.msite_id, MRB.msite_resp_id;
1081:
1082: -- Mini-site and party association (from ibe_msite_prty_accss table)
1083: OPEN x_party_access_cur FOR SELECT /*+ ORDERED USE_NL (V MM MP) INDEX (MM,IBE_MSITES_B_U1) */
1084: MM.msite_id, party_id
1085: FROM (select distinct to_number(t.column_value) as msite_id
1086: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t

Line 1088: ibe_msites_b MM, ibe_msite_prty_accss MP

1084: MM.msite_id, party_id
1085: FROM (select distinct to_number(t.column_value) as msite_id
1086: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1087: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
1088: ibe_msites_b MM, ibe_msite_prty_accss MP
1089: WHERE MM.msite_id = MP.msite_id
1090: AND sysdate BETWEEN MP.start_date_Active AND NVL(MP.end_date_active,sysdate)
1091: AND MM.msite_id = v.msite_id
1092: AND MM.site_type = 'I'