VIEW: MSC.MSC_COSTS_F#

Source

View Text - Preformatted

select PLAN_ID PLAN_ID, PLAN_RUN_ID PLAN_RUN_ID, SR_INSTANCE_ID SR_INSTANCE_ID, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, SOURCE_ORG_INSTANCE_ID SOURCE_ORG_INSTANCE_ID, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, CUSTOMER_REGION_ID CUSTOMER_REGION_ID, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, SUPPLIER_REGION_ID SUPPLIER_REGION_ID, IO_PLAN_FLAG IO_PLAN_FLAG, SHIP_METHOD SHIP_METHOD, DETAIL_DATE DETAIL_DATE, REVENUE REVENUE, REVENUE2 REVENUE2, MANUFACTURING_COST MANUFACTURING_COST, MANUFACTURING_COST2 MANUFACTURING_COST2, PURCHASING_COST PURCHASING_COST, PURCHASING_COST2 PURCHASING_COST2, TRANSPORTATION_COST TRANSPORTATION_COST, TRANSPORTATION_COST2 TRANSPORTATION_COST2, CARRYING_COST CARRYING_COST, CARRYING_COST2 CARRYING_COST2, SUPPLY_CHAIN_COST SUPPLY_CHAIN_COST, SUPPLY_CHAIN_COST2 SUPPLY_CHAIN_COST2, GROSS_MARGIN GROSS_MARGIN, GROSS_MARGIN2 GROSS_MARGIN2, FIXED_COST FIXED_COST, FIXED_COST2 FIXED_COST2, AGGR_TYPE AGGR_TYPE, CATEGORY_SET_ID CATEGORY_SET_ID, SR_CATEGORY_ID SR_CATEGORY_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_ID, OWNING_INST_ID OWNING_INST_ID, OWNING_ORG_ID OWNING_ORG_ID, FACILITY_COST FACILITY_COST, FACILITY_COST2 FACILITY_COST2, ITEM_TRAVEL_DISTANCE ITEM_TRAVEL_DISTANCE, SOURCE_COUNT SOURCE_COUNT, RISK_ITEM_COUNT RISK_ITEM_COUNT, CTB_MAKE_ORDER_CNT CTB_MAKE_ORDER_CNT, TOTAL_MAKE_ORDER_CNT TOTAL_MAKE_ORDER_CNT, AVAIL_COMPONENT_QTY AVAIL_COMPONENT_QTY, TOTAL_COMPONENT_QTY TOTAL_COMPONENT_QTY, READY_TO_BUILD_QTY READY_TO_BUILD_QTY, TOTAL_BUILD_QTY TOTAL_BUILD_QTY from "MSC"."MSC_COSTS_F"

View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, PLAN_RUN_ID PLAN_RUN_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SOURCE_ORG_INSTANCE_ID SOURCE_ORG_INSTANCE_ID
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, CUSTOMER_REGION_ID CUSTOMER_REGION_ID
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, SUPPLIER_REGION_ID SUPPLIER_REGION_ID
, IO_PLAN_FLAG IO_PLAN_FLAG
, SHIP_METHOD SHIP_METHOD
, DETAIL_DATE DETAIL_DATE
, REVENUE REVENUE
, REVENUE2 REVENUE2
, MANUFACTURING_COST MANUFACTURING_COST
, MANUFACTURING_COST2 MANUFACTURING_COST2
, PURCHASING_COST PURCHASING_COST
, PURCHASING_COST2 PURCHASING_COST2
, TRANSPORTATION_COST TRANSPORTATION_COST
, TRANSPORTATION_COST2 TRANSPORTATION_COST2
, CARRYING_COST CARRYING_COST
, CARRYING_COST2 CARRYING_COST2
, SUPPLY_CHAIN_COST SUPPLY_CHAIN_COST
, SUPPLY_CHAIN_COST2 SUPPLY_CHAIN_COST2
, GROSS_MARGIN GROSS_MARGIN
, GROSS_MARGIN2 GROSS_MARGIN2
, FIXED_COST FIXED_COST
, FIXED_COST2 FIXED_COST2
, AGGR_TYPE AGGR_TYPE
, CATEGORY_SET_ID CATEGORY_SET_ID
, SR_CATEGORY_ID SR_CATEGORY_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_ID
, OWNING_INST_ID OWNING_INST_ID
, OWNING_ORG_ID OWNING_ORG_ID
, FACILITY_COST FACILITY_COST
, FACILITY_COST2 FACILITY_COST2
, ITEM_TRAVEL_DISTANCE ITEM_TRAVEL_DISTANCE
, SOURCE_COUNT SOURCE_COUNT
, RISK_ITEM_COUNT RISK_ITEM_COUNT
, CTB_MAKE_ORDER_CNT CTB_MAKE_ORDER_CNT
, TOTAL_MAKE_ORDER_CNT TOTAL_MAKE_ORDER_CNT
, AVAIL_COMPONENT_QTY AVAIL_COMPONENT_QTY
, TOTAL_COMPONENT_QTY TOTAL_COMPONENT_QTY
, READY_TO_BUILD_QTY READY_TO_BUILD_QTY
, TOTAL_BUILD_QTY TOTAL_BUILD_QTY
FROM "MSC"."MSC_COSTS_F"