EDW_CST_COGS_F_IV |
|
EDW_MTL_UOM_CLS_CONV_F_IV |
|
EDW_MTL_UOM_CONV_F_IV |
|
INVBV_ABC_ASSGN_GROUP_CLASSES |
- Retrofitted |
INVBV_ABC_ASSIGNMENTS |
- Retrofitted |
INVBV_ABC_ASSIGNMENT_GROUPS |
- Retrofitted |
INVBV_ABC_CLASSES |
- Retrofitted |
INVBV_CUSTOMER_ITEMS |
- Retrofitted |
INVBV_CUSTOMER_ITEM_XREFS |
- Retrofitted |
INVBV_CYCLE_COUNTS |
- Retrofitted |
INVBV_CYCLE_COUNT_ADJUSTMENTS |
- Retrofitted |
INVBV_CYCLE_COUNT_CLASSES |
- Retrofitted |
INVBV_CYCLE_COUNT_ITEMS |
- Retrofitted |
INVBV_DESCRIPTIVE_ELEMENTS |
- Retrofitted |
INVBV_EXTERNAL_ITEM_XREFS |
- Retrofitted |
INVBV_EXT_ITEM_XREF_TYPES |
- Retrofitted |
INVBV_FREIGHT_CARRIERS |
|
INVBV_FUTURE_ITEM_STATUSES |
- Retrofitted |
INVBV_GL_ACCOUNT_ALIASES |
- Retrofitted |
INVBV_INTERORG_LEAD_TIMES |
- Retrofitted |
INVBV_INTERORG_SHIPPING_INFO |
- Retrofitted |
INVBV_INVENTORY_DEMANDS |
- Retrofitted |
INVBV_INVENTORY_LOCATORS |
- Retrofitted |
INVBV_INVENTORY_ORGANIZATIONS |
- Retrofitted |
INVBV_INVENTORY_RESERVATIONS |
- Retrofitted |
INVBV_INVENTORY_SUPPLIES |
- Retrofitted |
INVBV_INVENTORY_TXN_TYPES |
- Retrofitted |
INVBV_INV_BY_PERIOD_AND_ITEM |
retrofitted |
INVBV_ITEMS |
- Retrofitted |
INVBV_ITEM_CATALOG_GROUPS |
- Retrofitted |
INVBV_ITEM_CATEGORIES |
- Retrofitted |
INVBV_ITEM_CATEGORY_ASGNS |
- Retrofitted |
INVBV_ITEM_CATEGORY_TYPES |
- Retrofitted |
INVBV_ITEM_CATEGORY_TYPE_ASGNS |
- Retrofitted |
INVBV_ITEM_DESC_ELEMENT_VALUES |
- Retrofitted |
INVBV_ITEM_RELATIONS |
- Retrofitted |
INVBV_ITEM_REPLENISH_COUNTS |
- Retrofitted |
INVBV_ITEM_REVISIONS |
- Retrofitted |
INVBV_ITEM_STATUS_ATTR_VALUES |
- Retrofitted |
INVBV_ITEM_STATUS_CODES |
- Retrofitted |
INVBV_KANBAN_CARDS |
- Retrofitted |
INVBV_KANBAN_CARD_ACTIVITIES |
- Retrofitted |
INVBV_KANBAN_LOCATION_ITEMS |
- Retrofitted |
INVBV_LOTS |
- Retrofitted |
INVBV_LOT_TRANSACTIONS |
- Retrofitted |
INVBV_MANUFACTURERS |
- Retrofitted |
INVBV_MATERIAL_TRANSACTIONS |
- Retrofitted |
INVBV_MFG_PART_NUMBERS |
- Retrofitted |
INVBV_MOVEMENT_PARAMETERS |
- Retrofitted |
INVBV_MOVEMENT_STATISTICS |
- Retrofitted |
INVBV_MOVE_ORDERS_HEADERS |
|
INVBV_MOVE_ORDERS_LINES |
|
INVBV_ONHAND_BALANCES |
- Retrofitted |
INVBV_ORGANIZATION_ITEMS |
- Retrofitted |
INVBV_ORG_ITEM_REVISIONS |
- Retrofitted |
INVBV_PHYSICAL_ADJUSTMENTS |
- Retrofitted |
INVBV_PHYSICAL_INVENTORIES |
- Retrofitted |
INVBV_PHYSICAL_INV_COUNTS |
- Retrofitted |
INVBV_PRODUCT_FAMILY_MEMBERS |
- Retrofitted |
INVBV_SERIAL_NUMBERS |
- Retrofitted |
INVBV_SERIAL_NUMBER_TXNS |
- Retrofitted |
INVBV_SHIP_METHODS |
- Retrofitted |
INVBV_SUBINVENTORIES |
- Retrofitted |
INVBV_SUB_REPLENISH_COUNTS |
- Retrofitted |
INVBV_TRANSACTION_SOURCE_TYPES |
- Retrofitted |
INVBV_UNITS_OF_MEASURE |
- Retrofitted |
INVBV_UOM_CLASSES |
- Retrofitted |
INVBV_UOM_CLASS_CONVERSIONS |
- Retrofitted |
INVBV_UOM_CONVERSIONS |
- Retrofitted |
INVFV_ABC_ASSGN_GROUP_CLASSES |
- Retrofitted |
INVFV_ABC_ASSIGNMENTS |
- Retrofitted |
INVFV_ABC_ASSIGNMENT_GROUPS |
- Retrofitted |
INVFV_ABC_CLASSES |
- Retrofitted |
INVFV_CUSTOMER_ITEMS |
|
INVFV_CUSTOMER_ITEM_XREFS |
|
INVFV_CYCLE_COUNTS |
- Retrofitted |
INVFV_CYCLE_COUNT_ADJUSTMENTS |
- Retrofitted |
INVFV_CYCLE_COUNT_CLASSES |
- Retrofitted |
INVFV_CYCLE_COUNT_ITEMS |
- Retrofitted |
INVFV_DESCRIPTIVE_ELEMENTS |
|
INVFV_EXTERNAL_ITEM_XREFS |
|
INVFV_EXT_ITEM_XREF_TYPES |
|
INVFV_FREIGHT_CARRIERS |
|
INVFV_FUTURE_ITEM_STATUSES |
|
INVFV_GL_ACCOUNT_ALIASES |
- Retrofitted |
INVFV_INTERORG_LEAD_TIMES |
- Retrofitted |
INVFV_INTERORG_SHIPPING_INFO |
- Retrofitted |
INVFV_INVENTORY_DEMANDS |
- Retrofitted |
INVFV_INVENTORY_LOCATORS |
- Retrofitted |
INVFV_INVENTORY_ORGANIZATIONS |
- Retrofitted |
INVFV_INVENTORY_RESERVATIONS |
- Retrofitted |
INVFV_INVENTORY_SUPPLIES |
- Retrofitted |
INVFV_INVENTORY_TXN_TYPES |
- Retrofitted |
INVFV_INV_BY_PERIOD_AND_ITEM |
|
INVFV_ITEMS |
|
INVFV_ITEM_CATALOG_GROUPS |
|
INVFV_ITEM_CATEGORIES |
|
INVFV_ITEM_CATEGORY_ASGNS |
|
INVFV_ITEM_CATEGORY_TYPES |
|
INVFV_ITEM_CATEGORY_TYPE_ASGNS |
|
INVFV_ITEM_DESC_ELEMENT_VALUES |
|
INVFV_ITEM_RELATIONS |
|
INVFV_ITEM_REPLENISH_COUNTS |
- Retrofitted |
INVFV_ITEM_REVISIONS |
|
INVFV_ITEM_STATUS_ATTR_VALUES |
|
INVFV_ITEM_STATUS_CODES |
|
INVFV_KANBAN_CARDS |
- Retrofitted |
INVFV_KANBAN_CARD_ACTIVITIES |
- Retrofitted |
INVFV_KANBAN_LOCATION_ITEMS |
- Retrofitted |
INVFV_LOTS |
- Retrofitted |
INVFV_LOT_TRANSACTIONS |
- Retrofitted |
INVFV_MANUFACTURERS |
|
INVFV_MATERIAL_TRANSACTIONS |
- Retrofitted |
INVFV_MFG_PART_NUMBERS |
|
INVFV_MOVEMENT_PARAMETERS |
- Retrofitted |
INVFV_MOVEMENT_STATISTICS |
- Retrofitted |
INVFV_MOVE_ORDERS_HEADERS |
|
INVFV_MOVE_ORDERS_LINES |
|
INVFV_ONHAND_BALANCES |
- Retrofitted |
INVFV_ORGANIZATION_ITEMS |
|
INVFV_ORG_ITEM_REVISIONS |
|
INVFV_PHYSICAL_ADJUSTMENTS |
- Retrofitted |
INVFV_PHYSICAL_INVENTORIES |
- Retrofitted |
INVFV_PHYSICAL_INV_COUNTS |
- Retrofitted |
INVFV_PRODUCT_FAMILY_MEMBERS |
|
INVFV_SERIAL_NUMBERS |
- Retrofitted |
INVFV_SERIAL_NUMBER_TXNS |
- Retrofitted |
INVFV_SHIP_METHODS |
- Retrofitted |
INVFV_SUBINVENTORIES |
- Retrofitted |
INVFV_SUB_REPLENISH_COUNTS |
- Retrofitted |
INVFV_TRANSACTION_SOURCE_TYPES |
- Retrofitted |
INVFV_UNITS_OF_MEASURE |
- Retrofitted |
INVFV_UOM_CLASSES |
- Retrofitted |
INVFV_UOM_CLASS_CONVERSIONS |
- Retrofitted |
INVFV_UOM_CONVERSIONS |
- Retrofitted |
INV_3PL_CLIENTS_V |
|
INV_3PL_CONTRACTS_V |
|
INV_BIS_ITEM_COSTS |
Cost for Inventory Items with standard cost, and items with average cost using |
INV_BIS_SUPPLY_CHAIN_INVENTORY |
Supply Chain Inventory Information |
INV_LOT_SERIAL_COLUMNS_V |
View of Lot and Serial Descriptive Flex Field Column |
INV_LOT_SERIAL_CONTEXT_V |
View of Lot and Serial Descriptive Flex Field Context |
INV_ORGANIZATION_INFO_V |
|
INV_ORGANIZATION_NAME_V |
|
MFG_LOOKUPS |
MFG_LOOKUPS is a view of selected columns from the table FND_LOOKUP_VALUES. |
MFG_LOOKUPS_V |
MFG_LOOKUPS_V is a view of selected columns from the table FND_LOOKUP_VALUES. |
MTL_ABC_ASSGNMNT_GROUPS_ALL_V |
10SC ONLY |
MTL_ABC_ASSGN_GROUP_CLASSES_V |
10SC ONLY |
MTL_ABC_ASSIGNMENTS_V |
10SC ONLY |
MTL_ABC_ASSIGNMENT_GROUPS_V |
10SC ONLY |
MTL_ABC_CLASSES_ALL_V |
10SC ONLY |
MTL_ABC_CLASSES_V |
10SC ONLY |
MTL_ABC_CLASSES_VAL_V |
10SC ONLY |
MTL_ABC_COMPILES_V |
- Retrofitted |
MTL_ABC_COMPILE_HEADERS_V |
- Retrofitted |
MTL_ACTIONS_VL |
Actions Code View |
MTL_ADJUSTMENT_LOTSERIAL_V |
|
MTL_ADJ_SYNC_WRAPPER_V |
|
MTL_AGREEMENT_DETAILS_V |
|
MTL_ALL_PRIMARY_UOMS_VV |
10SC ONLY |
MTL_ATT_QTY_V |
No longer used |
MTL_AVAILABLE_INVENTORY_V |
View of select available inventory |
MTL_BILLING_RULE_HEADERS_VL |
|
MTL_BILLING_RULE_LINES_V |
|
MTL_BILLING_SOURCES_VL |
|
MTL_BIS_INV_VALUE_V |
Stores Onhand/Intransit quantity and value for Inventory items at organization and intransit owning organizations respectively. |
MTL_CATALOG_SEARCH_ITEMS_ALL_V |
10SC ONLY |
MTL_CATEGORIES_B_KFV |
Categories Key Flexfield View |
MTL_CATEGORIES_V |
10SC ONLY |
MTL_CATEGORIES_VL |
Categories multilingual view |
MTL_CATEGORY_ACCOUNTS_V |
- Retrofitted |
MTL_CATEGORY_GRANTS_V |
Provides information regarding parties and roles on categories |
MTL_CATEGORY_SETS_ALL_V |
10SC ONLY |
MTL_CATEGORY_SETS_V |
10SC ONLY |
MTL_CATEGORY_SETS_VL |
Category Sets multilingual view |
MTL_CATEGORY_SET_VALID_CATS_V |
10SC ONLY |
MTL_CC_ENTRIES_INTERFACE_V |
Cycle Count Entries Interface View |
MTL_CC_GRAPH_DAY_V |
10SC ONLY |
MTL_CC_GRAPH_MONTH_V |
10SC ONLY |
MTL_CC_GRAPH_PERIOD_V |
10SC ONLY |
MTL_CC_GRAPH_QTR_V |
10SC ONLY |
MTL_CC_GRAPH_V |
10SC ONLY |
MTL_CC_GRAPH_WK_V |
10SC ONLY |
MTL_CC_INTERFACE_ERRORS_V |
Cycle Count Entries Interface Errors View |
MTL_CC_SCHEDULES_V |
10SC ONLY |
MTL_CC_SUBINVENTORIES_ALL_V |
10SC ONLY |
MTL_CLIENT_ITEMS_VL |
|
MTL_CLIENT_PARAMETERS_V |
|
MTL_COMMODITY_CODES_ACTIVE_V |
10SC ONLY |
MTL_COMMODITY_CODES_ALL_V |
10SC ONLY |
MTL_CONSUMPTION_DEFINITION_V |
For Consumption setup forms |
MTL_COUNTRY_ASSIGNMENTS_V |
View joins territories and country assignments |
MTL_CROSS_REFERENCES_SRW_V |
10SC ONLY |
MTL_CROSS_REFERENCES_V |
10SC ONLY |
MTL_CROSS_REFERENCES_VL |
This table contains the columns of MTL_CROSS_REFERENCES_B and MTL_CROSS_REFERENCES_TL for current user's language settings |
MTL_CST_TXN_COST_DETAILS_V |
|
MTL_CUSTOMER_ITEMS_ACTIVE_V |
10SC ONLY |
MTL_CUSTOMER_ITEMS_ALL_V |
10SC ONLY |
MTL_CUSTOMER_ITEM_XREFS_V |
10SC ONLY |
MTL_CYCLE_COUNT_CLASSES_ALL_V |
10SC ONLY |
MTL_CYCLE_COUNT_CLASSES_V |
10SC ONLY |
MTL_CYCLE_COUNT_ENTRIES_ALL_V |
10SC ONLY |
MTL_CYCLE_COUNT_ENTRIES_V |
10SC ONLY |
MTL_CYCLE_COUNT_HEADERS_ALL_V |
10SC ONLY |
MTL_CYCLE_COUNT_HEADERS_V |
10SC ONLY |
MTL_CYCLE_COUNT_HEADERS_VAL_V |
10SC ONLY |
MTL_CYCLE_COUNT_ITEMS_ALL_V |
10SC ONLY |
MTL_CYCLE_COUNT_ITEMS_V |
10SC ONLY |
MTL_DEFAULT_CATEGORY_SETS_FK_V |
10SC ONLY |
MTL_DEFAULT_SETS_VIEW |
Required to get around SRS's 240 char limit when defaulting category sets |
MTL_DEMAND_HISTORY_ITEMS_V |
10SC ONLY |
MTL_DEMAND_HISTORY_V |
10SC ONLY |
MTL_DEMAND_INTERFACE_V |
10SC ONLY |
MTL_DEMAND_INTERFACE_VIEW |
A view for demand interface table. |
MTL_DEMAND_OM_VIEW |
|
MTL_DEMAND_V |
10SC ONLY |
MTL_DESCR_ELEMENT_VALUES_V |
10SC ONLY |
MTL_DESCR_ELEM_VAL_V |
10SC ONLY |
MTL_EAM_ASSET_ACTIVITIES_V |
View for Asset Activities |
MTL_EAM_ASSET_ACTIVITIES_WB_V |
View for Activity Workbench |
MTL_EAM_ASSET_ATTR_GROUPS_V |
View for Asset Attribute Groups |
MTL_EAM_ASSET_ATTR_VALUES_V |
View for Asset Attribute Values |
MTL_EAM_ASSET_NUMBERS_ALL_V |
View for Asset Number details |
MTL_EAM_ASSET_NUMBERS_V |
View for Asset Numbers |
MTL_EAM_ASSET_NUM_INTERFACE_V |
Asset Number Interface View |
MTL_EAM_ASSET_REBUILDS_DTLS_V |
View shows the details of Assets and Rebuilds. |
MTL_EAM_ASSET_REBUILDS_V |
View for Asset and Rebuild information. |
MTL_EAM_EQUIP_RESOURCES_V |
View for EAM equipment resources |
MTL_EAM_ITEMS_V |
View of all EAM items. |
MTL_EAM_JOBS_RESOURCES_V |
Job resources for EAM (Enterprise Asset management) |
MTL_EAM_NETWORK_ASSETS_V |
View for EAM Asset Routes |
MTL_ECONOMIC_ZONES_VL |
Joins the base economic zone table and translated economic zone table |
MTL_EMPLOYEES_CURRENT_VIEW |
View of employees currently assigned to a given organization |
MTL_EMPLOYEES_VIEW |
View of employees |
MTL_FETCH_AGREEMENT_LINES |
|
MTL_FISCAL_CAT_ACCOUNTS_V |
PAC Category Accounts |
MTL_FORECAST_DATES_COST_V |
- Retrofitted |
MTL_GENEALOGY_QA_DATA |
|
MTL_GENERIC_DISPOSITIONS_KFV |
Account Alias Key Flexfield View |
MTL_GRADES_VL |
Grade Code View |
MTL_GRADE_CHANGE_ERV |
|
MTL_GRD_STS_HISTORY_V |
|
MTL_GROSS_REQ_COST_V |
- Retrofitted |
MTL_GROUP_ATPS_VIEW |
This view is used for ATP and derived from MTL_DEMAND_INTERFACE |
MTL_GROUP_ITEM_ATPS_VIEW |
This view is used for ATP and derived from MTL_DEMAND_INTERFACE |
MTL_INTERCOMPANY_PARAMETERS_V |
10SC ONLY |
MTL_INTERFACE_PROC_CONTROLS_V |
10SC ONLY |
MTL_INV_TXNS_MFG_LOTS_V |
|
MTL_ITEM_ATTRIBUTES_V |
10SC ONLY |
MTL_ITEM_ATTRIBUTE_NAMES_V |
10SC ONLY |
MTL_ITEM_ATTR_APPL_INST_V |
|
MTL_ITEM_ATTR_FIELDS_V |
10SC ONLY |
MTL_ITEM_CATALOG_GROUPS_B_KFV |
Item Catalog Groups dummy key flexfield view |
MTL_ITEM_CATALOG_GROUPS_KFV |
Item Catalog Key Flexfield View |
MTL_ITEM_CATALOG_GROUPS_V |
10SC ONLY |
MTL_ITEM_CATALOG_GROUPS_VL |
Item Catalog Groups multilingual view |
MTL_ITEM_CATEGORIES_V |
10SC ONLY |
MTL_ITEM_CATEGORIES_VIEW |
10SC ONLY |
MTL_ITEM_FLEXFIELDS |
This view is based on the key flexfield view MTL_SYSTEM_ITEMS_B_KFV. It contains columns with padded and unpadded concatenated segments of |
MTL_ITEM_FLEXFIELDS_OLD |
Contains concatenated item segments, inventory_item_id |
MTL_ITEM_LOCATIONS_KFV |
Item Locations Key Flexfield View |
MTL_ITEM_LOCATIONS_VIEW |
View of item quantities by locator |
MTL_ITEM_LOT_QUANTITIES_VIEW |
Item lot quantities under subinventory and locator |
MTL_ITEM_LOT_UOM_CONV_ERV |
|
MTL_ITEM_ORG_CATEG_V |
10SC ONLY |
MTL_ITEM_ORG_REV_V |
10SC ONLY |
MTL_ITEM_QUANTITIES_VIEW |
Item onhand quantities view |
MTL_ITEM_REVISIONS_ALL_V |
10SC ONLY |
MTL_ITEM_REVISIONS_ORG_VAL_V |
10SC ONLY |
MTL_ITEM_REVISIONS_VL |
Item Revisions multilingual view |
MTL_ITEM_REV_HIGHDATE_V |
10SC ONLY |
MTL_ITEM_STATUS_VAL_V |
10SC ONLY |
MTL_ITEM_STATUS_VL |
This table contains the columns of MTL_ITEM_STATUS_TL a for current user's language settings |
MTL_ITEM_SUB_AST_TRK_VAL_V |
- Retrofitted |
MTL_ITEM_SUB_AST_VAL_V |
- Retrofitted |
MTL_ITEM_SUB_EXP_TRK_VAL_V |
- Retrofitted |
MTL_ITEM_SUB_EXP_VAL_V |
- Retrofitted |
MTL_ITEM_SUB_INVENTORIES_ALL_V |
10SC ONLY |
MTL_ITEM_SUB_TRK_ALL_V |
- Retrofitted |
MTL_ITEM_SUB_TRK_VAL_V |
- Retrofitted |
MTL_ITEM_SUB_VAL_V |
- Retrofitted |
MTL_ITEM_TEMPLATES_ALL_V |
10SC ONLY |
MTL_ITEM_TEMPLATES_VL |
This table contains the columns of MTL_ITEM_TEMPLATES_B and MTL_ITEM_TEMPLATES_TL for current user's language settings |
MTL_ITEM_TEMPL_ATTRIBUTES_V |
10SC ONLY |
MTL_ITEM_UOMS_VIEW |
Holds valid UOMs for items, considering the conversions that are defined |
MTL_KANBAN_CARDS_V |
- Retrofitted |
MTL_KANBAN_CARD_ACTIVITY_V |
- Retrofitted |
MTL_KANBAN_PULL_SEQUENCES_V |
retrofitted |
MTL_LE_ECONOMIC_ZONES_V |
Join between the table MTL_Le_Economic_Zones, the view MTL_Economic_Zones_VL and HR_Legal_Entities |
MTL_LOT_CONV_AUDITDETAILS_ERV |
|
MTL_LOT_CONV_AUDIT_DETAILS_V |
Lot Specific UOM Conversions Audit Details |
MTL_LOT_DEMAND_VAL_V |
|
MTL_LOT_ISSUES_VAL_V |
10SC ONLY |
MTL_LOT_NUMBERS_ALL_V |
10SC ONLYCHANGES DONE AS VIEW IS NON MERGEABLE DUE TO JOIN ON MTL_MATERIAL_STATUSES_VL |
MTL_LOT_NUMBERS_ERV |
|
MTL_LOT_NUMBERS_SRW_V |
10SC ONLY |
MTL_LOT_NUMBERS_VAL_V |
10SC ONLY |
MTL_LOT_ONHAND_SUM_V |
Quantity view for Lot uom conversion use |
MTL_LOT_SERIAL_DFF_ERV |
Required for electronic records. Selects the lot and serial attributes out of the description flexfield data model. |
MTL_LOT_UOM_CLASS_CONV_V |
Lot Specific UOM Conversions |
MTL_MATERIAL_STATUSES_VL |
Multilingual view for material status tables. - Used by WMS only |
MTL_MATERIAL_STATUS_HIST_ERV |
|
MTL_MATERIAL_TXNS_TEMP_VIEW |
A View of MTL_MATERIAL_TRANSACTIONS_TEMP used in an Inquiry form |
MTL_MATERIAL_TXNS_VAL_V |
- Retrofitted |
MTL_MFG_BATCHES_SECURITY_V |
View of gme batches with securities for genealogy |
MTL_MFG_BATCHES_V |
View of gme batches for Genealogy |
MTL_MFG_COMPONENTS_V |
|
MTL_MFG_GENEALOGY_LOTATTR_V |
|
MTL_MFG_LOTS_TRANS_V |
|
MTL_MFG_PART_NUMBERS_ALL_V |
10SC ONLY |
MTL_MFG_PRODUCTS_V |
|
MTL_MGD_INVPOS_DATA_SETS_V |
This view lists the names of the existing data sets created by the Inventory Position View feature. |
MTL_MOVEMENT_PARAMETERS_V |
10SC ONLY |
MTL_MOVEMENT_STATISTICS_V |
|
MTL_MOVE_ORDER_HEADERS_V |
- Retrofitted |
MTL_MOVE_ORDER_LINES_V |
- Retrofitted |
MTL_MVT_STATS_RULE_SETS_VL |
Multilingual view for Rule Sets tables. |
MTL_MWB_GTMP_V |
Material Workbench Global Temporary Table View |
MTL_NEGATIVE_VIEW |
View of onhand negative inventory |
MTL_OBJECT_GRANTS_V |
|
MTL_OBJECT_NUMBERS_V |
View of the genealogy object numbers |
MTL_ONHAND_ATP |
This view would be used by Planning to calculate the ATPable quantity for an item. |
MTL_ONHAND_DUMMY_V |
|
MTL_ONHAND_ITEMS_V |
10SC ONLY |
MTL_ONHAND_LOCATOR_LOT_V |
10SC ONLY |
MTL_ONHAND_LOCATOR_V |
10SC ONLY |
MTL_ONHAND_LOT_V |
10SC ONLY |
MTL_ONHAND_LPN_MWB_V |
LPN content view for Material Workbench |
MTL_ONHAND_LPN_V |
This view contains information about packed material that resides in LPNs. |
MTL_ONHAND_NET |
|
MTL_ONHAND_NEW_LPN_MWB_V |
LPN content view for Material Workbench |
MTL_ONHAND_NEW_LPN_V |
LPN content view |
MTL_ONHAND_QTY_COST_V |
- Retrofitted |
MTL_ONHAND_QUANTITIES |
View of items owned, planned and physically belonging to the same inventory organization |
MTL_ONHAND_REV_V |
10SC ONLY |
MTL_ONHAND_SERIAL_MWB_V |
Onhand Serial View for the Material Work Bench |
MTL_ONHAND_SERIAL_V |
|
MTL_ONHAND_SUB_V |
10SC ONLY |
MTL_ONHAND_SYNC_V |
|
MTL_ONHAND_TOTAL_MWB_V |
Onhand Total View for the Material Work Bench |
MTL_ONHAND_TOTAL_V |
|
MTL_OPSM_LOT_EXPORT_V |
|
MTL_OPSM_SYSTEM_ITEMS_V |
|
MTL_ORGANIZATIONS |
View of organizations |
MTL_ORG_ASSIGN_V |
10SC ONLY |
MTL_ORG_REPORT_TEMP_FK_V |
10SC ONLY |
MTL_PAC_TXN_COST_DETAILS_V |
|
MTL_PARAMETERS_ALL_V |
- Retrofitted |
MTL_PARAMETERS_VIEW |
- Retrofitted |
MTL_PENDING_TXNS_MFG_LOTS_V |
|
MTL_PENDING_TXN_DETAILS_V |
|
MTL_PERIODS |
View of period dates and inventory value for open periods |
MTL_PERIOD_SUMMARY_V |
10SC ONLY |
MTL_PHYSICAL_ADJUSTMENTS_V |
10SC ONLY |
MTL_PHYSICAL_ADJUSTMENTS_VIEW |
Physical inventory adjustments created by Item Counts. |
MTL_PHYSICAL_INVENTORIES_V |
View based on table MTL_PHYSICAL_INVENTORIES. Has all the Physical Inventory Setup Information. |
MTL_PHYSICAL_INVENTORY_TAGS_V |
View based on table MTL_PHYSICAL_INVENTORY_TAGS. Has information for all the Physical Inventory tags. |
MTL_PHYSICAL_SUBINVENTORIES_V |
10SC ONLY |
MTL_PHY_ADJ_COST_V |
- Retrofitted |
MTL_PHY_INV_TAGS_COST_V |
- Retrofitted |
MTL_PRIMARY_UOMS_VV |
10SC ONLY |
MTL_PROCURING_TXN_FLOW_HDRS_V |
MTL_PROCURING_TXN_FLOW_HDRS_V is a view of transaction flow headres for procuring flow. |
MTL_PROCURING_TXN_FLOW_LINES_V |
MTL_PROCURING_TXN_FLOW_LINES_V is a view for transaction flow lines of type procuring. This view is used by Oracle Procuring to query the tr |
MTL_PROJECT_DEMAND_VIEW |
- Retrofitted |
MTL_PROJECT_V |
- Retrofitted |
MTL_QOH_ITEM_ALL_V |
10SC ONLY |
MTL_QOH_ITEM_V |
10SC ONLY |
MTL_QOH_LOCATOR_V |
10SC ONLY |
MTL_QOH_LOC_ALL_V |
10SC ONLY |
MTL_QOH_LOT_ALL_V |
10SC ONLY |
MTL_QOH_LOT_V |
10SC ONLY |
MTL_QOH_REV_ALL_V |
10SC ONLY |
MTL_QOH_REV_V |
10SC ONLY |
MTL_QOH_SUB_ALL_V |
10SC ONLY |
MTL_QOH_SUB_V |
10SC ONLY |
MTL_RCV_MWB_NEW_OH_V |
|
MTL_RCV_MWB_ONHAND_V |
MTL_RCV_MWB_ONHAND_V is used in the material workbench to query the on-hand quantities of materials that are in receiving. |
MTL_RCV_SERIAL_MWB_OH_V |
MTL_RCV_SERIAL_MWB_OH_V is a new view which needs to be used for querying data when the user chooses subinventory type of Receiving and user |
MTL_RCV_SERIAL_OH_V |
MTL_RCV_SERIAL_OH_V is used in the material workbench to query the on-hand quantities of materials that are in receiving and are serial cont |
MTL_RELATED_ITEMS_ALL_V |
10SC ONLY |
MTL_RELATED_ITEMS_CUST_REF_V |
|
MTL_RELATED_ITEMS_PLN_INFO_V |
|
MTL_RELATED_ITEMS_VIEW |
View of MTL_RELATED_ITEMS with reciprocal item relationships appearing twice |
MTL_REPLENISH_HEADERS_VIEW |
- Retrofitted |
MTL_REPLENISH_LINES_VIEW |
- Retrofitted |
MTL_RESERVATIONS_ALL_V |
|
MTL_RESERVATIONS_INTERFACE_V |
|
MTL_RESERVATIONS_V |
10SC ONLY |
MTL_RESERVATIONS_VIEW |
Not used |
MTL_ROUTING_REV_HIGHDATE_V |
10SC ONLY |
MTL_SAFETY_STOCKS_VIEW |
- Retrofitted |
MTL_SALES_ORDERS_KFV |
Sales Orders Key Flexfield View |
MTL_SECINV_QUANTITIES_VIEW |
View of Item subinventory |
MTL_SECONDARY_INVENTORIES_FK_V |
- Retrofitted |
MTL_SECONDARY_LOCATORS_ALL_V |
10SC ONLY |
MTL_SERIAL_NUMBERS_ALL_V |
10SC ONLY |
MTL_SERIAL_NUMBERS_SRW_V |
10SC ONLY |
MTL_SERIAL_NUMBERS_TEMP_ERV |
Required by electronic records to snapshot serial numbers. |
MTL_SERIAL_NUMBERS_VAL_V |
10SC ONLY |
MTL_SERIAL_NUMBER_GEN_V |
|
MTL_SERVICE_CONTRACTS_V |
|
MTL_SHIPPING_NETWORK_VIEW |
- Retrofitted |
MTL_SHORT_SUMMARY_V |
Summary view of the material shortages temp table |
MTL_STATUS_CONTROL_V |
|
MTL_STAT_ATTRIB_VALUES_ALL_V |
10SC ONLY |
MTL_STAT_TYPE_USAGES_V |
Join of Stat_Type_Usages, Hr Legal Entities, Category Sets, Economic Zones View and Hr Locations |
MTL_SUBINVENTORIES_ALL_V |
- Retrofitted |
MTL_SUBINVENTORIES_TRK_VAL_V |
- Retrofitted |
MTL_SUBINVENTORIES_VAL_V |
- Retrofitted |
MTL_SUB_AST_TRK_VAL_V |
- Retrofitted |
MTL_SUB_AST_VAL_V |
- Retrofitted |
MTL_SUB_EXP_TRK_VAL_V |
- Retrofitted |
MTL_SUB_EXP_VAL_V |
- Retrofitted |
MTL_SUB_TRK_ALL_V |
- Retrofitted |
MTL_SUMMARY_TEMP_V |
10SC ONLY |
MTL_SUPPLIER_SITES_V |
- Retrofitted |
MTL_SYSTEM_ITEMS_B_KFV |
System Items Key Flexfield View |
MTL_SYSTEM_ITEMS_ER1_V |
ERES : View to support ERES framework for Items |
MTL_SYSTEM_ITEMS_ER2_V |
ERES : View to support ERES framework for Items Catalog Group Assignment |
MTL_SYSTEM_ITEMS_ER3_V |
ERES : View to support ERES framework for Items Catalog Group Assignment(Summary View) |
MTL_SYSTEM_ITEMS_ER4_V |
ERES : View to support ERES framework for Items Organization Assignment |
MTL_SYSTEM_ITEMS_FKEYS_V |
10SC ONLY |
MTL_SYSTEM_ITEMS_FVL |
Base view for the Define System Items (INVIDITM) form MTL_SYSTEM_ITEMS block. This view is MLS enabled. |
MTL_SYSTEM_ITEMS_VL |
System Items multilingual view with concatenated segments column |
MTL_TASK_V |
- Retrofitted |
MTL_TRANSACTIONS_INTERFACE_V |
- Retrofitted |
MTL_TRANSACTIONS_TEMP_ALL_V |
- Retrofitted |
MTL_TRANSACTION_DETAILS_V |
|
MTL_TRANSACTION_FLOWS_V |
MTL_TRANSACTION_FLOWS_V is a view for Intercompany transaction flows of type shipping and procuring flows. |
MTL_TRANSACTION_FLOW_HEADERS_V |
MTL_TRANSACTION_FLOW_HEADERS_V is a view for Intercompany transaction flow headers of type shipping and procuring flows. |
MTL_TRANSACTION_FLOW_LINES_V |
MTL_TRANSACTION_FLOW_LINES_V is a view for Intercompany transaction flow lines of type shipping and procuring flow for each header. |
MTL_TRANSACTION_LOTS_TEMP_V |
|
MTL_TRANSACTION_LOTS_VIEW |
A view showing all material lot number transactions. |
MTL_TRANSACTION_LOT_VAL_V |
10SC ONLY |
MTL_TRANSACTION_REASONS_ALL_V |
10SC ONLY |
MTL_TRANSACTION_REASONS_VAL_V |
10SC ONLY |
MTL_TRANSACT_INTERFACE_VIEW |
Transaction interface status view |
MTL_TRAN_TYPES_SYS_VAL_VIEW |
- Retrofitted |
MTL_TRAN_TYPES_USER_VAL_VIEW |
- Retrofitted |
MTL_TRX_TYPES_VIEW |
- Retrofitted |
MTL_TXN_BACKORDERS_V |
|
MTL_TXN_REQUEST_HEADERS_V |
|
MTL_TXN_REQUEST_LINES_V |
|
MTL_TXN_SOURCE_TYPES_ALL_V |
10SC ONLY |
MTL_TXN_SRC_FOR_TRAN_TYPE_VIEW |
- Retrofitted |
MTL_UNITS_OF_MEASURE_AV |
10SC ONLY |
MTL_UNITS_OF_MEASURE_VL |
MTL_UNITS_OF_MEASURE_VL is a view of selected columns from the table MTL_UNITS_OF_MEASURE_TL. |
MTL_UNITS_OF_MEASURE_VV |
10SC ONLY |
MTL_UNIT_TRANSACTIONS_ALL_V |
10SC ONLY |
MTL_UOM_CLASSES_AV |
10SC ONLY |
MTL_UOM_CLASSES_VL |
|
MTL_UOM_CLASSES_VV |
10SC ONLY |
MTL_UOM_CLASS_CONV_VAL_V |
10SC ONLY |
MTL_UOM_CONVERSIONS_VAL_V |
10SC ONLY |
MTL_UOM_CONVERSIONS_VIEW |
View giving unit of measure conversion rates between the primary unit of measure and another unit of measure |
MTL_VENDOR_LOT_VIEW |
Supplier information |
MTL_WORK_ORDER_HEADER_V |
|
ORG_ACCESS_V |
10SC ONLY |
ORG_ACCESS_VIEW |
Organization access view resolving all organizations available for each responsibility |
ORG_ACCT_PERIODS_V |
10SC ONLY |
ORG_ENABLED_FREIGHT_VAL_V |
- Retrofitted |
ORG_FREIGHT_CODE_ALL_V |
10SC ONLY |
ORG_FREIGHT_CODE_VAL_V |
10SC ONLY |
ORG_FREIGHT_VL |
|
ORG_GL_BATCHES_V |
10SC ONLY |
ORG_ORGANIZATION_DEFINITIONS |
Inventory organizations |
ORG_ORGANIZATION_DEFINITIONS2 |
Inventory organizations and organizations "claiming" to be inventory organizations but do not have inventory parameters |
ORG_ORGANIZATION_DEF_MRC_V |
- Retrofitted |
ORG_ORG_DEFINITIONS_ALL_V |
10SC ONLY |
RCV_RECEIPT_CONFIRMATION_V |
|