[Home] [Help] [Dependency Information]
Object Name: | FND_GRANTS# |
---|---|
Object Type: | VIEW |
Owner: | APPLSYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GRANT_GUID | RAW | (16) | Yes | |
GRANTEE_TYPE | VARCHAR2 | (8) | Yes | |
GRANTEE_KEY | VARCHAR2 | (240) | Yes | |
MENU_ID | NUMBER | (15) | Yes | |
START_DATE | DATE | Yes | ||
END_DATE | DATE | |||
OBJECT_ID | NUMBER | (15) | Yes | |
INSTANCE_TYPE | VARCHAR2 | (8) | Yes | |
INSTANCE_SET_ID | NUMBER | |||
INSTANCE_PK1_VALUE | VARCHAR2 | (256) | ||
INSTANCE_PK2_VALUE | VARCHAR2 | (256) | ||
INSTANCE_PK3_VALUE | VARCHAR2 | (256) | ||
INSTANCE_PK4_VALUE | VARCHAR2 | (256) | ||
INSTANCE_PK5_VALUE | VARCHAR2 | (256) | ||
PROGRAM_NAME | VARCHAR2 | (30) | ||
PROGRAM_TAG | VARCHAR2 | (30) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | |
GRANTEE_ORIG_SYSTEM | VARCHAR2 | (48) | ||
GRANTEE_ORIG_SYSTEM_ID | NUMBER | (15) | ||
CTX_SECGRP_ID | NUMBER | (15) | Yes | |
CTX_RESP_ID | NUMBER | (15) | Yes | |
CTX_RESP_APPL_ID | NUMBER | Yes | ||
CTX_ORG_ID | NUMBER | Yes | ||
PARAMETER1 | VARCHAR2 | (256) | ||
PARAMETER2 | VARCHAR2 | (256) | ||
PARAMETER3 | VARCHAR2 | (256) | ||
PARAMETER4 | VARCHAR2 | (256) | ||
PARAMETER5 | VARCHAR2 | (256) | ||
PARAMETER6 | VARCHAR2 | (256) | ||
PARAMETER7 | VARCHAR2 | (256) | ||
PARAMETER8 | VARCHAR2 | (256) | ||
PARAMETER9 | VARCHAR2 | (256) | ||
PARAMETER10 | VARCHAR2 | (256) | ||
NAME | VARCHAR2 | (80) | ||
DESCRIPTION | VARCHAR2 | (240) | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT GRANT_GUID
, GRANTEE_TYPE
, GRANTEE_KEY
, MENU_ID
, START_DATE
, END_DATE
, OBJECT_ID
, INSTANCE_TYPE
, INSTANCE_SET_ID
, INSTANCE_PK1_VALUE
, INSTANCE_PK2_VALUE
, INSTANCE_PK3_VALUE
, INSTANCE_PK4_VALUE
, INSTANCE_PK5_VALUE
, PROGRAM_NAME
, PROGRAM_TAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, GRANTEE_ORIG_SYSTEM
, GRANTEE_ORIG_SYSTEM_ID
, CTX_SECGRP_ID
, CTX_RESP_ID
, CTX_RESP_APPL_ID
, CTX_ORG_ID
, PARAMETER1
, PARAMETER2
, PARAMETER3
, PARAMETER4
, PARAMETER5
, PARAMETER6
, PARAMETER7
, PARAMETER8
, PARAMETER9
, PARAMETER10
, NAME
, DESCRIPTION
, ZD_EDITION_NAME
FROM APPLSYS.FND_GRANTS#;
|
|
|