[Home] [Help] [Dependency Information]
Object Name: | ASG_USER_PUBLICATION_ITEM_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 includes information of the user and the publicaiton, publication item 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 | (30) | Yes | User name. |
ITEM_ID | VARCHAR2 | (30) | Yes | Item id. |
PUBLICATION_ITEM_NAME | VARCHAR2 | (30) | Yes | Item name. |
PUBLICATION_ID | VARCHAR2 | (30) | Yes | Pub Id. |
PUBLICATION_NAME | VARCHAR2 | (30) | Yes | PUb name. |
Cut, paste (and edit) the following text to query this object:
SELECT RESOURCE_ID
, USER_ID
, USER_NAME
, ITEM_ID
, PUBLICATION_ITEM_NAME
, PUBLICATION_ID
, PUBLICATION_NAME
FROM APPS.ASG_USER_PUBLICATION_ITEM_V;
APPS.ASG_USER_PUBLICATION_ITEM_V is not referenced by any database object
|
|
|