DBA Data[Home] [Help]

VIEW: APPS.ISC_OPI_TOP_ORD_WK_S

Source

View Text - Preformatted

SELECT "SOBL_BOOK_FK_KEY","OPER_UNIT_FK_KEY","CAL_DAY_FK_KEY","TPRT_FK_KEY","ORDER_NUMBER","CUSTOMER_NAME","ORDERED_DATE","NET_BOOKED_VALUE","BOOKED_DATE","SHIPPED_VALUE","LATEST_SHIP_DATE","FULFILLED_VALUE","FULFILLED_DATE","INVOICED_VALUE","HEADER_ID","NUM_OF_ORDERS","RANK" FROM ISC_OPI_TOP_ORD_WK_BASE_V WHERE rank < 101
View Text - HTML Formatted

SELECT "SOBL_BOOK_FK_KEY"
, "OPER_UNIT_FK_KEY"
, "CAL_DAY_FK_KEY"
, "TPRT_FK_KEY"
, "ORDER_NUMBER"
, "CUSTOMER_NAME"
, "ORDERED_DATE"
, "NET_BOOKED_VALUE"
, "BOOKED_DATE"
, "SHIPPED_VALUE"
, "LATEST_SHIP_DATE"
, "FULFILLED_VALUE"
, "FULFILLED_DATE"
, "INVOICED_VALUE"
, "HEADER_ID"
, "NUM_OF_ORDERS"
, "RANK"
FROM ISC_OPI_TOP_ORD_WK_BASE_V
WHERE RANK < 101