APPS.OZF_SD_REQUEST_PUB dependencies on ENI_DENORM_HIERARCHIES

Line 410: FROM eni_denorm_hierarchies

406: FROM mtl_item_uoms_view a,
407: (SELECT inventory_item_id
408: FROM mtl_item_categories
409: WHERE category_id IN(SELECT child_id
410: FROM eni_denorm_hierarchies
411: WHERE parent_id = p_parent_id
412: AND organization_id = p_org_id)) b
413: WHERE a.organization_id = p_org_id
414: AND a.inventory_item_id = b.inventory_item_id

Line 479: FROM eni_denorm_hierarchies

475: CURSOR c_category_chk (p_category_id IN NUMBER) IS
476: SELECT 'Y'
477: FROM dual
478: WHERE EXISTS(SELECT 1
479: FROM eni_denorm_hierarchies
480: WHERE parent_id = p_category_id);
481:
482: BEGIN
483: l_uom_code := NULL;