APPS.IBE_DSP_HIERARCHY_QUERY_PVT dependencies on IBE_MSITES_VL

Line 854: FROM ibe_msites_vl

850: --
851: -- Get included mini-sites for a section
852: --
853: OPEN x_incl_mini_site_csr FOR SELECT msite_id, msite_name, msite_description
854: FROM ibe_msites_vl
855: WHERE EXISTS
856: (SELECT mini_site_id FROM ibe_dsp_msite_sct_sects
857: WHERE mini_site_id = msite_id
858: AND mini_site_id <> l_master_mini_site_id

Line 873: FROM ibe_msites_vl

869: -- the section is the mini-site's root section
870: --
871: OPEN x_cndt_mini_site_csr FOR SELECT msite_id, msite_name,
872: msite_description
873: FROM ibe_msites_vl
874: WHERE msite_id <> l_master_mini_site_id AND
875: (msite_root_section_id = p_section_id OR
876: EXISTS (SELECT mini_site_id FROM ibe_dsp_msite_sct_sects
877: WHERE mini_site_id = msite_id

Line 889: FROM ibe_msites_vl

885: -- ibe_msites_b table for which the msite_root_section is null or the master root section id
886: --
887: OPEN x_cndt_mini_site_csr FOR SELECT msite_id, msite_name,
888: msite_description
889: FROM ibe_msites_vl
890: WHERE msite_id <> l_master_mini_site_id
891: --bug 3410883
892: AND (msite_root_section_id = l_master_root_section_id or msite_root_section_id is null)
893: AND site_type = 'I'

Line 1093: FROM ibe_msites_vl

1089: --
1090: -- Get included mini-sites for item
1091: --
1092: OPEN x_incl_mini_site_csr FOR SELECT msite_id, msite_name, msite_description
1093: FROM ibe_msites_vl
1094: WHERE EXISTS
1095: (SELECT mini_site_id FROM ibe_dsp_msite_sct_items
1096: WHERE mini_site_id = msite_id
1097: AND section_item_id IN

Line 1107: FROM ibe_msites_vl

1103: --
1104: -- Get candidate mini-sites for item
1105: --
1106: OPEN x_cndt_mini_site_csr FOR SELECT msite_id, msite_name, msite_description
1107: FROM ibe_msites_vl
1108: WHERE EXISTS
1109: (SELECT mini_site_id FROM ibe_dsp_msite_sct_sects
1110: WHERE mini_site_id = msite_id
1111: AND mini_site_id <> l_master_mini_site_id