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: CS_CP_ORDERINFO_RG_V

Product:	CS - Service
Description:	This view lists the order information
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT OOH.ORDER_NUMBER
, OOH.ORDERED_DATE
, OOH.CUST_PO_NUMBER
, OOL.LINE_NUMBER
, OOL.LINK_TO_LINE_ID
FROM ASO_I_OE_ORDER_HEADERS_V OOH
, ASO_I_OE_ORDER_LINES_V OOL
WHERE OOL.HEADER_ID = OOH.HEADER_ID(+)

Columns

Name
ORDER_NUMBER
ORDERED_DATE
CUST_PO_NUMBER
LINE_NUMBER
LINE_ID