VIEW: APPS.POS_SUPPLIER_USERS_V

Source

View Text - Preformatted

SELECT fu.user_id, fu.user_name, fu.end_date user_end_date, fu.person_party_id person_party_id, pv.party_id vendor_party_id, pv.vendor_id, hzr.relationship_id, hzr.party_id rel_party_id, hzr.end_date FROM po_vendors pv, hz_parties user_party, fnd_user fu, hz_relationships hzr, ak_web_user_sec_attr_values sec WHERE fu.person_party_id = user_party.party_id AND hzr.relationship_type = 'CONTACT' AND hzr.relationship_code = 'CONTACT_OF' AND hzr.subject_id = fu.person_party_id AND hzr.subject_type = 'PERSON' AND hzr.subject_table_name = 'HZ_PARTIES' AND hzr.object_type = 'ORGANIZATION' AND hzr.object_table_name = 'HZ_PARTIES' AND hzr.object_id = pv.party_id AND hzr.status = 'A' AND sec.web_user_id = fu.user_id AND sec.attribute_code = 'ICX_SUPPLIER_ORG_ID' AND sec.number_value = pv.vendor_id AND sec.ATTRIBUTE_APPLICATION_ID=177

View Text - HTML Formatted

SELECT FU.USER_ID
, FU.USER_NAME
, FU.END_DATE USER_END_DATE
, FU.PERSON_PARTY_ID PERSON_PARTY_ID
, PV.PARTY_ID VENDOR_PARTY_ID
, PV.VENDOR_ID
, HZR.RELATIONSHIP_ID
, HZR.PARTY_ID REL_PARTY_ID
, HZR.END_DATE
FROM PO_VENDORS PV
, HZ_PARTIES USER_PARTY
, FND_USER FU
, HZ_RELATIONSHIPS HZR
, AK_WEB_USER_SEC_ATTR_VALUES SEC
WHERE FU.PERSON_PARTY_ID = USER_PARTY.PARTY_ID
AND HZR.RELATIONSHIP_TYPE = 'CONTACT'
AND HZR.RELATIONSHIP_CODE = 'CONTACT_OF'
AND HZR.SUBJECT_ID = FU.PERSON_PARTY_ID
AND HZR.SUBJECT_TYPE = 'PERSON'
AND HZR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND HZR.OBJECT_TYPE = 'ORGANIZATION'
AND HZR.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND HZR.OBJECT_ID = PV.PARTY_ID
AND HZR.STATUS = 'A'
AND SEC.WEB_USER_ID = FU.USER_ID
AND SEC.ATTRIBUTE_CODE = 'ICX_SUPPLIER_ORG_ID'
AND SEC.NUMBER_VALUE = PV.VENDOR_ID
AND SEC.ATTRIBUTE_APPLICATION_ID=177