[Home] [Help] [Dependency Information]
Object Name: | PA_REP_RES_SCHHRS_PAD_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_REP_RES_SCHHRS_PAD_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_NAME | VARCHAR2 | (30) | Yes | Name of the Project |
PROJECT_NUMBER | VARCHAR2 | (25) | Yes | Number of the Project |
PROJECT_TYPE | VARCHAR2 | (20) | Yes | Type of the Project |
PROJECT_ID | NUMBER | Yes | Internal identifier for the project | |
PROJECT_MANAGER_NAME | VARCHAR2 | (4000) | Name of the Project Manager | |
PROBABILITY | NUMBER | Percentage of probability of getting the project | ||
TEAM_ROLE | VARCHAR2 | (80) | Yes | Team Role name of the resource |
ASSIGNMENT_WORK_TYPE | VARCHAR2 | (80) | Yes | Work type of the assignment |
START_DATE | DATE | Start date of the project | ||
END_DATE | DATE | End date of the project | ||
CONFIRMED_HOURS | NUMBER | Number of hours for which the resource is confirmed | ||
PROVISIONAL_HOURS | NUMBER | Number of hours for which the resource is provisional | ||
PA_PERIOD | VARCHAR2 | (30) | PA Period name | |
PERIOD_SET_NAME | VARCHAR2 | (30) | Period Set Name | |
RESOURCE_ID | NUMBER | Internal identifier for the resource | ||
RESOURCE_NAME | VARCHAR2 | (240) | Name of the resource | |
PA_PERIOD_START_DATE | DATE | Yes | PA Period start date | |
ORG_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_NAME
, PROJECT_NUMBER
, PROJECT_TYPE
, PROJECT_ID
, PROJECT_MANAGER_NAME
, PROBABILITY
, TEAM_ROLE
, ASSIGNMENT_WORK_TYPE
, START_DATE
, END_DATE
, CONFIRMED_HOURS
, PROVISIONAL_HOURS
, PA_PERIOD
, PERIOD_SET_NAME
, RESOURCE_ID
, RESOURCE_NAME
, PA_PERIOD_START_DATE
, ORG_ID
FROM APPS.PA_REP_RES_SCHHRS_PAD_V;
APPS.PA_REP_RES_SCHHRS_PAD_V is not referenced by any database object
|
|
|