eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_MINISITERUNTIME_PVT dependencies on IBE_DSP_SECTION_ITEMS

Line 200: || ' FROM ibe_dsp_section_items '

196:
197: OPEN x_items_cur FOR 'SELECT /*+ first_rows */ inventory_item_id '
198: || 'FROM ( '
199: || ' SELECT section_item_id '
200: || ' FROM ibe_dsp_section_items '
201: || ' WHERE section_id IN '
202: || ' ( '
203: || ' SELECT child_section_id '
204: || ' FROM ibe_dsp_msite_sct_sects s1 '

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 238: || ' ibe_dsp_section_items i2 '

234: || ' SELECT child_section_id '
235: || ' FROM ibe_dsp_msite_sct_sects '
236: || ' WHERE mini_site_id = :l_c_msite_id '
237: || ' ) s3, '
238: || ' ibe_dsp_section_items i2 '
239: || ' WHERE i2.section_id = s3.child_section_id '
240: || ' AND NOT EXISTS '
241: || ' ( '
242: || ' SELECT null '

Line 248: || ' ibe_dsp_section_items i0 '

244: || ' WHERE mini_site_id = :l_c_msite_id '
245: || ' AND i3.section_item_id = i2.section_item_id '
246: || ' ) '
247: || ' ) v1, '
248: || ' ibe_dsp_section_items i0 '
249: || 'WHERE i0.section_item_id = v1.section_item_id'
250: USING x_master_msite_id, l_msite_id, x_master_msite_id, x_master_msite_id,
251: l_msite_id, x_master_msite_id, l_msite_id, l_msite_id, l_msite_id;
252:

Line 254: -- || 'FROM ibe_dsp_section_items '

250: USING x_master_msite_id, l_msite_id, x_master_msite_id, x_master_msite_id,
251: l_msite_id, x_master_msite_id, l_msite_id, l_msite_id, l_msite_id;
252:
253: -- OPEN x_items_cur FOR 'SELECT inventory_item_id '
254: -- || 'FROM ibe_dsp_section_items '
255: -- || 'WHERE section_item_id IN '
256: -- || '(SELECT section_item_id FROM ibe_dsp_section_items '
257: -- || 'WHERE section_id IN '
258: -- || '(SELECT child_section_id FROM ibe_dsp_msite_sct_sects '

Line 256: -- || '(SELECT section_item_id FROM ibe_dsp_section_items '

252:
253: -- OPEN x_items_cur FOR 'SELECT inventory_item_id '
254: -- || 'FROM ibe_dsp_section_items '
255: -- || 'WHERE section_item_id IN '
256: -- || '(SELECT section_item_id FROM ibe_dsp_section_items '
257: -- || 'WHERE section_id IN '
258: -- || '(SELECT child_section_id FROM ibe_dsp_msite_sct_sects '
259: -- || 'WHERE mini_site_id = :master_mini_site_id '
260: -- || 'AND child_section_id NOT IN '

Line 492: -- FROM ibe_dsp_section_items

488: AND PRIOR mini_site_id = l_c_master_msite_id;
489:
490: -- Description of the SQL
491: -- IS SELECT inventory_item_id
492: -- FROM ibe_dsp_section_items
493: -- WHERE section_item_id IN
494: ---- Get all the section items for the excluded sections for the mini-site
495: ---- starting from mini-site's root section
496: -- (SELECT section_item_id FROM ibe_dsp_section_items

Line 496: -- (SELECT section_item_id FROM ibe_dsp_section_items

492: -- FROM ibe_dsp_section_items
493: -- WHERE section_item_id IN
494: ---- Get all the section items for the excluded sections for the mini-site
495: ---- starting from mini-site's root section
496: -- (SELECT section_item_id FROM ibe_dsp_section_items
497: -- WHERE section_id IN
498: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
499: -- WHERE mini_site_id = l_c_master_msite_id
500: -- AND child_section_id NOT IN

Line 525: -- FROM ibe_dsp_section_items

521: -- Changing the cursor to new cursor based on new performance query
522: --
523: -- CURSOR c2(l_c_master_msite_id IN NUMBER, l_c_msite_id IN NUMBER)
524: -- IS SELECT inventory_item_id
525: -- FROM ibe_dsp_section_items
526: -- WHERE section_item_id IN
527: -- (SELECT section_item_id FROM ibe_dsp_section_items
528: -- WHERE section_id IN
529: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

Line 527: -- (SELECT section_item_id FROM ibe_dsp_section_items

523: -- CURSOR c2(l_c_master_msite_id IN NUMBER, l_c_msite_id IN NUMBER)
524: -- IS SELECT inventory_item_id
525: -- FROM ibe_dsp_section_items
526: -- WHERE section_item_id IN
527: -- (SELECT section_item_id FROM ibe_dsp_section_items
528: -- WHERE section_id IN
529: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
530: -- WHERE mini_site_id = l_c_master_msite_id
531: -- AND child_section_id NOT IN

Line 553: FROM ibe_dsp_section_items idsi

549: l_root_section_id IN NUMBER) IS
550: SELECT /*+ first_rows */ inventory_item_id
551: FROM (
552: SELECT section_item_id, inventory_item_id
553: FROM ibe_dsp_section_items idsi
554: WHERE section_id IN
555: (
556: SELECT child_section_id
557: FROM ibe_dsp_msite_sct_sects s1

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 583: ibe_dsp_section_items i2

579: )
580: UNION
581: SELECT section_item_id, inventory_item_id
582: FROM ibe_dsp_msite_sct_sects s3,
583: ibe_dsp_section_items i2
584: WHERE i2.section_id = s3.child_section_id
585: AND s3.mini_site_id = l_c_msite_id
586: AND NOT EXISTS
587: (

Line 598: -- FROM ibe_dsp_section_items

594:
595: -- SELECT /*+ first_rows */ inventory_item_id
596: -- FROM (
597: -- SELECT section_item_id
598: -- FROM ibe_dsp_section_items
599: -- WHERE section_id IN
600: -- (
601: -- SELECT child_section_id
602: -- FROM ibe_dsp_msite_sct_sects s1

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 636: -- ibe_dsp_section_items i2

632: -- SELECT child_section_id
633: -- FROM ibe_dsp_msite_sct_sects
634: -- WHERE mini_site_id = l_c_msite_id
635: -- ) s3,
636: -- ibe_dsp_section_items i2
637: -- WHERE i2.section_id = s3.child_section_id
638: -- AND NOT EXISTS
639: -- (
640: -- SELECT null

Line 646: -- ibe_dsp_section_items i0

642: -- WHERE mini_site_id = l_c_msite_id
643: -- AND i3.section_item_id = i2.section_item_id
644: -- )
645: -- ) v1,
646: -- ibe_dsp_section_items i0
647: -- WHERE i0.section_item_id = v1.section_item_id;
648:
649: CURSOR c3
650: IS SELECT msite_id FROM ibe_msites_b