How to fetch "Source" from licenses and certifications in SQL query?
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:
0