Product: | OE - Order Entry |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | Not implemented in this database |
SELECT LISTLN.PRICE_LIST_LINE_ID
, LISTLN.METHOD_CODE
, LISTLN.LIST_PRICE
, LISTLN.START_DATE_ACTIVE
, LISTLN.END_DATE_ACTIVE
, '_DF:OE:SO_PRICE_LIST_LINES:LISTLN'
, '_DF:OE:PRICING_ATTRIBUTES:LISTLN'
, PRICE_LIST.NAME
, RULE.NAME
, '_KF:INV:MSTK:ITEM' /* ITEM_NUMBER */
, UOM.UNIT_OF_MEASURE
, LISTLN.PRICE_LIST_ID
, LISTLN.PRICING_RULE_ID
, LISTLN.INVENTORY_ITEM_ID
, LISTLN.UNIT_CODE
, LISTLN.LAST_UPDATE_DATE
, LISTLN.LAST_UPDATED_BY
, LISTLN.CREATION_DATE
, LISTLN.CREATED_BY
FROM SO_PRICE_LIST_LINES LISTLN
, SO_PRICE_LISTS PRICE_LIST
, SO_PRICING_RULES RULE
, MTL_SYSTEM_ITEMS ITEM
, MTL_UNITS_OF_MEASURE UOM
WHERE LISTLN.PRICE_LIST_ID = PRICE_LIST.PRICE_LIST_ID AND LISTLN.INVENTORY_ITEM_ID = ITEM.INVENTORY_ITEM_ID AND ITEM.ORGANIZATION_ID = FND_PROFILE.VALUE_SPECIFIC('SO_ORGANIZATION_ID') AND LISTLN.PRICING_RULE_ID = RULE.PRICING_RULE_ID(+) AND LISTLN.UNIT_CODE = UOM.UOM_CODE(+) WITH READ ONLY