VIEW: MSC.MSC_ST_COSTS_F#

Source

View Text - Preformatted

select ST_TRANSACTION_ID ST_TRANSACTION_ID, ERROR_CODE ERROR_CODE, SR_INSTANCE_ID SR_INSTANCE_ID, ORGANIZATION_ID ORGANIZATION_ID, SOURCE_ORG_INSTANCE_ID SOURCE_ORG_INSTANCE_ID, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_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, ORGANIZATION_CODE ORGANIZATION_CODE, SOURCE_ORG_CODE SOURCE_ORG_CODE, ITEM_NAME ITEM_NAME, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_SITE_CODE CUSTOMER_SITE_CODE, CUSTOMER_ZONE CUSTOMER_ZONE, SUPPLIER_NAME SUPPLIER_NAME, SUPPLIER_SITE_CODE SUPPLIER_SITE_CODE, SUPPLIER_ZONE SUPPLIER_ZONE, 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, 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, OWNING_ORG_CODE OWNING_ORG_CODE, 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_ST_COSTS_F"

View Text - HTML Formatted

SELECT ST_TRANSACTION_ID ST_TRANSACTION_ID
, ERROR_CODE ERROR_CODE
, SR_INSTANCE_ID SR_INSTANCE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SOURCE_ORG_INSTANCE_ID SOURCE_ORG_INSTANCE_ID
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_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
, ORGANIZATION_CODE ORGANIZATION_CODE
, SOURCE_ORG_CODE SOURCE_ORG_CODE
, ITEM_NAME ITEM_NAME
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_SITE_CODE CUSTOMER_SITE_CODE
, CUSTOMER_ZONE CUSTOMER_ZONE
, SUPPLIER_NAME SUPPLIER_NAME
, SUPPLIER_SITE_CODE SUPPLIER_SITE_CODE
, SUPPLIER_ZONE SUPPLIER_ZONE
, 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
, 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
, OWNING_ORG_CODE OWNING_ORG_CODE
, 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_ST_COSTS_F"