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_DSP_HIERARCHY_QUERY_PVT dependencies on IBE_DSP_MSITE_SCT_SECTS

Line 62: 'FROM ibe_dsp_msite_sct_sects JDMSS ' ||

58: -- Open a cursor that retrieves the sections path from the root section
59: -- to p_object_id's immediate parent, in the reverse order
60: OPEN l_section_path_csr FOR
61: 'SELECT JDMSS.parent_section_id ' ||
62: 'FROM ibe_dsp_msite_sct_sects JDMSS ' ||
63: 'START WITH JDMSS.child_section_id = :section_id ' ||
64: 'AND JDMSS.mini_site_id = :master_mini_site_id1 ' ||
65: 'CONNECT BY JDMSS.child_section_id = PRIOR JDMSS.parent_section_id ' ||
66: 'AND JDMSS.mini_site_id = :master_mini_site_id2 ' ||

Line 322: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS, fnd_lookups L1,

318: OPEN x_section_section_csr FOR SELECT S.section_id, S.access_name,
319: S.display_name, S.section_type_code, L1.meaning, S.status_code, L2.meaning,
320: MSS.mini_site_section_section_id, MSS.object_version_number,
321: MSS.start_date_active, MSS.end_date_active, MSS.sort_order
322: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS, fnd_lookups L1,
323: fnd_lookups L2
324: WHERE S.section_id IN
325: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
326: WHERE parent_section_id = p_section_id

Line 325: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

321: MSS.start_date_active, MSS.end_date_active, MSS.sort_order
322: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS, fnd_lookups L1,
323: fnd_lookups L2
324: WHERE S.section_id IN
325: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
326: WHERE parent_section_id = p_section_id
327: AND mini_site_id = l_master_mini_site_id)
328: AND MSS.child_section_id = S.section_id
329: AND MSS.mini_site_id = l_master_mini_site_id

Line 343: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS, fnd_lookups L1,

339: OPEN x_section_section_csr FOR SELECT S.section_id, S.access_name,
340: S.display_name, S.section_type_code, L1.meaning, S.status_code, L2.meaning,
341: MSS.mini_site_section_section_id, MSS.object_version_number,
342: MSS.start_date_active, MSS.end_date_active, MSS.sort_order
343: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS, fnd_lookups L1,
344: fnd_lookups L2
345: WHERE MSS.parent_section_id = p_section_id
346: AND MSS.child_section_id = S.section_id
347: AND MSS.mini_site_id = l_master_mini_site_id

Line 427: SELECT rowid FROM ibe_dsp_msite_sct_sects

423: l_row_id VARCHAR2(30);
424:
425: -- Check if l_c_section_id has child sections
426: CURSOR c1(l_c_section_id IN NUMBER, l_c_master_mini_site_id IN NUMBER) IS
427: SELECT rowid FROM ibe_dsp_msite_sct_sects
428: WHERE mini_site_id = l_c_master_mini_site_id
429: AND parent_section_id = l_c_section_id;
430:
431: BEGIN

Line 792: IS SELECT parent_section_id FROM ibe_dsp_msite_sct_sects

788: l_master_root_section_id NUMBER;
789: l_parent_section_id NUMBER;
790:
791: CURSOR c1(l_c_section_id IN NUMBER, l_c_master_mini_site_id IN NUMBER)
792: IS SELECT parent_section_id FROM ibe_dsp_msite_sct_sects
793: WHERE mini_site_id = l_c_master_mini_site_id
794: AND child_section_id = l_c_section_id;
795:
796: BEGIN

Line 856: (SELECT mini_site_id FROM ibe_dsp_msite_sct_sects

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
859: AND child_section_id = p_section_id)
860: ORDER BY msite_name;

Line 876: EXISTS (SELECT mini_site_id FROM ibe_dsp_msite_sct_sects

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
878: AND mini_site_id <> l_master_mini_site_id
879: AND child_section_id = l_parent_section_id))
880: ORDER BY msite_name;

