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]

Table: IRC_OFFERS

Product:	PER - Human Resources
Description:	Table to maintain details of iRecruitment Offers
Implementation/DBA Data:	HR.IRC_OFFERS

Primary Key: IRC_OFFERS_PK

OFFER_ID

Primary Key: IRC_OFFERS_U1

APPLICANT_ASSIGNMENT_ID
OFFER_VERSION

Foreign Keys

Table	Foreign Table	Foreign Key Column
IRC_OFFERS	PER_ADDRESSES	IRC_OFFERS.ADDRESS_ID
IRC_OFFERS	FND_USER	IRC_OFFERS.RESPONDENT_ID
IRC_OFFERS	XDO_TEMPLATES_B	IRC_OFFERS.TEMPLATE_ID
IRC_OFFERS	PER_ALL_VACANCIES	IRC_OFFERS.VACANCY_ID
IRC_OFFER_STATUS_HISTORY	IRC_OFFERS	IRC_OFFER_STATUS_HISTORY.OFFER_ID