OM销售-订单行信息

2014-01-02

line items 画面项目：

Main tab：

ordered item : oe_order_lines_all.ordered_item

qty : oe_order_lines_all.ordered_quantity

uom : oe_order_lines_all.order_quantity_uom

unit selling price :  oe_order_lines_all.unit_selling_price

request date : oe_oder_lines_all.request_date

schedule ship date :  oe_order_lines_all.schedule_ship_date

status : oe_order_lines_all.flow_status_code

line type :

SELECT lt.name
  FROM oe_order_lines_all      l,
       oe_transaction_types_tl lt
 WHERE lt.transaction_type_id = l.line_type_id
   AND lt.language = userenv('LANG')
   AND l.header_id = 182012
 ORDER BY line_id

qty cancalled : oe_order_lines_all.cancelled_quantity

qty shipped : oe_order_lines_all.shipped_quantity

reason : --

comments : --

salesrep :

SELECT rs.name
  FROM oe_order_lines_all l,
       r