VIEW: APPS.ISCBV_EDW_BOOK_SUM1_FCV

Source

View Text - Preformatted

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), 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, 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

View Text - HTML Formatted

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)
, 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
, 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