Line 1109: (SELECT mini_site_id FROM ibe_dsp_msite_sct_sects

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
1112: AND child_section_id IN
1113: (SELECT section_id FROM ibe_dsp_section_items

Line 1292: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS ,fnd_lookups fl,

1288: /*SELECT DISTINCT mss.parent_section_id,mss.child_section_id,
1289: s.display_name, mss.concat_ids, fl.meaning,s.status_code, s.start_date_active,
1290: child_sct.parent_section_id subsections,child_item.section_id products,
1291: s.section_type_code, fl1.meaning status_name,s.access_name,MSS.level_number
1292: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS ,fnd_lookups fl,
1293: fnd_lookups fl1, ibe_dsp_msite_sct_sects child_sct,ibe_dsp_section_items child_item
1294: WHERE S.section_id = MSS.child_section_id AND fl.lookup_code=s.section_type_code
1295: and fl.lookup_type= 'IBE_SECTION_TYPE' AND fl1.lookup_code=s.status_code
1296: AND fl1.lookup_type= 'IBE_SECTION_STATUS' AND fl.enabled_flag = fl1.enabled_flag

Line 1293: fnd_lookups fl1, ibe_dsp_msite_sct_sects child_sct,ibe_dsp_section_items child_item

1289: s.display_name, mss.concat_ids, fl.meaning,s.status_code, s.start_date_active,
1290: child_sct.parent_section_id subsections,child_item.section_id products,
1291: s.section_type_code, fl1.meaning status_name,s.access_name,MSS.level_number
1292: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS ,fnd_lookups fl,
1293: fnd_lookups fl1, ibe_dsp_msite_sct_sects child_sct,ibe_dsp_section_items child_item
1294: WHERE S.section_id = MSS.child_section_id AND fl.lookup_code=s.section_type_code
1295: and fl.lookup_type= 'IBE_SECTION_TYPE' AND fl1.lookup_code=s.status_code
1296: AND fl1.lookup_type= 'IBE_SECTION_STATUS' AND fl.enabled_flag = fl1.enabled_flag
1297: AND MSS.mini_site_id = p_msite_id AND s.section_id = child_sct.parent_section_id (+)

Line 1307: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS ,

1303: SELECT DISTINCT mss.parent_section_id,mss.child_section_id,
1304: s.display_name, mss.concat_ids, s.status_code,s.start_date_active,
1305: child_sct.parent_section_id subsections,child_item.section_id products,
1306: s.section_type_code, s.access_name,MSS.level_number
1307: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS ,
1308: ibe_dsp_msite_sct_sects child_sct,ibe_dsp_section_items child_item
1309: WHERE S.section_id = MSS.child_section_id
1310: AND MSS.mini_site_id = p_msite_id AND s.section_id = child_sct.parent_section_id (+)
1311: AND child_sct.mini_site_id (+) = p_msite_id

Line 1308: ibe_dsp_msite_sct_sects child_sct,ibe_dsp_section_items child_item

1304: s.display_name, mss.concat_ids, s.status_code,s.start_date_active,
1305: child_sct.parent_section_id subsections,child_item.section_id products,
1306: s.section_type_code, s.access_name,MSS.level_number
1307: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS ,
1308: ibe_dsp_msite_sct_sects child_sct,ibe_dsp_section_items child_item
1309: WHERE S.section_id = MSS.child_section_id
1310: AND MSS.mini_site_id = p_msite_id AND s.section_id = child_sct.parent_section_id (+)
1311: AND child_sct.mini_site_id (+) = p_msite_id
1312: AND s.section_id = child_item.section_id (+)

Line 1319: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS

1315: */
1316: SELECT DISTINCT mss.parent_section_id,mss.child_section_id,
1317: s.display_name, mss.concat_ids, s.status_code,s.start_date_active,
1318: s.section_type_code, s.access_name,MSS.level_number
1319: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS
1320: WHERE S.section_id = MSS.child_section_id
1321: AND MSS.mini_site_id = p_msite_id
1322: AND mss.level_number <= p_level_number
1323: ORDER BY MSS.level_number, mss.parent_section_id,s.display_name;

Line 1332: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS ,fnd_lookups fl,

1328: /* SELECT DISTINCT mss.parent_section_id,mss.child_section_id,
1329: s.display_name, mss.concat_ids, fl.meaning,s.status_code, s.start_date_active,
1330: child_sct.parent_section_id subsections,child_item.section_id products,
1331: s.section_type_code, fl1.meaning status_name,s.access_name,MSS.level_number
1332: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS ,fnd_lookups fl,
1333: fnd_lookups fl1, ibe_dsp_msite_sct_sects child_sct,ibe_dsp_section_items child_item
1334: WHERE S.section_id = MSS.child_section_id AND fl.lookup_code=s.section_type_code
1335: and fl.lookup_type= 'IBE_SECTION_TYPE' AND fl1.lookup_code=s.status_code
1336: AND fl1.lookup_type= 'IBE_SECTION_STATUS' AND fl.enabled_flag = fl1.enabled_flag

Line 1333: fnd_lookups fl1, ibe_dsp_msite_sct_sects child_sct,ibe_dsp_section_items child_item

1329: s.display_name, mss.concat_ids, fl.meaning,s.status_code, s.start_date_active,
1330: child_sct.parent_section_id subsections,child_item.section_id products,
1331: s.section_type_code, fl1.meaning status_name,s.access_name,MSS.level_number
1332: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS ,fnd_lookups fl,
1333: fnd_lookups fl1, ibe_dsp_msite_sct_sects child_sct,ibe_dsp_section_items child_item
1334: WHERE S.section_id = MSS.child_section_id AND fl.lookup_code=s.section_type_code
1335: and fl.lookup_type= 'IBE_SECTION_TYPE' AND fl1.lookup_code=s.status_code
1336: AND fl1.lookup_type= 'IBE_SECTION_STATUS' AND fl.enabled_flag = fl1.enabled_flag
1337: AND MSS.mini_site_id = p_msite_id AND s.section_id = child_sct.parent_section_id (+)

Line 1346: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS ,

1342: SELECT DISTINCT mss.parent_section_id,mss.child_section_id,
1343: s.display_name, mss.concat_ids, s.status_code,s.start_date_active,
1344: child_sct.parent_section_id subsections,child_item.section_id products,
1345: s.section_type_code, s.access_name,MSS.level_number
1346: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS ,
1347: ibe_dsp_msite_sct_sects child_sct,ibe_dsp_section_items child_item
1348: WHERE S.section_id = MSS.child_section_id
1349: AND MSS.mini_site_id = p_msite_id AND s.section_id = child_sct.parent_section_id (+)
1350: AND child_sct.mini_site_id (+) = p_msite_id

Line 1347: ibe_dsp_msite_sct_sects child_sct,ibe_dsp_section_items child_item

1343: s.display_name, mss.concat_ids, s.status_code,s.start_date_active,
1344: child_sct.parent_section_id subsections,child_item.section_id products,
1345: s.section_type_code, s.access_name,MSS.level_number
1346: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS ,
1347: ibe_dsp_msite_sct_sects child_sct,ibe_dsp_section_items child_item
1348: WHERE S.section_id = MSS.child_section_id
1349: AND MSS.mini_site_id = p_msite_id AND s.section_id = child_sct.parent_section_id (+)
1350: AND child_sct.mini_site_id (+) = p_msite_id
1351: AND s.section_id = child_item.section_id (+)

Line 1357: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS

1353: */
1354: SELECT DISTINCT mss.parent_section_id,mss.child_section_id,
1355: s.display_name, mss.concat_ids, s.status_code,s.start_date_active,
1356: s.section_type_code, s.access_name,MSS.level_number
1357: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS
1358: WHERE S.section_id = MSS.child_section_id
1359: AND MSS.mini_site_id = p_msite_id
1360: ORDER BY MSS.level_number, mss.parent_section_id,s.display_name;
1361: