VIEW: APPS.IGI_STP_SITE_BAL

Source

View Text - Preformatted

SELECT CS. cust_account_id "STP_ID" , CSITES. cust_acct_site_id "ADDRESS_ID" , IGI.STP_COMMON_REF "ADDRESS_NAME" , VEN.VENDOR_ID , SITES.VENDOR_SITE_ID , CSITES.ORG_ID FROM HZ_PARTY_SITES PSITES, HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL CSITES, HZ_PARTIES PS, HZ_CUST_ACCOUNTS CS, igi_ra_addresses IGI, AP_SUPPLIER_SITES SITES, igi_po_vendors VEN WHERE PSITES.PARTY_SITE_ID = CSITES.PARTY_SITE_ID AND LOC.LOCATION_ID = PSITES.LOCATION_ID AND PS.PARTY_ID = CS.PARTY_ID AND CS. cust_account_id = CSITES. cust_account_id AND CSITES. cust_acct_site_id = IGI.ADDRESS_ID AND CS. cust_account_id = VEN.CUSTOMER_ID AND VEN.VENDOR_ID = SITES.VENDOR_ID AND SITES.VENDOR_SITE_CODE = IGI.STP_COMMON_REF

View Text - HTML Formatted

SELECT CS. CUST_ACCOUNT_ID "STP_ID"
, CSITES. CUST_ACCT_SITE_ID "ADDRESS_ID"
, IGI.STP_COMMON_REF "ADDRESS_NAME"
, VEN.VENDOR_ID
, SITES.VENDOR_SITE_ID
, CSITES.ORG_ID
FROM HZ_PARTY_SITES PSITES
, HZ_LOCATIONS LOC
, HZ_CUST_ACCT_SITES_ALL CSITES
, HZ_PARTIES PS
, HZ_CUST_ACCOUNTS CS
, IGI_RA_ADDRESSES IGI
, AP_SUPPLIER_SITES SITES
, IGI_PO_VENDORS VEN
WHERE PSITES.PARTY_SITE_ID = CSITES.PARTY_SITE_ID
AND LOC.LOCATION_ID = PSITES.LOCATION_ID
AND PS.PARTY_ID = CS.PARTY_ID
AND CS. CUST_ACCOUNT_ID = CSITES. CUST_ACCOUNT_ID
AND CSITES. CUST_ACCT_SITE_ID = IGI.ADDRESS_ID
AND CS. CUST_ACCOUNT_ID = VEN.CUSTOMER_ID
AND VEN.VENDOR_ID = SITES.VENDOR_ID
AND SITES.VENDOR_SITE_CODE = IGI.STP_COMMON_REF