VIEW: INV.MTL_DEMAND_HISTORIES#

Source

View Text - Preformatted

select INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, PERIOD_START_DATE PERIOD_START_DATE, PERIOD_TYPE PERIOD_TYPE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, STD_WIP_USAGE STD_WIP_USAGE, CLOSED_FLAG CLOSED_FLAG, SALES_ORDER_DEMAND SALES_ORDER_DEMAND, MISCELLANEOUS_ISSUE MISCELLANEOUS_ISSUE, INTERORG_ISSUE INTERORG_ISSUE, C_COLUMN1 C_COLUMN1, C_COLUMN2 C_COLUMN2, C_COLUMN3 C_COLUMN3, C_COLUMN4 C_COLUMN4, C_COLUMN5 C_COLUMN5, N_COLUMN1 N_COLUMN1, N_COLUMN2 N_COLUMN2, N_COLUMN3 N_COLUMN3, N_COLUMN4 N_COLUMN4, N_COLUMN5 N_COLUMN5, D_COLUMN1 D_COLUMN1, D_COLUMN2 D_COLUMN2, D_COLUMN3 D_COLUMN3, D_COLUMN4 D_COLUMN4, D_COLUMN5 D_COLUMN5, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "INV"."MTL_DEMAND_HISTORIES"

View Text - HTML Formatted

SELECT INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, PERIOD_START_DATE PERIOD_START_DATE
, PERIOD_TYPE PERIOD_TYPE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, STD_WIP_USAGE STD_WIP_USAGE
, CLOSED_FLAG CLOSED_FLAG
, SALES_ORDER_DEMAND SALES_ORDER_DEMAND
, MISCELLANEOUS_ISSUE MISCELLANEOUS_ISSUE
, INTERORG_ISSUE INTERORG_ISSUE
, C_COLUMN1 C_COLUMN1
, C_COLUMN2 C_COLUMN2
, C_COLUMN3 C_COLUMN3
, C_COLUMN4 C_COLUMN4
, C_COLUMN5 C_COLUMN5
, N_COLUMN1 N_COLUMN1
, N_COLUMN2 N_COLUMN2
, N_COLUMN3 N_COLUMN3
, N_COLUMN4 N_COLUMN4
, N_COLUMN5 N_COLUMN5
, D_COLUMN1 D_COLUMN1
, D_COLUMN2 D_COLUMN2
, D_COLUMN3 D_COLUMN3
, D_COLUMN4 D_COLUMN4
, D_COLUMN5 D_COLUMN5
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "INV"."MTL_DEMAND_HISTORIES"