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_PROD_VALUESET dependencies on FND_FLEX_VALUE_NORM_HIERARCHY

Line 24: AND NOT EXISTS (SELECT NULL FROM FND_FLEX_VALUE_NORM_HIERARCHY H

20: AND T.CATEGORY_ID = V1.CATEGORY_ID
21: AND T.PARENT_CATEGORY_ID = V.CATEGORY_ID
22: AND V1.CONCATENATED_SEGMENTS = F.FLEX_VALUE
23: AND F.FLEX_VALUE_SET_ID = l_flex_val_set_id
24: AND NOT EXISTS (SELECT NULL FROM FND_FLEX_VALUE_NORM_HIERARCHY H
25: WHERE FLEX_VALUE_SET_ID = F.FLEX_VALUE_SET_ID
26: AND PARENT_FLEX_VALUE = V.CONCATENATED_SEGMENTS
27: AND RANGE_ATTRIBUTE = DECODE(F.SUMMARY_FLAG, 'Y', 'P', 'C')
28: AND CHILD_FLEX_VALUE_LOW = V1.CONCATENATED_SEGMENTS

Line 46: and not exists( select 'X' from fnd_flex_value_norm_hierarchy h

42: and b.structure_id = l_struct_id
43: and b.concatenated_segments = f.flex_value
44: and f.flex_value_set_id = l_flex_val_set_id
45: and l_top_node is not null
46: and not exists( select 'X' from fnd_flex_value_norm_hierarchy h
47: where flex_value_set_id = f.flex_value_set_id
48: and parent_flex_value = l_top_node
49: and range_attribute= decode(f.summary_flag,'Y','P','C')
50: and child_flex_value_low = b.concatenated_segments

Line 644: delete from fnd_flex_value_norm_hierarchy hrchy

640: -- Changed the first part of the select statement to remove the child flex
641: -- ranges defined in hierarchy
642:
643: /* ** Performance fix - see Bug 4960193 ** */
644: delete from fnd_flex_value_norm_hierarchy hrchy
645: where flex_value_set_id = l_flex_val_set_id
646: and exists (
647: select null
648: from fnd_flex_values b