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_SEARCH_SETUP_PVT dependencies on MTL_SYSTEM_ITEMS_TL

Line 246: FND_FILE.PUT_LINE(FND_FILE.LOG,' you have in mtl_system_items_tl table');

242: ----dbms_output.put_line(' Populating search table IBE_CT_IMEDIA_SEARCH');
243:
244: FND_FILE.PUT_LINE(FND_FILE.LOG,' Populating search table IBE_CT_IMEDIA_SEARCH');
245: FND_FILE.PUT_LINE(FND_FILE.LOG,' This may take a while depending on how many rows');
246: FND_FILE.PUT_LINE(FND_FILE.LOG,' you have in mtl_system_items_tl table');
247:
248: l_use_category_search := FND_PROFILE.VALUE_specific('IBE_USE_CATEGORY_SEARCH',671,0,671);
249:
250: /* Profile for fuzzy search is defaulted to 'No' so if found to be null

Line 317: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c

313: b.LONG_DESCRIPTION,
314: ibe_search_setup_pvt.WriteToLob(b.DESCRIPTION,b.LONG_DESCRIPTION,a.concatenated_segments),
315: a.web_status,
316: null
317: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c
318: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and
319: b.organization_id = c.organization_id and
320: c.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID and
321: c.organization_id = a.organization_id and

Line 357: FROM mtl_system_items_b_kfv a,mtl_system_items_tl b,mtl_item_categories c

353: b.LONG_DESCRIPTION,
354: ibe_search_setup_pvt.WriteToLob(b.DESCRIPTION,b.LONG_DESCRIPTION,a.concatenated_segments),
355: a.web_status,
356: null
357: FROM mtl_system_items_b_kfv a,mtl_system_items_tl b,mtl_item_categories c
358: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and b.organization_id = c.organization_id
359: and c.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID and c.organization_id = a.organization_id
360: and exists ( select 1
361: from oe_system_parameters_all osp

Line 396: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c

392: b.LONG_DESCRIPTION,
393: ibe_search_setup_pvt.WriteToLob(b.DESCRIPTION,b.LONG_DESCRIPTION,a.concatenated_segments),
394: a.web_status,
395: null
396: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c
397: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and b.organization_id = c.organization_id
398: and c.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID and c.organization_id = a.organization_id
399: and exists ( select 1
400: from oe_system_parameters_all osp

Line 435: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c

431: b.LONG_DESCRIPTION,
432: ibe_search_setup_pvt.WriteToLob(b.DESCRIPTION,b.LONG_DESCRIPTION,a.concatenated_segments),
433: a.web_status,
434: null
435: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c
436: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and b.organization_id = c.organization_id
437: and c.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID and c.organization_id = a.organization_id
438: and exists (select 1
439: from oe_system_parameters_all osp

Line 474: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c

470: b.LONG_DESCRIPTION,
471: ibe_search_setup_pvt.WriteToLob(b.DESCRIPTION,b.LONG_DESCRIPTION,a.concatenated_segments),
472: a.web_status,
473: null
474: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c
475: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and b.organization_id = c.organization_id
476: and c.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID and c.organization_id = a.organization_id
477: and exists (select 1
478: from oe_system_parameters_all osp

Line 514: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c

510: b.LONG_DESCRIPTION,
511: ibe_search_setup_pvt.WriteToLob(b.DESCRIPTION,b.LONG_DESCRIPTION,a.concatenated_segments),
512: a.web_status,
513: null
514: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c
515: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and b.organization_id = c.organization_id
516: and c.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID and c.organization_id = a.organization_id
517: and exists (select 1
518: from oe_system_parameters_all osp