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_SECTION_ITEMS

Line 149: FROM ibe_dsp_section_items SI, mtl_system_items_vl MTL, fnd_lookups L

145: OPEN x_sectionitem_item_csr FOR SELECT MTL.inventory_item_id,
146: MTL.organization_id, MTL.concatenated_segments, MTL.description,
147: MTL.web_status, L.meaning, SI.section_item_id, SI.object_version_number,
148: SI.start_date_active, SI.end_date_active, SI.sort_order
149: FROM ibe_dsp_section_items SI, mtl_system_items_vl MTL, fnd_lookups L
150: WHERE SI.section_id = p_section_id
151: AND SI.inventory_item_id = MTL.inventory_item_id
152: AND SI.organization_id = MTL.organization_id
153: AND L.lookup_type = 'IBE_ITEM_STATUS'

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 1098: (SELECT section_item_id FROM ibe_dsp_section_items

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
1098: (SELECT section_item_id FROM ibe_dsp_section_items
1099: WHERE inventory_item_id = p_inventory_item_id
1100: AND organization_id = p_organization_id))
1101: ORDER BY msite_name;
1102:

Line 1113: (SELECT section_id FROM ibe_dsp_section_items

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
1114: WHERE inventory_item_id = p_inventory_item_id
1115: AND organization_id = p_organization_id))
1116: ORDER BY msite_name;
1117:

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 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 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 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 (+)