View: OE_PRINT_CUST_ADDRESS_V

Product:	ONT - Order Management
Description:	This view is used to print the Bill-To, Ship-To and Deliver-To address of Customers from the Blanket Sales Agreement lines.
Implementation/DBA Data:	APPS.OE_PRINT_CUST_ADDRESS_V

View Text

SELECT SU.SITE_USE_ID
, SU.LOCATION LOCATION
, LOC.ADDRESS1 ADDRESS1
, LOC.ADDRESS2 ADDRESS2
, LOC.ADDRESS3 ADDRESS3
, LOC.ADDRESS4 ADDRESS4
, LOC.CITY CITY
, LOC.STATE STATE
, LOC.POSTAL_CODE POSTAL_CODE
, LOC.COUNTRY COUNTRY
, LOC.COUNTY COUNTY
, LOC.PROVINCE PROVINCE
FROM HZ_CUST_SITE_USES_ALL SU
, HZ_PARTY_SITES PS
, HZ_LOCATIONS LOC
, HZ_CUST_ACCT_SITES_ALL CAS
WHERE SU.CUST_ACCT_SITE_ID = CAS.CUST_ACCT_SITE_ID
AND CAS.PARTY_SITE_ID = PS.PARTY_SITE_ID
AND LOC.LOCATION_ID = PS.LOCATION_ID

Columns