DBA Data[Home] [Help]

APPS.FII_FA_CAT_C dependencies on FA_SYSTEM_CONTROLS

Line 196: FA_SYSTEM_CONTROLS sys,

192: l_major_val_type_code,
193: l_parent_value_set_id
194: FROM fnd_id_flex_segments seg,
195: FND_SEGMENT_ATTRIBUTE_VALUES fsav,
196: FA_SYSTEM_CONTROLS sys,
197: fnd_flex_value_sets fv
198: WHERE fsav.application_id = 140
199: AND fsav.id_flex_code = 'CAT#'
200: AND fsav.id_flex_num = sys.category_flex_structure

Line 275: FA_SYSTEM_CONTROLS sys,

271: l_minor_val_type_code,
272: l_parent_value_set_id
273: FROM fnd_id_flex_segments seg,
274: FND_SEGMENT_ATTRIBUTE_VALUES fsav,
275: FA_SYSTEM_CONTROLS sys,
276: fnd_flex_value_sets fv
277: WHERE fsav.application_id = 140
278: AND fsav.id_flex_code = 'CAT#'
279: AND fsav.id_flex_num = sys.category_flex_structure

Line 559: FA_SYSTEM_CONTROLS sys, '; -- completed below

555:
556: l_from_stmt :=
557: ' FROM fnd_id_flex_segments seg1,
558: FA_CATEGORIES_B cat,
559: FA_SYSTEM_CONTROLS sys, '; -- completed below
560:
561: l_where_stmt :=
562: ' WHERE cat.category_id > ' || p_max_cat_id || '
563: AND seg1.application_id = 140