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_MSITE_SCT_SECTS

Line 183: || 'FROM ibe_dsp_msite_sct_sects '

179: IF (l_exclude_flag = 'Y')
180: THEN
181:
182: OPEN x_sections_cur FOR 'SELECT child_section_id '
183: || 'FROM ibe_dsp_msite_sct_sects '
184: || 'WHERE mini_site_id = :master_mini_site_id AND '
185: || 'sysdate BETWEEN start_date_active AND NVL(end_date_active,sysdate) '
186: || 'AND child_section_id NOT IN '
187: || '(SELECT child_section_id FROM ibe_dsp_msite_sct_sects '

Line 187: || '(SELECT child_section_id FROM ibe_dsp_msite_sct_sects '

183: || 'FROM ibe_dsp_msite_sct_sects '
184: || 'WHERE mini_site_id = :master_mini_site_id AND '
185: || 'sysdate BETWEEN start_date_active AND NVL(end_date_active,sysdate) '
186: || 'AND child_section_id NOT IN '
187: || '(SELECT child_section_id FROM ibe_dsp_msite_sct_sects '
188: || 'WHERE mini_site_id = :msite_id) '
189: || 'START WITH child_section_id = :root_section_id '
190: || 'AND mini_site_id = :master_mini_site_id '
191: || 'CONNECT BY PRIOR child_section_id = parent_section_id '

Line 204: || ' FROM ibe_dsp_msite_sct_sects s1 '

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 '
205: || ' WHERE mini_site_id = :l_c_master_msite_id '
206: || ' AND NOT EXISTS '
207: || ' ( '
208: || ' SELECT child_section_id '

Line 209: || ' FROM ibe_dsp_msite_sct_sects s2 '

205: || ' WHERE mini_site_id = :l_c_master_msite_id '
206: || ' AND NOT EXISTS '
207: || ' ( '
208: || ' SELECT child_section_id '
209: || ' FROM ibe_dsp_msite_sct_sects s2 '
210: || ' WHERE mini_site_id = :l_c_msite_id '
211: || ' AND s2.child_section_id = s1.child_section_id '
212: || ' ) '
213: || ' CONNECT BY PRIOR child_section_id = parent_section_id '

Line 235: || ' FROM ibe_dsp_msite_sct_sects '

231: || ' UNION '
232: || ' SELECT /*+ ordered use_nl(s3,i2) */ section_item_id '
233: || ' FROM ( '
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 '

Line 258: -- || '(SELECT child_section_id FROM ibe_dsp_msite_sct_sects '

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 '
261: -- || '(SELECT child_section_id FROM ibe_dsp_msite_sct_sects '
262: -- || 'WHERE mini_site_id = :msite_id) '

Line 261: -- || '(SELECT child_section_id FROM ibe_dsp_msite_sct_sects '

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 '
261: -- || '(SELECT child_section_id FROM ibe_dsp_msite_sct_sects '
262: -- || 'WHERE mini_site_id = :msite_id) '
263: -- || 'START WITH child_section_id = :root_section_id '
264: -- || 'AND mini_site_id = :master_mini_site_id '
265: -- || 'CONNECT BY PRIOR child_section_id = parent_section_id '

Line 269: -- || '(SELECT child_section_id FROM ibe_dsp_msite_sct_sects '

265: -- || 'CONNECT BY PRIOR child_section_id = parent_section_id '
266: -- || 'AND PRIOR mini_site_id = :master_mini_site_id '
267: -- || 'AND mini_site_id = :master_mini_site_id) '
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))) '

Line 476: FROM ibe_dsp_msite_sct_sects

472: l_root_section_id NUMBER;
473:
474: CURSOR c1(l_c_master_msite_id IN NUMBER, l_c_msite_id IN NUMBER)
475: IS SELECT child_section_id
476: FROM ibe_dsp_msite_sct_sects
477: WHERE mini_site_id = l_c_master_msite_id AND
478: sysdate BETWEEN start_date_active AND NVL(end_date_active,sysdate)
479: AND child_section_id NOT IN
480: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

Line 480: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

476: FROM ibe_dsp_msite_sct_sects
477: WHERE mini_site_id = l_c_master_msite_id AND
478: sysdate BETWEEN start_date_active AND NVL(end_date_active,sysdate)
479: AND child_section_id NOT IN
480: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
481: WHERE mini_site_id = l_c_msite_id)
482: START WITH child_section_id =
483: (SELECT msite_root_section_id FROM ibe_msites_b
484: WHERE msite_id = l_c_msite_id)

Line 498: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

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
501: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
502: -- WHERE mini_site_id = l_c_msite_id)

Line 501: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

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
501: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
502: -- WHERE mini_site_id = l_c_msite_id)
503: -- START WITH child_section_id =
504: -- (SELECT msite_root_section_id FROM ibe_msites_b
505: -- WHERE msite_id = l_c_msite_id)

Line 514: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

510: ---- Get all the section items for the included sections for the mini-site
511: ---- starting from mini-site's root section, but the section-items themselves
512: ---- are excluded.
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)));

Line 529: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

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
532: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
533: -- WHERE mini_site_id = l_c_msite_id)

Line 532: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

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
532: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
533: -- WHERE mini_site_id = l_c_msite_id)
534: -- START WITH child_section_id =
535: -- (SELECT msite_root_section_id FROM ibe_msites_b
536: -- WHERE msite_id = l_c_msite_id)

Line 542: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

538: -- CONNECT BY PRIOR child_section_id = parent_section_id
539: -- AND PRIOR mini_site_id = l_c_master_msite_id
540: -- AND mini_site_id = l_c_master_msite_id)
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)));

Line 557: FROM ibe_dsp_msite_sct_sects s1

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
558: WHERE mini_site_id = l_c_master_msite_id
559: AND NOT EXISTS
560: (
561: SELECT child_section_id

Line 562: FROM ibe_dsp_msite_sct_sects s2

558: WHERE mini_site_id = l_c_master_msite_id
559: AND NOT EXISTS
560: (
561: SELECT child_section_id
562: FROM ibe_dsp_msite_sct_sects s2
563: WHERE mini_site_id = l_c_msite_id
564: AND s2.child_section_id = s1.child_section_id
565: )
566: CONNECT BY PRIOR child_section_id = parent_section_id

Line 582: FROM ibe_dsp_msite_sct_sects s3,

578: AND i1.inventory_item_id = idsi.inventory_item_id
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

Line 602: -- FROM ibe_dsp_msite_sct_sects s1

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
603: -- WHERE mini_site_id = l_c_master_msite_id
604: -- AND NOT EXISTS
605: -- (
606: -- SELECT child_section_id

Line 607: -- FROM ibe_dsp_msite_sct_sects s2

603: -- WHERE mini_site_id = l_c_master_msite_id
604: -- AND NOT EXISTS
605: -- (
606: -- SELECT child_section_id
607: -- FROM ibe_dsp_msite_sct_sects s2
608: -- WHERE mini_site_id = l_c_msite_id
609: -- AND s2.child_section_id = s1.child_section_id
610: -- )
611: -- CONNECT BY PRIOR child_section_id = parent_section_id

Line 633: -- FROM ibe_dsp_msite_sct_sects

629: -- UNION
630: -- SELECT /*+ ordered use_nl(s3,i2) */ section_item_id
631: -- FROM (
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