APPS.ENI_DBI_IVA_PKG dependencies on ENI_DENORM_HIERARCHIES

Line 111: from eni_denorm_hierarchies edh

107: l_category1 := TRIM(both '''' from l_category);
108: IF (l_category1 IS NOT NULL) THEN
109: select top_node_flag,leaf_node_flag
110: into top_flag,leaf_flag
111: from eni_denorm_hierarchies edh
112: where edh.parent_id = l_category1
113: and edh.child_id = edh.parent_id;
114:
115: IF (top_flag = 'Y' and leaf_flag = 'Y') THEN

Line 153: l_from_clause := ' eni_dbi_inv_sum_mv edismv , eni_denorm_hierarchies edh ';

149: l_where_clause := ' AND edismv.marker = 3 ';
150:
151: ELSIF (l_item_org IS NULL AND l_category IS NOT NULL) THEN
152:
153: l_from_clause := ' eni_dbi_inv_sum_mv edismv , eni_denorm_hierarchies edh ';
154: l_where_clause := ' AND edismv.marker = 3 ' ||
155: ' AND edh.parent_id = &' || 'ITEM+ENI_ITEM_VBH_CAT' ||
156: ' AND edismv.product_category_id = edh.child_id ';
157:

Line 165: l_from_clause := ' eni_dbi_inv_sum_mv edismv, eni_denorm_hierarchies edh ';

161: l_where_clause := ' AND edismv.marker = 3 ' ||
162: ' AND edismv.item_org_id IN ( &' || 'ITEM+ENI_ITEM ) ';
163:
164: ELSIF (l_item_org IS NOT NULL AND l_category IS NOT NULL) THEN
165: l_from_clause := ' eni_dbi_inv_sum_mv edismv, eni_denorm_hierarchies edh ';
166: l_where_clause := ' AND edismv.marker = 3 ' ||
167: ' AND edismv.item_org_id IN ( &' || 'ITEM+ENI_ITEM ) '||
168: ' AND edh.parent_id = &' || 'ITEM+ENI_ITEM_VBH_CAT' ||
169: ' AND edismv.product_category_id = edh.child_id ';

Line 216: l_from_clause := ' eni_dbi_inv_sum_mv edismv, eni_denorm_hierarchies edh ';

212: ' AND lookupv.parent_id = lookupv.child_id ';
213:
214: ELSIF (l_item_org IS NOT NULL AND l_category IS NULL) THEN
215:
216: l_from_clause := ' eni_dbi_inv_sum_mv edismv, eni_denorm_hierarchies edh ';
217: l_where_clause := ' AND edismv.marker = 3 ' ||
218: ' AND edismv.item_org_id IN ( &' || 'ITEM+ENI_ITEM ) ' ||
219: ' AND edh.top_node_flag = ''Y'' ' ||
220: ' AND edismv.product_category_id = edh.child_id ';

Line 226: l_from_clause:= ' eni_dbi_inv_sum_mv edismv, eni_denorm_hierarchies edh ';

222: l_group_by_clause := ' edh.parent_id ';
223:
224: ELSIF (l_item_org IS NOT NULL AND l_category IS NOT NULL) THEN
225:
226: l_from_clause:= ' eni_dbi_inv_sum_mv edismv, eni_denorm_hierarchies edh ';
227: l_where_clause := ' AND edismv.marker = 3 ' ||
228: ' AND edismv.item_org_id IN ( &' || 'ITEM+ENI_ITEM ) '||
229: ' AND edh.parent_id = &' || 'ITEM+ENI_ITEM_VBH_CAT' ||
230: ' AND edismv.product_category_id = edh.child_id ';

Line 257: l_from_clause := ' eni_dbi_inv_base_mv odipmv, eni_denorm_hierarchies edh ';

253: IF (l_item_org IS NULL AND l_category IS NULL) THEN
254: l_from_clause := ' eni_dbi_inv_base_mv odipmv ';
255: l_where_clause := NULL;
256: ELSIF (l_item_org IS NULL AND l_category IS NOT NULL) THEN
257: l_from_clause := ' eni_dbi_inv_base_mv odipmv, eni_denorm_hierarchies edh ';
258: l_where_clause := ' AND edh.parent_id = &' || 'ITEM+ENI_ITEM_VBH_CAT' ||
259: ' AND odipmv.item_category_id = edh.child_id ';
260: ELSIF (l_item_org IS NOT NULL AND l_category IS NULL) THEN
261: l_from_clause := ' eni_dbi_inv_base_mv odipmv ';

Line 264: l_from_clause := ' eni_dbi_inv_base_mv odipmv , eni_denorm_hierarchies edh ';

260: ELSIF (l_item_org IS NOT NULL AND l_category IS NULL) THEN
261: l_from_clause := ' eni_dbi_inv_base_mv odipmv ';
262: l_where_clause := ' AND odipmv.item_master_org_id IN ( &' || 'ITEM+ENI_ITEM ) ';
263: ELSIF (l_item_org IS NOT NULL AND l_category IS NOT NULL) THEN
264: l_from_clause := ' eni_dbi_inv_base_mv odipmv , eni_denorm_hierarchies edh ';
265: l_where_clause := ' AND odipmv.item_master_org_id IN ( &' || 'ITEM+ENI_ITEM ) '||
266: ' AND edh.parent_id = &' || 'ITEM+ENI_ITEM_VBH_CAT' ||
267: ' AND odipmv.item_category_id = edh.child_id ';
268: END IF;