eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: SO_ORDER_NUMBERS_V

Product:	OE - Order Entry
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT HD.ORDER_NUMBER
, HD.HEADER_ID
, HD.DATE_ORDERED
, HD.ORDER_CATEGORY
, SL.MEANING ORDER_CATEGORY_DESC
, OT.NAME ORDER_TYPE
, HD.ORDER_TYPE_ID
, HD.PURCHASE_ORDER_NUM
, HD.ORIGINAL_SYSTEM_SOURCE_CODE
, HD.ORIGINAL_SYSTEM_REFERENCE
, RC.CUSTOMER_NAME
, RC.CUSTOMER_NUMBER
, HD.CUSTOMER_ID
, HD.SHIP_METHOD_CODE
, HD.SHIPMENT_PRIORITY_CODE
, HD.OPEN_FLAG
FROM RA_CUSTOMERS RC
, SO_ORDER_TYPES OT
, SO_LOOKUPS SL
, SO_HEADERS HD
WHERE HD.ORDER_TYPE_ID = OT.ORDER_TYPE_ID
AND HD.CUSTOMER_ID = RC.CUSTOMER_ID (+)
AND SL.LOOKUP_CODE = HD.ORDER_CATEGORY
AND SL.LOOKUP_TYPE = 'ORDER_CATEGORY'

Columns

Name
ORDER_NUMBER
HEADER_ID
DATE_ORDERED
ORDER_CATEGORY
ORDER_CATEGORY_DESC
ORDER_TYPE
ORDER_TYPE_ID
PURCHASE_ORDER_NUM
ORIGINAL_SYSTEM_SOURCE_CODE
ORIGINAL_SYSTEM_REFERENCE
CUSTOMER_NAME
CUSTOMER_NUMBER
CUSTOMER_ID
SHIP_METHOD_CODE
SHIPMENT_PRIORITY_CODE
OPEN_FLAG