Oracle Fusion HCM Knowledge Hub

 Query to get below details corresponding to a DFF in Fusion: DESCRIPTIVE_FLEXFIELD_CODE, CONTEXT_CODE, SEGMENT_CODE, NAME, COLUMN_NAME, VALUE_SET_CODE, DISPLAY_TYPE, PROMPT, SHORT_PROMPT, ENABLED_FLAG, REQUIRED_FLAG, READ_ONLY_FLAG, DESCRIPTION, SEQUENCE_NUMBER, BI_ENABLED_FLAG ********************************************************************************************************************** SELECT fdsv.descriptive_flexfield_code ,fdsv.context_code ,fdsv.segment_code ,fdsv.name ,fdsv.column_name ,fvvs.value_set_code ,fdsv.display_type ,fdsv.prompt ,fdsv.short_prompt ,fdsv.enabled_flag ,fdsv.required_flag ,fdsv.read_only_flag ,fdsv.description ,fdsv.sequence_number ,fdsv.derivation_value ,fdsv.bi_enabled_flag FROM fnd_df_segments_vl fdsv, fnd_vs_value_sets fvvs WHERE fdsv.value_set_id = fvvs.value_set_id(+) AND fdsv.descriptive_flexfield_code = 'PER_ASG_DF'

Below is the query to get the HDL file information if the UCM ID is known :  SELECT * FROM hrc_dl_file_lines  WHERE data_set_bus_obj_id IN  (SELECT data_set_bus_obj_id FROM hrc_dl_data_set_bus_objs WHERE data_set_id IN  ( SELECT data_set_id FROM hrc_dl_data_sets WHERE ucm_content_id = 'UCMXXXXXX'))