Product: | AS - Sales Foundation |
---|---|
Description: | Order history addresses view |
Implementation/DBA Data: | Not implemented in this database |
SELECT HEAD.ROWID
, HEAD.HEADER_ID
, HEAD.LAST_UPDATE_DATE
, HEAD.LAST_UPDATED_BY
, HEAD.CREATION_DATE
, HEAD.CREATED_BY
, HEAD.LAST_UPDATE_LOGIN
, HEAD.SHIP_TO_SITE_USE_ID
, HEAD.SHIP_TO_CONTACT_ID
, CONT1.LAST_NAME
, CONT1.FIRST_NAME
, CUST1.CUSTOMER_ID
, CUST1.CUSTOMER_NAME
, CUST1.CUSTOMER_NUMBER
, ADDR1.ADDRESS_ID
, ADDR1.ADDRESS1
, ADDR1.ADDRESS2
, ADDR1.ADDRESS3
, ADDR1.ADDRESS4
, ADDR1.CITY
, ADDR1.STATE
, ADDR1.PROVINCE
, ADDR1.POSTAL_CODE
, ADDR1.COUNTY
, ADDR1.COUNTRY
, HEAD.INVOICE_TO_SITE_USE_ID
, HEAD.INVOICE_TO_CONTACT_ID
, CONT2.LAST_NAME
, CONT2.FIRST_NAME
, CUST2.CUSTOMER_ID
, CUST2.CUSTOMER_NAME
, CUST2.CUSTOMER_NUMBER
, ADDR2.ADDRESS_ID
, ADDR2.ADDRESS1
, ADDR2.ADDRESS2
, ADDR2.ADDRESS3
, ADDR2.ADDRESS4
, ADDR2.CITY
, ADDR2.STATE
, ADDR2.PROVINCE
, ADDR2.POSTAL_CODE
, ADDR2.COUNTY
, ADDR2.COUNTRY
FROM RA_ADDRESSES ADDR1
, RA_CUSTOMERS CUST1
, RA_ADDRESSES ADDR2
, RA_CUSTOMERS CUST2
, RA_CONTACTS CONT1
, RA_CONTACTS CONT2
, RA_SITE_USES SU1
, RA_SITE_USES SU2
, SO_HEADERS HEAD
WHERE HEAD.SHIP_TO_CONTACT_ID = CONT1.CONTACT_ID(+)
AND HEAD.SHIP_TO_SITE_USE_ID = SU1.SITE_USE_ID(+)
AND SU1.ADDRESS_ID = ADDR1.ADDRESS_ID(+)
AND CUST1.CUSTOMER_ID(+) = ADDR1.CUSTOMER_ID
AND HEAD.INVOICE_TO_CONTACT_ID = CONT2.CONTACT_ID(+)
AND HEAD.INVOICE_TO_SITE_USE_ID = SU2.SITE_USE_ID(+)
AND SU2.ADDRESS_ID = ADDR2.ADDRESS_ID(+)
AND CUST2.CUSTOMER_ID(+) = ADDR2.CUSTOMER_ID