[Home] [Help]
View: SO_FC_ORDERS_V
Product: | OE - Order Entry |
Description: | Cash Management sales order inflow |
Implementation/DBA Data: |
APPS.SO_FC_ORDERS_V
|
View Text
SELECT ( L.ORDERED_QUANTITY - NVL(L.CANCELLED_QUANTITY
, 0) - NVL(L.INVOICED_QUANTITY
, 0)) * NVL(L.SELLING_PRICE
, 0)
, NVL(H.DATE_ORDERED
, SYSDATE)
, NVL(H.DATE_REQUESTED_CURRENT
, NVL(L.DATE_REQUESTED_CURRENT
, SYSDATE))
, H.CURRENCY_CODE
, H.ORG_ID
, (( L.ORDERED_QUANTITY - NVL(L.CANCELLED_QUANTITY
, 0) - NVL(L.INVOICED_QUANTITY
, 0)) * NVL(L.SELLING_PRICE
, 0)) * NVL(H.CONVERSION_RATE
, 1)
FROM SO_HEADERS_ALL H
, SO_LINES_ALL L
WHERE H.OPEN_FLAG = 'Y'
AND NVL(H.S1
, 15) = 1
AND L.HEADER_ID = H.HEADER_ID
AND H.ORDER_CATEGORY = 'R'
AND L.LINE_TYPE_CODE != 'PARENT'
AND NVL(L.S5
, 18) NOT IN ( 9
, 8)
Columns
Name |
AMOUNT |
DATE_ORDERED |
DATE_REQUESTED |
CURRENCY_CODE |
ORG_ID |
FUNCTIONAL_AMOUNT |