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

Line 25: from fnd_id_flex_segments s

21: p_id_flex_num in number,
22: p_qualifier in varchar2,
23: p_segnum in number) is
24: select s.segment_num, s.application_column_name, s.flex_value_set_id
25: from fnd_id_flex_segments s
26: where s.application_id = p_application_id
27: and s.id_flex_code = p_id_flex_code
28: and s.id_flex_num = p_id_flex_num
29: and s.enabled_flag = 'Y'

Line 34: from fnd_id_flex_segments s,

30: and p_qualifier = 'ALL'
31: and p_segnum is null
32: union all
33: select s.segment_num, s.application_column_name, s.flex_value_set_id
34: from fnd_id_flex_segments s,
35: fnd_segment_attribute_values sav,
36: fnd_segment_attribute_types sat
37: where s.application_id = p_application_id
38: and s.id_flex_code = p_id_flex_code

Line 55: from fnd_id_flex_segments s

51: and p_qualifier <> 'ALL'
52: and p_segnum is null
53: union all
54: select s.segment_num, s.application_column_name, s.flex_value_set_id
55: from fnd_id_flex_segments s
56: where s.application_id = p_application_id
57: and s.id_flex_code = p_id_flex_code
58: and s.id_flex_num = p_id_flex_num
59: and s.enabled_flag = 'Y'

Line 70: from FND_FLEX_VALUE_SETS a, FND_ID_FLEX_SEGMENTS b, FND_ID_FLEX_SEGMENTS c

66: p_id_flex_num in number,
67: p_value_set_id in number)
68: Is
69: select c.segment_num parent_seg_num
70: from FND_FLEX_VALUE_SETS a, FND_ID_FLEX_SEGMENTS b, FND_ID_FLEX_SEGMENTS c
71: where b.APPLICATION_ID = p_application_id
72: and b.ID_FLEX_CODE = p_id_flex_code
73: and b.ID_FLEX_NUM = p_id_flex_num
74: and (b.FLEX_VALUE_SET_ID = a.FLEX_VALUE_SET_ID)

Line 398: segnum fnd_id_flex_segments.segment_num%type;

394: p_operand1 in varchar2 default null,
395: p_operand2 in varchar2 default null)
396: return varchar2
397: is
398: segnum fnd_id_flex_segments.segment_num%type;
399: colname fnd_id_flex_segments.application_column_name%type;
400: seg_value_set_id fnd_flex_value_sets.flex_value_set_id%type;
401:
402: sep fnd_id_flex_structures.concatenated_segment_delimiter%type;

Line 399: colname fnd_id_flex_segments.application_column_name%type;

395: p_operand2 in varchar2 default null)
396: return varchar2
397: is
398: segnum fnd_id_flex_segments.segment_num%type;
399: colname fnd_id_flex_segments.application_column_name%type;
400: seg_value_set_id fnd_flex_value_sets.flex_value_set_id%type;
401:
402: sep fnd_id_flex_structures.concatenated_segment_delimiter%type;
403: op1 seg_array;

Line 412: l_segnum fnd_id_flex_segments.segment_num%type;

408: table_alias varchar2(40);
409: buffer varchar2(2000);
410:
411: l_qualifier fnd_segment_attribute_types.segment_attribute_type%type;
412: l_segnum fnd_id_flex_segments.segment_num%type;
413: l_id_flex_num number;
414: begin
415: IF (g_print_debug) THEN
416: fa_rx_util_pkg.debug('fa_rx_flex_pkg.flex_sql()+');

Line 598: segnum fnd_id_flex_segments.segment_num%type;

594: l_unique_id_column_name varchar2(30);
595: l_sep fnd_id_flex_structures.concatenated_segment_delimiter%type;
596: c integer;
597: rows integer;
598: segnum fnd_id_flex_segments.segment_num%type;
599: colname fnd_id_flex_segments.application_column_name%type;
600: seg_value_set_id fnd_flex_value_sets.flex_value_set_id%type;
601: buffer varchar2(2000);
602:

Line 599: colname fnd_id_flex_segments.application_column_name%type;

595: l_sep fnd_id_flex_structures.concatenated_segment_delimiter%type;
596: c integer;
597: rows integer;
598: segnum fnd_id_flex_segments.segment_num%type;
599: colname fnd_id_flex_segments.application_column_name%type;
600: seg_value_set_id fnd_flex_value_sets.flex_value_set_id%type;
601: buffer varchar2(2000);
602:
603: l_qualifier fnd_segment_attribute_types.segment_attribute_type%type;

Line 604: l_segnum fnd_id_flex_segments.segment_num%type;

600: seg_value_set_id fnd_flex_value_sets.flex_value_set_id%type;
601: buffer varchar2(2000);
602:
603: l_qualifier fnd_segment_attribute_types.segment_attribute_type%type;
604: l_segnum fnd_id_flex_segments.segment_num%type;
605: l_id_flex_num number;
606: l_counter number := 0;
607: begin
608: IF (g_print_debug) THEN

Line 855: segnum fnd_id_flex_segments.segment_num%type;

851: segments seg_array;
852: err_num number;
853: sep fnd_id_flex_structures.concatenated_segment_delimiter%type;
854:
855: segnum fnd_id_flex_segments.segment_num%type;
856: colname fnd_id_flex_segments.application_column_name%type;
857: seg_value_set_id fnd_flex_value_sets.flex_value_set_id%type;
858:
859: seg_value varchar2(50);

Line 856: colname fnd_id_flex_segments.application_column_name%type;

852: err_num number;
853: sep fnd_id_flex_structures.concatenated_segment_delimiter%type;
854:
855: segnum fnd_id_flex_segments.segment_num%type;
856: colname fnd_id_flex_segments.application_column_name%type;
857: seg_value_set_id fnd_flex_value_sets.flex_value_set_id%type;
858:
859: seg_value varchar2(50);
860: seg_desc fnd_flex_values_vl.description%type;

Line 866: l_segnum fnd_id_flex_segments.segment_num%type;

862: seg_parent_value FND_FLEX_VALUES.PARENT_FLEX_VALUE_LOW%type;
863: i number;
864:
865: l_qualifier fnd_segment_attribute_types.segment_attribute_type%type;
866: l_segnum fnd_id_flex_segments.segment_num%type;
867: l_id_flex_num number;
868: l_counter number := 0;
869: found boolean;
870: begin