DBA Data[Home] [Help]

APPS.IBE_SEARCH_SETUP_PVT dependencies on MTL_ITEM_CATEGORIES

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