APPS.IBE_MINISITERUNTIME_PVT dependencies on IBE_DSP_MSITE_SCT_ITEMS

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 118: FROM ibe_dsp_msite_sct_items i3

114: AND s3.mini_site_id = l_c_msite_id
115: AND NOT EXISTS
116: (
117: SELECT null
118: FROM ibe_dsp_msite_sct_items i3
119: WHERE mini_site_id = l_c_msite_id
120: AND i3.section_item_id = i2.section_item_id
121: )
122: );

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 508: || ' FROM ibe_dsp_msite_sct_items i3 '

504: || ' WHERE i2.section_id = s3.child_section_id '
505: || ' AND NOT EXISTS '
506: || ' ( '
507: || ' SELECT null '
508: || ' FROM ibe_dsp_msite_sct_items i3 '
509: || ' WHERE mini_site_id = :l_c_msite_id '
510: || ' AND i3.section_item_id = i2.section_item_id '
511: || ' ) '
512: || ' ) v1, '

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

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))) '
539: -- USING x_master_msite_id, l_msite_id, l_root_section_id,
540: -- x_master_msite_id, x_master_msite_id, x_master_msite_id,
541: -- l_msite_id, l_msite_id;

Line 782: -- (SELECT section_item_id FROM ibe_dsp_msite_sct_items

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)));
784:
785: --
786: -- Changing the cursor to new cursor based on new performance query

Line 810: -- (SELECT section_item_id FROM ibe_dsp_msite_sct_items

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)));
812:
813: CURSOR c2(l_c_master_msite_id IN NUMBER, l_c_msite_id IN NUMBER,
814: l_root_section_id IN NUMBER) IS

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 854: FROM ibe_dsp_msite_sct_items i3

850: AND s3.mini_site_id = l_c_msite_id
851: AND NOT EXISTS
852: (
853: SELECT null
854: FROM ibe_dsp_msite_sct_items i3
855: WHERE mini_site_id = l_c_msite_id
856: AND i3.section_item_id = i2.section_item_id
857: )
858: );

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 906: -- FROM ibe_dsp_msite_sct_items i3

902: -- WHERE i2.section_id = s3.child_section_id
903: -- AND NOT EXISTS
904: -- (
905: -- SELECT null
906: -- FROM ibe_dsp_msite_sct_items i3
907: -- WHERE mini_site_id = l_c_msite_id
908: -- AND i3.section_item_id = i2.section_item_id
909: -- )
910: -- ) v1,