[Home] [Help]
View: BIC_REVENUE_TRX_SUMMARY_V
Product: | BIC - Customer Intelligence (obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT A.BILL_TO_CUSTOMER_ID CUSTOMER_ID
, A.CUSTOMER_TRX_ID
, A.TRX_DATE
, A.PURCHASE_ORDER
, A.PURCHASE_ORDER_DATE
, A.SHIP_DATE_ACTUAL
, SUM(NVL(B.QUANTITY_ORDERED
, 0)*NVL(B.UNIT_SELLING_PRICE
, 0)) ORDERED_AMOUNT
, SUM(NVL(B.QUANTITY_CREDITED
, 0)*NVL(B.UNIT_SELLING_PRICE
, 0)) CREDITED_AMOUNT
, SUM(NVL(B.QUANTITY_INVOICED
, 0)*NVL(B.UNIT_SELLING_PRICE
, 0)) INVOICED_AMOUNT
FROM RA_CUSTOMER_TRX_ALL A
, RA_CUSTOMER_TRX_LINES_ALL B
WHERE A.CUSTOMER_TRX_ID = B.CUSTOMER_TRX_ID GROUP BY A.BILL_TO_CUSTOMER_ID
, A.CUSTOMER_TRX_ID
, A.TRX_DATE
, A.PURCHASE_ORDER
, A.PURCHASE_ORDER_DATE
, A.SHIP_DATE_ACTUAL
Columns
Name |
CUSTOMER_ID |
CUSTOMER_TRX_ID |
TRX_DATE |
PURCHASE_ORDER |
PURCHASE_ORDER_DATE |
SHIP_DATE_ACTUAL |
ORDERED_AMOUNT |
CREDITED_AMOUNT |
INVOICED_AMOUNT |