DBA Data[Home] [Help]

APPS.FA_WHATIF_DEPRN2_PKG dependencies on FA_SYSTEM_CONTROLS

Line 102: from fa_system_controls)

98: from fnd_columns c, fnd_id_flex_segments g, fnd_id_flex_structures s
99: where g.application_id = 140
100: and g.id_flex_code = 'KEY#'
101: and g.id_flex_num = ( select asset_key_flex_structure
102: from fa_system_controls)
103: and g.enabled_flag = 'Y'
104: and c.application_id = 140
105: and c.table_id = (select table_id
106: from fnd_tables

Line 119: from fa_system_controls)

115: from fnd_columns c, fnd_id_flex_segments g, fnd_id_flex_structures s
116: where g.application_id = 140
117: and g.id_flex_code = 'LOC#'
118: and g.id_flex_num = ( select location_flex_structure
119: from fa_system_controls)
120: and g.enabled_flag = 'Y'
121: and c.application_id = 140
122: and c.table_id = (select table_id
123: from fnd_tables

Line 136: from fa_system_controls)

132: from fnd_columns c, fnd_id_flex_segments g, fnd_id_flex_structures s
133: where g.application_id = 140
134: and g.id_flex_code = 'CAT#'
135: and g.id_flex_num = (select category_flex_structure
136: from fa_system_controls)
137: and g.enabled_flag = 'Y'
138: and c.application_id = 140
139: and c.table_id = (select table_id
140: from fnd_tables

Line 253: from fa_system_controls;

249:
250: select location_flex_structure, category_flex_structure,
251: asset_key_flex_structure
252: into h_loc_struct, h_cat_struct, h_key_struct
253: from fa_system_controls;
254:
255: h_mesg_name := 'FA_REC_SQL_ACCT_FLEX';
256:
257: select accounting_flex_structure into h_acct_struct