DBA Data[Home] [Help]

APPS.IBE_MINISITERUNTIME_PVT dependencies on IBE_MSITE_RESPS_TL

Line 558: ibe_msite_resps_tl respt ,

554: respt.language,
555: respt.display_name,
556: respb.start_date_active, respb.end_date_active -- added by YAXU on 08/06/02
557: From ibe_msite_resps_b respb ,
558: ibe_msite_resps_tl respt ,
559: ibe_msite_languages lang
560: Where respb.msite_id = l_msite_id
561: And respb.msite_resp_id = respt.msite_resp_id
562: And lang.msite_id = respb.msite_id

Line 1075: ibe_msites_b MM, ibe_msite_resps_b MRB, ibe_msite_resps_tl MRTL

1071: MRTL.display_name, MRB.start_date_active, MRB.end_date_active
1072: FROM (select distinct to_number(t.column_value) as msite_id
1073: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1074: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
1075: ibe_msites_b MM, ibe_msite_resps_b MRB, ibe_msite_resps_tl MRTL
1076: WHERE MM.msite_id = MRB.msite_id
1077: AND MRB.msite_resp_id = MRTL.msite_resp_id
1078: AND MM.msite_id = v.msite_id
1079: AND MM.site_type = 'I'