APPS.IBE_BI_PROD_CATG_PVT dependencies on ENI_ITEM_PROD_CAT_LOOKUP_V

Line 15: FROM eni_item_prod_cat_lookup_v --4776922

11: IS L_LEAF_node VARCHAR2(1);
12: BEGIN
13:
14: SELECT DISTINCT LEAF_NODE_FLAG INTO L_LEAF_NODE
15: FROM eni_item_prod_cat_lookup_v --4776922
16: WHERE ID = replace(l_Category_ID,'''','')
17: AND ID = PARENT_ID;
18:
19: IF(l_leaf_node = 'Y') THEN

Line 253: ' eni_item_prod_cat_lookup_v eip';

249: IF l_view_by ='ITEM+ENI_ITEM_VBH_CAT' THEN --View by is Prodcut Category
250:
251: l_from := l_from ||' eni_denorm_hierarchies edh,'||
252: ' mtl_default_category_sets mdc,'||
253: ' eni_item_prod_cat_lookup_v eip';
254:
255: l_where := l_where ||' AND prod_mv.category_id = edh.child_id '||
256: ' AND edh.object_type = ''CATEGORY_SET'' '||
257: ' AND edh.object_id = mdc.category_set_id '||

Line 301: l_from := l_from || ' ,eni_item_prod_cat_lookup_v eip ';

297: IF UPPER(l_category_id) <> 'ALL' THEN
298: IF (l_view_by = 'ITEM+ENI_ITEM_VBH_CAT') THEN
299: l_where := l_where ||' and edh.parent_id =(&ITEM+ENI_ITEM_VBH_CAT)';
300: ELSIF (l_view_by ='IBW_WEB_ANALYTICS_GROUP1+ENI_ITEM' ) THEN
301: l_from := l_from || ' ,eni_item_prod_cat_lookup_v eip ';
302: l_where := l_where ||' and item.vbh_category_id=eip.child_id '||
303: ' and eip.parent_id =(&ITEM+ENI_ITEM_VBH_CAT)';
304: END IF;
305: END IF;