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

VIEW: APPS.ENG_CHANGE_SUBJECTS_V

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

View Type

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


ENG_CHANGE_SUBJECTS_V stores information to display change subject information.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CHANGE_ID NUMBER

Change Id
CHANGE_LINE_ID NUMBER

Change line id
CREATED_BY NUMBER

Standard WHO column
CREATION_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER

Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
ENTITY_NAME VARCHAR2 (30)
Entity name
PK1_VALUE VARCHAR2 (100)
Primary key of the entity
PK2_VALUE VARCHAR2 (100)
Primary key of the entity
PK3_VALUE VARCHAR2 (100)
Primary key of the entity
PK4_VALUE VARCHAR2 (100)
Primary key of the entity
PK5_VALUE VARCHAR2 (100)
Primary key of the entity
OBJECT_NAME VARCHAR2 (30)
Name of the entity
SUBJECT_LEVEL NUMBER

Subject level
Query Text

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


SELECT CHANGE_ID
,      CHANGE_LINE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      ENTITY_NAME
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      OBJECT_NAME
,      SUBJECT_LEVEL
FROM APPS.ENG_CHANGE_SUBJECTS_V;

Dependencies

[top of page]

APPS.ENG_CHANGE_SUBJECTS_V references the following:

SchemaAPPS
SynonymENG_CHANGE_SUBJECTS
SynonymENG_REVISED_ITEMS
SynonymMTL_ITEM_REVISIONS_B

APPS.ENG_CHANGE_SUBJECTS_V is not referenced by any database object