View: ISCBV_EDW_BOOK_SUM1_FCV

View Text

SELECT SEQ_ID
, BOOKINGS_PK
, BILL_TO_CUST_FK
, CURRENCY_BASE_FK
, DATE_BOOKED_FK
, INSTANCE_FK
, OPERATING_UNIT_FK
, SET_OF_BOOKS_FK
, SUM(BOOKED_AMT_B)
, SUM(BOOKED_AMT_G)
, SUM(BOOKED_LIST_AMT_B)
, SUM(BOOKED_LIST_AMT_G)
, SUM(FULFILLED_AMT_B)
, SUM(FULFILLED_AMT_G)
, SUM(INVOICED_AMT_B)
, SUM(INVOICED_AMT_G)
, SUM(SHIPPED_AMT_B)
, SUM(SHIPPED_AMT_G)
, DATE_BOOKED
, MAX(DATE_LATEST_FULFILLED)
, MAX(DATE_LATEST_SHIP)
, MAX(DATE_ORDERED)
, HEADER_ID
, INSTANCE
, ORDER_NUMBER
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, USER_ATTRIBUTE6
, USER_ATTRIBUTE7
, USER_ATTRIBUTE8
, USER_ATTRIBUTE9
, USER_ATTRIBUTE10
, USER_ATTRIBUTE11
, USER_ATTRIBUTE12
, USER_ATTRIBUTE13
, USER_ATTRIBUTE14
, USER_ATTRIBUTE15
, USER_ATTRIBUTE16
, USER_ATTRIBUTE17
, USER_ATTRIBUTE18
, USER_ATTRIBUTE19
, USER_ATTRIBUTE20
, USER_ATTRIBUTE21
, USER_ATTRIBUTE22
, USER_ATTRIBUTE23
, USER_ATTRIBUTE24
, USER_ATTRIBUTE25
, USER_FK1
, USER_FK2
, USER_FK3
, USER_FK4
, USER_FK5
, SUM(USER_MEASURE1)
, SUM(USER_MEASURE2)
, SUM(USER_MEASURE3)
, SUM(USER_MEASURE4)
, SUM(USER_MEASURE5)
FROM ISCBV_EDW_BOOK_SUM1_BASE_FCV GROUP BY SEQ_ID
, BOOKINGS_PK
, BILL_TO_CUST_FK
, CURRENCY_BASE_FK
, DATE_BOOKED_FK
, INSTANCE_FK
, OPERATING_UNIT_FK
, SET_OF_BOOKS_FK
, DATE_BOOKED
, HEADER_ID
, INSTANCE
, ORDER_NUMBER
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, USER_ATTRIBUTE6
, USER_ATTRIBUTE7
, USER_ATTRIBUTE8
, USER_ATTRIBUTE9
, USER_ATTRIBUTE10
, USER_ATTRIBUTE11
, USER_ATTRIBUTE12
, USER_ATTRIBUTE13
, USER_ATTRIBUTE14
, USER_ATTRIBUTE15
, USER_ATTRIBUTE16
, USER_ATTRIBUTE17
, USER_ATTRIBUTE18
, USER_ATTRIBUTE19
, USER_ATTRIBUTE20
, USER_ATTRIBUTE21
, USER_ATTRIBUTE22
, USER_ATTRIBUTE23
, USER_ATTRIBUTE24
, USER_ATTRIBUTE25
, USER_FK1
, USER_FK2
, USER_FK3
, USER_FK4
, USER_FK5

Columns