VIEW: APPS.IRCFV_JOB_POSTING_CONTENTS

Source

View Text - Preformatted

SELECT ipt.name job_posting_name ,ipt.org_name organization_name ,dbms_lob.substr(ipt.org_description,4000) organization_description ,ipt.job_title job_title ,dbms_lob.substr(ipt.brief_description,4000) brief_job_description ,dbms_lob.substr(ipt.detailed_description,4000) detailed_job_description ,dbms_lob.substr(ipt.job_requirements,4000) job_requirements ,dbms_lob.substr(ipt.additional_details,4000) additional_details ,dbms_lob.substr(ipt.how_to_apply,4000) how_to_apply ,dbms_lob.substr(ipt.benefit_info,4000) benefit_info ,dbms_lob.substr(ipt.image_url,4000) image_url ,dbms_lob.substr(ipt.image_url_alt,4000) image_url_alt ,hr_bis.bis_decode_lookup('YES_NO', ipc.display_manager_info) display_manager_info ,hr_bis.bis_decode_lookup('YES_NO', ipc.display_recruiter_info) display_recruiter_info ,'_DF:PER:IRC_POSTING_CONTENTS:ipc' ,'_DF:PER:IRC_POSTING_CONTENT_DDF:ipc' ,ipc.display_manager_info display_manager_info_code ,ipc.display_recruiter_info display_recruiter_info_code ,ipc.posting_content_id posting_content_id FROM IRC_POSTING_CONTENTS ipc ,IRC_POSTING_CONTENTS_TL ipt WHERE ipc.posting_content_id = ipt.posting_content_id AND ipt.language = USERENV('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT IPT.NAME JOB_POSTING_NAME
, IPT.ORG_NAME ORGANIZATION_NAME
, DBMS_LOB.SUBSTR(IPT.ORG_DESCRIPTION
, 4000) ORGANIZATION_DESCRIPTION
, IPT.JOB_TITLE JOB_TITLE
, DBMS_LOB.SUBSTR(IPT.BRIEF_DESCRIPTION
, 4000) BRIEF_JOB_DESCRIPTION
, DBMS_LOB.SUBSTR(IPT.DETAILED_DESCRIPTION
, 4000) DETAILED_JOB_DESCRIPTION
, DBMS_LOB.SUBSTR(IPT.JOB_REQUIREMENTS
, 4000) JOB_REQUIREMENTS
, DBMS_LOB.SUBSTR(IPT.ADDITIONAL_DETAILS
, 4000) ADDITIONAL_DETAILS
, DBMS_LOB.SUBSTR(IPT.HOW_TO_APPLY
, 4000) HOW_TO_APPLY
, DBMS_LOB.SUBSTR(IPT.BENEFIT_INFO
, 4000) BENEFIT_INFO
, DBMS_LOB.SUBSTR(IPT.IMAGE_URL
, 4000) IMAGE_URL
, DBMS_LOB.SUBSTR(IPT.IMAGE_URL_ALT
, 4000) IMAGE_URL_ALT
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, IPC.DISPLAY_MANAGER_INFO) DISPLAY_MANAGER_INFO
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, IPC.DISPLAY_RECRUITER_INFO) DISPLAY_RECRUITER_INFO
, '_DF:PER:IRC_POSTING_CONTENTS:IPC'
, '_DF:PER:IRC_POSTING_CONTENT_DDF:IPC'
, IPC.DISPLAY_MANAGER_INFO DISPLAY_MANAGER_INFO_CODE
, IPC.DISPLAY_RECRUITER_INFO DISPLAY_RECRUITER_INFO_CODE
, IPC.POSTING_CONTENT_ID POSTING_CONTENT_ID
FROM IRC_POSTING_CONTENTS IPC
, IRC_POSTING_CONTENTS_TL IPT
WHERE IPC.POSTING_CONTENT_ID = IPT.POSTING_CONTENT_ID
AND IPT.LANGUAGE = USERENV('LANG') WITH READ ONLY