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

VIEW: APPS.ENG_LIST_ROLES_V

Object Details
Object Name: ENG_LIST_ROLES_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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


View to display engineering approval list


[View Source]

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (49)
Approval List Name
DISPLAY_NAME VARCHAR2 (10) Yes Approval list name that is displayed
DESCRIPTION VARCHAR2 (240)
Approval list description
NOTIFICATION_PREFERENCE VARCHAR2 (4000)
Notification Preference
LANGUAGE VARCHAR2 (0)
language
TERRITORY VARCHAR2 (0)
territory
EMAIL_ADDRESS VARCHAR2 (0)
email address
FAX VARCHAR2 (0)
Fax
ORIG_SYSTEM CHAR (8)
Original System
ORIG_SYSTEM_ID NUMBER
Yes Original System Identifier
START_DATE DATE

Approval list start date
STATUS CHAR (6)
Approval list status
EXPIRATION_DATE DATE

Approval list expiry date
SECURITY_GROUP_ID VARCHAR2 (0)
Security group identifier
USER_FLAG CHAR (1)
User flag
PARTITION_ID NUMBER

partition identifier
Query Text

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


SELECT NAME
,      DISPLAY_NAME
,      DESCRIPTION
,      NOTIFICATION_PREFERENCE
,      LANGUAGE
,      TERRITORY
,      EMAIL_ADDRESS
,      FAX
,      ORIG_SYSTEM
,      ORIG_SYSTEM_ID
,      START_DATE
,      STATUS
,      EXPIRATION_DATE
,      SECURITY_GROUP_ID
,      USER_FLAG
,      PARTITION_ID
FROM APPS.ENG_LIST_ROLES_V;

Dependencies

[top of page]

APPS.ENG_LIST_ROLES_V references the following:

SchemaAPPS
SynonymENG_ECN_APPROVAL_LISTS
PL/SQL PackageWF_PREF - show dependent code

APPS.ENG_LIST_ROLES_V is not referenced by any database object