ECC Outsourced Manufacturing, Outsourced Manufacturing Command Center Data Set

Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: jmf-subcon
Query Procedure: JMF_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: jmf_ecc_datasecurity_pkg_pub.GetFilterAttributeValues

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select
x.*
from
(
SELECT * FROM
                (SELECT ECC_SPEC_ID,
                        SUPPLIER_ID,
                        COMPONENT_ID,
                        COMPONENT_NAME,
                        COMPONENTDESCRIPTION,
                        COMPONENT_CATEGORY_ID,
                        COMPONENTTYPE,
                        COMPONENTUNITPRICE,
                        COMPONENTCURRENCY,
                        COMPONENTCOST,
                        COMPONENT_ALLOCATION,
                        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,
                        OEM_ORG_NAME,
                        MP_ORG_ID,
                        MP_ORG_CODE,
                        MP_ORG_NAME,
                        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,
                        DELAYEDRSO,
                        DELAYEDWO,
                        DELAYEDINTSO,
                        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_LINE_ID,
                        DROPSHIP_REQ_NUMBER,
                        DROPSHIP_PO_HEADER_ID,
                        DROPSHIP_PO_LINE_ID,
                        DROPSHIP_PO_SHIPMENT_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,
                        SPO_ALLOCATED_FLAG,
                        SPO_ONTIME_FLAG,
                        RSO_ONTIME_FLAG,
                        RPO_ONTIME_FLAG,
                        WO_ONTIME_FLAG,
                        INTSO_ONTIME_FLAG,
                        LANGUAGE
                 FROM JMF_ECC_SUBCON_V
                 WHERE language in ('US'))
             PIVOT (max(COMPONENTDESCRIPTION) as COMPONENTDESCRIPTION ,
                    max(COMPONENTTYPE) as COMPONENTTYPE,
                    max(COMPONENT_ALLOCATION) as COMPONENT_ALLOCATION,
                    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(DELAYEDRSO) as DELAYEDRSO,
                    max(DELAYEDWO) as DELAYEDWO,
                    max(DELAYEDINTSO) as DELAYEDINTSO,
                    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"))
) x
where
2=2
Parameter Name SQL text Validation
Operating Unit
x.oem_org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
LOV