eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: APPLSYS.UMX_REG_REQUESTS

Object Details

Object Name:	UMX_REG_REQUESTS
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.UMX_REG_REQUESTS
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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
UMX_REG_REQUESTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REG_REQUEST_ID
UMX_REG_REQUESTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUESTED_BY_USER_ID
UMX_REG_REQUESTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUESTED_FOR_USER_ID
UMX_REG_REQUESTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUESTED_FOR_PARTY_ID
UMX_REG_REQUESTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REG_SERVICE_CODE
UMX_REG_REQUESTS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AME_APPLICATION_ID AME_TRANSACTION_TYPE_ID
UMX_REG_REQUESTS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WF_ROLE_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
REG_REQUEST_ID	NUMBER		Yes	Request Id
REG_SERVICE_TYPE	VARCHAR2	(30)	Yes	The type of registration process for this request
STATUS_CODE	VARCHAR2	(30)	Yes	Status of the request
REQUESTED_START_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
SECURITY_GROUP_ID	NUMBER	(15)		Security Group
REQUESTED_BY_USER_ID	NUMBER	(15)		What user submitted this request
REQUESTED_FOR_USER_ID	NUMBER	(15)		On what user's behalf was this request submitted
REQUESTED_FOR_PARTY_ID	NUMBER			On what person's behalf was this request submitted
REQUESTED_USERNAME	VARCHAR2	(100)		The User Name being requested
REQUESTED_END_DATE	DATE
WF_ROLE_NAME	VARCHAR2	(320)		The role being requested
REG_SERVICE_CODE	VARCHAR2	(30)		The registration process for this request
AME_APPLICATION_ID	NUMBER			Application that owns the approval routing rules (defined in Oracle Approval Manager - AME)for this request
AME_TRANSACTION_TYPE_ID	VARCHAR2	(50)		The approval routing rules identifier (defined in Oracle Approval Manager - AME) for this request
JUSTIFICATION	VARCHAR2	(2000)		Justification / reason for the request, provided by the requester

Query Text

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


SELECT REG_REQUEST_ID
,      REG_SERVICE_TYPE
,      STATUS_CODE
,      REQUESTED_START_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      REQUESTED_BY_USER_ID
,      REQUESTED_FOR_USER_ID
,      REQUESTED_FOR_PARTY_ID
,      REQUESTED_USERNAME
,      REQUESTED_END_DATE
,      WF_ROLE_NAME
,      REG_SERVICE_CODE
,      AME_APPLICATION_ID
,      AME_TRANSACTION_TYPE_ID
,      JUSTIFICATION
FROM APPLSYS.UMX_REG_REQUESTS;

Dependencies

[top of page]

APPLSYS.UMX_REG_REQUESTS does not reference any database object

APPLSYS.UMX_REG_REQUESTS is referenced by following:

APPS: UMX_REG_REQUESTS