Product: | PER - Human Resources |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IRC_POSTING_CONTENTS_VL |
SELECT IPC.ROWID
, IPC.POSTING_CONTENT_ID
, IPC.DISPLAY_MANAGER_INFO
, IPC.DISPLAY_RECRUITER_INFO
, 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
FROM IRC_POSTING_CONTENTS IPC
, IRC_POSTING_CONTENTS_TL IPT
WHERE IPC.POSTING_CONTENT_ID = IPT.POSTING_CONTENT_ID
AND IPT.LANGUAGE = USERENV('LANG')