APPS.JTF_MINISITERUNTIME_PVT dependencies on JTF_DSP_SECTION_ITEMS

Line 187: || 'FROM jtf_dsp_section_items '

183: USING x_master_msite_id, l_msite_id, l_root_section_id,
184: x_master_msite_id, x_master_msite_id, x_master_msite_id;
185:
186: OPEN x_items_cur FOR 'SELECT inventory_item_id '
187: || 'FROM jtf_dsp_section_items '
188: || 'WHERE section_item_id IN '
189: || '(SELECT section_item_id FROM jtf_dsp_section_items '
190: || 'WHERE section_id IN '
191: || '(SELECT child_section_id FROM jtf_dsp_msite_sct_sects '

Line 189: || '(SELECT section_item_id FROM jtf_dsp_section_items '

185:
186: OPEN x_items_cur FOR 'SELECT inventory_item_id '
187: || 'FROM jtf_dsp_section_items '
188: || 'WHERE section_item_id IN '
189: || '(SELECT section_item_id FROM jtf_dsp_section_items '
190: || 'WHERE section_id IN '
191: || '(SELECT child_section_id FROM jtf_dsp_msite_sct_sects '
192: || 'WHERE mini_site_id = :master_mini_site_id '
193: || 'AND child_section_id NOT IN '

Line 339: -- FROM jtf_dsp_section_items

335: AND PRIOR mini_site_id = l_c_master_msite_id;
336:
337: -- Description of the SQL
338: -- IS SELECT inventory_item_id
339: -- FROM jtf_dsp_section_items
340: -- WHERE section_item_id IN
341: ---- Get all the section items for the excluded sections for the mini-site
342: ---- starting from mini-site's root section
343: -- (SELECT section_item_id FROM jtf_dsp_section_items

Line 343: -- (SELECT section_item_id FROM jtf_dsp_section_items

339: -- FROM jtf_dsp_section_items
340: -- WHERE section_item_id IN
341: ---- Get all the section items for the excluded sections for the mini-site
342: ---- starting from mini-site's root section
343: -- (SELECT section_item_id FROM jtf_dsp_section_items
344: -- WHERE section_id IN
345: -- (SELECT child_section_id FROM jtf_dsp_msite_sct_sects
346: -- WHERE mini_site_id = l_c_master_msite_id
347: -- AND child_section_id NOT IN

Line 369: FROM jtf_dsp_section_items

365: -- WHERE mini_site_id = l_c_msite_id)));
366:
367: CURSOR c2(l_c_master_msite_id IN NUMBER, l_c_msite_id IN NUMBER)
368: IS SELECT inventory_item_id
369: FROM jtf_dsp_section_items
370: WHERE section_item_id IN
371: (SELECT section_item_id FROM jtf_dsp_section_items
372: WHERE section_id IN
373: (SELECT child_section_id FROM jtf_dsp_msite_sct_sects

Line 371: (SELECT section_item_id FROM jtf_dsp_section_items

367: CURSOR c2(l_c_master_msite_id IN NUMBER, l_c_msite_id IN NUMBER)
368: IS SELECT inventory_item_id
369: FROM jtf_dsp_section_items
370: WHERE section_item_id IN
371: (SELECT section_item_id FROM jtf_dsp_section_items
372: WHERE section_id IN
373: (SELECT child_section_id FROM jtf_dsp_msite_sct_sects
374: WHERE mini_site_id = l_c_master_msite_id
375: AND child_section_id NOT IN