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_REP_ORG_COM_RES_LST_V

Object Details

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

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER	(15)	Yes	Internal identifier for the Organization
ORGANIZATION_NAME	VARCHAR2	(240)	Yes	Name of the organization
COMPETENCE_ID	NUMBER	(15)	Yes	Internal identifier for the competence
COMPETENCE_NAME	VARCHAR2	(700)	Yes	Name of the competence
PERSON_NAME	VARCHAR2	(240)	Yes	Name of the person
PERSON_ID	NUMBER		Yes	Internal identifier for the person
PROFICIENCY_LEVEL	NUMBER	(15)		Proficiency level of the person
MANAGER_NAME	VARCHAR2	(240)		Resource manager name of the person
MANAGER_ID	NUMBER	(15)		Internal identifier for the resource manager
JOB_NAME	VARCHAR2	(700)		Jon name of the person
JOB_ID	NUMBER	(15)	Yes	Internal identifier for the job
PROJECT_JOB_LEVEL	NUMBER			Project job level of the person
PROJECT_JOB_CODE	VARCHAR2	(150)		Project job code of the person
SCHEDULABLE_FLAG	VARCHAR2	(1)		Indicates if the resource is schedulable
LOCATION	VARCHAR2	(156)		Location of the person
PERSON_TYPE	VARCHAR2	(30)		Person Type of the resource

Query Text

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


SELECT ORGANIZATION_ID
,      ORGANIZATION_NAME
,      COMPETENCE_ID
,      COMPETENCE_NAME
,      PERSON_NAME
,      PERSON_ID
,      PROFICIENCY_LEVEL
,      MANAGER_NAME
,      MANAGER_ID
,      JOB_NAME
,      JOB_ID
,      PROJECT_JOB_LEVEL
,      PROJECT_JOB_CODE
,      SCHEDULABLE_FLAG
,      LOCATION
,      PERSON_TYPE
FROM APPS.PA_REP_ORG_COM_RES_LST_V;

Dependencies

[top of page]

APPS.PA_REP_ORG_COM_RES_LST_V references the following:

APPS: HR_GENERAL - show dependent code; HR_ORGANIZATION_UNITS; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; PA_RESOURCES_DENORM; PER_COMPETENCES; PER_COMPETENCE_ELEMENTS; PER_JOBS; PER_JOB_EXTRA_INFO; PER_PEOPLE_F; PER_RATING_LEVELS

APPS.PA_REP_ORG_COM_RES_LST_V is not referenced by any database object