DBA Data[Home] [Help] [Dependency Information]

VIEW: PA.PA_OBJECT_RELATIONSHIPS#

Object Details
Object Name: PA_OBJECT_RELATIONSHIPS#
Object Type: VIEW
Owner: PA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
OBJECT_RELATIONSHIP_ID NUMBER
Yes
OBJECT_TYPE_FROM VARCHAR2 (30) Yes
OBJECT_ID_FROM1 NUMBER (15)
OBJECT_TYPE_TO VARCHAR2 (30) Yes
OBJECT_ID_TO1 NUMBER (15)
RELATIONSHIP_TYPE VARCHAR2 (30) Yes
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
OBJECT_ID_FROM2 NUMBER

OBJECT_ID_FROM3 NUMBER

OBJECT_ID_FROM4 NUMBER

OBJECT_ID_FROM5 NUMBER

OBJECT_ID_TO2 NUMBER

OBJECT_ID_TO3 NUMBER

OBJECT_ID_TO4 NUMBER

OBJECT_ID_TO5 NUMBER

RELATIONSHIP_SUBTYPE VARCHAR2 (30)
LAG_DAY NUMBER

IMPORTED_LAG VARCHAR2 (30)
PRIORITY VARCHAR2 (30)
RECORD_VERSION_NUMBER NUMBER

PM_PRODUCT_CODE VARCHAR2 (30)
LAST_UPDATE_LOGIN NUMBER

WEIGHTING_PERCENTAGE NUMBER (17)
COMMENTS VARCHAR2 (240)
STATUS_CODE VARCHAR2 (30)
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# references the following:

SchemaPA
TablePA_OBJECT_RELATIONSHIPS
PA.PA_OBJECT_RELATIONSHIPS# is referenced by following:

SchemaAPPS
SynonymPA_OBJECT_RELATIONSHIPS