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.PAFV_PROJECTS

Object Details

Object Name:	PAFV_PROJECTS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PAFV_PROJECTS
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

A Business Intelligence System view

This shows information about the highest units of work defined in Oracle Projects where funding can be allocated, and where revenue and invoice items are generated and maintained.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	The unqiue identifier of the project.
PROJECT_STATUS	VARCHAR2	(80)	Yes	Project Status
PROJECT_NAME	VARCHAR2	(30)	Yes	User defined name that uniquely identifies the project .
PROJECT_NUMBER	VARCHAR2	(25)	Yes	The project number that uniquely identifies the project.
DESCRIPTION	VARCHAR2	(250)		Description
START_DATE	DATE			The date on which the project starts.
COMPLETION_DATE	DATE			The date on which the project is completed.
CLOSED_DATE	DATE			The date when the project is closed.
_LA:WF_STATUS	CHAR	(52)		Workflow Status
_LA:PM_PRODUCT	CHAR	(54)		Project Management Product
PM_PROJECT_REFERENCE	VARCHAR2	(25)		Project Management Project Reference
_LA:PUBLIC_SECTOR_FLAG	CHAR	(49)		Public Sector flag
DISTRIBUTION_RULE	VARCHAR2	(20)		Distribution Rule
DISTRIBUTION_RULE_MEANING	VARCHAR2	(80)		Distribution Rule Meaning
_DF	CHAR	(32)		Descriptive Flexfield
_LA:TEMPLATE_FLAG	CHAR	(44)		Template flag
CARRYING_OUT_ORGANIZATION_ID	NUMBER	(15)	Yes	Unique identifier for Carrying Out Organization
CARRYING_OUT_ORG_NAME	VARCHAR2	(240)	Yes	Carrying Out Organization Name
PROJECT_TYPE	VARCHAR2	(20)	Yes	Project Type
PROJECT_TYPE_DESCRIPTION	VARCHAR2	(250)		Project Type Description
ORG_ID	NUMBER	(15)		Unique identifier for Organization
ORGANIZATION_NAME	VARCHAR2	(240)		Organization Name
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column.
CREATION_DATE	DATE		Yes	Standard WHO column.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column.

Query Text

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


SELECT PROJECT_ID
,      PROJECT_STATUS
,      PROJECT_NAME
,      PROJECT_NUMBER
,      DESCRIPTION
,      START_DATE
,      COMPLETION_DATE
,      CLOSED_DATE
,      _LA:WF_STATUS
,      _LA:PM_PRODUCT
,      PM_PROJECT_REFERENCE
,      _LA:PUBLIC_SECTOR_FLAG
,      DISTRIBUTION_RULE
,      DISTRIBUTION_RULE_MEANING
,      _DF
,      _LA:TEMPLATE_FLAG
,      CARRYING_OUT_ORGANIZATION_ID
,      CARRYING_OUT_ORG_NAME
,      PROJECT_TYPE
,      PROJECT_TYPE_DESCRIPTION
,      ORG_ID
,      ORGANIZATION_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.PAFV_PROJECTS;

Dependencies

[top of page]

APPS.PAFV_PROJECTS references the following:

APPS: HR_ALL_ORGANIZATION_UNITS; HR_ALL_ORGANIZATION_UNITS_TL; PA_DISTRIBUTION_RULES; PA_PROJECTS_ALL; PA_PROJECT_STATUSES; PA_PROJECT_TYPES_ALL

APPS.PAFV_PROJECTS is not referenced by any database object