VIEW: APPS.ISC_OPI_TOP_ORD_QTD_BASE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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