PMI Views (171)

PMI - Process Manufacturing Intelligence (Obsolete) — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
`EDW_PMI_FORMULA_A_LTC_IV`
`EDW_PMI_GRADE_A_LTC_IV`
`EDW_PMI_INVLOC_A_LTC_IV`
`EDW_PMI_PASY_PASY_LCV`
`EDW_PMI_PASY_PASY_LTC_IV`
`EDW_PMI_PFRM_PFRM_LCV`
`EDW_PMI_PFRM_PFRM_LTC_IV`
`EDW_PMI_PGRD_PGRD_LCV`
`EDW_PMI_PGRD_PGRD_LTC_IV`
`EDW_PMI_PMIL_PCMP_LCV`
`EDW_PMI_PMIL_PCMP_LTC_IV`
`EDW_PMI_PMIL_PLOC_LCV`
`EDW_PMI_PMIL_PLOC_LTC_IV`
`EDW_PMI_PMIL_PORG_LCV`
`EDW_PMI_PMIL_PORG_LTC_IV`
`EDW_PMI_PMIL_PWHS_LCV`
`EDW_PMI_PMIL_PWHS_LTC_IV`
`EDW_PMI_PRTG_PRTG_LCV`
`EDW_PMI_PRTG_PRTG_LTC_IV`
`EDW_PMI_QCASSAY_A_LTC_IV`
`EDW_PMI_ROUTING_A_LTC_IV`
`PMIBV_BATCH_MATERIAL_V`	Info. on a batch and ingredients, prods, and byprods of that batch.
`PMIBV_BURDEN_V`	Costing information for Burden (overhead) details
`PMIBV_COMPANY_LOV_V`	PMI LOV View for Plant
`PMIBV_COSTCALPERIOD_LOV_V`	PMI LOV View for Cost Calendar Period
`PMIBV_COSTCAL_LOV_V`	PMI LOV View for Cost Calendar
`PMIBV_COSTMETHOD_LOV_V`	PMI LOV View for Cost Method
`PMIBV_CURRENTINVENTORY_V`	Qty and availability info for Items in Inv at the present time by warehouse, loc, lot and item.
`PMIBV_FORMULA_COST_V`	Costing Information for product by formula
`PMIBV_FORMULA_LOV_V`	PMI LOV View for Formula
`PMIBV_FORMULA_SUMMARY_V`	The prod and effectivity info for a formula incl. routing info. This does'nt contain ingredient info.
`PMIBV_GL_CM_COST_COMPARISON_V`	Costing info from the GL and OPM tables combined to facilitate comparison of these two sources of similar data.
`PMIBV_INVCALPERIOD_LOV_V`	PMI LOV View for Cost Calendar Period
`PMIBV_INVCAL_LOV_V`	PMI LOV View for Inventory Calendar
`PMIBV_INVENTORY_TRANSACTIONS_V`	All inventory transactions from the completed transactions table and the pending transactions table.
`PMIBV_INV_SUMMARY_V`	The purpose of this view is to find the Inventory balance by item/warehouse/grade. This view also birngs in the item information from the I
`PMIBV_ITEM_COST_FROM_GL_V`	Costing info for an item. Costing info is retrieved from the GL equivalent of the item_cost view which retrieves data from OPM tables.
`PMIBV_ITEM_COST_V`	Costing info for an item. Costing info is retrieved from CM tables, OPM equivalent of the item_cost_from_GL view which retrieves data from
`PMIBV_ITEM_LOV_V`	PMI LOV View for Item
`PMIBV_ITEM_PRICE_V`	Pricing information for an item broken down by quantity, warehouse, grade, customer, pricelist.
`PMIBV_LOT_DEST_SHIP_V`	This view provides the relationship between a lot and the shipments that its destination lots have been involved in.
`PMIBV_LOT_LIST_V`	Lot List View used by Lot Genealogy workbook
`PMIBV_LOT_LOV_V`	PMI LOV View for Lot
`PMIBV_LOT_SHARED_SHIP_V`	provides the relationship between a lot and the shipments that its destination lots have been involved in. A Shared Lot here refers to the l
`PMIBV_LOT_SOURCE_PURCH_V`	This view lists the raw material lots that went into a product lot.
`PMIBV_ORGANIZATION_LOV_V`	PMI LOV View for Organization
`PMIBV_ORGANIZATION_V`	Process Manufacturing Organizations
`PMIBV_PERIODINVENTORY_V`	Qty and usage info for Items in Inv. for closed periods by whse, location, lot and item, unioned with Current inv. in the open period.
`PMIBV_PLANT_LOV_V`	PMI LOV View for Plant
`PMIBV_PRODUCTFORMULA_INV_V`	Formula Detail with Onhand Quantity of the Ingredients
`PMIBV_PRODUCTFORMULA_V`	The prod and ingredient info for a formula. This does not contain infor on effectivity, routing or coproducts.
`PMIBV_QCRESULT_V`	QC Results View
`PMIBV_QC_ASSAYS_V`	QC Assays Base View
`PMIBV_QC_MATCH_DTL_V`	QC Specification and results matching Base view
`PMIBV_QC_MATCH_HDR_V`	QC Customer Sepecification and results matching Base view
`PMIBV_QC_PRODUCTION_SPEC_V`	QC Production Specification Full View
`PMIBV_QC_RESULTS_V`	QC Results Full View
`PMIBV_QC_SAMPLE_V`	QC Samples Full View
`PMIBV_QC_SPECIFICATIONS_V`	QC Specifications Base View
`PMIBV_RESOURCE_LOV_V`	PMI LOV View for Resource
`PMIBV_RESOURCE_PLAN_V`	Availability and planned usage of Process Manufacturing resources
`PMIBV_ROUTING_LOV_V`	PMI LOV View for Routing
`PMIBV_STANDARD_COST_LEDGER_V`	Ledger of OPM Costing detail information produced during Cost Rollup processing.
`PMIBV_UOM_V`	Process Manufacturing Units of Measure and their associated conversion factors.
`PMIBV_VENDOR_LOV_V`	PMI LOV View for Vendor
`PMIBV_WAREHOUSE_LOV_V`	PMI LOV View for Warehouse
`PMIFV_BATCH_DETAILS_V`	Batch Details
`PMIFV_BATCH_INPUT_V`	Batch Input Details
`PMIFV_BATCH_LOTS_V`	Lots produced by a batch
`PMIFV_BATCH_MATERIAL_V`	Information on a batch and the ingredients, products, and byproducts of that batch.
`PMIFV_BATCH_OPRN_DETAIL_V`	Batch Operation Details
`PMIFV_BATCH_QC_V`	Batch QC Details Consolidated
`PMIFV_BATCH_STATUS_V`	Batch Status
`PMIFV_BATCH_TRANS_V`	Batch Transaction Details
`PMIFV_BTCH_QCRSLT_V`	Batch QC Results
`PMIFV_BURDEN_V`	Costing information for Burden (Overhead) details
`PMIFV_CURRENTINVENTORY_V`	Qty and availability info. for Items in Inv. at the present time by whse, loc, lot and item.
`PMIFV_FORMULA_COST_V`	Costing Information for product by formula
`PMIFV_FORMULA_SUMMARY_V`	The product and effectivity information for a formula including routing information. This does not contain ingredient information.
`PMIFV_GL_CM_COST_COMPARISON_V`	Costing information from both the GL and Process Manufacturing costing tables.
`PMIFV_INVENTORY_TRANSACTIONS_V`	This view contains detail information about all completed and pending Inventory transaction .
`PMIFV_INV_SUMMARY_V`	This View finds the Inv. balance by item/Whse/Grade.
`PMIFV_ITEM_COST_FROM_GL_V`	Costing information for an item retrieved from Oracle Financial GL tables. This is the GL equivalent of the item_cost view which retrieves
`PMIFV_ITEM_COST_V`	Costing information for an item retrieved from costing tables. This is the OPM costing tables equivalent of the item_cost_from_GL view whi
`PMIFV_ITEM_PRICE_V`	Pricing information for an item broken down by quantity, warehouse, grade, customer, pricelist.
`PMIFV_LOT_DEST_ONHAND_V`	PMI View for Lot Genealogy Where Used Onhand
`PMIFV_LOT_DEST_SHIP_V`	This view provides the relationship between a lot and the shipments that its destination lots have been involved in.
`PMIFV_LOT_EVENT_V`	This view is used to access inventory events involving each lot.
`PMIFV_LOT_LIST_V`	Lot List View used by Lot Genealogy workbook
`PMIFV_LOT_RESOURCE_LIST_V`	This view lists lots that shared a particular set of parameters.
`PMIFV_LOT_SHARED_ONHAND_V`	This view lists the onhand balances of all prod lots with ING lots.
`PMIFV_LOT_SHARED_SHIP_V`	provides the relationship between a lot and the shipments that its destination lots have been involved in. A Shared Lot here refers to the l
`PMIFV_LOT_SOURCE_ONHAND_V`	This view lists the onhand balances of all lot sources of product lot.
`PMIFV_LOT_SOURCE_PURCH_V`	PMI Lot Genealogy Raw Materials
`PMIFV_ORGANIZATION_V`	Process Manufacturing Organizations
`PMIFV_PERIODINVENTORY_V`	Qty & usage info. for Items in Inv. for closed periods by whse, loc, lot & itm.
`PMIFV_PRODUCTFORMULA_INV_V`	Formula detail with Onhanad inventory of the Ingredients
`PMIFV_PRODUCTFORMULA_V`	The product and ingredient information for a formula. This does not contain information on effectivity, routing or coproducts.
`PMIFV_PROD_EFFI_V`	Batch Efficiency
`PMIFV_QCRESULT_V`	QC Results View
`PMIFV_QC_ASSAYS_V`	QC Assays Full View
`PMIFV_QC_MATCH_DTL_V`	QC Sepecification and results matching Full view
`PMIFV_QC_MATCH_HDR_V`	QC Customer Sepecification and results matching Full view
`PMIFV_QC_PRODUCTION_SPEC_V`	QC Production Specification Full View
`PMIFV_QC_RESULTS_V`	QC Results Full View
`PMIFV_QC_SAMPLE_V`	QC Samples Full View
`PMIFV_QC_SPECIFICATIONS_V`	QC Specifications Base View
`PMIFV_RESOURCE_PLAN_V`	Availability and planned usage of Process Manufacturing resources
`PMIFV_SALES_DETAILS_V`	Details of all shipped sales orders which are associated to corresponding GL periods.
`PMIFV_STANDARD_COST_LEDGER_V`	Ledger of Process Manufacturing Costing detail information produced during Cost Rollup processing.
`PMIFV_UOM_V`	Process Manufacturing Units of Measure and their associated conversion factors.
`PMITS_FINAL_SUBLEDGER_V`	GL subsidiary ledger. Liaison between subsystems and GL. Stores all the bookings of OPM subsystem transactions (documents). Updated by the O
`PMITS_FORMULA_MASTER_V`	GMD Formula Master View
`PMITS_INV_LINE_SUMM_V`	This View Summarizes Transactions at Line Level
`PMITS_ITEM_LOT_UOM_CONV_V`	This is created on top of OPM IC_ITEM_CNV. This view gives UOM Conversion factor at item lot level.
`PMITS_ITEM_MASTER_V`	This is a view on top of OPM Item Master table. It contains all information relating to an item, such as lot/sublot control, unit of measure
`PMITS_OPERATION_ACTIVITIES_V`	GMD Operation Activities View
`PMITS_OPERATION_MASTER_V`	GMD Operation Master View
`PMITS_OPERATION_RESOURCES_V`	GMD Operation Resources View
`PMITS_QC_ALL_SPEC_VRS_V`	This view gives Information about Spec Validity Rules defined in OPM QC Module
`PMITS_QC_RESULTS_V`	Using this view users can access Quality control Results and Associated spec and test level min and max allowed values
`PMITS_QC_SAMPLES_V`	This view Provide Sample information
`PMITS_QC_SPEC_TESTS_V`	Using this view user can access tests associated with a spec. it also provides reference information defined in test
`PMITS_QC_TESTS_V`	This View Provides QC Test deifnitions
`PMITS_RECIPE_MASTER_V`	Recipe Master
`PMITS_RECIPE_VALIDITY_RULE_V`	Recipe Validity Rules
`PMITS_ROUTING_DETAIL_V`	GMD Routing Detail View
`PMITS_ROUTING_MASTER_V`	GMD Routing Master View
`PMITS_TEST_SUBLEDGER_V`	GL subsidiary ledger. Liaison between subsystems and GL. Stores all the bookings of OPM subsystem transactions (documents). Updated by the O
`PMITS_WAREHOUSE_MASTER_V`	PMI Warehouse Master view
`PMI_ALOC_CLS_LOV_V`	Allocation Class List Of Values View
`PMI_ALOC_CLS_V`	Allocation Class List Of Values View
`PMI_COST_MTHD_LOV_V`	Cost Method List Of Values View
`PMI_COST_MTHD_V`	Cost Method List Of Values View
`PMI_EDW_BTCH_DTL_F_FCV`
`PMI_EDW_BTCH_DTL_F_IV`
`PMI_EDW_BTCH_GRADE_F_FCV`
`PMI_EDW_BTCH_GRADE_F_IV`
`PMI_EDW_BTCH_QC_F_FCV`
`PMI_EDW_BTCH_QC_F_IV`
`PMI_EDW_BTCH_RSRC_F_FCV`
`PMI_EDW_BTCH_RSRC_F_IV`
`PMI_EDW_MARGIN_F_FCV`
`PMI_EDW_MARGIN_F_IV`
`PMI_GL_CALENDAR_V`	View to link GL Calendar to OPM Company
`PMI_GL_TIME_V`	View to get GL Calendar Period, Quarter and Year level data from GL Periods
`PMI_HZ_PARTY_V`	This view resolevs all HZ relation from cust size uses to parties and gets required data for sales details view
`PMI_INV_CALENDAR_V`	Inventory Calendar View
`PMI_INV_CLS_LOV_V`	Inventory Class List Of Values View
`PMI_INV_CLS_V`	Inventory Class List Of Values View
`PMI_ITEM_LOV_V`	This is LOV view for PMI Reports
`PMI_LOT_SHARED_V`	This view lists lots that share ingredient lots with another product start lot
`PMI_LOT_SOURCE_LEAF_V`	This view lists raw material lots that are used in the manufacture of a product lot. In this context, a raw material lot is any lot that ca
`PMI_PLNG_CLS_LOV_V`	Planning Class List Of Values View
`PMI_PLNG_CLS_V`	Planning Class List Of Values View
`PMI_REP_EXP_INVENTORY_V`	This view is used for PMI Expired Inventory Report
`PMI_REP_GROSS_MARGIN_V`	PMI Gross Margin Report view
`PMI_REP_LATE_BATCHES_V`	View to extract data for PMI Late Completed Batches Report
`PMI_REP_ONHAND_SALES_V`	This is view used for PMI Period On-Hand Inventory and Inventory Turns Report
`PMI_REP_PROD_ACTUAL_PLAN_V`	This is base view for PMI Production Variance Reports
`PMI_REP_PROD_STATUS_V`	This is view for PMI Production Status Report
`PMI_REP_PROD_USG_VARANCE_V`	PMI Product Usage Variance Report view
`PMI_REP_PROD_YLD_VARANCE_V`	This is view for PMI Production Usage Variance Report
`PMI_REP_QTR_ONHAND_V`	This is view for PMI Quarterly On-Hand Inventory Report
`PMI_REP_SALES_DETAILS_V`	PMI Sales Details Report view
`PMI_REP_TOP_10_PROD_INGRD_V`	This view is used for PMI Production Reports
`PMI_REP_YR_ONHAND_V`	This is view for PMI Yearly On-Hand Inventory Report
`PMI_UOM_LOV_V`	Unit of Measure List Of Values View
`PMI_UOM_V`	Unit of Measure List Of Values View
`PMI_WHSE_CLS_LOV_V`	Warehouse Class view
`PMI_WHSE_CLS_V`	Warehouse Class view