[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 |