VIEW: APPS.IRC_POSTING_CONTENTS_VL

Source

View Text - Preformatted

SELECT IPC.ROWID, IPC.POSTING_CONTENT_ID, IPC.DISPLAY_MANAGER_INFO, IPC.DISPLAY_RECRUITER_INFO, IPC.DATE_APPROVED, 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.IMAGE_URL, IPT.IMAGE_URL_ALT, IPT.BENEFIT_INFO, IPC.ATTRIBUTE_CATEGORY, IPC.ATTRIBUTE1, IPC.ATTRIBUTE2, IPC.ATTRIBUTE3, IPC.ATTRIBUTE4, IPC.ATTRIBUTE5, IPC.ATTRIBUTE6, IPC.ATTRIBUTE7, IPC.ATTRIBUTE8, IPC.ATTRIBUTE9, IPC.ATTRIBUTE10, IPC.ATTRIBUTE11, IPC.ATTRIBUTE12, IPC.ATTRIBUTE13, IPC.ATTRIBUTE14, IPC.ATTRIBUTE15, IPC.ATTRIBUTE16, IPC.ATTRIBUTE17, IPC.ATTRIBUTE18, IPC.ATTRIBUTE19, IPC.ATTRIBUTE20, IPC.ATTRIBUTE21, IPC.ATTRIBUTE22, IPC.ATTRIBUTE23, IPC.ATTRIBUTE24, IPC.ATTRIBUTE25, IPC.ATTRIBUTE26, IPC.ATTRIBUTE27, IPC.ATTRIBUTE28, IPC.ATTRIBUTE29, IPC.ATTRIBUTE30, 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, IPC.LAST_UPDATE_DATE, IPC.LAST_UPDATED_BY, IPC.LAST_UPDATE_LOGIN, IPC.CREATED_BY, IPC.CREATION_DATE, IPC.OBJECT_VERSION_NUMBER, IPC.RECRUITER_FULL_NAME, IPC.RECRUITER_EMAIL, IPC.RECRUITER_WORK_TELEPHONE, IPC.MANAGER_FULL_NAME, IPC.MANAGER_EMAIL, IPC.MANAGER_WORK_TELEPHONE FROM IRC_POSTING_CONTENTS IPC, IRC_POSTING_CONTENTS_TL IPT WHERE IPC.POSTING_CONTENT_ID = IPT.POSTING_CONTENT_ID AND IPT.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT IPC.ROWID
, IPC.POSTING_CONTENT_ID
, IPC.DISPLAY_MANAGER_INFO
, IPC.DISPLAY_RECRUITER_INFO
, IPC.DATE_APPROVED
, 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.IMAGE_URL
, IPT.IMAGE_URL_ALT
, IPT.BENEFIT_INFO
, IPC.ATTRIBUTE_CATEGORY
, IPC.ATTRIBUTE1
, IPC.ATTRIBUTE2
, IPC.ATTRIBUTE3
, IPC.ATTRIBUTE4
, IPC.ATTRIBUTE5
, IPC.ATTRIBUTE6
, IPC.ATTRIBUTE7
, IPC.ATTRIBUTE8
, IPC.ATTRIBUTE9
, IPC.ATTRIBUTE10
, IPC.ATTRIBUTE11
, IPC.ATTRIBUTE12
, IPC.ATTRIBUTE13
, IPC.ATTRIBUTE14
, IPC.ATTRIBUTE15
, IPC.ATTRIBUTE16
, IPC.ATTRIBUTE17
, IPC.ATTRIBUTE18
, IPC.ATTRIBUTE19
, IPC.ATTRIBUTE20
, IPC.ATTRIBUTE21
, IPC.ATTRIBUTE22
, IPC.ATTRIBUTE23
, IPC.ATTRIBUTE24
, IPC.ATTRIBUTE25
, IPC.ATTRIBUTE26
, IPC.ATTRIBUTE27
, IPC.ATTRIBUTE28
, IPC.ATTRIBUTE29
, IPC.ATTRIBUTE30
, 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
, IPC.LAST_UPDATE_DATE
, IPC.LAST_UPDATED_BY
, IPC.LAST_UPDATE_LOGIN
, IPC.CREATED_BY
, IPC.CREATION_DATE
, IPC.OBJECT_VERSION_NUMBER
, IPC.RECRUITER_FULL_NAME
, IPC.RECRUITER_EMAIL
, IPC.RECRUITER_WORK_TELEPHONE
, IPC.MANAGER_FULL_NAME
, IPC.MANAGER_EMAIL
, IPC.MANAGER_WORK_TELEPHONE
FROM IRC_POSTING_CONTENTS IPC
, IRC_POSTING_CONTENTS_TL IPT
WHERE IPC.POSTING_CONTENT_ID = IPT.POSTING_CONTENT_ID
AND IPT.LANGUAGE = USERENV('LANG')