eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: OEBV_DISCOUNT_LINES

Product:	OE - Order Entry
Description:	- Retrofitted
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT DISCOUNTLN.PERCENT
, DISCOUNTLN.AMOUNT
, DISCOUNTLN.PRICE
, DISCOUNTLN.START_DATE_ACTIVE
, DISCOUNTLN.END_DATE_ACTIVE
, '_DF:OE:SO_DISCOUNT_LINES:DISCOUNTLN'
, ENTITY.NAME /* DISCOUNT TYPE */
, DISCOUNTLN.DISCOUNT_LINE_ID
, DISCOUNTLN.DISCOUNT_ID
, DISCOUNTLN.ENTITY_ID /* ENTITY TYPE ID */
, DISCOUNTLN.ENTITY_VALUE /* DISCOUNT ENTITY ID */
, DECODE(DISCOUNTLN.ENTITY_ID
, 1001
, DISCOUNTLN.ENTITY_VALUE
, NULL) /* INVENTORY_ITEM_ID */
, DECODE(DISCOUNTLN.ENTITY_ID
, 1004
, DISCOUNTLN.ENTITY_VALUE
, NULL) /* CUSTOMER_PO_HEADER_ID */
, DECODE(DISCOUNTLN.ENTITY_ID
, 1005
, DISCOUNTLN.ENTITY_VALUE
, NULL) /* AGREEMENT_TYPE_ID */
, DECODE(DISCOUNTLN.ENTITY_ID
, 1006
, DISCOUNTLN.ENTITY_VALUE
, NULL) /* AGREEMENT_ID */
, DECODE(DISCOUNTLN.ENTITY_ID
, 1007
, DISCOUNTLN.ENTITY_VALUE
, NULL) /* ORDER_TYPE_ID */
, DECODE(DISCOUNTLN.ENTITY_ID
, 1010
, DISCOUNTLN.ENTITY_VALUE
, NULL) /* SKILL_LEVEL_ID */
, DECODE(DISCOUNTLN.ENTITY_ID
, 1011
, DISCOUNTLN.ENTITY_VALUE
, NULL) /* FIXED_PER_DIEM_ID */
, DECODE(DISCOUNTLN.ENTITY_ID
, 1012
, DISCOUNTLN.ENTITY_VALUE
, NULL) /* PRICING_ATTRIBUTE3 */
, DECODE(DISCOUNTLN.ENTITY_ID
, 1013
, DISCOUNTLN.ENTITY_VALUE
, NULL) /* PRICING_ATTRIBUTE4 */
, DECODE(DISCOUNTLN.ENTITY_ID
, 1014
, DISCOUNTLN.ENTITY_VALUE
, NULL) /* PRICING_ATTRIBUTE5 */
, DECODE(DISCOUNTLN.ENTITY_ID
, 1015
, DISCOUNTLN.ENTITY_VALUE
, NULL) /* PRICING_ATTRIBUTE6 */
, DECODE(DISCOUNTLN.ENTITY_ID
, 1016
, DISCOUNTLN.ENTITY_VALUE
, NULL) /* PRICING_ATTRIBUTE7 */
, DECODE(DISCOUNTLN.ENTITY_ID
, 1017
, DISCOUNTLN.ENTITY_VALUE
, NULL) /* PRICING_ATTRIBUTE8 */
, DECODE(DISCOUNTLN.ENTITY_ID
, 1018
, DISCOUNTLN.ENTITY_VALUE
, NULL) /* PRICING_ATTRIBUTE9 */
, DECODE(DISCOUNTLN.ENTITY_ID
, 1019
, DISCOUNTLN.ENTITY_VALUE
, NULL) /* PRICING_ATTRIBUTE10 */
, DECODE(DISCOUNTLN.ENTITY_ID
, 1045
, DISCOUNTLN.ENTITY_VALUE
, NULL) /* ITEM_CATEGORY_ID */
, DISCOUNTLN.LAST_UPDATE_DATE
, DISCOUNTLN.LAST_UPDATED_BY
, DISCOUNTLN.CREATION_DATE
, DISCOUNTLN.CREATED_BY
FROM SO_DISCOUNT_LINES DISCOUNTLN
, SO_ENTITIES ENTITY
, SO_ENTITY_USES USE
WHERE ENTITY.ENTITY_ID = DISCOUNTLN.ENTITY_ID
AND ENTITY.ENTITY_ID = USE.ENTITY_ID
AND USE.ENTITY_USE_CODE = 'DISCOUNTS' WITH READ ONLY

Columns

Name
DISCOUNT_PERCENT
DISCOUNT_AMOUNT
SELLING_PRICE
START_DATE
END_DATE
"_DF"
DISCOUNT_ENTITY_TYPE
DISCOUNT_LINE_ID
DISCOUNT_ID
DISCOUNT_ENTITY_TYPE_ID
DISCOUNT_ENTITY_ID
INVENTORY_ITEM_ID
CUSTOMER_PO_HEADER_ID
AGREEMENT_TYPE_ID
AGREEMENT_ID
ORDER_TYPE_ID
PRICING_ATTRIBUTE1
PRICING_ATTRIBUTE2
PRICING_ATTRIBUTE3
PRICING_ATTRIBUTE4
PRICING_ATTRIBUTE5
PRICING_ATTRIBUTE6
PRICING_ATTRIBUTE7
PRICING_ATTRIBUTE8
PRICING_ATTRIBUTE9
PRICING_ATTRIBUTE10
ITEM_CATEGORY_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY