You are browsing the archive for PMI.

Process Manufacturing Intelligence

Oracle OPM Intelligence Concurrent Programs:

CONCURRENT PROGRAM SHORT CODE CONCURRENT PROGRAM NAME
PMI_ONHAND_SALE_SUM PMI Onhand Sales Summary
PMI_PROD_SUM PMI Production Summary
PMICNVFC Item UOMs Details Report
PMI_EDW_MARGIN_F Publish OPM Margin Fact
EDW_PMI_ROUTING_M Publish OPM Routing Dimension
EDW_PMI_QCASSAY_M Publish OPM Quality Assay Dimension
EDW_PMI_INVLOC_M Publish OPM Inventory Location Dimension
EDW_PMI_GRADE_M Publish OPM Grade Dimension
EDW_PMI_FORMULA_M Publish OPM Formula Dimension
PMI_EDW_BTCH_RSRC_F Publish OPM Batch Resource Fact
PMI_EDW_BTCH_QC_F Publish OPM Batch Quality Control Fact
PMI_EDW_BTCH_GRADE_F Publish OPM Batch Grade Fact
PMI_EDW_BTCH_DTL_F Publish OPM Batch Details Fact
PMI_REFRESH_LOT_GENEALOGY PMI Lot Genealogy Summary
PMI_BATCH_STATUS_SUM PMI Batch Status Summary
EDW_PMI_INVLOC_M_T Collect OPM Inventory Location Dimension
EDW_PMI_FORMULA_M_T Collect Formula Dimension
PMI_PURGE_SUMM_TAB Purge PMI Summary Table
EDW_PMI_GRADE_M_T Collect Grade Dimension
EDW_PMI_QCASSAY_M_T Collect QC Assay Dimension
EDW_PMI_ROUTING_M_T Collect Routing Dimension
PMI_EDW_BTCH_DTL_F_T Collect PMI Batch Detail Fact
PMI_EDW_BTCH_GRADE_F_T Collect PMI Batch Grade Fact
PMI_EDW_BTCH_QC_F_T Collect PMI Batch Quality Fact
PMI_EDW_BTCH_RSRC_F_T Collect PMI Batch Resource Fact
PMI_EDW_MARGIN_F_T Collect PMI Margin Fact

Views in Process Manufacturing Intelligence Module

List of views in Oracle Process Manufacturing Intelligence Module

