View: IGS_FI_PARTY_VENDRS_V

Product:	IGS - Student System
Description:	Entity to retrieve relationships between the Party in Oracle Student System and Supplier in Oracle Payables.
Implementation/DBA Data:	APPS.IGS_FI_PARTY_VENDRS_V

View Text

SELECT REL.ROWID
, REL.PARTY_ID
, FIP.PERSON_NUMBER
, FIP.FULL_NAME
, FIP.API_PERSON_ID
, REL.VENDOR_ID
, POV.SEGMENT1
, POV.VENDOR_NAME
, REL.VENDOR_SITE_ID
, POS.VENDOR_SITE_CODE
, REL.CREATION_DATE
, REL.CREATED_BY
, REL.LAST_UPDATED_BY
, REL.LAST_UPDATE_DATE
, REL.LAST_UPDATE_LOGIN
, REL.REQUEST_ID
, REL.PROGRAM_APPLICATION_ID
, REL.PROGRAM_ID
, REL.PROGRAM_UPDATE_DATE
FROM IGS_FI_PARTY_VENDRS REL
, IGS_FI_PARTIES_V FIP
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL POS
WHERE REL.PARTY_ID = FIP.PERSON_ID
AND REL.VENDOR_ID = POV.VENDOR_ID
AND REL.VENDOR_SITE_ID = POS.VENDOR_SITE_ID

Columns