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_PROGRAM_LINKS_AMG_V

Object Details

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

View Type

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

This view provides program links information

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SUB_PROJECT_ID	NUMBER		Yes	Unique identifier of the subproject in Oracle Projects
SUB_PROJECT_NAME	VARCHAR2	(30)	Yes	User-defined name of the subproject
PM_SUB_PROJECT_REFERENCE	VARCHAR2	(25)		Unique identifier of the subproject in the external system
SUB_PROJECT_NUMBER	VARCHAR2	(25)	Yes	User-defined number of the subproject
SUB_STRUCTURE_VER_ID	NUMBER	(15)	Yes	Unique identifier of the linked structure version in the subproject in Oracle Projects
RELATIONSHIP_TYPE	VARCHAR2	(30)	Yes	Identifier of the type of link (LF indicates a link between financial structures, and LW indicates a link between workplan structures)
COMMENTS	VARCHAR2	(240)		Program link comments
PARENT_PROJECT_ID	NUMBER		Yes	Unique identifier of the parent project in Oracle Projects
PARENT_PROJECT_NAME	VARCHAR2	(30)	Yes	User-defined name of the parent project
PM_PARENT_PROJECT_REFERENCE	VARCHAR2	(25)		Unique identifier of the parent project in the external system
PARENT_PROJECT_NUMBER	VARCHAR2	(25)	Yes	User-defined number of the parent project
PARENT_STRUCTURE_VER_ID	NUMBER	(15)		Unique identifier of the linked structure version in the parent project in Oracle Projects
PARENT_TASK_VERSION_ID	NUMBER	(15)	Yes	Unique identifier of the linked task version in the parent project in Oracle Projects
PARENT_TASK_ID	NUMBER	(15)	Yes	Unique identifier of the linked task in the parent project in Oracle Projects
PARENT_TASK_NUMBER	VARCHAR2	(100)		User-defined number of the linked task in the parent project
PARENT_TASK_NAME	VARCHAR2	(240)	Yes	User-defined name of the linked task in the parent project
PM_PARENT_TASK_REFERENCE	VARCHAR2	(25)		Unique identifier of the linked task in the parent project in the external system
OBJECT_RELATIONSHIP_ID	NUMBER		Yes	Unique identifier for the program link in Oracle Projects

Query Text

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


SELECT SUB_PROJECT_ID
,      SUB_PROJECT_NAME
,      PM_SUB_PROJECT_REFERENCE
,      SUB_PROJECT_NUMBER
,      SUB_STRUCTURE_VER_ID
,      RELATIONSHIP_TYPE
,      COMMENTS
,      PARENT_PROJECT_ID
,      PARENT_PROJECT_NAME
,      PM_PARENT_PROJECT_REFERENCE
,      PARENT_PROJECT_NUMBER
,      PARENT_STRUCTURE_VER_ID
,      PARENT_TASK_VERSION_ID
,      PARENT_TASK_ID
,      PARENT_TASK_NUMBER
,      PARENT_TASK_NAME
,      PM_PARENT_TASK_REFERENCE
,      OBJECT_RELATIONSHIP_ID
FROM APPS.PA_PROGRAM_LINKS_AMG_V;

Dependencies

[top of page]

APPS.PA_PROGRAM_LINKS_AMG_V references the following:

APPS: PA_OBJECT_RELATIONSHIPS; PA_PROJECTS_ALL; PA_PROJ_ELEMENTS; PA_PROJ_ELEMENT_VERSIONS; PA_PROJ_ELEM_VER_STRUCTURE

APPS.PA_PROGRAM_LINKS_AMG_V is not referenced by any database object