View: IGI_STP_SITE_BAL

Product:	IGI - Public Sector Financials International
Description:	View which displays the active Sites for a Single Third Party.
Implementation/DBA Data:	APPS.IGI_STP_SITE_BAL

View Text

SELECT CUST.CUSTOMER_ID STP_ID
, ADDR.ADDRESS_ID ADDRESS_ID
, IGI.STP_COMMON_REF ADDRESS_NAME
, VEN.VENDOR_ID
, SITES.VENDOR_SITE_ID
FROM RA_ADDRESSES ADDR
, RA_HCUSTOMERS CUST
, IGI_RA_ADDRESSES IGI
, PO_VENDOR_SITES SITES
, IGI_PO_VENDORS VEN
WHERE CUST.CUSTOMER_ID = ADDR.CUSTOMER_ID
AND ADDR.ADDRESS_ID = IGI.ADDRESS_ID
AND CUST.CUSTOMER_ID = VEN.CUSTOMER_ID
AND VEN.VENDOR_ID = SITES.VENDOR_ID
AND SITES.VENDOR_SITE_CODE = IGI.STP_COMMON_REF

Columns