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


VIEW: APPS.ENG_CHANGE_OBJ_RELATIONSHIPS_V

Object Details
Object Name: ENG_CHANGE_OBJ_RELATIONSHIPS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewENG.ENG_CHANGE_OBJ_RELATIONSHIPS_V
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


ENG_CHANGE_OBJ_RELATIONSHIPS_V stores information to display the relationships between change objects.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CHANGE_ID NUMBER

Change identifier
CHANGE_RELATIONSHIP_ID NUMBER

Change Relationship identifier
RELATIONSHIP_CODE VARCHAR2 (30)
Relationship internal code
RELATIONSHIP VARCHAR2 (80)
Relationship display value
OBJECT_TO_NAME VARCHAR2 (30)
Related object name
OBJECT_TO VARCHAR2 (80)
Related object
OBJECT_TO_ID1 NUMBER

Primary key of the related object
OBJECT_TO_ID2 NUMBER

Primary key of the related object
OBJECT_TO_ID3 NUMBER

Primary key of the related object
OBJECT_TO_URL VARCHAR2 (196)
URL of the related object
RELATIONSHIP_TO_NUMBER VARCHAR2 (52)
RELATIONSHIP_TO_NAME VARCHAR2 (240)
Name of the relationship
RELATIONSHIP_TYPE VARCHAR2 (150)
Type of the relationship
WUSED_RELATIONSHIP CHAR (1)
WUSED_RELATIONSHIP
STATUS VARCHAR2 (80)
Status of the relationship if it Open, Approved etc
NEED_BY_DATE DATE

Need by date
REVISION VARCHAR2 (3)
Revision
CREATION_DATE DATE

Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
REVISION_LABEL VARCHAR2 (80)
Standard WHO column
Query Text

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


SELECT CHANGE_ID
,      CHANGE_RELATIONSHIP_ID
,      RELATIONSHIP_CODE
,      RELATIONSHIP
,      OBJECT_TO_NAME
,      OBJECT_TO
,      OBJECT_TO_ID1
,      OBJECT_TO_ID2
,      OBJECT_TO_ID3
,      OBJECT_TO_URL
,      RELATIONSHIP_TO_NUMBER
,      RELATIONSHIP_TO_NAME
,      RELATIONSHIP_TYPE
,      WUSED_RELATIONSHIP
,      STATUS
,      NEED_BY_DATE
,      REVISION
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      REVISION_LABEL
FROM APPS.ENG_CHANGE_OBJ_RELATIONSHIPS_V;

Dependencies

[top of page]

APPS.ENG_CHANGE_OBJ_RELATIONSHIPS_V references the following:

SchemaAPPS
SynonymENG_CHANGE_OBJ_RELATIONSHIPS
SynonymENG_CHANGE_ORDER_TYPES
SynonymENG_CHANGE_ORDER_TYPES_TL
SynonymENG_CHANGE_STATUSES_TL
SynonymENG_ENGINEERING_CHANGES
SynonymFND_LOOKUP_VALUES
ViewFND_LOOKUP_VALUES_VL
ViewMTL_ITEM_REVISIONS_VL
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymPA_PROJECTS_ALL
SynonymPA_TASKS

APPS.ENG_CHANGE_OBJ_RELATIONSHIPS_V is not referenced by any database object