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]

TABLE: PA.PA_OBJECT_RELATIONSHIPS

Object Details

Object Name:	PA_OBJECT_RELATIONSHIPS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_OBJECT_RELATIONSHIPS
Subobject Name:
Status:	VALID

This table is used to store all relationships relating to projects, structures and tasks.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_OBJECT_RELATIONSHIPS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	OBJECT_RELATIONSHIP_ID
PA_OBJECT_RELATIONSHIPS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	OBJECT_TYPE_FROM OBJECT_ID_FROM1 OBJECT_ID_FROM2 OBJECT_TYPE_TO OBJECT_ID_TO1 OBJECT_ID_TO2 RELATIONSHIP_TYPE
PA_OBJECT_RELATIONSHIPS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_TYPE_FROM OBJECT_ID_FROM1 OBJECT_ID_FROM2 RELATIONSHIP_TYPE
PA_OBJECT_RELATIONSHIPS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_TYPE_TO OBJECT_ID_TO1 OBJECT_ID_TO2 RELATIONSHIP_TYPE
PA_OBJECT_RELATIONSHIPS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_ID_FROM2
PA_OBJECT_RELATIONSHIPS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_ID_TO1
PA_OBJECT_RELATIONSHIPS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RELATIONSHIP_TYPE
PA_OBJECT_RELATIONSHIPS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_ID_FROM1
PA_OBJECT_RELATIONSHIPS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_ID_TO2

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_RELATIONSHIP_ID	NUMBER		Yes	System generated unique identifier of the object relationship
OBJECT_TYPE_FROM	VARCHAR2	(30)	Yes	The type of the predecessor such as PA_PROJECTS or PA_TASKS
OBJECT_ID_FROM1	NUMBER	(15)		The identifier of the predecessor such as PROJECT_ID if the object_type is PA_PROJECTS
OBJECT_TYPE_TO	VARCHAR2	(30)	Yes	The type of the successor such as PA_PROJECTS or PA_TASKS
OBJECT_ID_TO1	NUMBER	(15)		The identifier of the predecessor
RELATIONSHIP_TYPE	VARCHAR2	(30)	Yes	The type of relationship between the two objects
CREATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
OBJECT_ID_FROM2	NUMBER			The identifier of the predecessor
OBJECT_ID_FROM3	NUMBER			The identifier of the predecessor
OBJECT_ID_FROM4	NUMBER			The identifier of the predecessor
OBJECT_ID_FROM5	NUMBER			The identifier of the predecessor
OBJECT_ID_TO2	NUMBER			The identifier of the successor
OBJECT_ID_TO3	NUMBER			The identifier of the successor
OBJECT_ID_TO4	NUMBER			The identifier of the successor
OBJECT_ID_TO5	NUMBER			The identifier of the successor
RELATIONSHIP_SUBTYPE	VARCHAR2	(30)		Further classifies the relationship-type. For example, if relationship-type is Dependency then the relationship_subtype could be Finish-to-Start
LAG_DAY	NUMBER			Days by which the successor can be started before or after its predecessor
IMPORTED_LAG	VARCHAR2	(30)		Lag imported from external project management system
PRIORITY	VARCHAR2	(30)		The priority of the relationship between two objects
RECORD_VERSION_NUMBER	NUMBER			System generated number for record locking in self service applications
PM_PRODUCT_CODE	VARCHAR2	(30)		The identifier of the external project management system from which the dependency was imported
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
WEIGHTING_PERCENTAGE	NUMBER	(17)		The Task Weighting used for % Complete derivation for the branch of the work breakdown structure.
COMMENTS	VARCHAR2	(240)		Comments for the relationship.
STATUS_CODE	VARCHAR2	(30)		The status code of the relationship.

Query Text

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


SELECT OBJECT_RELATIONSHIP_ID
,      OBJECT_TYPE_FROM
,      OBJECT_ID_FROM1
,      OBJECT_TYPE_TO
,      OBJECT_ID_TO1
,      RELATIONSHIP_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      OBJECT_ID_FROM2
,      OBJECT_ID_FROM3
,      OBJECT_ID_FROM4
,      OBJECT_ID_FROM5
,      OBJECT_ID_TO2
,      OBJECT_ID_TO3
,      OBJECT_ID_TO4
,      OBJECT_ID_TO5
,      RELATIONSHIP_SUBTYPE
,      LAG_DAY
,      IMPORTED_LAG
,      PRIORITY
,      RECORD_VERSION_NUMBER
,      PM_PRODUCT_CODE
,      LAST_UPDATE_LOGIN
,      WEIGHTING_PERCENTAGE
,      COMMENTS
,      STATUS_CODE
FROM PA.PA_OBJECT_RELATIONSHIPS;

Dependencies

[top of page]

PA.PA_OBJECT_RELATIONSHIPS does not reference any database object

PA.PA_OBJECT_RELATIONSHIPS is referenced by following:

APPS: PA_OBJECT_RELATIONSHIPS