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


VIEW: APPS.PER_RECRUITMENT_ACTIVITIES_V

Object Details
Object Name: PER_RECRUITMENT_ACTIVITIES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.PER_RECRUITMENT_ACTIVITIES_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)

RECRUITMENT_ACTIVITY_ID NUMBER (15) Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
AUTHORISING_PERSON_ID NUMBER (10)

AUTH_PERSON_NAME VARCHAR2 (240)

AUTH_NUMBER VARCHAR2 (30)

RUN_BY_ORGANIZATION_ID NUMBER (15)

ORG_RUN_BY_NAME VARCHAR2 (240)

D_TYPE VARCHAR2 (80)

INTERNAL_CONTACT_PERSON_ID NUMBER (10)

INT_CONTACT_NAME VARCHAR2 (240)

INT_CONT_NUM VARCHAR2 (30)

PARENT_RECRUITMENT_ACTIVITY_ID NUMBER (15)

PARENT_REC_NAME VARCHAR2 (30)

D_PARENT_REC_TYPE VARCHAR2 (80)

C_PARENT_REC_TYPE_CODE VARCHAR2 (30)

CURRENCY_CODE VARCHAR2 (15)

DATE_START DATE
Yes
NAME VARCHAR2 (30) Yes
ACTUAL_COST VARCHAR2 (30)

D_ACTUAL_COST VARCHAR2 (4000)

COMMENTS CLOB (4000)

CONTACT_TELEPHONE_NUMBER VARCHAR2 (60)

DATE_CLOSING DATE


DATE_END DATE


EXTERNAL_CONTACT VARCHAR2 (80)

PLANNED_COST VARCHAR2 (30)

D_PLANNED_COST VARCHAR2 (4000)

TYPE VARCHAR2 (30)

REQUEST_ID NUMBER (15)

PROGRAM_APPLICATION_ID NUMBER (15)

PROGRAM_ID NUMBER (15)

PROGRAM_UPDATE_DATE DATE


ATTRIBUTE_CATEGORY VARCHAR2 (30)

ATTRIBUTE1 VARCHAR2 (150)

ATTRIBUTE2 VARCHAR2 (150)

ATTRIBUTE3 VARCHAR2 (150)

ATTRIBUTE4 VARCHAR2 (150)

ATTRIBUTE5 VARCHAR2 (150)

ATTRIBUTE6 VARCHAR2 (150)

ATTRIBUTE7 VARCHAR2 (150)

ATTRIBUTE8 VARCHAR2 (150)

ATTRIBUTE9 VARCHAR2 (150)

ATTRIBUTE10 VARCHAR2 (150)

ATTRIBUTE11 VARCHAR2 (150)

ATTRIBUTE12 VARCHAR2 (150)

ATTRIBUTE13 VARCHAR2 (150)

ATTRIBUTE14 VARCHAR2 (150)

ATTRIBUTE15 VARCHAR2 (150)

ATTRIBUTE16 VARCHAR2 (150)

ATTRIBUTE17 VARCHAR2 (150)

ATTRIBUTE18 VARCHAR2 (150)

ATTRIBUTE19 VARCHAR2 (150)

ATTRIBUTE20 VARCHAR2 (150)

LAST_UPDATE_DATE DATE


LAST_UPDATED_BY NUMBER (15)

LAST_UPDATE_LOGIN NUMBER (15)

CREATED_BY NUMBER (15)

CREATION_DATE DATE


Query Text

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


SELECT ROW_ID
,      RECRUITMENT_ACTIVITY_ID
,      BUSINESS_GROUP_ID
,      AUTHORISING_PERSON_ID
,      AUTH_PERSON_NAME
,      AUTH_NUMBER
,      RUN_BY_ORGANIZATION_ID
,      ORG_RUN_BY_NAME
,      D_TYPE
,      INTERNAL_CONTACT_PERSON_ID
,      INT_CONTACT_NAME
,      INT_CONT_NUM
,      PARENT_RECRUITMENT_ACTIVITY_ID
,      PARENT_REC_NAME
,      D_PARENT_REC_TYPE
,      C_PARENT_REC_TYPE_CODE
,      CURRENCY_CODE
,      DATE_START
,      NAME
,      ACTUAL_COST
,      D_ACTUAL_COST
,      COMMENTS
,      CONTACT_TELEPHONE_NUMBER
,      DATE_CLOSING
,      DATE_END
,      EXTERNAL_CONTACT
,      PLANNED_COST
,      D_PLANNED_COST
,      TYPE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PER_RECRUITMENT_ACTIVITIES_V;

Dependencies

[top of page]

APPS.PER_RECRUITMENT_ACTIVITIES_V references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_API - show dependent code
PL/SQL PackageHR_CHKFMT - show dependent code
ViewHR_LOOKUPS
SynonymPER_ALL_PEOPLE_F
SynonymPER_RECRUITMENT_ACTIVITIES

APPS.PER_RECRUITMENT_ACTIVITIES_V is not referenced by any database object