VIEW: APPS.ISC_OPI_IND_WK_S

Source

View Text - Preformatted

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

View Text - HTML Formatted

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