APPS.IBE_MINISITERUNTIME_PVT dependencies on IBE_MSITE_LANGUAGES

Line 421: FROM ibe_msite_languages a, ibe_msites_tl b

417: AND site_type = 'I';
418:
419: OPEN x_name_cur FOR SELECT a.language_code,
420: b.msite_name, b.msite_description
421: FROM ibe_msite_languages a, ibe_msites_tl b
422: WHERE a.language_code = b.language
423: AND b.msite_id = a.msite_id
424: AND b.msite_id = l_msite_id;
425:

Line 426: OPEN x_lang_cur FOR SELECT language_code from ibe_msite_languages l

422: WHERE a.language_code = b.language
423: AND b.msite_id = a.msite_id
424: AND b.msite_id = l_msite_id;
425:
426: OPEN x_lang_cur FOR SELECT language_code from ibe_msite_languages l
427: WHERE l.msite_id = l_msite_id
428: AND l.enable_flag = 'Y';
429:
430: OPEN x_currency_cur FOR SELECT currency_code, bizpartner_prc_listid,

Line 559: ibe_msite_languages lang

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
563: And lang.language_code = respt.language

Line 1028: ibe_msites_b MM, ibe_msites_tl TL, ibe_msite_languages L

1024: MM.msite_id, L.language_code, TL.msite_name,TL.msite_description
1025: FROM(select distinct to_number(t.column_value) as msite_id
1026: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1027: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
1028: ibe_msites_b MM, ibe_msites_tl TL, ibe_msite_languages L
1029: WHERE L.language_code = TL.language
1030: AND L.msite_id = MM.msite_id
1031: AND TL.msite_id = MM.msite_id
1032: AND MM.msite_id = v.msite_id

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

1032: AND MM.msite_id = v.msite_id
1033: AND MM.site_type = 'I'
1034: ORDER BY MM.msite_id;
1035:
1036: -- Language assocation(from ibe_msite_languages table)
1037: OPEN x_lang_cur FOR SELECT /*+ ORDERED
1038: USE_NL (V MM L)
1039: INDEX (MM,IBE_MSITES_B_U1) */
1040: MM.msite_id, L.language_code

Line 1046: ibe_msite_languages L

1042: (select distinct to_number(t.column_value) as msite_id
1043: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1044: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
1045: ibe_msites_b MM,
1046: ibe_msite_languages L
1047: WHERE MM.msite_id = L.msite_id
1048: AND MM.msite_id = v.msite_id
1049: AND MM.site_type = 'I'
1050: AND L.enable_flag = 'Y'