DBA Data[Home] [Help]

APPS.FA_RX_SHARED_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 45: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,

41: -- (Code copied from fnd_flex_apis.get_qualifier_segnum in
42: -- FND source control.)
43:
44: SELECT s.segment_num INTO this_segment_num
45: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
46: fnd_segment_attribute_types sat
47: WHERE s.application_id = 101
48: AND s.id_flex_code = 'GL#'
49: AND s.id_flex_num = structure_num

Line 73: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,

69:
70: -- get Account segment
71:
72: SELECT s.segment_num INTO this_segment_num
73: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
74: fnd_segment_attribute_types sat
75: WHERE s.application_id = 101
76: AND s.id_flex_code = 'GL#'
77: AND s.id_flex_num = structure_num

Line 102: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,

98:
99: -- Get Cost Center segment
100:
101: SELECT s.segment_num INTO this_segment_num
102: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
103: fnd_segment_attribute_types sat
104: WHERE s.application_id = 101
105: AND s.id_flex_code = 'GL#'
106: AND s.id_flex_num = structure_num

Line 169: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,

165: -- (Code copied from fnd_flex_apis.get_qualifier_segnum in
166: -- FND source control.)
167:
168: SELECT to_number(substr(s.application_column_name,8,2)) INTO this_segment_num
169: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
170: fnd_segment_attribute_types sat
171: WHERE s.application_id = 101
172: AND s.id_flex_code = 'GL#'
173: AND s.id_flex_num = structure_num

Line 200: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,

196:
197: -- get Account segment
198:
199: SELECT to_number(substr(s.application_column_name,8,2)) INTO this_segment_num
200: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
201: fnd_segment_attribute_types sat
202: WHERE s.application_id = 101
203: AND s.id_flex_code = 'GL#'
204: AND s.id_flex_num = structure_num

Line 230: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,

226:
227: -- Get Cost Center segment
228:
229: SELECT to_number(substr(s.application_column_name,8,2)) INTO this_segment_num
230: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
231: fnd_segment_attribute_types sat
232: WHERE s.application_id = 101
233: AND s.id_flex_code = 'GL#'
234: AND s.id_flex_num = structure_num