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.

[Home] [Help]

View: QA_USER_GROUP_V

Product:	QA - Quality
Description:	FND user to TCA group association used in data security
Implementation/DBA Data:	APPS.QA_USER_GROUP_V

View Text

SELECT FU.USER_ID
, FU.USER_NAME
, HP.EMAIL_ADDRESS
, HP1.PARTY_ID
, HP.PARTY_NUMBER
, HP.PARTY_NAME
, HP1.PARTY_NAME
, HP.VALIDATED_FLAG
, HP.PERSON_FIRST_NAME
, HP.PERSON_LAST_NAME
, HR.PARTY_RELATIONSHIP_ID
, HR.SUBJECT_ID
, HR.OBJECT_ID
, HP.LAST_UPDATE_DATE
, HR.STATUS
, HR.PARTY_ID
FROM HZ_PARTIES HP
, HZ_PARTIES HP1
, QA_HZ_PARTY_RELATIONSHIPS_V HR
, FND_USER FU
WHERE HP.PARTY_ID = HR.SUBJECT_ID
AND HR.OBJECT_ID = HP1.PARTY_ID
AND HP.PARTY_TYPE = 'PERSON'
AND HP.PARTY_ID = FU.PERSON_PARTY_ID
AND NVL(FU.START_DATE
, SYSDATE - 1) <= SYSDATE
AND NVL(FU.END_DATE
, SYSDATE + 1) > SYSDATE

Columns

Name
USER_ID
USER_NAME
EMAIL_ADDRESS
PARTY_ID
PARTY_NUMBER
PERSON_NAME
GROUP_NAME
VALIDATED_FLAG
PERSON_FIRST_NAME
PERSON_LAST_NAME
RELATIONSHIP_ID
SUBJECT_ID
OBJECT_ID
LAST_UPDATE_DATE
STATUS
REL_PARTY_ID