Product: | OE - Order Entry |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | Not implemented in this database |
SELECT DISCOUNT.NAME
, '_LA:DISCOUNT_TYPE_CODE:SO_LOOKUPS:DISCOUNTS:MEANING'
, '_LA:GSA_INDICATOR:SO_LOOKUPS:YES_NO:MEANING'
, '_LA:PRORATE_FLAG:SO_LOOKUPS:PRORATION_TYPE:MEANING'
, DISCOUNT.PERCENT
, DISCOUNT.AMOUNT
, DISCOUNT.START_DATE_ACTIVE
, DISCOUNT.END_DATE_ACTIVE
, DISCOUNT.DESCRIPTION
, '_LA:AUTOMATIC_DISCOUNT_FLAG:SO_LOOKUPS:YES_NO:MEANING'
, '_LA:OVERRIDE_ALLOWED_FLAG:SO_LOOKUPS:YES_NO:MEANING'
, '_DF:OE:SO_DISCOUNTS:SO_DISCOUNTS'
, PRICE_LIST.NAME
, DISCOUNT.DISCOUNT_ID
, DISCOUNT.PRICE_LIST_ID
, DISCOUNT.LAST_UPDATE_DATE
, DISCOUNT.LAST_UPDATED_BY
, DISCOUNT.CREATION_DATE
, DISCOUNT.CREATED_BY
FROM SO_DISCOUNTS DISCOUNT
, SO_PRICE_LISTS PRICE_LIST
WHERE DISCOUNT.PRICE_LIST_ID = PRICE_LIST.PRICE_LIST_ID WITH READ ONLY