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.

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

VIEW: APPS.PA_REQMNT_CANDIDATES_AMG_V

Object Details

Object Name:	PA_REQMNT_CANDIDATES_AMG_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_REQMNT_CANDIDATES_AMG_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view shows all existing candidates with their associated project requirement information.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CANDIDATE_ID	NUMBER	(15)	Yes	The identifier of the candidate
CANDIDATE_NAME	VARCHAR2	(240)	Yes	The name of the candidate
RESOURCE_ID	NUMBER		Yes	The resource identifier of the candidate
PERSON_ID	NUMBER		Yes	The person identifier of the candidate
PROJECT_ID	NUMBER			The identifier of the project to which the requirement belongs
PROJECT_NAME	VARCHAR2	(30)	Yes	The name of the project to which the requirement belongs
PROJECT_NUMBER	VARCHAR2	(25)	Yes	The number of the project to which the requirement belongs
REQUIREMENT_ID	NUMBER	(15)	Yes	The identifier of the requirement to which the candidate belongs
REQUIREMENT_NAME	VARCHAR2	(80)	Yes	The name of the requirement to which the candidate belongs
REQUIREMENT_START_DATE	DATE			The start date of the requirement to which the candidate belongs
REQUIREMENT_END_DATE	DATE			The end date of the requirement to which the candidate belongs
STATUS_CODE	VARCHAR2	(30)		The status code of the candidate
STATUS_NAME	VARCHAR2	(80)	Yes	The status name of the candidate
SYSTEM_STATUS_CODE	VARCHAR2	(30)	Yes	The system status code of the candidate
NOMINATED_BY	VARCHAR2	(4000)		The name of the person who nominated the candidate
NOMINATED_BY_PERSON_ID	NUMBER	(15)		The identifier of the person who nominated the candidate
NOMINATED_DATE	DATE		Yes	The date of the candidate nomination
NOMINATED_COMMENTS	VARCHAR2	(2000)		The candidate nomination comments
CANDIDATE_RANKING	NUMBER			The ranking of the candidate
RECORD_VERSION_NUMBER	NUMBER		Yes	The system-generated version of the candidate record

Query Text

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


SELECT CANDIDATE_ID
,      CANDIDATE_NAME
,      RESOURCE_ID
,      PERSON_ID
,      PROJECT_ID
,      PROJECT_NAME
,      PROJECT_NUMBER
,      REQUIREMENT_ID
,      REQUIREMENT_NAME
,      REQUIREMENT_START_DATE
,      REQUIREMENT_END_DATE
,      STATUS_CODE
,      STATUS_NAME
,      SYSTEM_STATUS_CODE
,      NOMINATED_BY
,      NOMINATED_BY_PERSON_ID
,      NOMINATED_DATE
,      NOMINATED_COMMENTS
,      CANDIDATE_RANKING
,      RECORD_VERSION_NUMBER
FROM APPS.PA_REQMNT_CANDIDATES_AMG_V;

Dependencies

[top of page]

APPS.PA_REQMNT_CANDIDATES_AMG_V references the following:

APPS: PA_CANDIDATES; PA_CANDIDATE_UTILS - show dependent code; PA_PROJECTS_ALL; PA_PROJECT_ASSIGNMENTS; PA_PROJECT_STATUSES; PA_RESOURCES_DENORM

APPS.PA_REQMNT_CANDIDATES_AMG_V is not referenced by any database object