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 FND_LOOKUPS

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 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 323: fnd_lookups L2

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
327: AND 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 344: fnd_lookups L2

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
348: AND L1.lookup_type = 'IBE_SECTION_TYPE'

Line 603: OPEN x_section_type_csr FOR SELECT lookup_code, meaning FROM fnd_lookups

599: x_section_path := '';
600: END;
601:
602: -- Get the 'list of section type' cursor
603: OPEN x_section_type_csr FOR SELECT lookup_code, meaning FROM fnd_lookups
604: WHERE lookup_type = 'IBE_SECTION_TYPE';
605:
606: -- Get the 'list of section type' cursor
607: OPEN x_section_status_csr FOR SELECT lookup_code, meaning FROM fnd_lookups

Line 607: OPEN x_section_status_csr FOR SELECT lookup_code, meaning FROM fnd_lookups

603: OPEN x_section_type_csr FOR SELECT lookup_code, meaning FROM fnd_lookups
604: WHERE lookup_type = 'IBE_SECTION_TYPE';
605:
606: -- Get the 'list of section type' cursor
607: OPEN x_section_status_csr FOR SELECT lookup_code, meaning FROM fnd_lookups
608: WHERE lookup_type = 'IBE_SECTION_STATUS';
609:
610: -- Get the deliverable list
611: -- bug 3610994

Line 983: OPEN x_web_status_type_csr FOR SELECT lookup_code, meaning FROM fnd_lookups

979: WHERE inventory_item_id = p_inventory_item_id
980: AND organization_id = p_organization_id;
981:
982: -- Get the 'list of item web status type' cursor
983: OPEN x_web_status_type_csr FOR SELECT lookup_code, meaning FROM fnd_lookups
984: WHERE lookup_type = 'IBE_ITEM_STATUS';
985:
986: EXCEPTION
987:

Line 1083: FROM mtl_system_items_vl MTL, fnd_lookups L

1079: OPEN x_inventory_item_csr FOR SELECT MTL.inventory_item_id,
1080: MTL.organization_id, MTL.web_status, L.meaning, MTL.description,
1081: MTL.concatenated_segments, MTL.creation_date, MTL.last_updated_by,
1082: MTL.last_update_login, MTL.last_update_date
1083: FROM mtl_system_items_vl MTL, fnd_lookups L
1084: WHERE MTL.inventory_item_id = p_inventory_item_id
1085: AND MTL.organization_id = p_organization_id
1086: AND L.lookup_type = 'IBE_ITEM_STATUS'
1087: AND L.lookup_code = MTL.web_status;

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