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_RPT_PROJECT_ATTRIBUTES

Object Details

Object Name:	PA_RPT_PROJECT_ATTRIBUTES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_RPT_PROJECT_ATTRIBUTES
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Reporting view that displays information about projects for Oracle Discoverer Workbooks. All Reporting Profiles must be set up at the site level of the application in order to use this view correctly. Specifically, the Reporting Class Category and Reporting Role Type profiles need to be set in order to retrieve data for the Class Category, Class Code, Project Role Type, and Project Key Member items to return values.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	The system-generated number that uniquely identifies the project
PROJECT_STATUS	VARCHAR2	(80)	Yes	The user-defined project status name
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. The project number can be user-entered or system-generated as defined in the implementation options
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 that the project was closed by changing the project status to Closed
PM_PRODUCT	VARCHAR2	(30)		The identifier of the external project management system from which the project was imported
PM_PROJECT_REFERENCE	VARCHAR2	(25)		The identifier of the projectin the external project management system from which the project was imported
PROJECT_ORGANIZATION_ID	NUMBER	(15)	Yes	The identifier of the organization that is responsible for the project work
PROJECT_ORGANIZATION_NAME	VARCHAR2	(240)	Yes	Name of the organization
PROJECT_TYPE	VARCHAR2	(20)	Yes	The project type that classifies the project and defaults project information upon project entry
PROJECT_TYPE_CLASS_CODE	VARCHAR2	(30)		Indicates the class of project type
ORG_ID	NUMBER	(15)		Operating unit identifier for multi-organization installations
OPERATING_UNIT_NAME	VARCHAR2	(240)		Name of the organization
CLASS_CATEGORY1	VARCHAR2	(4000)		The reporting class category attributes
CLASS_CODE1	VARCHAR2	(4000)		The class code assigned to the project
CLASS_CATEGORY2	VARCHAR2	(4000)		The reporting class category attributes
CLASS_CODE2	VARCHAR2	(4000)		The class code assigned to the project
CLASS_CATEGORY3	VARCHAR2	(4000)		The reporting class category attributes
CLASS_CODE3	VARCHAR2	(4000)		The class code assigned to the project
PROJECT_ROLE_TYPE1	VARCHAR2	(4000)		The reporting project role type attributes
PROJECT_KEYMEMBER1	VARCHAR2	(4000)		The key member assigned to the project for the given project role type
PROJECT_ROLE_TYPE2	VARCHAR2	(4000)		The reporting project role type attributes
PROJECT_KEYMEMBER2	VARCHAR2	(4000)		The key member assigned to the project for the given project role type
PROJECT_ROLE_TYPE3	VARCHAR2	(4000)		The reporting project role type attributes
PROJECT_KEYMEMBER3	VARCHAR2	(4000)		The key member assigned to the project for the given project role type
STATUS_REPORTING_FLAG	VARCHAR2	(1)	Yes	Indicates whether the project has been enabled for status reporting

Query Text

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


SELECT PROJECT_ID
,      PROJECT_STATUS
,      PROJECT_NAME
,      PROJECT_NUMBER
,      START_DATE
,      COMPLETION_DATE
,      CLOSED_DATE
,      PM_PRODUCT
,      PM_PROJECT_REFERENCE
,      PROJECT_ORGANIZATION_ID
,      PROJECT_ORGANIZATION_NAME
,      PROJECT_TYPE
,      PROJECT_TYPE_CLASS_CODE
,      ORG_ID
,      OPERATING_UNIT_NAME
,      CLASS_CATEGORY1
,      CLASS_CODE1
,      CLASS_CATEGORY2
,      CLASS_CODE2
,      CLASS_CATEGORY3
,      CLASS_CODE3
,      PROJECT_ROLE_TYPE1
,      PROJECT_KEYMEMBER1
,      PROJECT_ROLE_TYPE2
,      PROJECT_KEYMEMBER2
,      PROJECT_ROLE_TYPE3
,      PROJECT_KEYMEMBER3
,      STATUS_REPORTING_FLAG
FROM APPS.PA_RPT_PROJECT_ATTRIBUTES;

Dependencies

[top of page]

APPS.PA_RPT_PROJECT_ATTRIBUTES references the following:

APPS: HR_ALL_ORGANIZATION_UNITS; HR_GENERAL - show dependent code; HR_ORGANIZATION_UNITS; HR_SECURITY - show dependent code; PA_PROJECTS_ALL; PA_PROJECT_STATUSES; PA_PROJECT_STATUS_CONTROLS; PA_PROJECT_TYPES; PA_RPT_UTILS - show dependent code; PA_SECURITY - show dependent code

APPS.PA_RPT_PROJECT_ATTRIBUTES is not referenced by any database object