APPS.IBE_MINISITERUNTIME_PVT dependencies on IBE_DSP_MSITE_SCT_ITEMS

Line 227: || ' FROM ibe_dsp_section_items i1, ibe_dsp_msite_sct_items i2 '

223: || ' ) '
224: || ' AND inventory_item_id NOT IN '
225: || ' ( '
226: || ' SELECT inventory_item_id '
227: || ' FROM ibe_dsp_section_items i1, ibe_dsp_msite_sct_items i2 '
228: || ' WHERE i1.section_item_id = i2.section_item_id '
229: || ' AND i2.mini_site_id = :l_c_msite_id '
230: || ' ) '
231: || ' UNION '

Line 243: || ' FROM ibe_dsp_msite_sct_items i3 '

239: || ' WHERE i2.section_id = s3.child_section_id '
240: || ' AND NOT EXISTS '
241: || ' ( '
242: || ' SELECT null '
243: || ' FROM ibe_dsp_msite_sct_items i3 '
244: || ' WHERE mini_site_id = :l_c_msite_id '
245: || ' AND i3.section_item_id = i2.section_item_id '
246: || ' ) '
247: || ' ) v1, '

Line 272: -- || '(SELECT section_item_id FROM ibe_dsp_msite_sct_items '

268: -- || 'OR (section_id IN '
269: -- || '(SELECT child_section_id FROM ibe_dsp_msite_sct_sects '
270: -- || 'WHERE mini_site_id = :msite_id) '
271: -- || 'AND section_item_id NOT IN '
272: -- || '(SELECT section_item_id FROM ibe_dsp_msite_sct_items '
273: -- || 'WHERE mini_site_id = :msite_id))) '
274: -- USING x_master_msite_id, l_msite_id, l_root_section_id,
275: -- x_master_msite_id, x_master_msite_id, x_master_msite_id,
276: -- l_msite_id, l_msite_id;

Line 517: -- (SELECT section_item_id FROM ibe_dsp_msite_sct_items

513: -- OR (section_id IN
514: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
515: -- WHERE mini_site_id = l_c_msite_id)
516: -- AND section_item_id NOT IN
517: -- (SELECT section_item_id FROM ibe_dsp_msite_sct_items
518: -- WHERE mini_site_id = l_c_msite_id)));
519:
520: --
521: -- Changing the cursor to new cursor based on new performance query

Line 545: -- (SELECT section_item_id FROM ibe_dsp_msite_sct_items

541: -- OR (section_id IN
542: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
543: -- WHERE mini_site_id = l_c_msite_id)
544: -- AND section_item_id NOT IN
545: -- (SELECT section_item_id FROM ibe_dsp_msite_sct_items
546: -- WHERE mini_site_id = l_c_msite_id)));
547:
548: CURSOR c2(l_c_master_msite_id IN NUMBER, l_c_msite_id IN NUMBER,
549: l_root_section_id IN NUMBER) IS

Line 575: FROM ibe_dsp_section_items i1, ibe_dsp_msite_sct_items i2

571: )
572: AND NOT EXISTS
573: (
574: SELECT inventory_item_id
575: FROM ibe_dsp_section_items i1, ibe_dsp_msite_sct_items i2
576: WHERE i1.section_item_id = i2.section_item_id
577: AND i2.mini_site_id = l_c_msite_id
578: AND i1.inventory_item_id = idsi.inventory_item_id
579: )

Line 589: FROM ibe_dsp_msite_sct_items i3

585: AND s3.mini_site_id = l_c_msite_id
586: AND NOT EXISTS
587: (
588: SELECT null
589: FROM ibe_dsp_msite_sct_items i3
590: WHERE mini_site_id = l_c_msite_id
591: AND i3.section_item_id = i2.section_item_id
592: )
593: );

Line 625: -- FROM ibe_dsp_section_items i1, ibe_dsp_msite_sct_items i2

621: -- )
622: -- AND inventory_item_id NOT IN
623: -- (
624: -- SELECT inventory_item_id
625: -- FROM ibe_dsp_section_items i1, ibe_dsp_msite_sct_items i2
626: -- WHERE i1.section_item_id = i2.section_item_id
627: -- AND i2.mini_site_id = l_c_msite_id
628: -- )
629: -- UNION

Line 641: -- FROM ibe_dsp_msite_sct_items i3

637: -- WHERE i2.section_id = s3.child_section_id
638: -- AND NOT EXISTS
639: -- (
640: -- SELECT null
641: -- FROM ibe_dsp_msite_sct_items i3
642: -- WHERE mini_site_id = l_c_msite_id
643: -- AND i3.section_item_id = i2.section_item_id
644: -- )
645: -- ) v1,