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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: QP.QP_GRANTS

Object Details

Object Name:	QP_GRANTS
Object Type:	TABLE
Owner:	QP
FND Design Data:	QP.QP_GRANTS
Subobject Name:
Status:	VALID

QP_GRANTS works with FND data security system to achieve data security for pricing entities. All
instance type of privileges are stored in QP_GRANTS table and all set type of privileges are stored in
FND_GRANTS for performance concern. QP security will rely on the privileges stored in both
QP_GRANTS and FND_GRANTS table to achieve security authorization.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QP_GRANTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	GRANT_ID
QP_GRANTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_ID MENU_ID INSTANCE_ID GRANTEE_ID
QP_GRANTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_ID INSTANCE_ID GRANTEE_ID
QP_GRANTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GRANTEE_TYPE GRANTEE_ID
QP_GRANTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INSTANCE_ID START_DATE END_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
GRANT_ID	NUMBER		Yes	System generated unique identifier
OBJECT_ID	NUMBER		Yes	Foreign key to seeded 'QP_LIST_HEADERS' object in fnd_objects
INSTANCE_TYPE	VARCHAR2	(5)	Yes	Types of pricing entities, valid values being 'PRL'-standard pricelist, 'MOD'-modifier and 'AGR'-agreement pricelist
INSTANCE_ID	NUMBER		Yes	Identifier of Pricing Entities, e.g. for pricing entities from QP_LIST_HEADERS object, it is the list_header_id.
GRANTEE_TYPE	VARCHAR2	(10)	Yes	Type of Grantee, can be 'GLOBAL' -global, 'OU'-operating unit, 'RESP' -responsibility, 'USER' -user
GRANTEE_ID	NUMBER		Yes	Identifier of a specific grantee; For 'GLOBAL', it is -1; For 'OU', foreign key to hr_operating_units; For'RESP', foreign key to fnd_responsibilities; For 'USER', foreign key to fnd_user.
MENU_ID	NUMBER		Yes	Foreign key to fnd_menus table, seeded 'QP_SECU_VIEWONLY' and 'QP_SECU_MAINTAIN' in fnd_menus.
START_DATE	DATE			effective start date
END_DATE	DATE			effective end date
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT GRANT_ID
,      OBJECT_ID
,      INSTANCE_TYPE
,      INSTANCE_ID
,      GRANTEE_TYPE
,      GRANTEE_ID
,      MENU_ID
,      START_DATE
,      END_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM QP.QP_GRANTS;

Dependencies

[top of page]

QP.QP_GRANTS does not reference any database object

QP.QP_GRANTS is referenced by following:

QP: QP_GRANTS#