[Home] [Help] [Dependency Information]
Object Name: | IGS_SC_GRANT_CONDS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_SC_GRANT_CONDS_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
Self-Service view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJ_GROUP_ID | NUMBER | Yes | Object group identifier generated from the table IGS_SC_OBJ_GROUPS | |
GRANT_ID | NUMBER | Yes | Grant identifier generated from the table IGS_SC_GRANTS | |
GRANT_COND_NUM | NUMBER | (3) | Yes | Grant condition number. The possible values are 1-999 per restrictions on number of conditions per grant |
OBJ_ATTRIB_ID | NUMBER | Object attribute identifier generated from table IGS_SC_OBJ_ATTRIBS | ||
OBJ_ATTRIB_NAME | VARCHAR2 | (260) | Object attribute name that is defined by the user | |
USER_ATTRIB_ID | NUMBER | User attribute identifier generated from table IGS_SC_USR_ATTRIBS | ||
USER_ATTRIB_NAME | VARCHAR2 | (260) | User attribute name defined by user | |
CONDITION | VARCHAR2 | (30) | Condition of the grant | |
TEXT_VALUE | VARCHAR2 | (260) | Condition text value | |
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | (15) | 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 |
Cut, paste (and edit) the following text to query this object:
SELECT OBJ_GROUP_ID
, GRANT_ID
, GRANT_COND_NUM
, OBJ_ATTRIB_ID
, OBJ_ATTRIB_NAME
, USER_ATTRIB_ID
, USER_ATTRIB_NAME
, CONDITION
, TEXT_VALUE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGS_SC_GRANT_CONDS_V;
APPS.IGS_SC_GRANT_CONDS_V is not referenced by any database object
|
|
|