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 86: FROM ibe_dsp_msite_sct_sects s1

82: FROM ibe_dsp_section_items idsi
83: WHERE section_id IN
84: (
85: SELECT child_section_id
86: FROM ibe_dsp_msite_sct_sects s1
87: WHERE mini_site_id = l_c_master_msite_id
88: AND NOT EXISTS
89: (
90: SELECT child_section_id

Line 91: FROM ibe_dsp_msite_sct_sects s2

87: WHERE mini_site_id = l_c_master_msite_id
88: AND NOT EXISTS
89: (
90: SELECT child_section_id
91: FROM ibe_dsp_msite_sct_sects s2
92: WHERE mini_site_id = l_c_msite_id
93: AND s2.child_section_id = s1.child_section_id
94: )
95: CONNECT BY PRIOR child_section_id = parent_section_id

Line 111: FROM ibe_dsp_msite_sct_sects s3,

107: AND i1.inventory_item_id = idsi.inventory_item_id
108: )
109: UNION
110: SELECT section_item_id, inventory_item_id
111: FROM ibe_dsp_msite_sct_sects s3,
112: ibe_dsp_section_items i2
113: WHERE i2.section_id = s3.child_section_id
114: AND s3.mini_site_id = l_c_msite_id
115: AND NOT EXISTS

Line 228: FROM ibe_dsp_msite_sct_sects

224: 'Get_Msite_Excluded_Sections';
225:
226: CURSOR c1(l_c_master_msite_id IN NUMBER, l_c_msite_id IN NUMBER)
227: IS SELECT child_section_id
228: FROM ibe_dsp_msite_sct_sects
229: WHERE mini_site_id = l_c_master_msite_id AND
230: sysdate BETWEEN start_date_active AND NVL(end_date_active,sysdate)
231: AND child_section_id NOT IN
232: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

Line 232: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

228: FROM ibe_dsp_msite_sct_sects
229: WHERE mini_site_id = l_c_master_msite_id AND
230: sysdate BETWEEN start_date_active AND NVL(end_date_active,sysdate)
231: AND child_section_id NOT IN
232: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
233: WHERE mini_site_id = l_c_msite_id)
234: START WITH child_section_id =
235: (SELECT msite_root_section_id FROM ibe_msites_b
236: WHERE msite_id = l_c_msite_id)

Line 448: || 'FROM ibe_dsp_msite_sct_sects '

444: IF (l_exclude_flag = 'Y')
445: THEN
446:
447: OPEN x_sections_cur FOR 'SELECT child_section_id '
448: || 'FROM ibe_dsp_msite_sct_sects '
449: || 'WHERE mini_site_id = :master_mini_site_id AND '
450: || 'sysdate BETWEEN start_date_active AND NVL(end_date_active,sysdate) '
451: || 'AND child_section_id NOT IN '
452: || '(SELECT child_section_id FROM ibe_dsp_msite_sct_sects '

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

448: || 'FROM ibe_dsp_msite_sct_sects '
449: || 'WHERE mini_site_id = :master_mini_site_id AND '
450: || 'sysdate BETWEEN start_date_active AND NVL(end_date_active,sysdate) '
451: || 'AND child_section_id NOT IN '
452: || '(SELECT child_section_id FROM ibe_dsp_msite_sct_sects '
453: || 'WHERE mini_site_id = :msite_id) '
454: || 'START WITH child_section_id = :root_section_id '
455: || 'AND mini_site_id = :master_mini_site_id '
456: || 'CONNECT BY PRIOR child_section_id = parent_section_id '

Line 469: || ' FROM ibe_dsp_msite_sct_sects s1 '

465: || ' FROM ibe_dsp_section_items '
466: || ' WHERE section_id IN '
467: || ' ( '
468: || ' SELECT child_section_id '
469: || ' FROM ibe_dsp_msite_sct_sects s1 '
470: || ' WHERE mini_site_id = :l_c_master_msite_id '
471: || ' AND NOT EXISTS '
472: || ' ( '
473: || ' SELECT child_section_id '

Line 474: || ' FROM ibe_dsp_msite_sct_sects s2 '

470: || ' WHERE mini_site_id = :l_c_master_msite_id '
471: || ' AND NOT EXISTS '
472: || ' ( '
473: || ' SELECT child_section_id '
474: || ' FROM ibe_dsp_msite_sct_sects s2 '
475: || ' WHERE mini_site_id = :l_c_msite_id '
476: || ' AND s2.child_section_id = s1.child_section_id '
477: || ' ) '
478: || ' CONNECT BY PRIOR child_section_id = parent_section_id '

Line 500: || ' FROM ibe_dsp_msite_sct_sects '

496: || ' UNION '
497: || ' SELECT /*+ ordered use_nl(s3,i2) */ section_item_id '
498: || ' FROM ( '
499: || ' SELECT child_section_id '
500: || ' FROM ibe_dsp_msite_sct_sects '
501: || ' WHERE mini_site_id = :l_c_msite_id '
502: || ' ) s3, '
503: || ' ibe_dsp_section_items i2 '
504: || ' WHERE i2.section_id = s3.child_section_id '

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

519: -- || 'FROM ibe_dsp_section_items '
520: -- || 'WHERE section_item_id IN '
521: -- || '(SELECT section_item_id FROM ibe_dsp_section_items '
522: -- || 'WHERE section_id IN '
523: -- || '(SELECT child_section_id FROM ibe_dsp_msite_sct_sects '
524: -- || 'WHERE mini_site_id = :master_mini_site_id '
525: -- || 'AND child_section_id NOT IN '
526: -- || '(SELECT child_section_id FROM ibe_dsp_msite_sct_sects '
527: -- || 'WHERE mini_site_id = :msite_id) '

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

522: -- || 'WHERE section_id IN '
523: -- || '(SELECT child_section_id FROM ibe_dsp_msite_sct_sects '
524: -- || 'WHERE mini_site_id = :master_mini_site_id '
525: -- || 'AND child_section_id NOT IN '
526: -- || '(SELECT child_section_id FROM ibe_dsp_msite_sct_sects '
527: -- || 'WHERE mini_site_id = :msite_id) '
528: -- || 'START WITH child_section_id = :root_section_id '
529: -- || 'AND mini_site_id = :master_mini_site_id '
530: -- || 'CONNECT BY PRIOR child_section_id = parent_section_id '

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

530: -- || 'CONNECT BY PRIOR child_section_id = parent_section_id '
531: -- || 'AND PRIOR mini_site_id = :master_mini_site_id '
532: -- || 'AND mini_site_id = :master_mini_site_id) '
533: -- || 'OR (section_id IN '
534: -- || '(SELECT child_section_id FROM ibe_dsp_msite_sct_sects '
535: -- || 'WHERE mini_site_id = :msite_id) '
536: -- || 'AND section_item_id NOT IN '
537: -- || '(SELECT section_item_id FROM ibe_dsp_msite_sct_items '
538: -- || 'WHERE mini_site_id = :msite_id))) '

Line 741: FROM ibe_dsp_msite_sct_sects

737: l_root_section_id NUMBER;
738:
739: CURSOR c1(l_c_master_msite_id IN NUMBER, l_c_msite_id IN NUMBER)
740: IS SELECT child_section_id
741: FROM ibe_dsp_msite_sct_sects
742: WHERE mini_site_id = l_c_master_msite_id AND
743: sysdate BETWEEN start_date_active AND NVL(end_date_active,sysdate)
744: AND child_section_id NOT IN
745: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

Line 745: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

741: FROM ibe_dsp_msite_sct_sects
742: WHERE mini_site_id = l_c_master_msite_id AND
743: sysdate BETWEEN start_date_active AND NVL(end_date_active,sysdate)
744: AND child_section_id NOT IN
745: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
746: WHERE mini_site_id = l_c_msite_id)
747: START WITH child_section_id =
748: (SELECT msite_root_section_id FROM ibe_msites_b
749: WHERE msite_id = l_c_msite_id)

Line 763: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

759: ---- Get all the section items for the excluded sections for the mini-site
760: ---- starting from mini-site's root section
761: -- (SELECT section_item_id FROM ibe_dsp_section_items
762: -- WHERE section_id IN
763: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
764: -- WHERE mini_site_id = l_c_master_msite_id
765: -- AND child_section_id NOT IN
766: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
767: -- WHERE mini_site_id = l_c_msite_id)

Line 766: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

762: -- WHERE section_id IN
763: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
764: -- WHERE mini_site_id = l_c_master_msite_id
765: -- AND child_section_id NOT IN
766: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
767: -- WHERE mini_site_id = l_c_msite_id)
768: -- START WITH child_section_id =
769: -- (SELECT msite_root_section_id FROM ibe_msites_b
770: -- WHERE msite_id = l_c_msite_id)

Line 779: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

