[Home] [Help] [Dependency Information]
Object Name: | ASG_USER_APPLICATION_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View contains the information of the user and the application, responsibility, publicaiton information which the user has subscribed to.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_ID | NUMBER | Yes | Resource id. | |
USER_ID | NUMBER | Yes | User id. | |
USER_NAME | VARCHAR2 | (100) | Yes | User name. |
APPLICATION_ID | NUMBER | Yes | Application id. | |
APPLICATION_NAME | VARCHAR2 | (240) | Yes | Application name. |
RESPONSIBILITY_ID | NUMBER | Yes | Responsibility Id. | |
RESPONSIBILITY_NAME | VARCHAR2 | (100) | Yes | Responsibility Name. |
PUBLICATION_ID | VARCHAR2 | (30) | Yes | Publication Id. |
PUBLICATION_NAME | VARCHAR2 | (30) | Yes | PUblication name. |
Cut, paste (and edit) the following text to query this object:
SELECT RESOURCE_ID
, USER_ID
, USER_NAME
, APPLICATION_ID
, APPLICATION_NAME
, RESPONSIBILITY_ID
, RESPONSIBILITY_NAME
, PUBLICATION_ID
, PUBLICATION_NAME
FROM APPS.ASG_USER_APPLICATION_V;
APPS.ASG_USER_APPLICATION_V is not referenced by any database object
|
|
|