PMI_ALOC_CLS_LOV_V
PMI_ALOC_CLS_V
PMI_COST_MTHD_LOV_V
PMI_COST_MTHD_V
PMI_GL_CALENDAR_V
PMI_GL_TIME_V
PMI_HZ_PARTY_V
PMI_INV_CALENDAR_V
PMI_INV_CLS_LOV_V
PMI_INV_CLS_V
PMI_ITEM_LOV_V
PMI_LOT_SHARED_V
PMI_LOT_SOURCE_LEAF_V
PMI_PLNG_CLS_LOV_V
PMI_PLNG_CLS_V
PMI_REP_EXP_INVENTORY_V
PMI_REP_GROSS_MARGIN_V
PMI_REP_LATE_BATCHES_V
PMI_REP_ONHAND_SALES_V
PMI_REP_PROD_ACTUAL_PLAN_V
PMI_REP_PROD_STATUS_V
PMI_REP_PROD_USG_VARANCE_V
PMI_REP_PROD_YLD_VARANCE_V
PMI_REP_QTR_ONHAND_V
PMI_REP_SALES_DETAILS_V
PMI_REP_TOP_10_PROD_INGRD_V
PMI_REP_YR_ONHAND_V
PMI_UOM_LOV_V
PMI_UOM_V
PMI_WHSE_CLS_LOV_V
PMI_WHSE_CLS_V
PMIBV_BATCH_MATERIAL_V
PMIBV_BURDEN_V
PMIBV_COMPANY_LOV_V
PMIBV_COSTCAL_LOV_V
PMIBV_COSTCALPERIOD_LOV_V
PMIBV_COSTMETHOD_LOV_V
PMIBV_CURRENTINVENTORY_V
PMIBV_FORMULA_COST_V
PMIBV_FORMULA_LOV_V
PMIBV_FORMULA_SUMMARY_V
PMIBV_GL_CM_COST_COMPARISON_V
PMIBV_INV_SUMMARY_V
PMIBV_INVCAL_LOV_V
PMIBV_INVCALPERIOD_LOV_V
PMIBV_INVENTORY_TRANSACTIONS_V
PMIBV_ITEM_COST_FROM_GL_V
PMIBV_ITEM_COST_V
PMIBV_ITEM_LOV_V
PMIBV_ITEM_PRICE_V
PMIBV_LOT_DEST_SHIP_V
PMIBV_LOT_LIST_V
PMIBV_LOT_LOV_V
PMIBV_LOT_SHARED_SHIP_V
PMIBV_LOT_SOURCE_PURCH_V
PMIBV_ORGANIZATION_LOV_V
PMIBV_ORGANIZATION_V
PMIBV_PERIODINVENTORY_V
PMIBV_PLANT_LOV_V
PMIBV_PRODUCTFORMULA_INV_V
PMIBV_PRODUCTFORMULA_V
PMIBV_QC_ASSAYS_V
PMIBV_QC_MATCH_DTL_V
PMIBV_QC_MATCH_HDR_V
PMIBV_QC_PRODUCTION_SPEC_V
PMIBV_QC_RESULTS_V
PMIBV_QC_SAMPLE_V
PMIBV_QC_SPECIFICATIONS_V
PMIBV_QCRESULT_V
PMIBV_RESOURCE_LOV_V
PMIBV_RESOURCE_PLAN_V
PMIBV_ROUTING_LOV_V
PMIBV_STANDARD_COST_LEDGER_V
PMIBV_UOM_V
PMIBV_VENDOR_LOV_V
PMIBV_WAREHOUSE_LOV_V
PMIFV_BATCH_DETAILS_V
PMIFV_BATCH_INPUT_V
PMIFV_BATCH_LOTS_V
PMIFV_BATCH_MATERIAL_V
PMIFV_BATCH_OPRN_DETAIL_V
PMIFV_BATCH_QC_V
PMIFV_BATCH_STATUS_V
PMIFV_BATCH_TRANS_V
PMIFV_BTCH_QCRSLT_V
PMIFV_BURDEN_V
PMIFV_CURRENTINVENTORY_V
PMIFV_FORMULA_COST_V
PMIFV_FORMULA_SUMMARY_V
PMIFV_GL_CM_COST_COMPARISON_V
PMIFV_INV_SUMMARY_V
PMIFV_INVENTORY_TRANSACTIONS_V
PMIFV_ITEM_COST_FROM_GL_V
PMIFV_ITEM_COST_V
PMIFV_ITEM_PRICE_V
PMIFV_LOT_DEST_ONHAND_V
PMIFV_LOT_DEST_SHIP_V
PMIFV_LOT_EVENT_V
PMIFV_LOT_LIST_V
PMIFV_LOT_RESOURCE_LIST_V
PMIFV_LOT_SHARED_ONHAND_V
PMIFV_LOT_SHARED_SHIP_V
PMIFV_LOT_SOURCE_ONHAND_V
PMIFV_LOT_SOURCE_PURCH_V
PMIFV_ORGANIZATION_V
PMIFV_PERIODINVENTORY_V
PMIFV_PROD_EFFI_V
PMIFV_PRODUCTFORMULA_INV_V
PMIFV_PRODUCTFORMULA_V
PMIFV_QC_ASSAYS_V
PMIFV_QC_MATCH_DTL_V
PMIFV_QC_MATCH_HDR_V
PMIFV_QC_PRODUCTION_SPEC_V
PMIFV_QC_RESULTS_V
PMIFV_QC_SAMPLE_V
PMIFV_QC_SPECIFICATIONS_V
PMIFV_QCRESULT_V
PMIFV_RESOURCE_PLAN_V
PMIFV_SALES_DETAILS_V
PMIFV_STANDARD_COST_LEDGER_V
PMIFV_UOM_V
PMITS_FINAL_SUBLEDGER_V
PMITS_FORMULA_MASTER_V
PMITS_INV_LINE_SUMM_V
PMITS_ITEM_LOT_UOM_CONV_V
PMITS_ITEM_MASTER_V
PMITS_OPERATION_ACTIVITIES_V
PMITS_OPERATION_MASTER_V
PMITS_OPERATION_RESOURCES_V
PMITS_QC_ALL_SPEC_VRS_V
PMITS_QC_RESULTS_V
PMITS_QC_SAMPLES_V
PMITS_QC_SPEC_TESTS_V
PMITS_QC_TESTS_V
PMITS_RECIPE_MASTER_V
PMITS_RECIPE_VALIDITY_RULE_V
PMITS_ROUTING_DETAIL_V
PMITS_ROUTING_MASTER_V
PMITS_TEST_SUBLEDGER_V
PMITS_WAREHOUSE_MASTER_V