VIEW: GMF.CM_WHSE_SRC#

Source

View Text - Preformatted

select SRC_WHSE_ID SRC_WHSE_ID, ORGN_CODE ORGN_CODE, CALENDAR_CODE CALENDAR_CODE, PERIOD_CODE PERIOD_CODE, ITEMCOST_CLASS ITEMCOST_CLASS, ITEM_ID ITEM_ID, WHSE_CODE WHSE_CODE, SOURCING_ALLOC_PCT SOURCING_ALLOC_PCT, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, TRANS_CNT TRANS_CNT, TEXT_CODE TEXT_CODE, DELETE_MARK DELETE_MARK, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, COST_CATEGORY_ID COST_CATEGORY_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, PERIOD_ID PERIOD_ID, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, MASTER_ORGANIZATION_ID MASTER_ORGANIZATION_ID, LEGAL_ENTITY_ID LEGAL_ENTITY_ID from "GMF"."CM_WHSE_SRC"

View Text - HTML Formatted

SELECT SRC_WHSE_ID SRC_WHSE_ID
, ORGN_CODE ORGN_CODE
, CALENDAR_CODE CALENDAR_CODE
, PERIOD_CODE PERIOD_CODE
, ITEMCOST_CLASS ITEMCOST_CLASS
, ITEM_ID ITEM_ID
, WHSE_CODE WHSE_CODE
, SOURCING_ALLOC_PCT SOURCING_ALLOC_PCT
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, TRANS_CNT TRANS_CNT
, TEXT_CODE TEXT_CODE
, DELETE_MARK DELETE_MARK
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, COST_CATEGORY_ID COST_CATEGORY_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, PERIOD_ID PERIOD_ID
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, MASTER_ORGANIZATION_ID MASTER_ORGANIZATION_ID
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
FROM "GMF"."CM_WHSE_SRC"