Product: | OE - Order Entry |
---|---|
Description: | |
Implementation/DBA Data: | APPS.SO_PRICE_ADJUSTMENTS_V |
SELECT ADJ.ROWID ROW_ID
, ADJ.PRICE_ADJUSTMENT_ID
, ADJ.CREATION_DATE
, ADJ.CREATED_BY
, ADJ.LAST_UPDATE_DATE
, ADJ.LAST_UPDATED_BY
, ADJ.LAST_UPDATE_LOGIN
, ADJ.PROGRAM_APPLICATION_ID
, ADJ.PROGRAM_ID
, ADJ.PROGRAM_UPDATE_DATE
, ADJ.REQUEST_ID
, ADJ.HEADER_ID
, ADJ.DISCOUNT_ID
, ADJ.DISCOUNT_LINE_ID
, ADJ.AUTOMATIC_FLAG
, ADJ.PERCENT
, ADJ.LINE_ID
, ADJ.CONTEXT
, ADJ.ATTRIBUTE1
, ADJ.ATTRIBUTE2
, ADJ.ATTRIBUTE3
, ADJ.ATTRIBUTE4
, ADJ.ATTRIBUTE5
, ADJ.ATTRIBUTE6
, ADJ.ATTRIBUTE7
, ADJ.ATTRIBUTE8
, ADJ.ATTRIBUTE9
, ADJ.ATTRIBUTE10
, ADJ.ATTRIBUTE11
, ADJ.ATTRIBUTE12
, ADJ.ATTRIBUTE13
, ADJ.ATTRIBUTE14
, ADJ.ATTRIBUTE15
, DISCOUNT.NAME ADJUSTMENT_NAME
, DISCOUNT.DISCOUNT_TYPE_CODE ADJUSTMENT_TYPE_CODE
, DISCOUNT.OVERRIDE_ALLOWED_FLAG OVERRIDE_ALLOWED_FLAG
, OELUP.MEANING ADJUSTMENT_TYPE_NAME
FROM SO_LOOKUPS OELUP
, SO_PRICE_ADJUSTMENTS ADJ
, SO_DISCOUNTS DISCOUNT
WHERE OELUP.LOOKUP_TYPE = 'DISCOUNTS'
AND OELUP.LOOKUP_CODE = DISCOUNT.DISCOUNT_TYPE_CODE
AND ADJ.DISCOUNT_ID = DISCOUNT.DISCOUNT_ID