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


VIEW: APPS.PJM_PROJECT_PROJ_V

Object Details
Object Name: PJM_PROJECT_PROJ_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPJM.PJM_PROJECT_PROJ_V
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


PJM_PROJECT_PROJ_V returns combined project and seiban summary information.
This view corresponds to the Project Information web inquiry region. It also serves as the base object for the Project Drilldowns, Project Manufacturing Drilldowns and Procurement Drilldowns regions that contain drilldown buttons.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15)
System-generated number that uniquely identifies a project or seiban
PROJECT_NUMBER VARCHAR2 (25)
User-entered number that uniquely identifies a project or seiban
PROJECT_NAME VARCHAR2 (30)
User-entered project/seiban name
PROJECT_DESCRIPTION VARCHAR2 (250)
Project description
START_DATE DATE

Project start date
COMPLETION_DATE DATE

Project completion date
PROJECT_STATUS VARCHAR2 (80)
Project status
PROJECT_TYPE VARCHAR2 (20)
Project type
PROJECT_ORGANIZATION_ID NUMBER

Unique identifier of organization owning the project
PROJECT_ORGANIZATION_NAME VARCHAR2 (240)
Name of organization owning the project
MANAGER_NAME VARCHAR2 (240)
Project manager name
OPERATING_UNIT NUMBER

Operating unit unique identifer
SEIBAN_NUMBER_FLAG NUMBER

Flag indicating whether the PROJECT_ID identifier identifies a project or seiban
Query Text

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


SELECT PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_NAME
,      PROJECT_DESCRIPTION
,      START_DATE
,      COMPLETION_DATE
,      PROJECT_STATUS
,      PROJECT_TYPE
,      PROJECT_ORGANIZATION_ID
,      PROJECT_ORGANIZATION_NAME
,      MANAGER_NAME
,      OPERATING_UNIT
,      SEIBAN_NUMBER_FLAG
FROM APPS.PJM_PROJECT_PROJ_V;

Dependencies

[top of page]

APPS.PJM_PROJECT_PROJ_V references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
ViewPA_PROJECT_PLAYERS
SynonymPA_PROJECT_STATUSES
SynonymPER_ALL_PEOPLE_F
ViewPJM_PROJECTS_ALL_OU_V

APPS.PJM_PROJECT_PROJ_V is not referenced by any database object