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.

VIEW: APPLSYS.FND_GRANTS#

Source

View Text - Preformatted


select GRANT_GUID GRANT_GUID, GRANTEE_TYPE GRANTEE_TYPE, GRANTEE_KEY GRANTEE_KEY, MENU_ID MENU_ID, START_DATE START_DATE, END_DATE END_DATE, OBJECT_ID OBJECT_ID, INSTANCE_TYPE INSTANCE_TYPE, INSTANCE_SET_ID INSTANCE_SET_ID, INSTANCE_PK1_VALUE INSTANCE_PK1_VALUE, INSTANCE_PK2_VALUE INSTANCE_PK2_VALUE, INSTANCE_PK3_VALUE INSTANCE_PK3_VALUE, INSTANCE_PK4_VALUE INSTANCE_PK4_VALUE, INSTANCE_PK5_VALUE INSTANCE_PK5_VALUE, PROGRAM_NAME PROGRAM_NAME, PROGRAM_TAG PROGRAM_TAG, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, GRANTEE_ORIG_SYSTEM GRANTEE_ORIG_SYSTEM, GRANTEE_ORIG_SYSTEM_ID GRANTEE_ORIG_SYSTEM_ID, CTX_SECGRP_ID CTX_SECGRP_ID, CTX_RESP_ID CTX_RESP_ID, CTX_RESP_APPL_ID CTX_RESP_APPL_ID, CTX_ORG_ID CTX_ORG_ID, PARAMETER1 PARAMETER1, PARAMETER2 PARAMETER2, PARAMETER3 PARAMETER3, PARAMETER4 PARAMETER4, PARAMETER5 PARAMETER5, PARAMETER6 PARAMETER6, PARAMETER7 PARAMETER7, PARAMETER8 PARAMETER8, PARAMETER9 PARAMETER9, PARAMETER10 PARAMETER10, NAME NAME, DESCRIPTION DESCRIPTION, ZD_EDITION_NAME ZD_EDITION_NAME from "APPLSYS"."FND_GRANTS"

View Text - HTML Formatted

SELECT GRANT_GUID GRANT_GUID
, GRANTEE_TYPE GRANTEE_TYPE
, GRANTEE_KEY GRANTEE_KEY
, MENU_ID MENU_ID
, START_DATE START_DATE
, END_DATE END_DATE
, OBJECT_ID OBJECT_ID
, INSTANCE_TYPE INSTANCE_TYPE
, INSTANCE_SET_ID INSTANCE_SET_ID
, INSTANCE_PK1_VALUE INSTANCE_PK1_VALUE
, INSTANCE_PK2_VALUE INSTANCE_PK2_VALUE
, INSTANCE_PK3_VALUE INSTANCE_PK3_VALUE
, INSTANCE_PK4_VALUE INSTANCE_PK4_VALUE
, INSTANCE_PK5_VALUE INSTANCE_PK5_VALUE
, PROGRAM_NAME PROGRAM_NAME
, PROGRAM_TAG PROGRAM_TAG
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, GRANTEE_ORIG_SYSTEM GRANTEE_ORIG_SYSTEM
, GRANTEE_ORIG_SYSTEM_ID GRANTEE_ORIG_SYSTEM_ID
, CTX_SECGRP_ID CTX_SECGRP_ID
, CTX_RESP_ID CTX_RESP_ID
, CTX_RESP_APPL_ID CTX_RESP_APPL_ID
, CTX_ORG_ID CTX_ORG_ID
, PARAMETER1 PARAMETER1
, PARAMETER2 PARAMETER2
, PARAMETER3 PARAMETER3
, PARAMETER4 PARAMETER4
, PARAMETER5 PARAMETER5
, PARAMETER6 PARAMETER6
, PARAMETER7 PARAMETER7
, PARAMETER8 PARAMETER8
, PARAMETER9 PARAMETER9
, PARAMETER10 PARAMETER10
, NAME NAME
, DESCRIPTION DESCRIPTION
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "APPLSYS"."FND_GRANTS"