[Home] [Help]
| Product: | ISC - Supply Chain Intelligence (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT SOB.SOBL_BOOK_PK_KEY SOBL_BOOK_FK_KEY
, ORG.OPER_OPERATING_UNIT_PK_KEY OPER_UNIT_FK_KEY
, T.DAY_DAY_PK_KEY CAL_DAY_FK_KEY
, T.ECPR_CAL_PERIOD_PK_KEY EC_PERIOD_FK_KEY
, T.ECQR_CAL_QTR_PK_KEY EC_QTR_FK_KEY
, CUST.TPRT_TRADE_PARTNER_PK_KEY TPRT_FK_KEY
, ORDER_NUMBER ORDER_NUMBER
, TPRT_NAME CUSTOMER_NAME
, DATE_ORDERED ORDERED_DATE
, BOOKED_AMT_G NET_BOOKED_VALUE
, DATE_BOOKED BOOKED_DATE
, SHIPPED_AMT_G SHIPPED_VALUE
, DATE_LATEST_SHIP LATEST_SHIP_DATE
, FULFILLED_AMT_G FULFILLED_VALUE
, DATE_LATEST_FULFILLED FULFILLED_DATE
, INVOICED_AMT_G INVOICED_VALUE
, HEADER_ID HEADER_ID
, 1 NUM_OF_ORDERS
, RANK() OVER (ORDER BY BOOKED_AMT_G DESC) RANK
FROM ISC_EDW_BOOK_SUM1_F BOOK
, EDW_TRD_PARTNER_M CUST
, EDW_ORGANIZATION_M ORG
, EDW_GL_BOOK_M SOB
, EDW_TIME_M T
WHERE BOOK.BILL_TO_CUST_FK_KEY = CUST.TPLO_TPARTNER_LOC_PK_KEY
AND BOOK.DATE_BOOKED_FK_KEY = T.CDAY_CAL_DAY_PK_KEY
AND BOOK.OPERATING_UNIT_FK_KEY = ORG.ORGA_ORGANIZATION_PK_KEY
AND BOOK.SET_OF_BOOKS_FK_KEY = SOB.FABK_FA_BOOK_PK_KEY
AND DATE_BOOKED BETWEEN FII_TIME_WH_API.GET_CURR_EQTR_START
AND FII_TIME_WH_API.TODAY