OM销售-订单头信息

2014-01-02

1. 订单头信息

order management super user-> orders,returns-> sales order

order information-MAIN 画面项目：

customer:     

SELECT party.party_name
FROM hz_parties       party,
            hz_cust_accounts cust_acct,
           oe_order_headers_all h 
where party.party_id(+) = cust_acct.party_id
and cust_acct.cust_account_id(+) = h.sold_to_org_id
and h.order_number = '101111100002';

customer number:  

SELECT cust_acct.account_number
  FROM hz_cust_accounts     cust_acct,
       oe_order_headers_all h
 WHERE cust_acct.cust_account_id = h.sold_to_org_id
   AND h.order_number = '101111100002';

customer po:  

SELECT t.cust_po_number
FROM oe_order_headers_all t
WHERE t.order_number = '101111100002';

customer contact:  --

ship to location: 

SELECT ship_su.location
FROM hz_cust_site_uses_all ship_su,
     oe_order_headers_all h
WHERE ship_su.site_use_id = h.ship_to_org_id
and h.order_number = '101111100002';

SELECT ship_loc.address1,
       ship_loc.address2,
       decode(ship_loc.postal