View: QA_GRANTED_PRIVILEGES_V

Product:	QA - Quality
Description:	This is the view corresponding to QA_GRANTED_PRIVILEGES
Implementation/DBA Data:	APPS.QA_GRANTED_PRIVILEGES_V

View Text

SELECT QGP.ROWID
, QGP.LAST_UPDATE_DATE
, QGP.LAST_UPDATED_BY
, QGP.CREATION_DATE
, QGP.CREATED_BY
, QGP.LAST_UPDATE_LOGIN
, HP.PARTY_NAME
, QP.NAME
, QGP.QA_GRANT_ID
, QGP.GRANTEE_ID
, QGP.PLAN_ID
, QGP.SETUP_FLAG
, QGP.ENTER_FLAG
, QGP.VIEW_FLAG
, QGP.UPDATE_FLAG
, QGP.DELETE_FLAG
FROM HZ_PARTIES HP
, QA_PLANS_VAL_V QP
, QA_GRANTED_PRIVILEGES QGP
WHERE HP.PARTY_TYPE = 'GROUP'
AND HP.GROUP_TYPE = 'QA'
AND QP.PLAN_ID = QGP.PLAN_ID
AND QGP.GRANTEE_ID = HP.PARTY_ID

Columns