APPS.IBE_MINISITERUNTIME_PVT dependencies on IBE_MSITE_CURRENCIES

Line 433: FROM ibe_msite_currencies c

429:
430: OPEN x_currency_cur FOR SELECT currency_code, bizpartner_prc_listid,
431: registered_prc_listid, walkin_prc_listid, orderable_limit,
432: payment_threshold, partner_prc_listid -- added by YAXU for payment threshold
433: FROM ibe_msite_currencies c
434: WHERE c.msite_id = l_msite_id;
435:
436: l_exclude_flag :=
437: FND_PROFILE.Value_Specific('IBE_USE_CATALOG_EXCLUSIONS',null,null,

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

1049: AND MM.site_type = 'I'
1050: AND L.enable_flag = 'Y'
1051: ORDER BY MM.msite_id;
1052:
1053: -- Currency assocation(from ibe_msite_currencies table)
1054: OPEN x_currency_cur FOR SELECT /*+ ORDERED USE_NL (V MM C) INDEX (MM,IBE_MSITES_B_U1) */
1055: MM.msite_id, C.currency_code,
1056: C.bizpartner_prc_listid,C.registered_prc_listid, C.walkin_prc_listid,
1057: C.orderable_limit,

Line 1062: ibe_msites_b MM, ibe_msite_currencies C

1058: C.payment_threshold,C.partner_prc_listid
1059: FROM (select distinct to_number(t.column_value) as msite_id
1060: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1061: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
1062: ibe_msites_b MM, ibe_msite_currencies C
1063: WHERE MM.msite_id = C.msite_id
1064: AND MM.msite_id = v.msite_id
1065: AND MM.site_type = 'I'
1066: ORDER BY MM.msite_id;