VIEW: INV.MTL_SUPPLY_DEMAND_TEMP#

Source

View Text - Preformatted

select SEQ_NUM SEQ_NUM, GROUP_ID GROUP_ID, 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, ROW_NUMBER ROW_NUMBER, RECORD_TYPE RECORD_TYPE, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ATP_PERIOD_TOTAL_SUPPLY ATP_PERIOD_TOTAL_SUPPLY, ATP_PERIOD_TOTAL_DEMAND ATP_PERIOD_TOTAL_DEMAND, SUPPLY_DEMAND_SOURCE_TYPE SUPPLY_DEMAND_SOURCE_TYPE, SUPPLY_DEMAND_TYPE SUPPLY_DEMAND_TYPE, DISPOSITION_TYPE DISPOSITION_TYPE, DISPOSITION_ID DISPOSITION_ID, ATP ATP, QUANTITY QUANTITY, ON_HAND_QUANTITY ON_HAND_QUANTITY, ATP_PERIOD_START_DATE ATP_PERIOD_START_DATE, ATP_PERIOD_END_DATE ATP_PERIOD_END_DATE, REQUIREMENT_DATE REQUIREMENT_DATE, C_COLUMN1 C_COLUMN1, C_COLUMN2 C_COLUMN2, C_COLUMN3 C_COLUMN3, C_COLUMN4 C_COLUMN4, C_COLUMN5 C_COLUMN5, C_COLUMN6 C_COLUMN6, C_COLUMN7 C_COLUMN7, C_COLUMN8 C_COLUMN8, 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, PERIOD_NET_AVAILABLE PERIOD_NET_AVAILABLE, UOM_CODE UOM_CODE, RESOURCE_ID RESOURCE_ID, DEPARTMENT_ID DEPARTMENT_ID from "INV"."MTL_SUPPLY_DEMAND_TEMP"

View Text - HTML Formatted

SELECT SEQ_NUM SEQ_NUM
, GROUP_ID GROUP_ID
, 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
, ROW_NUMBER ROW_NUMBER
, RECORD_TYPE RECORD_TYPE
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ATP_PERIOD_TOTAL_SUPPLY ATP_PERIOD_TOTAL_SUPPLY
, ATP_PERIOD_TOTAL_DEMAND ATP_PERIOD_TOTAL_DEMAND
, SUPPLY_DEMAND_SOURCE_TYPE SUPPLY_DEMAND_SOURCE_TYPE
, SUPPLY_DEMAND_TYPE SUPPLY_DEMAND_TYPE
, DISPOSITION_TYPE DISPOSITION_TYPE
, DISPOSITION_ID DISPOSITION_ID
, ATP ATP
, QUANTITY QUANTITY
, ON_HAND_QUANTITY ON_HAND_QUANTITY
, ATP_PERIOD_START_DATE ATP_PERIOD_START_DATE
, ATP_PERIOD_END_DATE ATP_PERIOD_END_DATE
, REQUIREMENT_DATE REQUIREMENT_DATE
, C_COLUMN1 C_COLUMN1
, C_COLUMN2 C_COLUMN2
, C_COLUMN3 C_COLUMN3
, C_COLUMN4 C_COLUMN4
, C_COLUMN5 C_COLUMN5
, C_COLUMN6 C_COLUMN6
, C_COLUMN7 C_COLUMN7
, C_COLUMN8 C_COLUMN8
, 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
, PERIOD_NET_AVAILABLE PERIOD_NET_AVAILABLE
, UOM_CODE UOM_CODE
, RESOURCE_ID RESOURCE_ID
, DEPARTMENT_ID DEPARTMENT_ID
FROM "INV"."MTL_SUPPLY_DEMAND_TEMP"