APPS.BIL_BI_UTIL_PKG dependencies on ENI_DENORM_HIERARCHIES

Line 1205: l_denorm := ',eni_denorm_hierarchies pcd, mtl_default_category_sets d ';

1201: AND pcd.object_type = ''CATEGORY_SET''
1202: AND pcd.object_id = d.category_set_id
1203: AND d.functional_area_id = 11
1204: AND pcd.dbi_flag = ''Y''';
1205: l_denorm := ',eni_denorm_hierarchies pcd, mtl_default_category_sets d ';
1206: ELSE
1207: l_product_where_clause := ' AND pcd.parent_id = :l_prodcat '||
1208: ' AND sumry.product_category_id = pcd.child_id ';
1209: l_denorm := ',ENI_ITEM_PROD_CAT_LOOKUP_V pcd ';

Line 1230: l_denorm := ',eni_denorm_hierarchies eni1, mtl_default_category_sets d ';

1226: AND eni1.object_id = d.category_set_id
1227: AND d.functional_area_id = 11
1228: AND eni1.dbi_flag = ''Y''
1229: AND eni1.parent_id = :l_prodcat ';
1230: l_denorm := ',eni_denorm_hierarchies eni1, mtl_default_category_sets d ';
1231: END IF;
1232:
1233: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1234:

Line 1518: FROM ENI_DENORM_HIERARCHIES A,

1514: /* Variable Intialization */
1515: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
1516:
1517: SELECT a.leaf_node_flag INTO leaf_node
1518: FROM ENI_DENORM_HIERARCHIES A,
1519: MTL_DEFAULT_CATEGORY_SETS B
1520: WHERE B.FUNCTIONAL_AREA_ID = 11
1521: AND A.OBJECT_TYPE = 'CATEGORY_SET'
1522: AND A.OBJECT_ID = B.CATEGORY_SET_ID