Product: | OE - Order Entry |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT -- REGULAR ATTRIBUTES DISCOUNT_CUST.START_DATE_ACTIVE
, DISCOUNT_CUST.END_DATE_ACTIVE
, LOOKUP.MEANING
, '_DF:OE:SO_DISCOUNT_CUSTOMERS:DISCOUNT_CUST' -- RESOLVED FK RESOLUTIONS
, DISCOUNT.NAME
, CUSTOMER.CUSTOMER_NAME
, SITE_USE.LOCATION
, SITE_ADDR.ADDRESS1
, SITE_ADDR.ADDRESS2
, SITE_ADDR.ADDRESS3
, SITE_ADDR.ADDRESS4
, SITE_ADDR.CITY
, SITE_ADDR.STATE
, SITE_ADDR.POSTAL_CODE
, SITE_ADDR.PROVINCE
, SITE_ADDR.COUNTY
, SITE_ADDR.COUNTRY -- ID
, DISCOUNT_CUST.DISCOUNT_CUSTOMER_ID
, DISCOUNT_CUST.DISCOUNT_ID
, DISCOUNT_CUST.CUSTOMER_ID
, DISCOUNT_CUST.SITE_USE_ID
, SITE_USE.ADDRESS_ID -- WHO
, DISCOUNT_CUST.LAST_UPDATE_DATE
, DISCOUNT_CUST.LAST_UPDATED_BY
, DISCOUNT_CUST.CREATION_DATE
, DISCOUNT_CUST.CREATED_BY
FROM SO_DISCOUNT_CUSTOMERS DISCOUNT_CUST
, RA_CUSTOMERS CUSTOMER
, SO_DISCOUNTS DISCOUNT
, RA_SITE_USES_ALL SITE_USE
, RA_ADDRESSES_ALL SITE_ADDR
, AR_LOOKUPS LOOKUP
WHERE DISCOUNT_CUST.DISCOUNT_ID = DISCOUNT.DISCOUNT_ID(+) AND DISCOUNT_CUST.CUSTOMER_ID = CUSTOMER.CUSTOMER_ID(+) AND DISCOUNT_CUST.SITE_USE_ID = SITE_USE.SITE_USE_ID(+) AND SITE_USE.ADDRESS_ID = SITE_ADDR.ADDRESS_ID(+) AND LOOKUP.LOOKUP_TYPE(+) = 'CUSTOMER CLASS' AND LOOKUP.LOOKUP_CODE(+) = DISCOUNT_CUST.CUSTOMER_CLASS_CODE WITH READ ONLY