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.JTF_MINISITERUNTIME_PVT dependencies on JTF_DSP_MSITE_SCT_SECTS

Line 172: || 'FROM jtf_dsp_msite_sct_sects '

168: IF (l_exclude_flag = 'Y')
169: THEN
170:
171: OPEN x_sections_cur FOR 'SELECT child_section_id '
172: || 'FROM jtf_dsp_msite_sct_sects '
173: || 'WHERE mini_site_id = :master_mini_site_id AND '
174: || 'sysdate BETWEEN start_date_active AND NVL(end_date_active,sysdate) '
175: || 'AND child_section_id NOT IN '
176: || '(SELECT child_section_id FROM jtf_dsp_msite_sct_sects '

Line 176: || '(SELECT child_section_id FROM jtf_dsp_msite_sct_sects '

172: || 'FROM jtf_dsp_msite_sct_sects '
173: || 'WHERE mini_site_id = :master_mini_site_id AND '
174: || 'sysdate BETWEEN start_date_active AND NVL(end_date_active,sysdate) '
175: || 'AND child_section_id NOT IN '
176: || '(SELECT child_section_id FROM jtf_dsp_msite_sct_sects '
177: || 'WHERE mini_site_id = :msite_id) '
178: || 'START WITH child_section_id = :root_section_id '
179: || 'AND mini_site_id = :master_mini_site_id '
180: || 'CONNECT BY PRIOR child_section_id = parent_section_id '

Line 191: || '(SELECT child_section_id FROM jtf_dsp_msite_sct_sects '

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 '
194: || '(SELECT child_section_id FROM jtf_dsp_msite_sct_sects '
195: || 'WHERE mini_site_id = :msite_id) '

Line 194: || '(SELECT child_section_id FROM jtf_dsp_msite_sct_sects '

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 '
194: || '(SELECT child_section_id FROM jtf_dsp_msite_sct_sects '
195: || 'WHERE mini_site_id = :msite_id) '
196: || 'START WITH child_section_id = :root_section_id '
197: || 'AND mini_site_id = :master_mini_site_id '
198: || 'CONNECT BY PRIOR child_section_id = parent_section_id '

Line 202: || '(SELECT child_section_id FROM jtf_dsp_msite_sct_sects '

198: || 'CONNECT BY PRIOR child_section_id = parent_section_id '
199: || 'AND PRIOR mini_site_id = :master_mini_site_id '
200: || 'AND mini_site_id = :master_mini_site_id) '
201: || 'OR (section_id IN '
202: || '(SELECT child_section_id FROM jtf_dsp_msite_sct_sects '
203: || 'WHERE mini_site_id = :msite_id) '
204: || 'AND section_item_id NOT IN '
205: || '(SELECT section_item_id FROM jtf_dsp_msite_sct_items '
206: || 'WHERE mini_site_id = :msite_id))) '

Line 323: FROM jtf_dsp_msite_sct_sects

319: l_index BINARY_INTEGER;
320:
321: CURSOR c1(l_c_master_msite_id IN NUMBER, l_c_msite_id IN NUMBER)
322: IS SELECT child_section_id
323: FROM jtf_dsp_msite_sct_sects
324: WHERE mini_site_id = l_c_master_msite_id AND
325: sysdate BETWEEN start_date_active AND NVL(end_date_active,sysdate)
326: AND child_section_id NOT IN
327: (SELECT child_section_id FROM jtf_dsp_msite_sct_sects

Line 327: (SELECT child_section_id FROM jtf_dsp_msite_sct_sects

323: FROM jtf_dsp_msite_sct_sects
324: WHERE mini_site_id = l_c_master_msite_id AND
325: sysdate BETWEEN start_date_active AND NVL(end_date_active,sysdate)
326: AND child_section_id NOT IN
327: (SELECT child_section_id FROM jtf_dsp_msite_sct_sects
328: WHERE mini_site_id = l_c_msite_id)
329: START WITH child_section_id =
330: (SELECT msite_root_section_id FROM jtf_msites_b
331: WHERE msite_id = l_c_msite_id)

Line 345: -- (SELECT child_section_id FROM jtf_dsp_msite_sct_sects

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
348: -- (SELECT child_section_id FROM jtf_dsp_msite_sct_sects
349: -- WHERE mini_site_id = l_c_msite_id)

Line 348: -- (SELECT child_section_id FROM jtf_dsp_msite_sct_sects

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
348: -- (SELECT child_section_id FROM jtf_dsp_msite_sct_sects
349: -- WHERE mini_site_id = l_c_msite_id)
350: -- START WITH child_section_id =
351: -- (SELECT msite_root_section_id FROM jtf_msites_b
352: -- WHERE msite_id = l_c_msite_id)

Line 361: -- (SELECT child_section_id FROM jtf_dsp_msite_sct_sects

357: ---- Get all the section items for the included sections for the mini-site
358: ---- starting from mini-site's root section, but the section-items themselves
359: ---- are excluded.
360: -- OR (section_id IN
361: -- (SELECT child_section_id FROM jtf_dsp_msite_sct_sects
362: -- WHERE mini_site_id = l_c_msite_id)
363: -- AND section_item_id NOT IN
364: -- (SELECT section_item_id FROM jtf_dsp_msite_sct_items
365: -- WHERE mini_site_id = l_c_msite_id)));

Line 373: (SELECT child_section_id FROM jtf_dsp_msite_sct_sects

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
376: (SELECT child_section_id FROM jtf_dsp_msite_sct_sects
377: WHERE mini_site_id = l_c_msite_id)

Line 376: (SELECT child_section_id FROM jtf_dsp_msite_sct_sects

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
376: (SELECT child_section_id FROM jtf_dsp_msite_sct_sects
377: WHERE mini_site_id = l_c_msite_id)
378: START WITH child_section_id =
379: (SELECT msite_root_section_id FROM jtf_msites_b
380: WHERE msite_id = l_c_msite_id)

Line 386: (SELECT child_section_id FROM jtf_dsp_msite_sct_sects

382: CONNECT BY PRIOR child_section_id = parent_section_id
383: AND PRIOR mini_site_id = l_c_master_msite_id
384: AND mini_site_id = l_c_master_msite_id)
385: OR (section_id IN
386: (SELECT child_section_id FROM jtf_dsp_msite_sct_sects
387: WHERE mini_site_id = l_c_msite_id)
388: AND section_item_id NOT IN
389: (SELECT section_item_id FROM jtf_dsp_msite_sct_items
390: WHERE mini_site_id = l_c_msite_id)));