FND Design Data [Home] [Help]

View: ISC_OPI_IND_CR_TAB_S

Product: ISC - Supply Chain Intelligence (Obsolete)
Description:
Implementation/DBA Data: Not implemented in this database
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