VIEW: APPS.ISCBV_EDW_BACKLOG_SUM1_FCV

Source

View Text - Preformatted

SELECT BACKLOG_SUM1_PK, CUSTOMER_ID, FUNCTIONAL_CURRENCY, INSTANCE_CODE, SET_OF_BOOKS_ID, OPERATING_UNIT_ID, max(DAYS_OPEN), sum(DLQT_BKLG_AMT_B), sum(DLQT_BKLG_AMT_G), sum(DLQT_BKLG_LINE_COUNT), max(MAX_DAYS_LATE), sum(SHIP_BKLG_AMT_B), sum(SHIP_BKLG_AMT_G), sum(SHIP_BKLG_LINE_COUNT), DATE_BOOKED, DATE_OF_SNAPSHOT, HEADER_ID, ORDER_NUMBER FROM ISCBV_EDW_BACKLOG_SUM1_B_FCV WHERE SHIP_BKLG_AMT_B <> 0 GROUP BY BACKLOG_SUM1_PK, CUSTOMER_ID, FUNCTIONAL_CURRENCY, INSTANCE_CODE, SET_OF_BOOKS_ID, OPERATING_UNIT_ID, DATE_BOOKED, DATE_OF_SNAPSHOT, HEADER_ID, ORDER_NUMBER

View Text - HTML Formatted

SELECT BACKLOG_SUM1_PK
, CUSTOMER_ID
, FUNCTIONAL_CURRENCY
, INSTANCE_CODE
, SET_OF_BOOKS_ID
, OPERATING_UNIT_ID
, MAX(DAYS_OPEN)
, SUM(DLQT_BKLG_AMT_B)
, SUM(DLQT_BKLG_AMT_G)
, SUM(DLQT_BKLG_LINE_COUNT)
, MAX(MAX_DAYS_LATE)
, SUM(SHIP_BKLG_AMT_B)
, SUM(SHIP_BKLG_AMT_G)
, SUM(SHIP_BKLG_LINE_COUNT)
, DATE_BOOKED
, DATE_OF_SNAPSHOT
, HEADER_ID
, ORDER_NUMBER
FROM ISCBV_EDW_BACKLOG_SUM1_B_FCV
WHERE SHIP_BKLG_AMT_B <> 0 GROUP BY BACKLOG_SUM1_PK
, CUSTOMER_ID
, FUNCTIONAL_CURRENCY
, INSTANCE_CODE
, SET_OF_BOOKS_ID
, OPERATING_UNIT_ID
, DATE_BOOKED
, DATE_OF_SNAPSHOT
, HEADER_ID
, ORDER_NUMBER