APPS.IBE_SEARCH_SETUP_PVT dependencies on OE_SYSTEM_PARAMETERS_ALL

Line 323: from oe_system_parameters_all osp

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
322: exists (select 1
323: from oe_system_parameters_all osp
324: where osp.master_organization_id = b.organization_id));
325:
326: Elsif (l_search_category_set is null and
327: (l_search_web_status='PUBLISHED' or l_search_web_status is null))

Line 361: from oe_system_parameters_all osp

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
362: where osp.master_organization_id = b.organization_id)
363: and a.web_status='PUBLISHED');
364:
365:

Line 400: from oe_system_parameters_all osp

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
401: where osp.master_organization_id = b.organization_id)
402: and a.web_status in ('PUBLISHED','UNPUBLISHED'));
403:
404:

Line 439: from oe_system_parameters_all osp

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
440: where osp.master_organization_id = b.organization_id)
441: and c.category_set_id = l_search_category_set);
442:
443: Elsif (l_search_category_set is not null and

Line 478: from oe_system_parameters_all osp

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
479: where osp.master_organization_id = b.organization_id)
480: and c.category_set_id = l_search_category_set
481: and a.web_status = 'PUBLISHED');
482:

Line 518: from oe_system_parameters_all osp

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
519: where osp.master_organization_id = b.organization_id)
520: and c.category_set_id = l_search_category_set
521: and a.web_status IN ('PUBLISHED', 'UNPUBLISHED'));
522: