OPI Views (37)

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

View	Description
EDW_MTL_ILDM_LOCATOR_LCV	Source View for Locator Level of Inventory Locator Dimension
EDW_MTL_ILDM_OU_LCV	Source View for the Operating Unit level of the Inventory Locator Dimension
EDW_MTL_ILDM_PCMP_LCV	Source View for Inventory Organization Parent Group Level of Inventory Locator Dimension
EDW_MTL_ILDM_PLANT_LCV	Source View for Inventory Organization Level of Inventory Locator Dimension
EDW_MTL_ILDM_PORG_LCV	Source View for Inventory Organization Group Level of Inventory Locator Dimension
EDW_MTL_ILDM_SUB_INV_LCV	Source View for Sub- Inventory Organization Level of Inventory Locator Dimension
EDW_MTL_LOCATOR_FKV	Foreign Key View for the Locator level in the Inventory Location Dimension. The view will return the DataWarehouse Foreign key correspondin
EDW_MTL_SUB_INV_FKV	Foreign Key View for the Sub-Inventory level in the Inventory Location Dimension. The view will return the DataWarehouse Foreign key corres
EDW_MTL_UOMD_UOM_LCV	Source View for the UOM level of the UOM Dimension
EDW_OPI_ACTV_ACTV_LCV	Sources All Activities from Descrete and Process
EDW_OPI_LOTD_LOT_LCV	This is source view to populate Lot Level data in Lot Dimension
EDW_OPI_OPRN_OPRC_LCV	This View Sources the Operations Class associated to operations from Discrete and Process Manufacturing
EDW_OPI_OPRN_OPRN_LCV	This View Sources Operations used in routing from Discrete and Process Manufacturing
EDW_OPI_PRDL_PRDL_LCV	Level source view for the Production Line level of the Production Line dimension.
OPI_EDW_EXP_INV_VAL_PERD_V	Expired Inventory Value report source view
OPI_EDW_INV_QTY_PERD_V	On Hand Inventory Quantity report source view
OPI_EDW_INV_TURNS_PERD_V	Inventory Turns (Period Level) report source view
OPI_EDW_INV_TURNS_QTR_V	Inventory Turns (Quarter Level) report source view
OPI_EDW_INV_TURNS_YR_V	Inventory Turns (Year Level) report source view
OPI_EDW_INV_VALUE_PERD_V	On Hand Inventory Value, Total Inventory Value, Percentage Total Inventory Value and Work-In-Process Inventory Value reports source view
OPI_EDW_JOB_DETAIL_V	Material Efficiency, Late Jobs, Percentage Scrap, Linearity Index and Production Efficiency reports source view
OPI_EDW_OPIINV_DAILY_STAT_FCV	This is the source view for extracting Invetory Daily Transaction Summary data from the discrete Manufacturing source tables.
OPI_EDW_OPI_JOB_DETAIL_FCV	OPI Source View for Job Detail Fact
OPI_EDW_OPI_JOB_RSRC_FCV	This is the source view for extracting job-resource data from the Discrete Manufacturing source tables.
OPI_EDW_OPI_RES_UTIL_FCV	This is the source view for extracting job-resource data from the Discrete Manufacturing source tables.
OPI_EDW_OPMCOGS_FCV	This is the source view for extracting Cost of gods sold and shipment data from the Process Manufacturing source tables.
OPI_EDW_OPMINV_DAILY_STAT_FCV	This is the source view for extracting Invetory Daily Transaction Summary data from the Process Manufacturing source tables.
OPI_EDW_OPM_JOB_DETAIL_FCV	OPM Source View for Job Detail Fact. This Source View is based on OPM Batch and Material Details. The Source view Included the Products and
OPI_EDW_OPM_JOB_RSRC_FCV	This is the source view for extracting job-resource data from the Process Manufacturing source tables.
OPI_EDW_OPM_RES_UTIL_FCV	This view contains the extraction logic for data to the Resource Utilization fact from process manufacturing side.
OPI_EDW_PRODUCT_GROSS_MARGIN_V	Product Gross Margin report source view
OPI_EDW_PRODUCT_SALES_REV_V	Product Sales Revenue report source view
OPI_EDW_RSRC_EFFICIENCY_V	Resource Efficiency report source view
OPI_EDW_RSRC_UTIL_V	Resource Utilization report source view
OPI_EDW_UOM_CONV_FCV	Source view for the Unit of Measure Conversion Fact table
OPI_OPM_GL_CALENDAR_V	This view gives Oracle General Ledger calendar data for Oracle Process Manufacturing Companies
OPI_PMI_UOMS_MST_V	Allows for the translation of OPM Instance-UOMs to Apps Instance-UOM's. Once facts are in Apps Instance UOMs, they can be converted to EDW