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_SECTIONS_VL

Line 77: FROM ibe_dsp_sections_vl JDSV

73: EXIT WHEN l_section_path_csr%NOTFOUND;
74:
75: SELECT JDSV.display_name
76: INTO l_section_disp_name
77: FROM ibe_dsp_sections_vl JDSV
78: WHERE JDSV.section_id = l_section_id;
79:
80: l_display_name := l_section_disp_name || '/' || l_display_name;
81:

Line 88: FROM ibe_dsp_sections_vl JDSV

84: CLOSE l_section_path_csr;
85:
86: SELECT JDSV.display_name
87: INTO l_section_disp_name
88: FROM ibe_dsp_sections_vl JDSV
89: WHERE JDSV.section_id = p_object_id;
90:
91: l_display_name := l_display_name || l_section_disp_name;
92:

Line 133: OPEN x_section_csr FOR SELECT display_name FROM ibe_dsp_sections_vl

129: -- Initialize API return status to success
130: x_return_status := FND_API.G_RET_STS_SUCCESS;
131:
132: -- Get the section data
133: OPEN x_section_csr FOR SELECT display_name FROM ibe_dsp_sections_vl
134: WHERE section_id = p_section_id;
135: /* bug fix 4864940 */
136: l_organization_id_str
137: := FND_PROFILE.VALUE_SPECIFIC('IBE_ITEM_VALIDATION_ORGANIZATION',null,null,671);

Line 230: FROM ibe_dsp_sections_vl S, ibe_dsp_section_items SI

226: -- Get the section-item data and section data
227: OPEN x_sectionitem_section_csr FOR SELECT S.section_id, S.display_name,
228: SI.section_item_id, SI.object_version_number, SI.start_date_active,
229: SI.end_date_active, SI.sort_order
230: FROM ibe_dsp_sections_vl S, ibe_dsp_section_items SI
231: WHERE SI.inventory_item_id = p_inventory_item_id
232: AND SI.organization_id = p_organization_id
233: AND SI.section_id = S.section_id;
234:

Line 313: OPEN x_section_csr FOR SELECT display_name FROM ibe_dsp_sections_vl

309: x_root_section_id => l_master_root_section_id
310: );
311:
312: -- Get the (parent) section data
313: OPEN x_section_csr FOR SELECT display_name FROM ibe_dsp_sections_vl
314: WHERE section_id = p_section_id;
315:
316: -- Get the section-(child)section association data and child-section data
317: /*

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 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 591: FROM ibe_dsp_sections_vl

587: display_name, access_name, section_type_code, status_code,
588: start_date_active, end_date_active, description, long_description,
589: keywords, deliverable_id, display_context_id, auto_placement_rule,
590: order_by_clause
591: FROM ibe_dsp_sections_vl
592: WHERE section_id = p_section_id;
593:
594: -- Get the section path
595: BEGIN

Line 839: FROM ibe_dsp_sections_vl

835: -- Get the section data for p_section_id
836: --
837: OPEN x_section_csr FOR SELECT section_id, object_version_number,
838: display_name, available_in_all_sites_flag
839: FROM ibe_dsp_sections_vl
840: WHERE section_id = p_section_id;
841:
842: -- Get the section path
843: BEGIN

Line 1204: from ibe_dsp_sections_vl where section_id=p_section_id;

1200: l_master_root_section_id NUMBER;
1201:
1202: Cursor c1( p_section_id IN NUMBER) is
1203: select display_name,description
1204: from ibe_dsp_sections_vl where section_id=p_section_id;
1205:
1206:
1207: BEGIN
1208:

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 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 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 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 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: