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 82: FROM ibe_dsp_section_items idsi

78: l_root_section_id IN NUMBER) IS
79: SELECT /*+ first_rows */ inventory_item_id
80: FROM (
81: SELECT section_item_id, inventory_item_id
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

Line 104: FROM ibe_dsp_section_items i1, ibe_dsp_msite_sct_items i2

100: )
101: AND NOT EXISTS
102: (
103: SELECT inventory_item_id
104: FROM ibe_dsp_section_items i1, ibe_dsp_msite_sct_items i2
105: WHERE i1.section_item_id = i2.section_item_id
106: AND i2.mini_site_id = l_c_msite_id
107: AND i1.inventory_item_id = idsi.inventory_item_id
108: )

Line 112: ibe_dsp_section_items i2

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
116: (

Line 465: || ' FROM ibe_dsp_section_items '

461:
462: OPEN x_items_cur FOR 'SELECT /*+ first_rows */ inventory_item_id '
463: || 'FROM ( '
464: || ' SELECT section_item_id '
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 '

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

488: || ' ) '
489: || ' AND inventory_item_id NOT IN '
490: || ' ( '
491: || ' SELECT inventory_item_id '
492: || ' FROM ibe_dsp_section_items i1, ibe_dsp_msite_sct_items i2 '
493: || ' WHERE i1.section_item_id = i2.section_item_id '
494: || ' AND i2.mini_site_id = :l_c_msite_id '
495: || ' ) '
496: || ' UNION '

Line 503: || ' ibe_dsp_section_items i2 '

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 '
505: || ' AND NOT EXISTS '
506: || ' ( '
507: || ' SELECT null '

Line 513: || ' ibe_dsp_section_items i0 '

509: || ' WHERE mini_site_id = :l_c_msite_id '
510: || ' AND i3.section_item_id = i2.section_item_id '
511: || ' ) '
512: || ' ) v1, '
513: || ' ibe_dsp_section_items i0 '
514: || 'WHERE i0.section_item_id = v1.section_item_id'
515: USING x_master_msite_id, l_msite_id, x_master_msite_id, x_master_msite_id,
516: l_msite_id, x_master_msite_id, l_msite_id, l_msite_id, l_msite_id;
517:

Line 519: -- || 'FROM ibe_dsp_section_items '

515: USING x_master_msite_id, l_msite_id, x_master_msite_id, x_master_msite_id,
516: l_msite_id, x_master_msite_id, l_msite_id, l_msite_id, l_msite_id;
517:
518: -- OPEN x_items_cur FOR 'SELECT inventory_item_id '
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 '

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

517:
518: -- OPEN x_items_cur FOR 'SELECT inventory_item_id '
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 '

Line 757: -- FROM ibe_dsp_section_items

753: AND PRIOR mini_site_id = l_c_master_msite_id;
754:
755: -- Description of the SQL
756: -- IS SELECT inventory_item_id
757: -- FROM ibe_dsp_section_items
758: -- WHERE section_item_id IN
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

Line 761: -- (SELECT section_item_id FROM ibe_dsp_section_items

757: -- FROM ibe_dsp_section_items
758: -- WHERE section_item_id IN
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

Line 790: -- FROM ibe_dsp_section_items

786: -- Changing the cursor to new cursor based on new performance query
787: --
788: -- CURSOR c2(l_c_master_msite_id IN NUMBER, l_c_msite_id IN NUMBER)
789: -- IS SELECT inventory_item_id
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

Line 792: -- (SELECT section_item_id FROM ibe_dsp_section_items

788: -- CURSOR c2(l_c_master_msite_id IN NUMBER, l_c_msite_id IN NUMBER)
789: -- IS SELECT inventory_item_id
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

Line 818: FROM ibe_dsp_section_items idsi

814: l_root_section_id IN NUMBER) IS
815: SELECT /*+ first_rows */ inventory_item_id
816: FROM (
817: SELECT section_item_id, inventory_item_id
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

Line 840: FROM ibe_dsp_section_items i1, ibe_dsp_msite_sct_items i2

836: )
837: AND NOT EXISTS
838: (
839: SELECT inventory_item_id
840: FROM ibe_dsp_section_items i1, ibe_dsp_msite_sct_items i2
841: WHERE i1.section_item_id = i2.section_item_id
842: AND i2.mini_site_id = l_c_msite_id
843: AND i1.inventory_item_id = idsi.inventory_item_id
844: )

Line 848: ibe_dsp_section_items i2

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
852: (

Line 863: -- FROM ibe_dsp_section_items

859:
860: -- SELECT /*+ first_rows */ inventory_item_id
861: -- FROM (
862: -- SELECT section_item_id
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

Line 890: -- FROM ibe_dsp_section_items i1, ibe_dsp_msite_sct_items i2

886: -- )
887: -- AND inventory_item_id NOT IN
888: -- (
889: -- SELECT inventory_item_id
890: -- FROM ibe_dsp_section_items i1, ibe_dsp_msite_sct_items i2
891: -- WHERE i1.section_item_id = i2.section_item_id
892: -- AND i2.mini_site_id = l_c_msite_id
893: -- )
894: -- UNION

Line 901: -- ibe_dsp_section_items i2

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
903: -- AND NOT EXISTS
904: -- (
905: -- SELECT null

Line 911: -- ibe_dsp_section_items i0

907: -- WHERE mini_site_id = l_c_msite_id
908: -- AND i3.section_item_id = i2.section_item_id
909: -- )
910: -- ) v1,
911: -- ibe_dsp_section_items i0
912: -- WHERE i0.section_item_id = v1.section_item_id;
913:
914: CURSOR c3
915: IS SELECT msite_id FROM ibe_msites_b