View: SO_MANUAL_DISCOUNTS_V

Product:	OE - Order Entry
Description:
Implementation/DBA Data:	APPS.SO_MANUAL_DISCOUNTS_V

View Text

SELECT OEDIS.NAME "NAME"
, OEDIS.DISCOUNT_ID "DISCOUNT_ID"
, OEDIS.PRICE_LIST_ID "PRICE_LIST_ID"
, OEDIS.OVERRIDE_ALLOWED_FLAG "OVERRIDE_ALLOWED_FLAG"
, OEDIS.AMOUNT "AMOUNT"
, OEDIS.PERCENT "PERCENT"
, NVL( OEDIS.GSA_INDICATOR
, 'N' ) "GSA_INDICATOR"
, NVL( OEDLN.DISCOUNT_LINE_ID
, -1 ) "DISCOUNT_LINE_ID"
, OEDLN.ENTITY_ID "ENTITY_ID"
, OEDLN.ENTITY_VALUE "ENTITY_VALUE"
, OEDLN.PRICE "LINE_PRICE"
, OEDLN.AMOUNT "LINE_AMOUNT"
, OEDLN.PERCENT "LINE_PERCENT"
, OEPBL.PRICE "BREAK_PRICE"
, OEPBL.AMOUNT "BREAK_AMOUNT"
, OEPBL.PERCENT "BREAK_PERCENT"
, OEPBL.PRICE_BREAK_LINES_LOW_RANGE "PRICE_BREAK_LINES_LOW_RANGE"
, OEPBL.PRICE_BREAK_LINES_HIGH_RANGE "PRICE_BREAK_LINES_HIGH_RANGE"
, OEPBL.UNIT_CODE "UNIT_CODE"
, OEPBL.METHOD_TYPE_CODE "METHOD_TYPE_CODE"
, OESPL.ROUNDING_FACTOR "ROUNDING_FACTOR"
FROM SO_DISCOUNTS OEDIS
, SO_DISCOUNT_LINES OEDLN
, SO_PRICE_BREAK_LINES OEPBL
, SO_PRICE_LISTS OESPL
WHERE OEDIS.PRICE_LIST_ID = OESPL.PRICE_LIST_ID
AND OEDIS.DISCOUNT_TYPE_CODE = 'LINE_ITEM'
AND TRUNC(SYSDATE) BETWEEN NVL( OEDIS.START_DATE_ACTIVE
, TRUNC(SYSDATE) )
AND NVL( OEDIS.END_DATE_ACTIVE
, TRUNC(SYSDATE) )
AND OEDLN.DISCOUNT_ID (+) = OEDIS.DISCOUNT_ID
AND TRUNC(SYSDATE) BETWEEN NVL( OEDLN.START_DATE_ACTIVE
, TRUNC(SYSDATE) )
AND NVL( OEDLN.END_DATE_ACTIVE
, TRUNC(SYSDATE) )
AND OEPBL.DISCOUNT_LINE_ID (+) = OEDLN.DISCOUNT_LINE_ID
AND TRUNC(SYSDATE) BETWEEN NVL( OEPBL.START_DATE_ACTIVE
, TRUNC(SYSDATE) )
AND NVL( OEPBL.END_DATE_ACTIVE
, TRUNC(SYSDATE) )

Columns