VIEW: APPS.IRCBV_POSTING_CONTENTS_V

Source

View Text - Preformatted

SELECT IPT.NAME , IPT.ORG_NAME , IPT.ORG_DESCRIPTION , IPT.JOB_TITLE , IPT.BRIEF_DESCRIPTION , IPT.DETAILED_DESCRIPTION , IPT.JOB_REQUIREMENTS , IPT.ADDITIONAL_DETAILS , IPT.HOW_TO_APPLY , IPT.BENEFIT_INFO , IPT.IMAGE_URL , IPT.IMAGE_URL_ALT , HR_BIS.BIS_DECODE_LOOKUP('YES_NO',IPC.DISPLAY_MANAGER_INFO) , HR_BIS.BIS_DECODE_LOOKUP('YES_NO',IPC.DISPLAY_RECRUITER_INFO) , IPC.DATE_APPROVED , IPC.DISPLAY_MANAGER_INFO , IPC.DISPLAY_RECRUITER_INFO , IPC.IPC_INFORMATION_CATEGORY , IPC.IPC_INFORMATION1 , IPC.IPC_INFORMATION2 , IPC.IPC_INFORMATION3 , IPC.IPC_INFORMATION4 , IPC.IPC_INFORMATION5 , IPC.IPC_INFORMATION6 , IPC.IPC_INFORMATION7 , IPC.IPC_INFORMATION8 , IPC.IPC_INFORMATION9 , IPC.IPC_INFORMATION10 , IPC.IPC_INFORMATION11 , IPC.IPC_INFORMATION12 , IPC.IPC_INFORMATION13 , IPC.IPC_INFORMATION14 , IPC.IPC_INFORMATION15 , IPC.IPC_INFORMATION16 , IPC.IPC_INFORMATION17 , IPC.IPC_INFORMATION18 , IPC.IPC_INFORMATION19 , IPC.IPC_INFORMATION20 , IPC.IPC_INFORMATION21 , IPC.IPC_INFORMATION22 , IPC.IPC_INFORMATION23 , IPC.IPC_INFORMATION24 , IPC.IPC_INFORMATION25 , IPC.IPC_INFORMATION26 , IPC.IPC_INFORMATION27 , IPC.IPC_INFORMATION28 , IPC.IPC_INFORMATION29 , IPC.IPC_INFORMATION30 , '_DF:PER:IRC_POSTING_CONTENTS:IPC' , IPC.POSTING_CONTENT_ID , IPC.LAST_UPDATE_DATE , IPC.LAST_UPDATED_BY , IPC.LAST_UPDATE_LOGIN , IPC.CREATED_BY , IPC.CREATION_DATE 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
, IPT.ORG_NAME
, IPT.ORG_DESCRIPTION
, IPT.JOB_TITLE
, IPT.BRIEF_DESCRIPTION
, IPT.DETAILED_DESCRIPTION
, IPT.JOB_REQUIREMENTS
, IPT.ADDITIONAL_DETAILS
, IPT.HOW_TO_APPLY
, IPT.BENEFIT_INFO
, IPT.IMAGE_URL
, IPT.IMAGE_URL_ALT
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, IPC.DISPLAY_MANAGER_INFO)
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, IPC.DISPLAY_RECRUITER_INFO)
, IPC.DATE_APPROVED
, IPC.DISPLAY_MANAGER_INFO
, IPC.DISPLAY_RECRUITER_INFO
, IPC.IPC_INFORMATION_CATEGORY
, IPC.IPC_INFORMATION1
, IPC.IPC_INFORMATION2
, IPC.IPC_INFORMATION3
, IPC.IPC_INFORMATION4
, IPC.IPC_INFORMATION5
, IPC.IPC_INFORMATION6
, IPC.IPC_INFORMATION7
, IPC.IPC_INFORMATION8
, IPC.IPC_INFORMATION9
, IPC.IPC_INFORMATION10
, IPC.IPC_INFORMATION11
, IPC.IPC_INFORMATION12
, IPC.IPC_INFORMATION13
, IPC.IPC_INFORMATION14
, IPC.IPC_INFORMATION15
, IPC.IPC_INFORMATION16
, IPC.IPC_INFORMATION17
, IPC.IPC_INFORMATION18
, IPC.IPC_INFORMATION19
, IPC.IPC_INFORMATION20
, IPC.IPC_INFORMATION21
, IPC.IPC_INFORMATION22
, IPC.IPC_INFORMATION23
, IPC.IPC_INFORMATION24
, IPC.IPC_INFORMATION25
, IPC.IPC_INFORMATION26
, IPC.IPC_INFORMATION27
, IPC.IPC_INFORMATION28
, IPC.IPC_INFORMATION29
, IPC.IPC_INFORMATION30
, '_DF:PER:IRC_POSTING_CONTENTS:IPC'
, IPC.POSTING_CONTENT_ID
, IPC.LAST_UPDATE_DATE
, IPC.LAST_UPDATED_BY
, IPC.LAST_UPDATE_LOGIN
, IPC.CREATED_BY
, IPC.CREATION_DATE
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