DBA Data[Home] [Help]

APPS.FA_WHATIF_DEPRN2_PKG dependencies on FA_SYSTEM_CONTROLS

Line 81: from fa_system_controls)

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)
82: and g.enabled_flag = 'Y'
83: and c.application_id = 140
84: and c.table_id = (select table_id
85: from fnd_tables

Line 98: from fa_system_controls)

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)
99: and g.enabled_flag = 'Y'
100: and c.application_id = 140
101: and c.table_id = (select table_id
102: from fnd_tables

Line 115: from fa_system_controls)

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)
116: and g.enabled_flag = 'Y'
117: and c.application_id = 140
118: and c.table_id = (select table_id
119: from fnd_tables

Line 206: from fa_system_controls;

202:
203: select location_flex_structure, category_flex_structure,
204: asset_key_flex_structure
205: into h_loc_struct, h_cat_struct, h_key_struct
206: from fa_system_controls;
207:
208: h_mesg_name := 'FA_REC_SQL_ACCT_FLEX';
209:
210: select accounting_flex_structure into h_acct_struct