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