You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    How to fetch "Source" from licenses and certifications in SQL query?

    in Career and Succession 8 comments

    SELECT papf.person_number,

    ci.name,

    hpi.ITEM_TEXT240_1 title,

    hpi.ITEM_TEXT240_2 Certificate_Number,

    hpi.ITEM_TEXT240_4 Issued_By,

    hpi.ITEM_DATE_6 Issue_Date,

    hpi.ITEM_DATE_3 Expiration_Date,

    hpi.ITEM_CLOB_1 Comments,

    hpi.ITEM_CLOB_2 Restrictions,

    hpi.COUNTRY_CODE country,

    hpi.STATE_PROVINCE_CODE state,

    hpi.ITEM_TEXT30_1 Renewal_Required,

    hpi.ITEM_TEXT30_6 Verified

    ,hpi.last_update_date last_updated_date

    FROM

    HRT_PROFILES_B HPB,

    HRT_PROFILE_ITEMS HPI,

    HRT_CONTENT_TYPES_TL CT,

    HRT_CONTENT_ITEMS_TL CI,

    PER_ALL_PEOPLE_F papf

    WHERE 1=1  

    and papf.person_id= HPB.person_id

    and HPB.PROFILE_ID=HPI.PROFILE_ID

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!