eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENI_DBI_PRC_PKG dependencies on ENI_DENORM_HIERARCHIES

Line 119: from eni_denorm_hierarchies edh

115:
116: IF (l_category1 IS NOT NULL) THEN
117: select top_node_flag,leaf_node_flag
118: into top_flag,leaf_flag
119: from eni_denorm_hierarchies edh
120: where edh.parent_id = l_category1
121: and edh.child_id = edh.parent_id;
122:
123: IF (top_flag = 'Y' and leaf_flag = 'Y') THEN

Line 197: l_from_clause := ' eni_dbi_prc_sum1_mv edps1mv , eni_denorm_hierarchies edh';

193:
194: ELSIF (l_item IS NOT NULL AND l_category IS NULL) THEN
195:
196: l_summary := 'edps1mv';
197: l_from_clause := ' eni_dbi_prc_sum1_mv edps1mv , eni_denorm_hierarchies edh';
198: l_where_clause := ' AND edps1mv.item_org_id IN ('|| '&' || 'ITEM+ENI_ITEM)' ||
199: ' AND edh.top_node_flag = ''Y'' ' ||
200: ' AND edps1mv.product_category_id = edh.child_id ' ||
201: ' AND vbh.id = edh.imm_child_id ' ||

Line 433: l_from_clause := ' eni_dbi_prc_sum1_mv edps1mv, eni_denorm_hierarchies edh ';

429: IF (l_item IS NULL AND l_category IS NULL) THEN
430: l_from_clause := ' eni_dbi_prc_sum1_mv edps1mv ';
431: l_where_clause :='';
432: ELSIF (l_item IS NULL AND l_category IS NOT NULL) THEN
433: l_from_clause := ' eni_dbi_prc_sum1_mv edps1mv, eni_denorm_hierarchies edh ';
434: l_where_clause := ' AND edh.parent_id = :PRODUCT_CATEGORY ' ||
435: ' AND edps1mv.product_category_id = edh.child_id ';-- ||
436: --' AND edps1mv.inventory_item_id = eiv.inventory_item_id ' ||
437: --' AND edps1mv.organization_id = eiv.organization_id ';

Line 444: l_from_clause := ' eni_dbi_prc_sum1_mv edps1mv, eni_denorm_hierarchies edh ';

440: l_where_clause := ' AND edps1mv.item_org_id IN ('|| '&' || 'ITEM+ENI_ITEM)' ;--||
441: --' AND edps1mv.item_org_id = eiv.id ';
442: l_where_clause_outer := ' AND eiv.id = a.item_org_id ';
443: ELSIF (l_item IS NOT NULL AND l_category IS NOT NULL) THEN
444: l_from_clause := ' eni_dbi_prc_sum1_mv edps1mv, eni_denorm_hierarchies edh ';
445: l_where_clause := ' AND edh.parent_id = :PRODUCT_CATEGORY ' ||
446: ' AND edps1mv.product_category_id = edh.child_id ' ||
447: ' AND edps1mv.item_org_id IN ('|| '&' || 'ITEM+ENI_ITEM) '; -- ||
448: -- ' AND edps1mv.item_org_id IN (' || l_item_org || ')'; -- ||