775: ---- Get all the section items for the included sections for the mini-site
776: ---- starting from mini-site's root section, but the section-items themselves
777: ---- are excluded.
778: -- OR (section_id IN
779: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
780: -- WHERE mini_site_id = l_c_msite_id)
781: -- AND section_item_id NOT IN
782: -- (SELECT section_item_id FROM ibe_dsp_msite_sct_items
783: -- WHERE mini_site_id = l_c_msite_id)));

Line 794: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

790: -- FROM ibe_dsp_section_items
791: -- WHERE section_item_id IN
792: -- (SELECT section_item_id FROM ibe_dsp_section_items
793: -- WHERE section_id IN
794: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
795: -- WHERE mini_site_id = l_c_master_msite_id
796: -- AND child_section_id NOT IN
797: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
798: -- WHERE mini_site_id = l_c_msite_id)

Line 797: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

793: -- WHERE section_id IN
794: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
795: -- WHERE mini_site_id = l_c_master_msite_id
796: -- AND child_section_id NOT IN
797: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
798: -- WHERE mini_site_id = l_c_msite_id)
799: -- START WITH child_section_id =
800: -- (SELECT msite_root_section_id FROM ibe_msites_b
801: -- WHERE msite_id = l_c_msite_id)

Line 807: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

803: -- CONNECT BY PRIOR child_section_id = parent_section_id
804: -- AND PRIOR mini_site_id = l_c_master_msite_id
805: -- AND mini_site_id = l_c_master_msite_id)
806: -- OR (section_id IN
807: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
808: -- WHERE mini_site_id = l_c_msite_id)
809: -- AND section_item_id NOT IN
810: -- (SELECT section_item_id FROM ibe_dsp_msite_sct_items
811: -- WHERE mini_site_id = l_c_msite_id)));

Line 822: FROM ibe_dsp_msite_sct_sects s1

818: FROM ibe_dsp_section_items idsi
819: WHERE section_id IN
820: (
821: SELECT child_section_id
822: FROM ibe_dsp_msite_sct_sects s1
823: WHERE mini_site_id = l_c_master_msite_id
824: AND NOT EXISTS
825: (
826: SELECT child_section_id

Line 827: FROM ibe_dsp_msite_sct_sects s2

823: WHERE mini_site_id = l_c_master_msite_id
824: AND NOT EXISTS
825: (
826: SELECT child_section_id
827: FROM ibe_dsp_msite_sct_sects s2
828: WHERE mini_site_id = l_c_msite_id
829: AND s2.child_section_id = s1.child_section_id
830: )
831: CONNECT BY PRIOR child_section_id = parent_section_id

Line 847: FROM ibe_dsp_msite_sct_sects s3,

843: AND i1.inventory_item_id = idsi.inventory_item_id
844: )
845: UNION
846: SELECT section_item_id, inventory_item_id
847: FROM ibe_dsp_msite_sct_sects s3,
848: ibe_dsp_section_items i2
849: WHERE i2.section_id = s3.child_section_id
850: AND s3.mini_site_id = l_c_msite_id
851: AND NOT EXISTS

Line 867: -- FROM ibe_dsp_msite_sct_sects s1

863: -- FROM ibe_dsp_section_items
864: -- WHERE section_id IN
865: -- (
866: -- SELECT child_section_id
867: -- FROM ibe_dsp_msite_sct_sects s1
868: -- WHERE mini_site_id = l_c_master_msite_id
869: -- AND NOT EXISTS
870: -- (
871: -- SELECT child_section_id

Line 872: -- FROM ibe_dsp_msite_sct_sects s2

868: -- WHERE mini_site_id = l_c_master_msite_id
869: -- AND NOT EXISTS
870: -- (
871: -- SELECT child_section_id
872: -- FROM ibe_dsp_msite_sct_sects s2
873: -- WHERE mini_site_id = l_c_msite_id
874: -- AND s2.child_section_id = s1.child_section_id
875: -- )
876: -- CONNECT BY PRIOR child_section_id = parent_section_id

Line 898: -- FROM ibe_dsp_msite_sct_sects

894: -- UNION
895: -- SELECT /*+ ordered use_nl(s3,i2) */ section_item_id
896: -- FROM (
897: -- SELECT child_section_id
898: -- FROM ibe_dsp_msite_sct_sects
899: -- WHERE mini_site_id = l_c_msite_id
900: -- ) s3,
901: -- ibe_dsp_section_items i2
902: -- WHERE i2.section_id = s3.child_section_id