eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IRC_POSTING_CONTENTS_VL

Product:	PER - Human Resources
Description:
Implementation/DBA Data:	APPS.IRC_POSTING_CONTENTS_VL

View Text

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')

Columns

Name
ROW_ID
POSTING_CONTENT_ID
DISPLAY_MANAGER_INFO
DISPLAY_RECRUITER_INFO
DATE_APPROVED
NAME
ORG_NAME
ORG_DESCRIPTION
JOB_TITLE
BRIEF_DESCRIPTION
DETAILED_DESCRIPTION
JOB_REQUIREMENTS
ADDITIONAL_DETAILS
HOW_TO_APPLY
IMAGE_URL
IMAGE_URL_ALT
BENEFIT_INFO
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
ATTRIBUTE21
ATTRIBUTE22
ATTRIBUTE23
ATTRIBUTE24
ATTRIBUTE25
ATTRIBUTE26
ATTRIBUTE27
ATTRIBUTE28
ATTRIBUTE29
ATTRIBUTE30
IPC_INFORMATION_CATEGORY
IPC_INFORMATION1
IPC_INFORMATION2
IPC_INFORMATION3
IPC_INFORMATION4
IPC_INFORMATION5
IPC_INFORMATION6
IPC_INFORMATION7
IPC_INFORMATION8
IPC_INFORMATION9
IPC_INFORMATION10
IPC_INFORMATION11
IPC_INFORMATION12
IPC_INFORMATION13
IPC_INFORMATION14
IPC_INFORMATION15
IPC_INFORMATION16
IPC_INFORMATION17
IPC_INFORMATION18
IPC_INFORMATION19
IPC_INFORMATION20
IPC_INFORMATION21
IPC_INFORMATION22
IPC_INFORMATION23
IPC_INFORMATION24
IPC_INFORMATION25
IPC_INFORMATION26
IPC_INFORMATION27
IPC_INFORMATION28
IPC_INFORMATION29
IPC_INFORMATION30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
RECRUITER_FULL_NAME
RECRUITER_EMAIL
RECRUITER_WORK_TELEPHONE
MANAGER_FULL_NAME
MANAGER_EMAIL
MANAGER_WORK_TELEPHONE