DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.HRBV_RECRUITMENT_ACTIVITIES_V

Object Details
Object Name: HRBV_RECRUITMENT_ACTIVITIES_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Recruitment activitys (from PER_RECRUITMENT_ACTIVITIES table).


[View Source]

Columns
Name Datatype Length Mandatory Comments
CURRENCY_CODE VARCHAR2 (15)
Currency code.
DATE_START DATE
Yes Start date.
NAME VARCHAR2 (30) Yes Recruitment activity name.
ACTUAL_COST VARCHAR2 (30)
Actual cost.
COMMENTS CLOB (4000)
Comments.
CONTACT_TELEPHONE_NUMBER VARCHAR2 (60)
Contact telephone number.
DATE_CLOSING DATE

Closing date.
DATE_END DATE

End date.
EXTERNAL_CONTACT VARCHAR2 (80)
External contact.
PLANNED_COST VARCHAR2 (30)
Planned cost.
TYPE VARCHAR2 (30)
(Lookup code based on lookup type REC_TYPE).
TYPE_M VARCHAR2 (4000)
(Lookup meaning based on lookup type REC_TYPE).
STATUS VARCHAR2 (30)
(Lookup code based on lookup type REC_STATUS).
STATUS_M VARCHAR2 (4000)
(Lookup meaning based on lookup type REC_STATUS).
INTERNAL_POSTING VARCHAR2 (30)
Internal posting.
EXTERNAL_POSTING VARCHAR2 (30)
External posting.
RECRUITING_SITE_RESPONSE CLOB (4000)
Recruiting site response.
LAST_POSTED_DATE DATE

Last posted date.
_DF:RAA CHAR (38)
Descriptive Flexfield Column
RECRUITMENT_ACTIVITY_ID NUMBER (15) Yes Foreign Key to PER_RECUITMENT_ACTIVITY.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ALL_ORGANIZATION_UNITS.
AUTHORISING_PERSON_ID NUMBER (10)
Foreign key to PER_ALL_PEOPLE_F.
RUN_BY_ORGANIZATION_ID NUMBER (15)
Foreign key to HR_ALL_ORGANIZATION_UNITS.
INTERNAL_CONTACT_PERSON_ID NUMBER (10)
Foreign key to PER_ALL_PEOPLE_F.
PARENT_RECRUITMENT_ACTIVITY_ID NUMBER (15)
Foreign key to PER_RECRUITMENT_ACTIVITIES.
POSTING_CONTENT_ID NUMBER (15) Yes Foreign key to IRC_POSTING_CONTENTS.
RECRUITING_SITE_ID NUMBER (15) Yes Primary Key for IRC_ALL_RECRUITING_SITES.
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATED_BY NUMBER (15)
Standard who column
CREATED_BY NUMBER (15)
Standard who column
CREATION_DATE DATE

Standard who column
BG_SECURITY_FLAG_CODE CHAR (1)
Business group security flag code.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CURRENCY_CODE
,      DATE_START
,      NAME
,      ACTUAL_COST
,      COMMENTS
,      CONTACT_TELEPHONE_NUMBER
,      DATE_CLOSING
,      DATE_END
,      EXTERNAL_CONTACT
,      PLANNED_COST
,      TYPE
,      TYPE_M
,      STATUS
,      STATUS_M
,      INTERNAL_POSTING
,      EXTERNAL_POSTING
,      RECRUITING_SITE_RESPONSE
,      LAST_POSTED_DATE
,      _DF:RAA
,      RECRUITMENT_ACTIVITY_ID
,      BUSINESS_GROUP_ID
,      AUTHORISING_PERSON_ID
,      RUN_BY_ORGANIZATION_ID
,      INTERNAL_CONTACT_PERSON_ID
,      PARENT_RECRUITMENT_ACTIVITY_ID
,      POSTING_CONTENT_ID
,      RECRUITING_SITE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      BG_SECURITY_FLAG_CODE
FROM APPS.HRBV_RECRUITMENT_ACTIVITIES_V;

Dependencies

[top of page]

APPS.HRBV_RECRUITMENT_ACTIVITIES_V references the following:

SchemaAPPS
PL/SQL PackageHR_BIS - show dependent code
SynonymPER_RECRUITMENT_ACTIVITIES

APPS.HRBV_RECRUITMENT_ACTIVITIES_V is not referenced by any database object