[Home] [Help]
55:
56: cursor c_segs is
57: select 'GL_CODE_COMBINATIONS' , c.table_id, g.application_column_name,
58: g.segment_num, s.concatenated_segment_delimiter
59: from fnd_columns c, fnd_id_flex_segments g, fnd_id_flex_structures s
60: where g.application_id = 101
61: and g.id_flex_code = 'GL#'
62: and g.id_flex_num = (
63: select accounting_flex_structure
73: and s.id_flex_code = g.id_flex_code
74: and s.id_flex_num = g.id_flex_num
75: union -- asset key
76: select 'FA_ASSET_KEYWORDS', c.table_id,g.application_column_name, g.segment_num, s.concatenated_segment_delimiter
77: from fnd_columns c, fnd_id_flex_segments g, fnd_id_flex_structures s
78: where g.application_id = 140
79: and g.id_flex_code = 'KEY#'
80: and g.id_flex_num = ( select asset_key_flex_structure
81: from fa_system_controls)
90: and s.id_flex_code = g.id_flex_code
91: and s.id_flex_num = g.id_flex_num
92: union -- location
93: select 'FA_LOCATIONS', c.table_id, g.application_column_name, g.segment_num, s.concatenated_segment_delimiter
94: from fnd_columns c, fnd_id_flex_segments g, fnd_id_flex_structures s
95: where g.application_id = 140
96: and g.id_flex_code = 'LOC#'
97: and g.id_flex_num = ( select location_flex_structure
98: from fa_system_controls)
107: and s.id_flex_code = g.id_flex_code
108: and s.id_flex_num = g.id_flex_num
109: union -- category
110: select 'FA_CATEGORIES_B', c.table_id, g.application_column_name, g.segment_num, s.concatenated_segment_delimiter
111: from fnd_columns c, fnd_id_flex_segments g, fnd_id_flex_structures s
112: where g.application_id = 140
113: and g.id_flex_code = 'CAT#'
114: and g.id_flex_num = (select category_flex_structure
115: from fa_system_controls)