APPS.IBE_SEARCH_SETUP_PVT dependencies on OE_SYSTEM_PARAMETERS_ALL

Line 364: from oe_system_parameters_all osp

360: b.organization_id = c.organization_id and
361: c.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID and
362: c.organization_id = a.organization_id and
363: exists (select 1
364: from oe_system_parameters_all osp
365: where osp.master_organization_id = b.organization_id));
366:
367: Elsif (l_search_category_set is null and
368: (l_search_web_status='PUBLISHED' or l_search_web_status is null))

Line 402: from oe_system_parameters_all osp

398: FROM mtl_system_items_b_kfv a,mtl_system_items_tl b,mtl_item_categories c
399: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and b.organization_id = c.organization_id
400: and c.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID and c.organization_id = a.organization_id
401: and exists ( select 1
402: from oe_system_parameters_all osp
403: where osp.master_organization_id = b.organization_id)
404: and a.web_status='PUBLISHED');
405:
406:

Line 441: from oe_system_parameters_all osp

437: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c
438: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and b.organization_id = c.organization_id
439: and c.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID and c.organization_id = a.organization_id
440: and exists ( select 1
441: from oe_system_parameters_all osp
442: where osp.master_organization_id = b.organization_id)
443: and a.web_status in ('PUBLISHED','UNPUBLISHED'));
444:
445:

Line 480: from oe_system_parameters_all osp

476: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c
477: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and b.organization_id = c.organization_id
478: and c.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID and c.organization_id = a.organization_id
479: and exists (select 1
480: from oe_system_parameters_all osp
481: where osp.master_organization_id = b.organization_id)
482: and c.category_set_id = l_search_category_set);
483:
484: Elsif (l_search_category_set is not null and

Line 519: from oe_system_parameters_all osp

515: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c
516: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and b.organization_id = c.organization_id
517: and c.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID and c.organization_id = a.organization_id
518: and exists (select 1
519: from oe_system_parameters_all osp
520: where osp.master_organization_id = b.organization_id)
521: and c.category_set_id = l_search_category_set
522: and a.web_status = 'PUBLISHED');
523:

Line 559: from oe_system_parameters_all osp

555: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c
556: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and b.organization_id = c.organization_id
557: and c.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID and c.organization_id = a.organization_id
558: and exists (select 1
559: from oe_system_parameters_all osp
560: where osp.master_organization_id = b.organization_id)
561: and c.category_set_id = l_search_category_set
562: and a.web_status IN ('PUBLISHED', 'UNPUBLISHED'));
563: