[Home] [Help] [Dependency Information]
Object Name: | PA_REP_PROJ_RES_COMP_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_REP_PROJ_RES_COMP_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
PA_REP_ORG_RES_COMP_V is a view that lists all resource competence details by projects
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | (15) | Yes | Internal identifier for the Organization |
ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | Name of the organization |
PROJECT_ID | NUMBER | (15) | Yes | Id of project which the resource participates in |
PROJECT_NAME | VARCHAR2 | (30) | Yes | Name of project which the resource participates in |
PROJECT_NUMBER | VARCHAR2 | (25) | Yes | |
RESOURCE_ID | NUMBER | Yes | Resource id of the resource | |
RESOURCE_NAME | VARCHAR2 | (240) | Yes | Name of the resource |
RESOURCE_COMPETENCIES | VARCHAR2 | (4000) | Competencies possessed by the resource | |
RESOURCE_COMP_COUNT | NUMBER | Number of competencies the resource possesses | ||
LAST_UPDATED | DATE | Last update date of a specific competence | ||
MANAGER_ID | NUMBER | (15) | Manager id | |
MANAGER_NAME | VARCHAR2 | (240) | Manager name | |
JOB_ID | NUMBER | (15) | Yes | Job id |
JOB_NAME | VARCHAR2 | (700) | Job name | |
JOB_LEVEL | VARCHAR2 | (150) | Job level | |
JOB_CODE | VARCHAR2 | (150) | Job code | |
SCHEDULABLE_FLAG | VARCHAR2 | (1) | Indicates if the resource is schedulable | |
BILLABLE_FLAG | VARCHAR2 | (1) | Indicates if the resource is billable | |
PERSON_TYPE | VARCHAR2 | (30) | Person Type of the resource |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, ORGANIZATION_NAME
, PROJECT_ID
, PROJECT_NAME
, PROJECT_NUMBER
, RESOURCE_ID
, RESOURCE_NAME
, RESOURCE_COMPETENCIES
, RESOURCE_COMP_COUNT
, LAST_UPDATED
, MANAGER_ID
, MANAGER_NAME
, JOB_ID
, JOB_NAME
, JOB_LEVEL
, JOB_CODE
, SCHEDULABLE_FLAG
, BILLABLE_FLAG
, PERSON_TYPE
FROM APPS.PA_REP_PROJ_RES_COMP_V;
APPS.PA_REP_PROJ_RES_COMP_V is not referenced by any database object
|
|
|