View: PO_SUPPLIER_USERS_V

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.PO_SUPPLIER_USERS_V

View Text

SELECT FND_USER.USER_ID FND_USER_ID
, FND_USER.USER_NAME FND_USER_NAME
, FND_USER.CUSTOMER_ID FND_CUSTOMER_ID
, USER_PARTIES.PARTY_ID USER_PARTY_ID
, USER_PARTIES.PARTY_NAME USER_PARTY_NAME
, (USER_PARTIES.PERSON_FIRST_NAME || ' ' || DECODE(USER_PARTIES.PERSON_MIDDLE_NAME
, NULL
, ''
, (USER_PARTIES.PERSON_MIDDLE_NAME || ' ')) || USER_PARTIES.PERSON_LAST_NAME) AS USER_PARTY_FULL_NAME
, USER_PARTIES.EMAIL_ADDRESS USER_PARTY_EMAIL_ADDRESS
, USER_PARTIES.CITY USER_PARTY_CITY
, USER_PARTIES.STATE USER_PARTY_STATE
, USER_PARTIES.PROVINCE USER_PARTY_PROVINCE
, COMPANY_PARTIES.PARTY_ID VENDOR_PARTY_ID
, PO_VENDORS.VENDOR_NAME PO_VENDOR_NAME
, PO_VENDORS.VENDOR_ID PO_VENDOR_ID
FROM FND_USER
, HZ_PARTIES USER_PARTIES
, HZ_PARTIES COMPANY_PARTIES
, PO_VENDORS
, HZ_RELATIONSHIPS VENDOR_RELATIONSHIP
, HZ_RELATIONSHIPS EMPLOYMENT_RELATIONSHIP
WHERE FND_USER.CUSTOMER_ID = USER_PARTIES.PARTY_ID
AND EMPLOYMENT_RELATIONSHIP.OBJECT_ID = COMPANY_PARTIES.PARTY_ID
AND EMPLOYMENT_RELATIONSHIP.SUBJECT_ID = USER_PARTIES.PARTY_ID
AND EMPLOYMENT_RELATIONSHIP.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'
AND EMPLOYMENT_RELATIONSHIP.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
AND EMPLOYMENT_RELATIONSHIP.START_DATE <= SYSDATE
AND EMPLOYMENT_RELATIONSHIP.END_DATE >= SYSDATE
AND VENDOR_RELATIONSHIP.OBJECT_ID = PO_VENDORS.VENDOR_ID
AND VENDOR_RELATIONSHIP.SUBJECT_ID = COMPANY_PARTIES.PARTY_ID
AND VENDOR_RELATIONSHIP.RELATIONSHIP_TYPE = 'POS_VENDOR_PARTY'
AND VENDOR_RELATIONSHIP.RELATIONSHIP_CODE = 'PARTY_OF_VENDOR'
AND VENDOR_RELATIONSHIP.START_DATE <= SYSDATE
AND VENDOR_RELATIONSHIP.END_DATE >= SYSDATE

Columns