VIEW: GMF.GL_ITEM_CST#

Source

View Text - Preformatted

select FINAL_FLAG FINAL_FLAG, ORGN_CODE ORGN_CODE, WHSE_CODE WHSE_CODE, ITEM_ID ITEM_ID, COST_MTHD_CODE COST_MTHD_CODE, END_DATE END_DATE, START_DATE START_DATE, CALENDAR_CODE CALENDAR_CODE, PERIOD_CODE PERIOD_CODE, COST_TYPE COST_TYPE, ACCTG_COST ACCTG_COST, FMEFF_ID FMEFF_ID, ITEMCOST_ID ITEMCOST_ID, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, TRANS_CNT TRANS_CNT, DELETE_MARK DELETE_MARK, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, COST_TYPE_ID COST_TYPE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, PERIOD_ID PERIOD_ID from "GMF"."GL_ITEM_CST"

View Text - HTML Formatted

SELECT FINAL_FLAG FINAL_FLAG
, ORGN_CODE ORGN_CODE
, WHSE_CODE WHSE_CODE
, ITEM_ID ITEM_ID
, COST_MTHD_CODE COST_MTHD_CODE
, END_DATE END_DATE
, START_DATE START_DATE
, CALENDAR_CODE CALENDAR_CODE
, PERIOD_CODE PERIOD_CODE
, COST_TYPE COST_TYPE
, ACCTG_COST ACCTG_COST
, FMEFF_ID FMEFF_ID
, ITEMCOST_ID ITEMCOST_ID
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, TRANS_CNT TRANS_CNT
, DELETE_MARK DELETE_MARK
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, COST_TYPE_ID COST_TYPE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, PERIOD_ID PERIOD_ID
FROM "GMF"."GL_ITEM_CST"