APPS.IBE_MINISITERUNTIME_PVT dependencies on IBE_MSITE_CURRENCIES

Line 168: FROM ibe_msite_currencies c

164:
165: OPEN x_currency_cur FOR SELECT currency_code, bizpartner_prc_listid,
166: registered_prc_listid, walkin_prc_listid, orderable_limit,
167: payment_threshold, partner_prc_listid -- added by YAXU for payment threshold
168: FROM ibe_msite_currencies c
169: WHERE c.msite_id = l_msite_id;
170:
171: l_exclude_flag :=
172: FND_PROFILE.Value_Specific('IBE_USE_CATALOG_EXCLUSIONS',null,null,

Line 788: -- Currency assocation(from ibe_msite_currencies table)

784: AND MM.site_type = 'I'
785: AND L.enable_flag = 'Y'
786: ORDER BY MM.msite_id;
787:
788: -- Currency assocation(from ibe_msite_currencies table)
789: OPEN x_currency_cur FOR SELECT /*+ ORDERED USE_NL (V MM C) INDEX (MM,IBE_MSITES_B_U1) */
790: MM.msite_id, C.currency_code,
791: C.bizpartner_prc_listid,C.registered_prc_listid, C.walkin_prc_listid,
792: C.orderable_limit,

Line 797: ibe_msites_b MM, ibe_msite_currencies C

793: C.payment_threshold,C.partner_prc_listid
794: FROM (select distinct to_number(t.column_value) as msite_id
795: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
796: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
797: ibe_msites_b MM, ibe_msite_currencies C
798: WHERE MM.msite_id = C.msite_id
799: AND MM.msite_id = v.msite_id
800: AND MM.site_type = 'I'
801: ORDER BY MM.msite_id;