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: OEFV_DISCOUNT_LINES

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

View Text

SELECT /* TYPE = ITEM */ DISCOUNTLN.PERCENT
, DISCOUNTLN.AMOUNT
, DISCOUNTLN.PRICE
, DISCOUNTLN.START_DATE_ACTIVE
, DISCOUNTLN.END_DATE_ACTIVE
, '_DF:OE:SO_DISCOUNT_LINES:DISCOUNTLN'
, DISCOUNT.NAME
, ENTITY.NAME /* DISCOUNT ENTITY TYPE */
, ITEM.CONCATENATED_SEGMENTS
, DISCOUNTLN.DISCOUNT_LINE_ID
, DISCOUNTLN.DISCOUNT_ID
, DISCOUNTLN.ENTITY_ID /* IS THE ENTITY TYPE'S ID */
, DISCOUNTLN.ENTITY_VALUE /* IS THE DISCOUNTED ENTITY'S ID */
, DISCOUNTLN.ENTITY_VALUE /* INVENTORY_ITEM_ID */
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DISCOUNTLN.LAST_UPDATE_DATE
, DISCOUNTLN.LAST_UPDATED_BY
, DISCOUNTLN.CREATION_DATE
, DISCOUNTLN.CREATED_BY
FROM SO_DISCOUNT_LINES DISCOUNTLN
, SO_DISCOUNTS DISCOUNT
, SO_ENTITIES ENTITY
, MTL_SYSTEM_ITEMS_KFV ITEM
WHERE DISCOUNTLN.DISCOUNT_ID = DISCOUNT.DISCOUNT_ID
AND ENTITY.ENTITY_ID = DISCOUNTLN.ENTITY_ID
AND ENTITY.ENTITY_ID = '1001'
AND DISCOUNTLN.ENTITY_VALUE = ITEM.INVENTORY_ITEM_ID
AND FND_PROFILE.VALUE_SPECIFIC('SO_ORGANIZATION_ID') = ITEM.ORGANIZATION_ID UNION SELECT /* TYPE = CUSTOMER_PO */ DISCOUNTLN.PERCENT
, DISCOUNTLN.AMOUNT
, DISCOUNTLN.PRICE
, DISCOUNTLN.START_DATE_ACTIVE
, DISCOUNTLN.END_DATE_ACTIVE
, '_DF:OE:SO_DISCOUNT_LINES:DISCOUNTLN'
, DISCOUNT.NAME
, ENTITY.NAME /* IS THE DISCOUNT TYPE */
, DISCOUNTLN.ENTITY_VALUE /* JUST PO_NUMBER */
, DISCOUNTLN.DISCOUNT_LINE_ID
, DISCOUNTLN.DISCOUNT_ID
, DISCOUNTLN.ENTITY_ID /* IS THE ENTITY TYPE'S ID */
, DISCOUNTLN.ENTITY_VALUE /* IS THE DISCOUNTED ENTITY'S ID */
, NULL
, DISCOUNTLN.ENTITY_VALUE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DISCOUNTLN.LAST_UPDATE_DATE
, DISCOUNTLN.LAST_UPDATED_BY
, DISCOUNTLN.CREATION_DATE
, DISCOUNTLN.CREATED_BY
FROM SO_DISCOUNT_LINES DISCOUNTLN
, SO_DISCOUNTS DISCOUNT
, SO_ENTITIES ENTITY
WHERE DISCOUNTLN.DISCOUNT_ID = DISCOUNT.DISCOUNT_ID
AND ENTITY.ENTITY_ID = DISCOUNTLN.ENTITY_ID
AND ENTITY.ENTITY_ID = '1004' UNION SELECT /* TYPE = AGREEMENT_TYPE */ DISCOUNTLN.PERCENT
, DISCOUNTLN.AMOUNT
, DISCOUNTLN.PRICE
, DISCOUNTLN.START_DATE_ACTIVE
, DISCOUNTLN.END_DATE_ACTIVE
, '_DF:OE:SO_DISCOUNT_LINES:DISCOUNTLN'
, DISCOUNT.NAME
, ENTITY.NAME /* IS THE DISCOUNT TYPE */
, LOOKUP.MEANING /* AGREEMENT TYPE */
, DISCOUNTLN.DISCOUNT_LINE_ID
, DISCOUNTLN.DISCOUNT_ID
, DISCOUNTLN.ENTITY_ID /* IS THE ENTITY TYPE'S ID */
, DISCOUNTLN.ENTITY_VALUE /* IS THE DISCOUNTED ENTITY'S ID */
, NULL
, NULL
, DISCOUNTLN.ENTITY_VALUE /* AGREEMENT TYPE CODE */
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DISCOUNTLN.LAST_UPDATE_DATE
, DISCOUNTLN.LAST_UPDATED_BY
, DISCOUNTLN.CREATION_DATE
, DISCOUNTLN.CREATED_BY
FROM SO_DISCOUNT_LINES DISCOUNTLN
, SO_DISCOUNTS DISCOUNT
, SO_ENTITIES ENTITY
, SO_AGREEMENTS AGREEMENT
, SO_LOOKUPS LOOKUP
WHERE DISCOUNTLN.DISCOUNT_ID = DISCOUNT.DISCOUNT_ID
AND ENTITY.ENTITY_ID = DISCOUNTLN.ENTITY_ID
AND ENTITY.ENTITY_ID = '1005'
AND DISCOUNTLN.ENTITY_VALUE = AGREEMENT.AGREEMENT_TYPE_CODE
AND LOOKUP.LOOKUP_TYPE = 'AGREEMENT_TYPE'
AND LOOKUP.LOOKUP_CODE = DISCOUNTLN.ENTITY_VALUE UNION SELECT /* TYPE = AGREEMENT_NAME */ DISCOUNTLN.PERCENT
, DISCOUNTLN.AMOUNT
, DISCOUNTLN.PRICE
, DISCOUNTLN.START_DATE_ACTIVE
, DISCOUNTLN.END_DATE_ACTIVE
, '_DF:OE:SO_DISCOUNT_LINES:DISCOUNTLN'
, DISCOUNT.NAME
, ENTITY.NAME /* IS THE DISCOUNT TYPE */
, AGREEMENT.NAME
, DISCOUNTLN.DISCOUNT_LINE_ID
, DISCOUNTLN.DISCOUNT_ID
, DISCOUNTLN.ENTITY_ID /* IS THE ENTITY TYPE'S ID */
, DISCOUNTLN.ENTITY_VALUE /* IS THE DISCOUNTED ENTITY'S ID */
, NULL
, NULL
, NULL
, DISCOUNTLN.ENTITY_VALUE /* AGREEMENT ID */
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DISCOUNTLN.LAST_UPDATE_DATE
, DISCOUNTLN.LAST_UPDATED_BY
, DISCOUNTLN.CREATION_DATE
, DISCOUNTLN.CREATED_BY
FROM SO_DISCOUNT_LINES DISCOUNTLN
, SO_DISCOUNTS DISCOUNT
, SO_ENTITIES ENTITY
, SO_AGREEMENTS AGREEMENT
WHERE DISCOUNTLN.DISCOUNT_ID = DISCOUNT.DISCOUNT_ID
AND ENTITY.ENTITY_ID = DISCOUNTLN.ENTITY_ID
AND ENTITY.ENTITY_ID = '1006'
AND DISCOUNTLN.ENTITY_VALUE = AGREEMENT.AGREEMENT_ID UNION SELECT /* TYPE = ORDER_TYPE */ DISCOUNTLN.PERCENT
, DISCOUNTLN.AMOUNT
, DISCOUNTLN.PRICE
, DISCOUNTLN.START_DATE_ACTIVE
, DISCOUNTLN.END_DATE_ACTIVE
, '_DF:OE:SO_DISCOUNT_LINES:DISCOUNTLN'
, DISCOUNT.NAME
, ENTITY.NAME /* IS THE DISCOUNT TYPE */
, ORDER_TYPE.NAME
, DISCOUNTLN.DISCOUNT_LINE_ID
, DISCOUNTLN.DISCOUNT_ID
, DISCOUNTLN.ENTITY_ID /* IS THE ENTITY TYPE'S ID */
, DISCOUNTLN.ENTITY_VALUE /* IS THE DISCOUNTED ENTITY'S ID */
, NULL
, NULL
, NULL
, NULL
, DISCOUNTLN.ENTITY_VALUE /* ORDER TYPE ID */
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DISCOUNTLN.LAST_UPDATE_DATE
, DISCOUNTLN.LAST_UPDATED_BY
, DISCOUNTLN.CREATION_DATE
, DISCOUNTLN.CREATED_BY
FROM SO_DISCOUNT_LINES DISCOUNTLN
, SO_DISCOUNTS DISCOUNT
, SO_ENTITIES ENTITY
, SO_ORDER_TYPES_ALL ORDER_TYPE
WHERE DISCOUNTLN.DISCOUNT_ID = DISCOUNT.DISCOUNT_ID
AND ENTITY.ENTITY_ID = DISCOUNTLN.ENTITY_ID
AND ENTITY.ENTITY_ID = '1007'
AND DISCOUNTLN.ENTITY_VALUE = ORDER_TYPE.ORDER_TYPE_ID UNION SELECT /* TYPE=PA1 */ DISCOUNTLN.PERCENT
, DISCOUNTLN.AMOUNT
, DISCOUNTLN.PRICE
, DISCOUNTLN.START_DATE_ACTIVE
, DISCOUNTLN.END_DATE_ACTIVE
, '_DF:OE:SO_DISCOUNT_LINES:DISCOUNTLN'
, DISCOUNT.NAME
, ENTITY.NAME /* IS THE DISCOUNT TYPE */
, DISCOUNTLN.ENTITY_VALUE
, DISCOUNTLN.DISCOUNT_LINE_ID
, DISCOUNTLN.DISCOUNT_ID
, DISCOUNTLN.ENTITY_ID /* IS THE ENTITY TYPE'S ID */
, DISCOUNTLN.ENTITY_VALUE /* IS THE DISCOUNTED ENTITY'S ID */
, NULL
, NULL
, NULL
, NULL
, NULL
, DISCOUNTLN.ENTITY_VALUE /* PA1 */
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DISCOUNTLN.LAST_UPDATE_DATE
, DISCOUNTLN.LAST_UPDATED_BY
, DISCOUNTLN.CREATION_DATE
, DISCOUNTLN.CREATED_BY
FROM SO_DISCOUNT_LINES DISCOUNTLN
, SO_DISCOUNTS DISCOUNT
, SO_ENTITIES ENTITY
WHERE DISCOUNTLN.DISCOUNT_ID = DISCOUNT.DISCOUNT_ID
AND ENTITY.ENTITY_ID = DISCOUNTLN.ENTITY_ID
AND ENTITY.ENTITY_ID = 1010 UNION SELECT /* TYPE = PA2 */ DISCOUNTLN.PERCENT
, DISCOUNTLN.AMOUNT
, DISCOUNTLN.PRICE
, DISCOUNTLN.START_DATE_ACTIVE
, DISCOUNTLN.END_DATE_ACTIVE
, '_DF:OE:SO_DISCOUNT_LINES:DISCOUNTLN'
, DISCOUNT.NAME
, ENTITY.NAME /* IS THE DISCOUNT TYPE */
, DISCOUNTLN.ENTITY_VALUE /* IS THE PA2 */
, DISCOUNTLN.DISCOUNT_LINE_ID
, DISCOUNTLN.DISCOUNT_ID
, DISCOUNTLN.ENTITY_ID /* IS THE ENTITY TYPE'S ID */
, DISCOUNTLN.ENTITY_VALUE /* IS THE DISCOUNTED ENTITY'S ID */
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DISCOUNTLN.ENTITY_VALUE /* PA */
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DISCOUNTLN.LAST_UPDATE_DATE
, DISCOUNTLN.LAST_UPDATED_BY
, DISCOUNTLN.CREATION_DATE
, DISCOUNTLN.CREATED_BY
FROM SO_DISCOUNT_LINES DISCOUNTLN
, SO_DISCOUNTS DISCOUNT
, SO_ENTITIES ENTITY
WHERE DISCOUNTLN.DISCOUNT_ID = DISCOUNT.DISCOUNT_ID
AND ENTITY.ENTITY_ID = DISCOUNTLN.ENTITY_ID
AND ENTITY.ENTITY_ID = 1011 UNION SELECT /* TYPE = PRICING_ATTRIBUTE3 */ DISCOUNTLN.PERCENT
, DISCOUNTLN.AMOUNT
, DISCOUNTLN.PRICE
, DISCOUNTLN.START_DATE_ACTIVE
, DISCOUNTLN.END_DATE_ACTIVE
, '_DF:OE:SO_DISCOUNT_LINES:DISCOUNTLN'
, DISCOUNT.NAME
, ENTITY.NAME /* IS THE DISCOUNT TYPE */
, DISCOUNTLN.ENTITY_VALUE /* IS PRICING_ATTRIBUTE3 */
, DISCOUNTLN.DISCOUNT_LINE_ID
, DISCOUNTLN.DISCOUNT_ID
, DISCOUNTLN.ENTITY_ID /* IS THE ENTITY TYPE'S ID */
, DISCOUNTLN.ENTITY_VALUE /* IS THE DISCOUNTED ENTITY'S ID */
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DISCOUNTLN.ENTITY_VALUE /* IS PRICING_ATTRIBUTE3 */
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DISCOUNTLN.LAST_UPDATE_DATE
, DISCOUNTLN.LAST_UPDATED_BY
, DISCOUNTLN.CREATION_DATE
, DISCOUNTLN.CREATED_BY
FROM SO_DISCOUNT_LINES DISCOUNTLN
, SO_DISCOUNTS DISCOUNT
, SO_ENTITIES ENTITY
WHERE DISCOUNTLN.DISCOUNT_ID = DISCOUNT.DISCOUNT_ID
AND ENTITY.ENTITY_ID = DISCOUNTLN.ENTITY_ID
AND ENTITY.ENTITY_ID = 1012 UNION SELECT /* TYPE = PRICING_ATTRIBUTE4 */ DISCOUNTLN.PERCENT
, DISCOUNTLN.AMOUNT
, DISCOUNTLN.PRICE
, DISCOUNTLN.START_DATE_ACTIVE
, DISCOUNTLN.END_DATE_ACTIVE
, '_DF:OE:SO_DISCOUNT_LINES:DISCOUNTLN'
, DISCOUNT.NAME
, ENTITY.NAME /* IS THE DISCOUNT TYPE */
, DISCOUNTLN.ENTITY_VALUE /* IS PRICING_ATTRIBUTE4 */
, DISCOUNTLN.DISCOUNT_LINE_ID
, DISCOUNTLN.DISCOUNT_ID
, DISCOUNTLN.ENTITY_ID /* IS THE ENTITY TYPE'S ID */
, DISCOUNTLN.ENTITY_VALUE /* IS THE DISCOUNTED ENTITY'S ID */
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DISCOUNTLN.ENTITY_VALUE /* IS PRICING_ATTRIBUTE4 */
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DISCOUNTLN.LAST_UPDATE_DATE
, DISCOUNTLN.LAST_UPDATED_BY
, DISCOUNTLN.CREATION_DATE
, DISCOUNTLN.CREATED_BY
FROM SO_DISCOUNT_LINES DISCOUNTLN
, SO_DISCOUNTS DISCOUNT
, SO_ENTITIES ENTITY
WHERE DISCOUNTLN.DISCOUNT_ID = DISCOUNT.DISCOUNT_ID
AND ENTITY.ENTITY_ID = DISCOUNTLN.ENTITY_ID
AND ENTITY.ENTITY_ID = 1013 UNION SELECT /* TYPE = PRICING_ATTRIBUTE5 */ DISCOUNTLN.PERCENT
, DISCOUNTLN.AMOUNT
, DISCOUNTLN.PRICE
, DISCOUNTLN.START_DATE_ACTIVE
, DISCOUNTLN.END_DATE_ACTIVE
, '_DF:OE:SO_DISCOUNT_LINES:DISCOUNTLN'
, DISCOUNT.NAME
, ENTITY.NAME /* IS THE DISCOUNT TYPE */
, DISCOUNTLN.ENTITY_VALUE /* IS PRICING_ATTRIBUTE5 */
, DISCOUNTLN.DISCOUNT_LINE_ID
, DISCOUNTLN.DISCOUNT_ID
, DISCOUNTLN.ENTITY_ID /* IS THE ENTITY TYPE'S ID */
, DISCOUNTLN.ENTITY_VALUE /* IS THE DISCOUNTED ENTITY'S ID */
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DISCOUNTLN.ENTITY_VALUE /* PRICING_ATTRIBUTE5 */
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DISCOUNTLN.LAST_UPDATE_DATE
, DISCOUNTLN.LAST_UPDATED_BY
, DISCOUNTLN.CREATION_DATE
, DISCOUNTLN.CREATED_BY
FROM SO_DISCOUNT_LINES DISCOUNTLN
, SO_DISCOUNTS DISCOUNT
, SO_ENTITIES ENTITY
WHERE DISCOUNTLN.DISCOUNT_ID = DISCOUNT.DISCOUNT_ID
AND ENTITY.ENTITY_ID = DISCOUNTLN.ENTITY_ID
AND ENTITY.ENTITY_ID = 1014 UNION SELECT /* TYPE = PRICING_ATTRIBUTE6 */ DISCOUNTLN.PERCENT
, DISCOUNTLN.AMOUNT
, DISCOUNTLN.PRICE
, DISCOUNTLN.START_DATE_ACTIVE
, DISCOUNTLN.END_DATE_ACTIVE
, '_DF:OE:SO_DISCOUNT_LINES:DISCOUNTLN'
, DISCOUNT.NAME
, ENTITY.NAME /* IS THE DISCOUNT TYPE */
, DISCOUNTLN.ENTITY_VALUE /* IS PRICING_ATTRIBUTE6 */
, DISCOUNTLN.DISCOUNT_LINE_ID
, DISCOUNTLN.DISCOUNT_ID
, DISCOUNTLN.ENTITY_ID /* IS THE ENTITY TYPE'S ID */
, DISCOUNTLN.ENTITY_VALUE /* IS THE DISCOUNTED ENTITY'S ID */
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DISCOUNTLN.ENTITY_VALUE /* IS PRICING_ATTRIBUTE6 */
, NULL
, NULL
, NULL
, NULL
, NULL
, DISCOUNTLN.LAST_UPDATE_DATE
, DISCOUNTLN.LAST_UPDATED_BY
, DISCOUNTLN.CREATION_DATE
, DISCOUNTLN.CREATED_BY
FROM SO_DISCOUNT_LINES DISCOUNTLN
, SO_DISCOUNTS DISCOUNT
, SO_ENTITIES ENTITY
WHERE DISCOUNTLN.DISCOUNT_ID = DISCOUNT.DISCOUNT_ID
AND ENTITY.ENTITY_ID = DISCOUNTLN.ENTITY_ID
AND ENTITY.ENTITY_ID = 1015 UNION SELECT /* TYPE = PRICING_ATTRIBUTE7 */ DISCOUNTLN.PERCENT
, DISCOUNTLN.AMOUNT
, DISCOUNTLN.PRICE
, DISCOUNTLN.START_DATE_ACTIVE
, DISCOUNTLN.END_DATE_ACTIVE
, '_DF:OE:SO_DISCOUNT_LINES:DISCOUNTLN'
, DISCOUNT.NAME
, ENTITY.NAME /* IS THE DISCOUNT TYPE */
, DISCOUNTLN.ENTITY_VALUE /* IS PRICING_ATTRIBUTE7 */
, DISCOUNTLN.DISCOUNT_LINE_ID
, DISCOUNTLN.DISCOUNT_ID
, DISCOUNTLN.ENTITY_ID /* IS THE ENTITY TYPE'S ID */
, DISCOUNTLN.ENTITY_VALUE /* IS THE DISCOUNTED ENTITY'S ID */
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DISCOUNTLN.ENTITY_VALUE /* IS PRICING_ATTRIBUTE7 */
, NULL
, NULL
, NULL
, NULL
, DISCOUNTLN.LAST_UPDATE_DATE
, DISCOUNTLN.LAST_UPDATED_BY
, DISCOUNTLN.CREATION_DATE
, DISCOUNTLN.CREATED_BY
FROM SO_DISCOUNT_LINES DISCOUNTLN
, SO_DISCOUNTS DISCOUNT
, SO_ENTITIES ENTITY
WHERE DISCOUNTLN.DISCOUNT_ID = DISCOUNT.DISCOUNT_ID
AND ENTITY.ENTITY_ID = DISCOUNTLN.ENTITY_ID
AND ENTITY.ENTITY_ID = 1016 UNION SELECT /* TYPE = PRICING_ATTRIBUTE8 */ DISCOUNTLN.PERCENT
, DISCOUNTLN.AMOUNT
, DISCOUNTLN.PRICE
, DISCOUNTLN.START_DATE_ACTIVE
, DISCOUNTLN.END_DATE_ACTIVE
, '_DF:OE:SO_DISCOUNT_LINES:DISCOUNTLN'
, DISCOUNT.NAME
, ENTITY.NAME /* IS THE DISCOUNT TYPE */
, DISCOUNTLN.ENTITY_VALUE /* IS PRICING_ATTRIBUTE8 */
, DISCOUNTLN.DISCOUNT_LINE_ID
, DISCOUNTLN.DISCOUNT_ID
, DISCOUNTLN.ENTITY_ID /* IS THE ENTITY TYPE'S ID */
, DISCOUNTLN.ENTITY_VALUE /* IS THE DISCOUNTED ENTITY'S ID */
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DISCOUNTLN.ENTITY_VALUE /* IS PRICING_ATTRIBUTE8 */
, NULL
, NULL
, NULL
, DISCOUNTLN.LAST_UPDATE_DATE
, DISCOUNTLN.LAST_UPDATED_BY
, DISCOUNTLN.CREATION_DATE
, DISCOUNTLN.CREATED_BY
FROM SO_DISCOUNT_LINES DISCOUNTLN
, SO_DISCOUNTS DISCOUNT
, SO_ENTITIES ENTITY
WHERE DISCOUNTLN.DISCOUNT_ID = DISCOUNT.DISCOUNT_ID
AND ENTITY.ENTITY_ID = DISCOUNTLN.ENTITY_ID
AND ENTITY.ENTITY_ID = 1017 UNION SELECT /* TYPE = PRICING_ATTRIBUTE9 */ DISCOUNTLN.PERCENT
, DISCOUNTLN.AMOUNT
, DISCOUNTLN.PRICE
, DISCOUNTLN.START_DATE_ACTIVE
, DISCOUNTLN.END_DATE_ACTIVE
, '_DF:OE:SO_DISCOUNT_LINES:DISCOUNTLN'
, DISCOUNT.NAME
, ENTITY.NAME /* IS THE DISCOUNT TYPE */
, DISCOUNTLN.ENTITY_VALUE /* IS PRICING_ATTRIBUTE9 */
, DISCOUNTLN.DISCOUNT_LINE_ID
, DISCOUNTLN.DISCOUNT_ID
, DISCOUNTLN.ENTITY_ID /* IS THE ENTITY TYPE'S ID */
, DISCOUNTLN.ENTITY_VALUE /* IS THE DISCOUNTED ENTITY'S ID */
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DISCOUNTLN.ENTITY_VALUE /* IS PRICING_ATTRIBUTE9 */
, NULL
, NULL
, DISCOUNTLN.LAST_UPDATE_DATE
, DISCOUNTLN.LAST_UPDATED_BY
, DISCOUNTLN.CREATION_DATE
, DISCOUNTLN.CREATED_BY
FROM SO_DISCOUNT_LINES DISCOUNTLN
, SO_DISCOUNTS DISCOUNT
, SO_ENTITIES ENTITY
WHERE DISCOUNTLN.DISCOUNT_ID = DISCOUNT.DISCOUNT_ID
AND ENTITY.ENTITY_ID = DISCOUNTLN.ENTITY_ID
AND ENTITY.ENTITY_ID = 1018 UNION SELECT /* TYPE = PRICING_ATTRIBUTE10 */ DISCOUNTLN.PERCENT
, DISCOUNTLN.AMOUNT
, DISCOUNTLN.PRICE
, DISCOUNTLN.START_DATE_ACTIVE
, DISCOUNTLN.END_DATE_ACTIVE
, '_DF:OE:SO_DISCOUNT_LINES:DISCOUNTLN'
, DISCOUNT.NAME
, ENTITY.NAME /* IS THE DISCOUNT TYPE */
, DISCOUNTLN.ENTITY_VALUE /* IS PRICING_ATTRIBUTE10 */
, DISCOUNTLN.DISCOUNT_LINE_ID
, DISCOUNTLN.DISCOUNT_ID
, DISCOUNTLN.ENTITY_ID /* IS THE ENTITY TYPE'S ID */
, DISCOUNTLN.ENTITY_VALUE /* IS THE DISCOUNTED ENTITY'S ID */
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DISCOUNTLN.ENTITY_VALUE /* IS PRICING_ATTRIBUTE10 */
, NULL
, DISCOUNTLN.LAST_UPDATE_DATE
, DISCOUNTLN.LAST_UPDATED_BY
, DISCOUNTLN.CREATION_DATE
, DISCOUNTLN.CREATED_BY
FROM SO_DISCOUNT_LINES DISCOUNTLN
, SO_DISCOUNTS DISCOUNT
, SO_ENTITIES ENTITY
WHERE DISCOUNTLN.DISCOUNT_ID = DISCOUNT.DISCOUNT_ID
AND ENTITY.ENTITY_ID = DISCOUNTLN.ENTITY_ID
AND ENTITY.ENTITY_ID = 1019 UNION SELECT /* TYPE = ITEM_CATEGORY */ DISCOUNTLN.PERCENT
, DISCOUNTLN.AMOUNT
, DISCOUNTLN.PRICE
, DISCOUNTLN.START_DATE_ACTIVE
, DISCOUNTLN.END_DATE_ACTIVE
, '_DF:OE:SO_DISCOUNT_LINES:DISCOUNTLN'
, DISCOUNT.NAME
, ENTITY.NAME /* IS THE DISCOUNT TYPE */
, CATEGORY.DESCRIPTION /* IS THE ITEM_CATEGORY */
, DISCOUNTLN.DISCOUNT_LINE_ID
, DISCOUNTLN.DISCOUNT_ID
, DISCOUNTLN.ENTITY_ID /* IS THE ENTITY TYPE'S ID */
, DISCOUNTLN.ENTITY_VALUE /* IS THE DISCOUNTED ENTITY'S ID */
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DISCOUNTLN.ENTITY_VALUE /* IS THE ITEM_CATEGORY */
, DISCOUNTLN.LAST_UPDATE_DATE
, DISCOUNTLN.LAST_UPDATED_BY
, DISCOUNTLN.CREATION_DATE
, DISCOUNTLN.CREATED_BY
FROM SO_DISCOUNT_LINES DISCOUNTLN
, SO_DISCOUNTS DISCOUNT
, SO_ENTITIES ENTITY
, MTL_CATEGORIES CATEGORY
WHERE DISCOUNTLN.DISCOUNT_ID = DISCOUNT.DISCOUNT_ID
AND ENTITY.ENTITY_ID = DISCOUNTLN.ENTITY_ID
AND DISCOUNTLN.ENTITY_VALUE = CATEGORY.CATEGORY_ID
AND ENTITY.ENTITY_ID = 1045 WITH READ ONLY

Columns

Name
DISCOUNT_PERCENT
DISCOUNT_AMOUNT
SELLING_PRICE
START_DATE
END_DATE
"_DF"
DISCOUNT_NAME
DISCOUNT_ENTITY_TYPE
DISCOUNT_ENTITY_NAME
DISCOUNT_LINE_ID
DISCOUNT_ID
DISCOUNT_ENTITY_TYPE_ID
DISCOUNT_ENTITY_ID
INVENTORY_ITEM_ID
CUSTOMER_PO_NUMBER
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