[Home] [Help]
View: ISC_OPI_IND_CR_TAB_S
View Text
SELECT MIN(SOBL_BOOK_FK_KEY)
, MEASURE_NAME
, SUM(NVL(MEASURE_QTD
, 0)) MEASURE_QTD
, SUM(NVL(MEASURE_WK
, 0)) MEASURE_WK
, SUM(NVL(MEASURE_QTD
, 0) - NVL(MEASURE_WK
, 0)) MEASURE_Q_W
, SORT_ORDER
FROM ISC_OPI_IND_CR_TAB_BASE_V GROUP BY MEASURE_NAME
, SORT_ORDER
Columns
Name |
SOBL_BOOK_FK_KEY |
MEASURE_NAME |
MEASURE_QTD |
MEASURE_WK |
MEASURE_Q_W |
SORT_ORDER |