DBA Data[Home] [Help]

APPS.FA_RX_SHARED_PKG dependencies on FND_SEGMENT_ATTRIBUTE_TYPES

Line 46: fnd_segment_attribute_types sat

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
50: AND s.enabled_flag = 'Y'

Line 74: fnd_segment_attribute_types sat

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
78: AND s.enabled_flag = 'Y'

Line 103: fnd_segment_attribute_types sat

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
107: AND s.enabled_flag = 'Y'

Line 170: fnd_segment_attribute_types sat

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
174: AND s.enabled_flag = 'Y'

Line 201: fnd_segment_attribute_types sat

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
205: AND s.enabled_flag = 'Y'

Line 231: fnd_segment_attribute_types sat

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
235: AND s.enabled_flag = 'Y'