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_PROJ_INFO_VIEW

Object Details

Object Name:	PA_PROJ_INFO_VIEW
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_PROJ_INFO_VIEW
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	Comments
ORG_ID	NUMBER	(15)
PROJECT_ID	NUMBER	(15)	Project identifier
PROJECT_NAME	VARCHAR2	(30)	Project name
PROJECT_NUMBER	VARCHAR2	(25)	Project number
START_DATE	DATE		Project start date
COMPLETION_DATE	DATE		Project completion date
PROJECT_STATUS	VARCHAR2	(80)	Status of the project
PROJECT_STATUS_CODE	VARCHAR2	(30)	Code that identifies the project status
PUBLIC_SECTOR_FLAG	VARCHAR2	(80)	Flag that indicates whether the project is public sector or private sector
PROJECT_TYPE	VARCHAR2	(20)	Project type that classifies the project and defaults project information upon project entry
DESCRIPTION	VARCHAR2	(250)	Description of the project
ORGANIZATION_ID	NUMBER	(15)	Identifier of the organization that is managing the project work
ORGANIZATION_NAME	VARCHAR2	(240)	Name of the organization managing the project work
MANAGER_PERSON_ID	NUMBER		Identifier of the project manager
MANAGER_NAME	VARCHAR2	(240)	Full name of the project manager
DISTRIBUTION_RULE	VARCHAR2	(30)	Distribution rule that specifies the contract project"s revenue accrual and billing method
PROJECT_ROLE_TYPE	VARCHAR2	(20)	Code that identifies the project role type of the project manager. This column displays PROJECT MANAGER
PROJECT_ROLE	VARCHAR2	(80)	Role type that a project manager has on a project. This column displays Project Manager
PROJECT_CURRENCY_CODE	VARCHAR2	(15)	Currency code of the project
PROJECT_RATE_DATE	DATE		Default value for project rate date which can be overridden at task
PROJECT_RATE_TYPE	VARCHAR2	(30)	Default value for project rate type which can be overridden at task
ALLOW_CROSS_CHARGE_FLAG	VARCHAR2	(1)	Flag to indicate whether cross charge are allowed

Query Text

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


SELECT ORG_ID
,      PROJECT_ID
,      PROJECT_NAME
,      PROJECT_NUMBER
,      START_DATE
,      COMPLETION_DATE
,      PROJECT_STATUS
,      PROJECT_STATUS_CODE
,      PUBLIC_SECTOR_FLAG
,      PROJECT_TYPE
,      DESCRIPTION
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      MANAGER_PERSON_ID
,      MANAGER_NAME
,      DISTRIBUTION_RULE
,      PROJECT_ROLE_TYPE
,      PROJECT_ROLE
,      PROJECT_CURRENCY_CODE
,      PROJECT_RATE_DATE
,      PROJECT_RATE_TYPE
,      ALLOW_CROSS_CHARGE_FLAG
FROM APPS.PA_PROJ_INFO_VIEW;

Dependencies

[top of page]

APPS.PA_PROJ_INFO_VIEW references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; HR_GENERAL - show dependent code; HR_ORGANIZATION_UNITS; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; PA_PROJECTS; PA_PROJECT_PLAYERS; PA_PROJECT_ROLE_TYPES; PA_PROJECT_STATUSES; PA_ROLE_JOB_BG_UTILS - show dependent code; PER_PEOPLE_F

APPS.PA_PROJ_INFO_VIEW is not referenced by any database object