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

VIEW: APPS.ENG_SUBJECT_ENTITIES_V

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

View Type

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


ENG_SUBJECT_ENTITIES_V stores information to display engineering subject entity information.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SUBJECT_ID NUMBER
Yes Subject identifier
SUBJECT_LEVEL NUMBER
Yes Subject level
ENTITY_NAME VARCHAR2 (30) Yes Entity name
PARENT_ENTITY_NAME VARCHAR2 (30)
Parent entity name
QUERY_OBJECT_NAME VARCHAR2 (30) Yes Table or view object name that contains the view of the entity
PK1_COLUMN_NAME VARCHAR2 (30)
Primary column of the entity
PK2_COLUMN_NAME VARCHAR2 (30)
Primary column of the entity
PK3_COLUMN_NAME VARCHAR2 (30)
Primary column of the entity
PK4_COLUMN_NAME VARCHAR2 (30)
Primary column of the entity
PK5_COLUMN_NAME VARCHAR2 (30)
Primary column of the entity
QUERY_COLUMN1_NAME VARCHAR2 (30) Yes Column1 in the object mentioned in query_object_name
QUERY_COLUMN2_NAME VARCHAR2 (30)
Column1 in the object mentioned in query_object_name
QUERY_COLUMN3_NAME VARCHAR2 (30)
Column1 in the object mentioned in query_object_name
QUERY_COLUMN4_NAME VARCHAR2 (30)
Column1 in the object mentioned in query_object_name
QUERY_COLUMN5_NAME VARCHAR2 (30)
Column1 in the object mentioned in query_object_name
QUERY_COLUMN1_TYPE VARCHAR2 (8)
Datatype of column1 in the object mentioned in query_object_name
QUERY_COLUMN2_TYPE VARCHAR2 (8)
Datatype of column2 in the object mentioned in query_object_name
QUERY_COLUMN3_TYPE VARCHAR2 (8)
Datatype of column3 in the object mentioned in query_object_name
QUERY_COLUMN4_TYPE VARCHAR2 (8)
Datatype of column4 in the object mentioned in query_object_name
QUERY_COLUMN5_TYPE VARCHAR2 (8)
Datatype of column5 in the object mentioned in query_object_name
QUERY_COLUMN1_DISPLAY_NAME VARCHAR2 (240)
Displayed name from the query
QUERY_COLUMN2_DISPLAY_NAME VARCHAR2 (240)
Displayed name from the query
FK1_COLUMN_NAME VARCHAR2 (30)
Foreign key of the entity name to the parent entity name
FK2_COLUMN_NAME VARCHAR2 (30)
Foreign key of the entity name to the parent entity name
FK3_COLUMN_NAME VARCHAR2 (30)
Foreign key of the entity name to the parent entity name
FK4_COLUMN_NAME VARCHAR2 (30)
Foreign key of the entity name to the parent entity name
FK5_COLUMN_NAME VARCHAR2 (30)
Foreign key of the entity name to the parent entity name
CREATED_BY NUMBER
Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER
Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
ENTITY_URL VARCHAR2 (2000)
URL to the entity page
BEAN_TYPE VARCHAR2 (1)
BEAN_TYPE
Query Text

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


SELECT SUBJECT_ID
,      SUBJECT_LEVEL
,      ENTITY_NAME
,      PARENT_ENTITY_NAME
,      QUERY_OBJECT_NAME
,      PK1_COLUMN_NAME
,      PK2_COLUMN_NAME
,      PK3_COLUMN_NAME
,      PK4_COLUMN_NAME
,      PK5_COLUMN_NAME
,      QUERY_COLUMN1_NAME
,      QUERY_COLUMN2_NAME
,      QUERY_COLUMN3_NAME
,      QUERY_COLUMN4_NAME
,      QUERY_COLUMN5_NAME
,      QUERY_COLUMN1_TYPE
,      QUERY_COLUMN2_TYPE
,      QUERY_COLUMN3_TYPE
,      QUERY_COLUMN4_TYPE
,      QUERY_COLUMN5_TYPE
,      QUERY_COLUMN1_DISPLAY_NAME
,      QUERY_COLUMN2_DISPLAY_NAME
,      FK1_COLUMN_NAME
,      FK2_COLUMN_NAME
,      FK3_COLUMN_NAME
,      FK4_COLUMN_NAME
,      FK5_COLUMN_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ENTITY_URL
,      BEAN_TYPE
FROM APPS.ENG_SUBJECT_ENTITIES_V;

Dependencies

[top of page]

APPS.ENG_SUBJECT_ENTITIES_V references the following:

SchemaAPPS
ViewENG_CHANGE_OBJECTS_V
SynonymENG_SUBJECT_ENTITIES
APPS.ENG_SUBJECT_ENTITIES_V is referenced by following:

SchemaAPPS
Package BodyENG_CHANGE_LINE_UTIL - show dependent code