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_DELIVERABLE_TYPES_AMG_V

Object Details

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

View Type

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

PA_DELIVERABLE_TYPES_AMG_V selects all the attributes of a Deliverable Types.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DELIVERABLE_TYPE_ID	NUMBER	(15)	Yes	The identifier of the project to which the deliverable belongs
DELIVERABLE_TYPE	VARCHAR2	(150)	Yes	Deliverable type name
DELIVERABLE_TYPE_CLASS_CODE	VARCHAR2	(30)		Deliverable Type Class Code.
DELIVERABLE_TYPE_CLASS_MEANING	VARCHAR2	(80)	Yes	Deliverable Type Class Code Meaning.
DESCRIPTION	VARCHAR2	(2000)		Deliverable Type Description.
EFFECTIVE_FROM_DATE	DATE		Yes	Effective from date
EFFECTIVE_TO_DATE	DATE			Effective to date
TASK_TYPE_CLASS_CODE	VARCHAR2	(30)		Deliverable type class code
INITIAL_STATUS_CODE	VARCHAR2	(150)		Initial deliverable status code
INITIAL_STATUS_MEANING	VARCHAR2	(80)		Initial deliverable status meaning.
PROG_ENTRY_ENABLE_FLAG	VARCHAR2	(1)		Flag to indicate whether Progress Entry is enabled.
ENABLE_DLVR_ACTIONS_FLAG	VARCHAR2	(1)		Enable deliverable actions flag.
RECORD_VERSION_NUMBER	NUMBER	(15)		Record version number of deliverable type.

Query Text

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


SELECT DELIVERABLE_TYPE_ID
,      DELIVERABLE_TYPE
,      DELIVERABLE_TYPE_CLASS_CODE
,      DELIVERABLE_TYPE_CLASS_MEANING
,      DESCRIPTION
,      EFFECTIVE_FROM_DATE
,      EFFECTIVE_TO_DATE
,      TASK_TYPE_CLASS_CODE
,      INITIAL_STATUS_CODE
,      INITIAL_STATUS_MEANING
,      PROG_ENTRY_ENABLE_FLAG
,      ENABLE_DLVR_ACTIONS_FLAG
,      RECORD_VERSION_NUMBER
FROM APPS.PA_DELIVERABLE_TYPES_AMG_V;

Dependencies

[top of page]

APPS.PA_DELIVERABLE_TYPES_AMG_V references the following:

APPS: PA_LOOKUPS; PA_PROJECT_STATUSES; PA_TASK_TYPES

APPS.PA_DELIVERABLE_TYPES_AMG_V is not referenced by any database object