ECC Outsourced Manufacturing, Outsourced Manufacturing Command Center Data Set, SQL1

Description
Columns: Ecc Spec Id, Component Id, Component Name, Component Category Id, Component Category Name, Component Category Description, Componentunitprice, Componentcurrency, Componentcost, Rso Allocated Quantity ...
Imported from ECC
SELECT * FROM ( select ECC_SPEC_ID, COMPONENT_ID, COMPONENT_NAME, COMPONENTDESCRIPTION,
    COMPONENT_CATEGORY_ID, COMPONENT_CATEGORY_NAME, COMPONENT_CATEGORY_DESCRIPTION, COMPONENTTYPE, COMPONENTUNITPRICE, COMPONENTCURRENCY,
    COMPONENTCOST, RSO_ALLOCATED_QUANTITY, RSO_ALLOCATION, PRIMARY_UOM, RSO_QUANTITY_ORDERED, RSO_QUANTITY_UOM, RSO_UNALLOCATEDQUANTITY,
   RSO_QUANTITY_UNINVOICED, RSO_HEADER_ID, RSO_NUMBER, RSO_LINE_ID, RSO_LINE_NUMBER, OEM_ORG_ID, OEM_ORG_CODE, MP_ORG_ID, MP_ORG_CODE,
    SUBCON_TYPE, ONHAND_QTY, RSO_PRICE, RSO_PRICE_QTY_UOM, RSO_EXTENDEDPRICE, RSO_SCHEDULE_SHIP_DATE, RSO_ACTUAL_SHIP_DATE, RPO_HEADER_ID,
    RPO_NUMBER, RPO_LINE_ID, RPO_LINE_NUMBER, RPO_SHIPMENT_ID, RSO_PAYMENT_TERM_ID, REPLENISHMENTPURCHASETERM, RECEIVEDQUANTITY, OPENSHIPMENTS,
    DELAYEDSHIPMENTS, RECEIVEDDATE, INTRANSIT_QTY, RSO_RETURNED_QTY, SUBCON_PO_SHIPMENT_ID, SUBCON_PO_HEADER_ID, SUBCONTRACT_ORDER,
    SUBCON_PO_LINE_ID, SUBCONTRACT_ORDER_LINE, SUBCON_ORDERED_QTY, SUBCON_QTY_RECEIVED, OPENSUBCON, DELAYEDSUBCON, PENDINGORDERVALUE,
    SUBCON_ALLOCATED_QTY, SUBCON_UNINVOICED_QTY, SUBCON_REQUIRED_DATE, OSA_ITEM_ID, OSA_NAME, OSA_DESC, OSA_CATEGORY_ID, OSA_CATEGORY_NAME,
    OSA_CATEGORY_DESCRIPTION, OSACOST, WO_ID, WO_NAME, WO_SCHEDULED_START_DATE, WO_SCHEDULED_COMP_DATE, WO_ACTUAL_COMP_DATE, WO_STATUS,
    QUANTITY_REQUIRED, QUANTITY_CONSUMED, PERCENT_CONSUMPTION, SUBCON_UNALLOCATED_QTY, SUBCON_ALLOCATION, SUBCON_ADJUSTMENT_ID,
    SUBCON_ADJUSTMENT_QTY, SUBCON_ADJUSTMENT_REASON, DROPSHIP_REQ_HEADER_ID, DROPSHIP_REQ_NUMBER, DROPSHIP_PO_HEADER_ID, DROPSHIP_PO_NUMBER,
    DROPSHIP_PO_SUPPLIER, SUBCON_PO_RECEIPT_NUMBER, SUBCON_PO_REJECTED_QTY, INSPECTION_DATE, INSPECTION_RESULT, REJECTION_REASON, QA_PLAN_ID,
    QA_COLLECTION_ID, QA_OCCURRENCE, CUSTOMERSALESORDER, CUSTOMERSALESORDERLINE, CUSTOMERNAME, SHIPDATE, CUSTOMERORDERFLAG, OSA_TYPE,
    MP_ORG_TYPE, INT_SO_HEADER_ID, INT_SO_NUMBER, INT_SO_LINE_ID, INT_SO_LINE_NUMBER, INT_SO_SCHEDULE_SHIP_DATE, INT_SO_ACTUAL_SHIP_DATE,
    ONHAND_VALUE, INTRANSIT_VALUE, REJECTED_VALUE, UNINVOICED_REPLENISHMENTS, UNINVOCED_ASSEMBLIES, CONSUMPTION_DETAILS, REJECTED_ASSEMBLIES,
     LANGUAGE from JMF_ECC_SUBCON_V WHERE language in ('US'))
	PIVOT (max(COMPONENTDESCRIPTION) as COMPONENTDESCRIPTION ,
               max(COMPONENTTYPE) as COMPONENTTYPE,
               max(RSO_ALLOCATION) as RSO_ALLOCATION,
               max(SUBCON_TYPE) as SUBCON_TYPE,
	           max(REPLENISHMENTPURCHASETERM) as REPLENISHMENTPURCHASETERM,
               max(OPENSHIPMENTS) as OPENSHIPMENTS,
               max(DELAYEDSHIPMENTS) as DELAYEDSHIPMENTS,
               max(OPENSUBCON) as OPENSUBCON,
               max(DELAYEDSUBCON) as DELAYEDSUBCON,
               max(OSA_DESC) as OSA_DESC,
               max(SUBCON_ALLOCATION) as SUBCON_ALLOCATION,
               max(CUSTOMERORDERFLAG) as CUSTOMERORDERFLAG,
               max(OSA_TYPE) as OSA_TYPE,
               max(MP_ORG_TYPE) as MP_ORG_TYPE for LANGUAGE in ('US' "US"))