VIEW: APPS.QA_USER_GROUP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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