Oracle Fusion Talent Useful Queries

 -------- Content Item Details -------------------------

SELECT 
a.content_value_set_id as ContentItemValueSetId, 
a.content_value_set_code, 
b.value_set_name as ContentItemValueSetName, 
value_set_description,
a.content_type_id
FROM FUSION.hrt_content_tp_valuesets_b a, 
            FUSION.hrt_content_tp_valuesets_tl b
WHERE a.content_value_set_id = b.content_value_set_id
and b.language = 'US'

----------------- Talent UI to HDL Fields Mapping Query ------------------

SELECT c.PROFILE_TYPE_ID ,

d.NAME SECTION_NAME ,

c.SECTION_CONTEXT ,

c.SECTION_ID ,

c.CONTENT_TYPE_ID ,

a.FIELD_NAME ,

b.ATTRIBUTE_LABEL LABEL_FROM_THE_UI ,

'-->' IS_USING ,

a.COLUMN_NAME ATTRIBUTE_USED_IN_HDL ,

a.VALUE_SET_NAME ,

a.INPUT_FIELD_TYPE_CODE ,

a.DISPLAY_FLAG

FROM HRT_PROFILE_TYP_SECTIONS c ,

HRT_PROFILE_TYP_SECTIONS_TL d,

HRT_PROFILE_TP_SC_PRP_B a ,

HRT_PROFILE_TP_SC_PRP_TL b

WHERE a.SECTION_PROP_ID =b.SECTION_PROP_ID

AND a.SECTION_ID =c.SECTION_ID

AND d.SECTION_ID =c.SECTION_ID

AND b.LANGUAGE ='US'

AND d.LANGUAGE ='US'

AND a.SOURCE_CODE IS NULL

AND a.DISPLAY_FLAG !='N'

AND c.TEMPLATE_BASED_SECTION_FLAG='Y'

AND SECTION_CONTEXT = 'LICENSE_CERTIFICATION_300000006046139'

/* AND (SECTION_CONTEXT LIKE '%PERSON_PERFORMANCE%' or SECTION_CONTEXT LIKE '%PERSON_POTENTIAL%')  */

--AND d.NAME LIKE '%replace_with_section_name%'

--AND b.ATTRIBUTE_LABEL LIKE '%replace_with_the_label_of_a_standard_field_as_you_see_it_in_ManageProfileTypes%'

ORDER BY c.PROFILE_TYPE_ID,

c.SECTION_ID ,

a.DISPLAY_ORDER

-------------- Qualifier Details --------------------------

select QUALIFIER_ID,DESCRIPTION

  from FUSION.HRT_QUALIFIERS_VL hqv,

   fusion.HRT_QUALIFIER_SETS_VL hqsv

 where hqv.QUALIFIER_SET_ID = hqsv.QUALIFIER_SET_ID  

  -- and SECTION_ID = 300000236137110

-- Rating Models Query --

select *

 from HRT_RATING_MODELS_VL

-- Rating Levels Query -- 

 select *

 from HRT_RATING_LEVELS_VL