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_VALUES

Line 18: FROM MTL_CATEGORY_SET_VALID_CATS T, MTL_CATEGORIES_KFV V, MTL_CATEGORIES_KFV V1, FND_FLEX_VALUES F

14: SELECT
15: V.CONCATENATED_SEGMENTS PARENT_CODE,
16: V1.CONCATENATED_SEGMENTS CHILD_CODE,
17: DECODE(F.SUMMARY_FLAG, 'Y', 'P', 'C') RANGE_ATTRIBUTE
18: FROM MTL_CATEGORY_SET_VALID_CATS T, MTL_CATEGORIES_KFV V, MTL_CATEGORIES_KFV V1, FND_FLEX_VALUES F
19: WHERE T.CATEGORY_SET_ID = g_catset_id
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

Line 38: mtl_categories_kfv b, fnd_flex_values f

34: select l_top_node parent_code,
35: concatenated_segments child_code,
36: decode(f.summary_flag,'Y','P','C') range_attribute
37: from mtl_category_set_valid_cats a,
38: mtl_categories_kfv b, fnd_flex_values f
39: where parent_category_id is null
40: and category_set_id = g_catset_id
41: and a.category_id = b.category_id
42: and b.structure_id = l_struct_id

Line 89: l_flex_value FND_FLEX_VALUES.FLEX_VALUE%TYPE;

85: l_summary_flag VARCHAR2(1);
86: l_enabled_flag VARCHAR2(1);
87:
88: l_flex_value_id NUMBER;
89: l_flex_value FND_FLEX_VALUES.FLEX_VALUE%TYPE;
90: l_new_enabled_flag VARCHAR2(1);
91: l_new_description FND_FLEX_VALUES_TL.DESCRIPTION%TYPE;
92: l_new_start_date DATE;
93: l_new_end_date DATE;

Line 91: l_new_description FND_FLEX_VALUES_TL.DESCRIPTION%TYPE;

87:
88: l_flex_value_id NUMBER;
89: l_flex_value FND_FLEX_VALUES.FLEX_VALUE%TYPE;
90: l_new_enabled_flag VARCHAR2(1);
91: l_new_description FND_FLEX_VALUES_TL.DESCRIPTION%TYPE;
92: l_new_start_date DATE;
93: l_new_end_date DATE;
94: l_old_enabled_flag VARCHAR2(1);
95: l_old_start_date DATE;

Line 98: l_old_description FND_FLEX_VALUES_TL.DESCRIPTION%TYPE;

94: l_old_enabled_flag VARCHAR2(1);
95: l_old_start_date DATE;
96: l_old_end_date DATE;
97: l_old_summary_flag VARCHAR2(1);
98: l_old_description FND_FLEX_VALUES_TL.DESCRIPTION%TYPE;
99: l_new_summary_flag VARCHAR2(1);
100: l_schema VARCHAR2(10) := 'ENI';
101:
102: table_not_found EXCEPTION;

Line 166: FROM fnd_flex_values

162: -- Ego view only stores the flex_value_id of the top node.
163: -- Getting the top node name from the id
164:
165: SELECT flex_value INTO l_top_node
166: FROM fnd_flex_values
167: WHERE flex_value_set_id = l_flex_val_set_id
168: AND flex_value_id = l_top_node;
169:
170: EXCEPTION

Line 218: FROM FND_FLEX_VALUE_CHILDREN_V a, fnd_flex_values b

214: b.ENABLED_FLAG,
215: b.START_DATE_ACTIVE,
216: b.END_DATE_ACTIVE,
217: 'P'
218: FROM FND_FLEX_VALUE_CHILDREN_V a, fnd_flex_values b
219: WHERE a.FLEX_VALUE_SET_ID = l_flex_val_set_id
220: and a.flex_value_set_id = b.flex_value_set_id
221: and a.flex_value = b.flex_value
222: UNION

Line 231: FROM FND_FLEX_VALUES A

227: ENABLED_FLAG,
228: START_DATE_ACTIVE,
229: END_DATE_ACTIVE,
230: 'P'
231: FROM FND_FLEX_VALUES A
232: WHERE flex_value_set_id = l_flex_val_set_id
233: AND not exists (Select flex_value
234: from fnd_flex_value_children_v
235: where flex_value_set_id = a.flex_value_set_id

Line 334: (SELECT NULL FROM FND_FLEX_VALUES F

330: AND T.LANGUAGE = USERENV(''LANG'')
331: AND V.CATEGORY_ID = H.CATEGORY_ID
332: AND H.CATEGORY_SET_ID = :g_catset_id
333: AND NOT EXISTS
334: (SELECT NULL FROM FND_FLEX_VALUES F
335: WHERE F.FLEX_VALUE = V.CONCATENATED_SEGMENTS
336: AND F.FLEX_VALUE_SET_ID = :l_flex_val_set_id)';
337:
338:

Line 341: -- INSERTING NEW VALUES INTO FND_FLEX_VALUES TABLE

337:
338:
339: l_count := 0;
340: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Opening Cursor to Insert new values');
341: -- INSERTING NEW VALUES INTO FND_FLEX_VALUES TABLE
342: OPEN new_values_cursor FOR l_sql_stmt USING l_struct_id, g_catset_id, l_flex_val_set_id;
343:
344: LOOP
345: FETCH new_values_cursor INTO

Line 429: FND_FLEX_VALUES F,

425: WHERE C.CATEGORY_SET_ID = H.CATEGORY_SET_ID
426: AND C.PARENT_CATEGORY_ID = V.CATEGORY_ID
427: AND ROWNUM = 1), ''N'') NEW_SUMMARY_FLAG
428: FROM MTL_CATEGORIES_KFV V, MTL_CATEGORIES_TL T,
429: FND_FLEX_VALUES F,
430: FND_FLEX_VALUES_TL FT,
431: MTL_CATEGORY_SET_VALID_CATS H
432: WHERE V.STRUCTURE_ID = :l_struct_id
433: AND V.CATEGORY_ID = T.CATEGORY_ID

Line 430: FND_FLEX_VALUES_TL FT,

426: AND C.PARENT_CATEGORY_ID = V.CATEGORY_ID
427: AND ROWNUM = 1), ''N'') NEW_SUMMARY_FLAG
428: FROM MTL_CATEGORIES_KFV V, MTL_CATEGORIES_TL T,
429: FND_FLEX_VALUES F,
430: FND_FLEX_VALUES_TL FT,
431: MTL_CATEGORY_SET_VALID_CATS H
432: WHERE V.STRUCTURE_ID = :l_struct_id
433: AND V.CATEGORY_ID = T.CATEGORY_ID
434: AND T.LANGUAGE = USERENV(''LANG'')

Line 533: from fnd_flex_values

529: -- value set
530:
531: Select summary_flag, enabled_flag
532: into l_summary_flag, l_enabled_flag
533: from fnd_flex_values
534: where flex_value = l_top_node
535: and flex_value_set_id = l_flex_val_set_id; --Bug 5087675
536: -- and rownum = 1; --Bug 5087675
537:

Line 648: from fnd_flex_values b

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
649: where hrchy.flex_value_set_id = b.flex_value_set_id
650: and hrchy.parent_flex_value = b.flex_value
651: and b.enabled_flag = 'Y')
652: and (parent_flex_value,