VIEW: PMI.PMI_ONHAND_SALE_SUM_TEMP#

Source

View Text - Preformatted

select FISCAL_YEAR FISCAL_YEAR, CO_CODE CO_CODE, ORGN_CODE ORGN_CODE, WHSE_CODE WHSE_CODE, PERIOD_ID PERIOD_ID, QUARTER QUARTER, PERIOD PERIOD, CONVERTIBLE_UOM CONVERTIBLE_UOM, ITEM_ID ITEM_ID, ITEM_NO ITEM_NO, ITEM_UM ITEM_UM, WHSE_ONHAND_QTY WHSE_ONHAND_QTY, WHSE_ONHAND_CONV WHSE_ONHAND_CONV, WHSE_ONHAND_VALUE WHSE_ONHAND_VALUE, WHSE_SALE_QTY WHSE_SALE_QTY, WHSE_SALE_CONV WHSE_SALE_CONV, WHSE_SALE_VALUE WHSE_SALE_VALUE, WHSE_RTRN_QTY WHSE_RTRN_QTY, WHSE_RTRN_CONV WHSE_RTRN_CONV, WHSE_RTRN_VALUE WHSE_RTRN_VALUE, LOG_END_DATE LOG_END_DATE, PERIOD_IND PERIOD_IND, WHSE_NAME WHSE_NAME, ORGN_NAME ORGN_NAME, PERIOD_NAME PERIOD_NAME, QUARTER_NAME QUARTER_NAME, PERIOD_SET_NAME PERIOD_SET_NAME, GL_PERIOD_YEAR GL_PERIOD_YEAR, GL_FISCAL_YEAR_NAME GL_FISCAL_YEAR_NAME, GL_PERIOD_END_DATE GL_PERIOD_END_DATE, GL_PERIOD_START_DATE GL_PERIOD_START_DATE, MISS_CONV_FACT_CNT MISS_CONV_FACT_CNT from "PMI"."PMI_ONHAND_SALE_SUM_TEMP"

View Text - HTML Formatted

SELECT FISCAL_YEAR FISCAL_YEAR
, CO_CODE CO_CODE
, ORGN_CODE ORGN_CODE
, WHSE_CODE WHSE_CODE
, PERIOD_ID PERIOD_ID
, QUARTER QUARTER
, PERIOD PERIOD
, CONVERTIBLE_UOM CONVERTIBLE_UOM
, ITEM_ID ITEM_ID
, ITEM_NO ITEM_NO
, ITEM_UM ITEM_UM
, WHSE_ONHAND_QTY WHSE_ONHAND_QTY
, WHSE_ONHAND_CONV WHSE_ONHAND_CONV
, WHSE_ONHAND_VALUE WHSE_ONHAND_VALUE
, WHSE_SALE_QTY WHSE_SALE_QTY
, WHSE_SALE_CONV WHSE_SALE_CONV
, WHSE_SALE_VALUE WHSE_SALE_VALUE
, WHSE_RTRN_QTY WHSE_RTRN_QTY
, WHSE_RTRN_CONV WHSE_RTRN_CONV
, WHSE_RTRN_VALUE WHSE_RTRN_VALUE
, LOG_END_DATE LOG_END_DATE
, PERIOD_IND PERIOD_IND
, WHSE_NAME WHSE_NAME
, ORGN_NAME ORGN_NAME
, PERIOD_NAME PERIOD_NAME
, QUARTER_NAME QUARTER_NAME
, PERIOD_SET_NAME PERIOD_SET_NAME
, GL_PERIOD_YEAR GL_PERIOD_YEAR
, GL_FISCAL_YEAR_NAME GL_FISCAL_YEAR_NAME
, GL_PERIOD_END_DATE GL_PERIOD_END_DATE
, GL_PERIOD_START_DATE GL_PERIOD_START_DATE
, MISS_CONV_FACT_CNT MISS_CONV_FACT_CNT
FROM "PMI"."PMI_ONHAND_SALE_SUM_TEMP"