APPS.IBE_MINISITERUNTIME_PVT dependencies on IBE_MSITE_LANGUAGES

Line 156: FROM ibe_msite_languages a, ibe_msites_tl b

152: AND site_type = 'I';
153:
154: OPEN x_name_cur FOR SELECT a.language_code,
155: b.msite_name, b.msite_description
156: FROM ibe_msite_languages a, ibe_msites_tl b
157: WHERE a.language_code = b.language
158: AND b.msite_id = a.msite_id
159: AND b.msite_id = l_msite_id;
160:

Line 161: OPEN x_lang_cur FOR SELECT language_code from ibe_msite_languages l

157: WHERE a.language_code = b.language
158: AND b.msite_id = a.msite_id
159: AND b.msite_id = l_msite_id;
160:
161: OPEN x_lang_cur FOR SELECT language_code from ibe_msite_languages l
162: WHERE l.msite_id = l_msite_id
163: AND l.enable_flag = 'Y';
164:
165: OPEN x_currency_cur FOR SELECT currency_code, bizpartner_prc_listid,

Line 294: ibe_msite_languages lang

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
297: And lang.msite_id = respb.msite_id
298: And lang.language_code = respt.language

Line 763: ibe_msites_b MM, ibe_msites_tl TL, ibe_msite_languages L

759: MM.msite_id, L.language_code, TL.msite_name,TL.msite_description
760: FROM(select distinct to_number(t.column_value) as msite_id
761: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
762: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
763: ibe_msites_b MM, ibe_msites_tl TL, ibe_msite_languages L
764: WHERE L.language_code = TL.language
765: AND L.msite_id = MM.msite_id
766: AND TL.msite_id = MM.msite_id
767: AND MM.msite_id = v.msite_id

Line 771: -- Language assocation(from ibe_msite_languages table)

767: AND MM.msite_id = v.msite_id
768: AND MM.site_type = 'I'
769: ORDER BY MM.msite_id;
770:
771: -- Language assocation(from ibe_msite_languages table)
772: OPEN x_lang_cur FOR SELECT /*+ ORDERED
773: USE_NL (V MM L)
774: INDEX (MM,IBE_MSITES_B_U1) */
775: MM.msite_id, L.language_code

Line 781: ibe_msite_languages L

777: (select distinct to_number(t.column_value) as msite_id
778: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
779: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
780: ibe_msites_b MM,
781: ibe_msite_languages L
782: WHERE MM.msite_id = L.msite_id
783: AND MM.msite_id = v.msite_id
784: AND MM.site_type = 'I'
785: AND L.enable_flag = 'Y'