[Home] [Help]
View: WSH_ORDER_VALUESET_V
Product: | OE - Order Entry |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT SH.HEADER_ID
, RPAD(TO_CHAR(SH.ORDER_NUMBER)
, 20)||SO_ORDER_TYPES.NAME "ORDER_NUMBER"
, CUSTOMER_NAME
, DATE_ORDERED
FROM SO_HEADERS_ALL SH
, RA_CUSTOMERS
, SO_ORDER_TYPES
WHERE RA_CUSTOMERS.CUSTOMER_ID = SH.CUSTOMER_ID
AND SO_ORDER_TYPES.ORDER_TYPE_ID = SH.ORDER_TYPE_ID
Columns
Name |
HEADER_ID |
ORDER_NUMBER |
CUSTOMER_NAME |
DATE_ORDERED |