Product: | OE - Order Entry |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | Not implemented in this database |
SELECT GROUPLINE.METHOD_CODE
, GROUPLINE.LIST_PRICE
, '_DF:OE:SO_ITEM_GROUP_LINES:GROUPLINE'
, '_KF:INV:MSTK:ITEM'
, UOM.UNIT_OF_MEASURE
, IGROUP.NAME
, RULE.NAME
, GROUPLINE.GROUP_LINE_ID
, GROUPLINE.INVENTORY_ITEM_ID
, GROUPLINE.UNIT_CODE
, GROUPLINE.GROUP_ID
, GROUPLINE.PRICING_RULE_ID
, GROUPLINE.LAST_UPDATE_DATE
, GROUPLINE.LAST_UPDATED_BY
, GROUPLINE.CREATION_DATE
, GROUPLINE.CREATED_BY
FROM SO_ITEM_GROUP_LINES GROUPLINE
, MTL_SYSTEM_ITEMS_KFV ITEM
, MTL_UNITS_OF_MEASURE UOM
, SO_ITEM_GROUPS IGROUP
, SO_PRICING_RULES RULE
WHERE UOM.UOM_CODE(+) = GROUPLINE.UNIT_CODE
AND RULE.PRICING_RULE_ID(+) = GROUPLINE.PRICING_RULE_ID
AND IGROUP.GROUP_ID = GROUPLINE.GROUP_ID
AND ITEM.INVENTORY_ITEM_ID = GROUPLINE.INVENTORY_ITEM_ID WITH READ ONLY