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.GL_FLEX_INSERT_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 266: /* FND_ID_FLEX_SEGMENTS */

262: /* GL_ACCOUNT_HIERARCHIES */
263: /* */
264: /* AOL Tables which are being used include : */
265: /* */
266: /* FND_ID_FLEX_SEGMENTS */
267: /* FND_SEGMENT_ATTRIBUTE_VALUES */
268: /* FND_FLEX_HIERARCHIES */
269: /* FND_FLEX_VALUE_HIERARCHIES */
270: /* FND_FLEX_VALUES */

Line 1108: col_name fnd_id_flex_segments.application_column_name%TYPE;

1104: FUNCTION glfisi(val_set IN OUT NOCOPY SegVsetArray) RETURN BOOLEAN IS
1105:
1106: i BINARY_INTEGER;
1107:
1108: col_name fnd_id_flex_segments.application_column_name%TYPE;
1109: vset_id fnd_id_flex_segments.flex_value_set_id%TYPE;
1110: e_val_set SegVsetArray;
1111:
1112: cursor valset(flex_num NUMBER,

Line 1109: vset_id fnd_id_flex_segments.flex_value_set_id%TYPE;

1105:
1106: i BINARY_INTEGER;
1107:
1108: col_name fnd_id_flex_segments.application_column_name%TYPE;
1109: vset_id fnd_id_flex_segments.flex_value_set_id%TYPE;
1110: e_val_set SegVsetArray;
1111:
1112: cursor valset(flex_num NUMBER,
1113: appl_id NUMBER,

Line 1117: from fnd_id_flex_segments

1113: appl_id NUMBER,
1114: flex_code VARCHAR2) IS
1115: select application_column_name,
1116: nvl(flex_value_set_id, 0) value_set_id
1117: from fnd_id_flex_segments
1118: where enabled_flag = 'Y'
1119: and id_flex_num = flex_num
1120: and application_id = appl_id
1121: and id_flex_code = flex_code;

Line 1566: 'from gl_code_combinations cc, gl_summary_hierarchies gsh, fnd_flex_values fv, fnd_id_flex_segments fs, ' ||

1562: sql_stmp := sql_stmp || ' ' ||
1563: 'and (segment' || i || '_type is null ' ||
1564: 'or segment' || i || '_type in (''D'', ''T'') ' ||
1565: 'or segment' || i || '_type in (select fh.hierarchy_name ' ||
1566: 'from gl_code_combinations cc, gl_summary_hierarchies gsh, fnd_flex_values fv, fnd_id_flex_segments fs, ' ||
1567: 'fnd_flex_hierarchies_vl fh ' ||
1568: 'where cc.code_combination_id = :ccid and ' ||
1569: 'cc.segment' || i || ' between gsh.child_flex_value_low and gsh.child_flex_value_high and ' ||
1570: 'gsh.flex_value_set_id = fv.flex_value_set_id and ' ||