[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT /* $Header: AFFFDDUB.pls 120.2.12010000.1 2008/07/25 14:13:42 appldev ship $ */
application_column_name,
description,
enabled_flag,
required_flag,
end_user_column_name,
column_seq_num,
display_flag,
display_size,
form_left_prompt,
form_above_prompt,
flex_value_set_id,
default_type,
default_value
FROM fnd_descr_flex_col_usage_vl
WHERE application_id = context.flexfield.application_id
AND descriptive_flexfield_name = context.flexfield.flexfield_name
AND descriptive_flex_context_code = context.context_code
AND (en_flag IS NULL OR enabled_flag = 'Y')
ORDER BY column_seq_num;
SELECT /* $Header: AFFFDDUB.pls 120.2.12010000.1 2008/07/25 14:13:42 appldev ship $ */
a.application_id, df.descriptive_flexfield_name
INTO ffld
FROM fnd_application_vl a, fnd_descriptive_flexs_vl df
WHERE a.application_short_name = appl_short_name
AND a.application_id = df.application_id
AND df.descriptive_flexfield_name = flexfield_name;
SELECT /* $Header: AFFFDDUB.pls 120.2.12010000.1 2008/07/25 14:13:42 appldev ship $ */
df.title, df.application_table_name, a.application_short_name,
df.description, df.concatenated_segment_delimiter,
df.default_context_field_name, df.default_context_value,
protected_flag,
form_context_prompt, context_column_name
INTO dflex
FROM fnd_application_vl a, fnd_descriptive_flexs_vl df
WHERE df.application_id = ffld.application_id
AND df.descriptive_flexfield_name = ffld.flexfield_name
AND a.application_id = df.table_application_id;
SELECT /* $Header: AFFFDDUB.pls 120.2.12010000.1 2008/07/25 14:13:42 appldev ship $ */
descriptive_flex_context_code, descriptive_flex_context_name,
description, global_flag, enabled_flag
FROM fnd_descr_flex_contexts_vl
WHERE application_id = flexfield.application_id
AND descriptive_flexfield_name = flexfield.flexfield_name
ORDER BY descriptive_flex_context_code;