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_DELIVERABLES_AMG_V

Object Details

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

View Type

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

PA_DELIVERABLES_AMG_V selects all the attributes of a Deliverable.

[View Source]

Columns

Name	Datatype	Length	Comments
PROJECT_ID	NUMBER	(15)	The identifier of the project to which the deliverable belongs
PROJECT_NAME	VARCHAR2	(30)	Identifies Project Name
PROJECT_NUMBER	VARCHAR2	(25)	Identifies Project Number
DELIVERABLE_ID	NUMBER	(15)	Unique identifier of deliverable
DELIVERABLE_NAME	VARCHAR2	(240)	User-defined alphanumeric character for deliverable name
DELIVERABLE_SHORT_NAME	VARCHAR2	(100)	User-defined alphanumeric character that uniquely identifies the deliverable within a project
DELIVERABLE_STATUS_MEANING	VARCHAR2	(80)	Deliverable status name.
DELIVERABLE_STATUS_CODE	VARCHAR2	(150)	Deliverable status code.
PROGRESS_STATUS_MEANING	VARCHAR2	(80)	Progress status name.
PROGRESS_STATUS_CODE	VARCHAR2	(150)	Progress status code.
DELIVERABLE_OWNER_NAME	VARCHAR2	(240)	Deliverable owner name.
DELIVERABLE_OWNER_ID	NUMBER	(15)	Deliverable owner id.
DELIVERABLE_TYPE	VARCHAR2	(150)	Deliverable Type.
DELIVERABLE_TYPE_ID	NUMBER	(15)	Deliverbale Type Id.
PROGRESS_WEIGHT	NUMBER	(17)	Progress weight of deliverable.
DESCRIPTION	VARCHAR2	(2000)	Progress Overview.
DUE_DATE	DATE		Due date of deliverable.
COMPLETION_DATE	DATE		Completion date of deliverable.
PM_DELIVERABLE_REFERENCE	VARCHAR2	(25)	The unique identifier of deliverable in external project management system .
PM_PRODUCT_CODE	VARCHAR2	(30)	The identifier of the external project management system from which the deliverable was imported.
RECORD_VERSION_NUMBER	NUMBER	(15)	Record version number of the deliverable.
AS_OF_DATE	DATE		As of Date of the deliverable progress record.
COMPLETED_PERCENTAGE	NUMBER		Physical percent complete of the deliverable.
PUBLISHED_BY_PARTY_ID	NUMBER		Person Id of the person publsihed the progress.
PROGRESS_COMMENT	VARCHAR2	(4000)	Progress Comment.
PROGRESS_OVERVIEW	VARCHAR2	(250)	Progress Overview information from pa_percent_completes table.
PROGRESS_ENTRY_ENABLED	VARCHAR2	(1)	Flag to indicate whetger percent complete entry is enabled for the deliverable type.

Query Text

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


SELECT PROJECT_ID
,      PROJECT_NAME
,      PROJECT_NUMBER
,      DELIVERABLE_ID
,      DELIVERABLE_NAME
,      DELIVERABLE_SHORT_NAME
,      DELIVERABLE_STATUS_MEANING
,      DELIVERABLE_STATUS_CODE
,      PROGRESS_STATUS_MEANING
,      PROGRESS_STATUS_CODE
,      DELIVERABLE_OWNER_NAME
,      DELIVERABLE_OWNER_ID
,      DELIVERABLE_TYPE
,      DELIVERABLE_TYPE_ID
,      PROGRESS_WEIGHT
,      DESCRIPTION
,      DUE_DATE
,      COMPLETION_DATE
,      PM_DELIVERABLE_REFERENCE
,      PM_PRODUCT_CODE
,      RECORD_VERSION_NUMBER
,      AS_OF_DATE
,      COMPLETED_PERCENTAGE
,      PUBLISHED_BY_PARTY_ID
,      PROGRESS_COMMENT
,      PROGRESS_OVERVIEW
,      PROGRESS_ENTRY_ENABLED
FROM APPS.PA_DELIVERABLES_AMG_V;

Dependencies

[top of page]

APPS.PA_DELIVERABLES_AMG_V references the following:

APPS: PA_LOOKUPS; PA_PERCENT_COMPLETES; PA_PROGRESS_ROLLUP; PA_PROJECTS_ALL; PA_PROJECT_STATUSES; PA_PROJ_ELEMENTS; PA_PROJ_ELEMENT_VERSIONS; PA_PROJ_ELEM_VER_SCHEDULE; PA_TASK_TYPES; PER_ALL_PEOPLE_F

APPS.PA_DELIVERABLES_AMG_V is not referenced by any database object