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

VIEW: APPS.PA_REP_PROJ_REQHRS_WK_V

Object Details
Object Name: PA_REP_PROJ_REQHRS_WK_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_REP_PROJ_REQHRS_WK_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
REQUIRED_HOURS NUMBER
Yes Number of required project hours for the assignment
PROJECT_NAME VARCHAR2 (30) Yes Name of the Project
PROJECT_ID NUMBER
Yes Internal identifier for the project
MANAGER_ID NUMBER (15) Yes Internal identifier for the manager
MANAGER_NAME VARCHAR2 (240)
Name of the Project Manager
ORGANIZATION_ID NUMBER (15) Yes Internal identifier for the Organization
YEAR NUMBER

Fiscal Year
MONTH NUMBER

Month
GLOBAL_WEEK_END_DATE DATE

Global Week End Date
WEEK_DAY DATE
Yes Day of the week
TEAM_ROLE VARCHAR2 (80)
Team Role Name
Query Text

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


SELECT REQUIRED_HOURS
,      PROJECT_NAME
,      PROJECT_ID
,      MANAGER_ID
,      MANAGER_NAME
,      ORGANIZATION_ID
,      YEAR
,      MONTH
,      GLOBAL_WEEK_END_DATE
,      WEEK_DAY
,      TEAM_ROLE
FROM APPS.PA_REP_PROJ_REQHRS_WK_V;

Dependencies

[top of page]

APPS.PA_REP_PROJ_REQHRS_WK_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPA_FORECAST_ITEMS
SynonymPA_PROJECTS_ALL
SynonymPA_PROJECT_ASSIGNMENTS
ViewPA_PROJECT_PLAYERS
SynonymPA_PROJECT_STATUSES
ViewPER_PEOPLE_X

APPS.PA_REP_PROJ_REQHRS_WK_V is not referenced by any database object