View: IRC_DEFAULT_POSTINGS_VL

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

View Text

SELECT IDP.ROWID
, IDP.DEFAULT_POSTING_ID
, IDP.POSITION_ID
, IDP.JOB_ID
, IDP.ORGANIZATION_ID
, IDT.ORG_NAME
, IDT.ORG_DESCRIPTION
, IDT.JOB_TITLE
, IDT.BRIEF_DESCRIPTION
, IDT.DETAILED_DESCRIPTION
, IDT.JOB_REQUIREMENTS
, IDT.ADDITIONAL_DETAILS
, IDT.HOW_TO_APPLY
, IDT.IMAGE_URL
, IDT.IMAGE_URL_ALT
, IDP.ATTRIBUTE_CATEGORY
, IDP.ATTRIBUTE1
, IDP.ATTRIBUTE2
, IDP.ATTRIBUTE3
, IDP.ATTRIBUTE4
, IDP.ATTRIBUTE5
, IDP.ATTRIBUTE6
, IDP.ATTRIBUTE7
, IDP.ATTRIBUTE8
, IDP.ATTRIBUTE9
, IDP.ATTRIBUTE10
, IDP.ATTRIBUTE11
, IDP.ATTRIBUTE12
, IDP.ATTRIBUTE13
, IDP.ATTRIBUTE14
, IDP.ATTRIBUTE15
, IDP.ATTRIBUTE16
, IDP.ATTRIBUTE17
, IDP.ATTRIBUTE18
, IDP.ATTRIBUTE19
, IDP.ATTRIBUTE20
, IDP.ATTRIBUTE21
, IDP.ATTRIBUTE22
, IDP.ATTRIBUTE23
, IDP.ATTRIBUTE24
, IDP.ATTRIBUTE25
, IDP.ATTRIBUTE26
, IDP.ATTRIBUTE27
, IDP.ATTRIBUTE28
, IDP.ATTRIBUTE29
, IDP.ATTRIBUTE30
, IDP.LAST_UPDATE_DATE
, IDP.LAST_UPDATED_BY
, IDP.LAST_UPDATE_LOGIN
, IDP.CREATED_BY
, IDP.CREATION_DATE
, IDP.OBJECT_VERSION_NUMBER
FROM IRC_DEFAULT_POSTINGS IDP
, IRC_DEFAULT_POSTINGS_TL IDT
WHERE IDP.DEFAULT_POSTING_ID = IDT.DEFAULT_POSTING_ID
AND IDT.LANGUAGE = USERENV('LANG')

Columns