View: POS_SUPPLIER_USERS_V

Product:	POS - iSupplier Portal
Description:	Queries the list of supplier users
Implementation/DBA Data:	APPS.POS_SUPPLIER_USERS_V

View Text

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

Columns