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

VIEW: APPS.UMX_ROLE_ASSIGNMENTS_V

Object Details
Object Name: UMX_ROLE_ASSIGNMENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFND.UMX_ROLE_ASSIGNMENTS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROLE_NAME VARCHAR2 (320)
NAME
REG_REQUEST_ID NUMBER

Request Id
STATUS_CODE VARCHAR2 (30)
Status of the request
DISPLAY_NAME VARCHAR2 (360)
DISPLAY_NAME
STATUS_TEXT VARCHAR2 (80)
STATUS
DETAIL_REGION_SWITCH VARCHAR2 (20)
Detail Region Switch
STATUS_TEXT_SWITCH VARCHAR2 (14)
Status Text Switch
ACTIVE_FROM DATE

Active From
ACTIVE_TO DATE

Active To
JUSTIFICATION VARCHAR2 (2000)
Justification
DESCRIPTION VARCHAR2 (1000)
Description
USER_NAME VARCHAR2 (320)
User Name
HIDE_SHOW CHAR (1)
HIde / Show
REMOVEIMG VARCHAR2 (12)
Remove Img
REG_SERVICE_CODE VARCHAR2 (30)
Reg Svc Code
USER_ID NUMBER (15)
User Id
Query Text

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


SELECT ROLE_NAME
,      REG_REQUEST_ID
,      STATUS_CODE
,      DISPLAY_NAME
,      STATUS_TEXT
,      DETAIL_REGION_SWITCH
,      STATUS_TEXT_SWITCH
,      ACTIVE_FROM
,      ACTIVE_TO
,      JUSTIFICATION
,      DESCRIPTION
,      USER_NAME
,      HIDE_SHOW
,      REMOVEIMG
,      REG_SERVICE_CODE
,      USER_ID
FROM APPS.UMX_ROLE_ASSIGNMENTS_V;

Dependencies

[top of page]

APPS.UMX_ROLE_ASSIGNMENTS_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUP_VALUES_VL
SynonymFND_USER
SynonymUMX_REG_REQUESTS
PL/SQL PackageUMX_REG_REQUESTS_PVT - show dependent code
ViewWF_ALL_ROLES_VL
ViewWF_ALL_USER_ROLE_ASSIGNMENTS
SynonymWF_LOCAL_ROLES
APPS.UMX_ROLE_ASSIGNMENTS_V is referenced by following:

SchemaAPPS
Package BodyARI_SELF_REGISTRATION_PKG - show dependent code