View: ISC_OPI_IND_WK_S

View Text

SELECT SOB.SOBL_BOOK_PK_KEY SOBL_BOOK_FK_KEY
, ORG.OPER_OPERATING_UNIT_PK_KEY OPER_UNIT_FK_KEY
, ORG.OPER_NAME OPER_UNIT_NAME
, SUM(NVL(ORDER_COUNT
, 0)) NUM_OF_ORDERS
, SUM(NVL(AMT_BOOKED_G
, 0)) BOOKED_VALUE
, SUM(NVL(AMT_SHIPPED_G
, 0)) SHIPPED_VALUE
, SUM(NVL(AMT_INVOICED_AR_G
, 0)) INVOICED_AR_VALUE
, SUM(NVL(AMT_INVOICED_OE_G
, 0)) INVOICED_OE_VALUE
, SUM(NVL(AMT_REV_EARNED_G
, 0)) EARNED_REVENUE
, SUM(NVL(AMT_CASH_RECEIVED_G
, 0)) CASH_COLLECTED
FROM FII_AR_OPERATIONS_SUMMARY FII
, EDW_GL_BOOK_M SOB
, EDW_ORGANIZATION_M ORG
WHERE FII.OPERATING_UNIT_FK_KEY = ORG.ORGA_ORGANIZATION_PK_KEY
AND FII.SET_OF_BOOKS_FK_KEY = SOB.FABK_FA_BOOK_PK_KEY
AND CALENDAR_DATE BETWEEN FII_TIME_WH_API.GET_CURR_EQTR_START
AND FII_TIME_WH_API.TODAY
AND CALENDAR_DATE >= TRUNC(FII_TIME_WH_API.TODAY) - 6 GROUP BY SOB.SOBL_BOOK_PK_KEY
, ORG.OPER_OPERATING_UNIT_PK_KEY
, ORG.OPER_NAME

Columns