VIEW: PMI.PMI_PROD_SUM#

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_USAGE_QTY WHSE_USAGE_QTY, WHSE_USAGE_CONV WHSE_USAGE_CONV, WHSE_USAGE_VALUE WHSE_USAGE_VALUE, WHSE_YIELD_QTY WHSE_YIELD_QTY, WHSE_YIELD_CONV WHSE_YIELD_CONV, WHSE_YIELD_VALUE WHSE_YIELD_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_START_DATE GL_PERIOD_START_DATE, GL_PERIOD_END_DATE GL_PERIOD_END_DATE, MISS_CONV_FACT_CNT MISS_CONV_FACT_CNT, GL_FISCAL_YEAR GL_FISCAL_YEAR from "PMI"."PMI_PROD_SUM"

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_USAGE_QTY WHSE_USAGE_QTY
, WHSE_USAGE_CONV WHSE_USAGE_CONV
, WHSE_USAGE_VALUE WHSE_USAGE_VALUE
, WHSE_YIELD_QTY WHSE_YIELD_QTY
, WHSE_YIELD_CONV WHSE_YIELD_CONV
, WHSE_YIELD_VALUE WHSE_YIELD_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_START_DATE GL_PERIOD_START_DATE
, GL_PERIOD_END_DATE GL_PERIOD_END_DATE
, MISS_CONV_FACT_CNT MISS_CONV_FACT_CNT
, GL_FISCAL_YEAR GL_FISCAL_YEAR
FROM "PMI"."PMI_PROD_SUM"