Here are few handy Oracle Apps queries :
FROM fnd_descriptive_flexs_vl fdfv
WHERE application_table_name = /* Give the table name here */
Step 2:
SELECT descriptive_flex_context_code, enabled_flag, description,
descriptive_flex_context_name
FROM fnd_descr_flex_contexts_vl
WHERE descriptive_flexfield_name = /* Get from Step 1 */
Step 3:
SELECT application_column_name, end_user_column_name, enabled_flag,
display_flag, DEFAULT_VALUE, description
FROM fnd_descr_flex_col_usage_vl
WHERE descriptive_flexfield_name = 'OE_HEADER_ATTRIBUTES'
AND descriptive_flex_context_code = /* Get from Step 2 */
To find the meaning of segment columns(key flexfield columns) in a table.
set_defining_column_name
FROM fnd_id_flexs
WHERE application_table_name = /* Give the table name here */
Step 2:
SELECT id_flex_num, id_flex_structure_code, structure_view_name,
id_flex_structure_name, description
FROM fnd_id_flex_structures_vl
WHERE id_flex_code = /* Get from Step 1 */
Step 3:
SELECT application_column_name, segment_name, enabled_flag, description
FROM fnd_id_flex_segments_vl
WHERE id_flex_code = /* Get from Step 2 */ AND id_flex_num = /* Get from Step 2 */
To
find the meaning of attribute columns(descriptive flexfield columns) in a
table.
Step
1:
SELECT
descriptive_flexfield_name, context_column_name, title, descriptionFROM fnd_descriptive_flexs_vl fdfv
WHERE application_table_name = /* Give the table name here */
Step 2:
SELECT descriptive_flex_context_code, enabled_flag, description,
descriptive_flex_context_name
FROM fnd_descr_flex_contexts_vl
WHERE descriptive_flexfield_name = /* Get from Step 1 */
Step 3:
SELECT application_column_name, end_user_column_name, enabled_flag,
display_flag, DEFAULT_VALUE, description
FROM fnd_descr_flex_col_usage_vl
WHERE descriptive_flexfield_name = 'OE_HEADER_ATTRIBUTES'
AND descriptive_flex_context_code = /* Get from Step 2 */
To find the meaning of segment columns(key flexfield columns) in a table.
Step 1:
SELECT
id_flex_code, id_flex_name, unique_id_column_name, description,set_defining_column_name
FROM fnd_id_flexs
WHERE application_table_name = /* Give the table name here */
Step 2:
SELECT id_flex_num, id_flex_structure_code, structure_view_name,
id_flex_structure_name, description
FROM fnd_id_flex_structures_vl
WHERE id_flex_code = /* Get from Step 1 */
Step 3:
SELECT application_column_name, segment_name, enabled_flag, description
FROM fnd_id_flex_segments_vl
WHERE id_flex_code = /* Get from Step 2 */ AND id_flex_num = /* Get from Step 2 */
No comments:
Post a Comment