[Home] [Help]
View: OEBV_DSCNTCASGNS
Product: | OE - Order Entry |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT -- REGULAR ATTRIBUTES DISCOUNT_CUST.START_DATE_ACTIVE
, DISCOUNT_CUST.END_DATE_ACTIVE
, LOOKUP.MEANING
, '_DF:OE:SO_DISCOUNT_CUSTOMERS:DISCOUNT_CUST' -- ID
, DISCOUNT_CUST.DISCOUNT_CUSTOMER_ID
, DISCOUNT_CUST.DISCOUNT_ID
, DISCOUNT_CUST.CUSTOMER_ID
, DISCOUNT_CUST.SITE_USE_ID
, SITE.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_SITE_USES_ALL SITE
, AR_LOOKUPS LOOKUP
WHERE DISCOUNT_CUST.SITE_USE_ID = SITE.SITE_USE_ID(+) AND LOOKUP.LOOKUP_TYPE(+) = 'CUSTOMER CLASS' AND LOOKUP.LOOKUP_CODE(+) = DISCOUNT_CUST.CUSTOMER_CLASS_CODE WITH READ ONLY
Columns
Name |
START_DATE |
END_DATE |
CUSTOMER_CLASS_NAME |
"_DF" |
DISCOUNT_CUSTOMER_ID |
DISCOUNT_ID |
CUSTOMER_ID |
SITE_USE_ID |
ADDRESS_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |