| SL No | View Name | Description |
| 1 | EDW_CST_COGS_F_IV | |
| 2 | EDW_MTL_UOM_CLS_CONV_F_IV | |
| 3 | EDW_MTL_UOM_CONV_F_IV | |
| 4 | ICX_MTL_DEMAND_SUMMARY_V | |
| 5 | INVBV_ABC_ASSGN_GROUP_CLASSES | - Retrofitted |
| 6 | INVBV_ABC_ASSIGNMENTS | - Retrofitted |
| 7 | INVBV_ABC_ASSIGNMENT_GROUPS | - Retrofitted |
| 8 | INVBV_ABC_CLASSES | - Retrofitted |
| 9 | INVBV_CUSTOMER_ITEMS | - Retrofitted |
| 10 | INVBV_CUSTOMER_ITEM_XREFS | - Retrofitted |
| 11 | INVBV_CYCLE_COUNTS | - Retrofitted |
| 12 | INVBV_CYCLE_COUNT_ADJUSTMENTS | - Retrofitted |
| 13 | INVBV_CYCLE_COUNT_CLASSES | - Retrofitted |
| 14 | INVBV_CYCLE_COUNT_ITEMS | - Retrofitted |
| 15 | INVBV_DESCRIPTIVE_ELEMENTS | - Retrofitted |
| 16 | INVBV_EXTERNAL_ITEM_XREFS | - Retrofitted |
| 17 | INVBV_EXT_ITEM_XREF_TYPES | - Retrofitted |
| 18 | INVBV_FREIGHT_CARRIERS | |
| 19 | INVBV_FUTURE_ITEM_STATUSES | - Retrofitted |
| 20 | INVBV_GL_ACCOUNT_ALIASES | - Retrofitted |
| 21 | INVBV_INTERORG_LEAD_TIMES | - Retrofitted |
| 22 | INVBV_INTERORG_SHIPPING_INFO | - Retrofitted |
| 23 | INVBV_INVENTORY_DEMANDS | - Retrofitted |
| 24 | INVBV_INVENTORY_LOCATORS | - Retrofitted |
| 25 | INVBV_INVENTORY_ORGANIZATIONS | - Retrofitted |
| 26 | INVBV_INVENTORY_RESERVATIONS | - Retrofitted |
| 27 | INVBV_INVENTORY_SUPPLIES | - Retrofitted |
| 28 | INVBV_INVENTORY_TXN_TYPES | - Retrofitted |
| 29 | INVBV_INV_BY_PERIOD_AND_ITEM | retrofitted |
| 30 | INVBV_ITEMS | - Retrofitted |
| 31 | INVBV_ITEM_CATALOG_GROUPS | - Retrofitted |
| 32 | INVBV_ITEM_CATEGORIES | - Retrofitted |
| 33 | INVBV_ITEM_CATEGORY_ASGNS | - Retrofitted |
| 34 | INVBV_ITEM_CATEGORY_TYPES | - Retrofitted |
| 35 | INVBV_ITEM_CATEGORY_TYPE_ASGNS | - Retrofitted |
| 36 | INVBV_ITEM_DESC_ELEMENT_VALUES | - Retrofitted |
| 37 | INVBV_ITEM_RELATIONS | - Retrofitted |
| 38 | INVBV_ITEM_REPLENISH_COUNTS | - Retrofitted |
| 39 | INVBV_ITEM_REVISIONS | - Retrofitted |
| 40 | INVBV_ITEM_STATUS_ATTR_VALUES | - Retrofitted |
| 41 | INVBV_ITEM_STATUS_CODES | - Retrofitted |
| 42 | INVBV_KANBAN_CARDS | - Retrofitted |
| 43 | INVBV_KANBAN_CARD_ACTIVITIES | - Retrofitted |
| 44 | INVBV_KANBAN_LOCATION_ITEMS | - Retrofitted |
| 45 | INVBV_LOTS | - Retrofitted |
| 46 | INVBV_LOT_TRANSACTIONS | - Retrofitted |
| 47 | INVBV_MANUFACTURERS | - Retrofitted |
| 48 | INVBV_MATERIAL_TRANSACTIONS | - Retrofitted |
| 49 | INVBV_MFG_PART_NUMBERS | - Retrofitted |
| 50 | INVBV_MOVEMENT_PARAMETERS | - Retrofitted |
| 51 | INVBV_MOVEMENT_STATISTICS | - Retrofitted |
| 52 | INVBV_MOVE_ORDERS_HEADERS | |
| 53 | INVBV_MOVE_ORDERS_LINES | |
| 54 | INVBV_ONHAND_BALANCES | - Retrofitted |
| 55 | INVBV_ORGANIZATION_ITEMS | - Retrofitted |
| 56 | INVBV_ORG_ITEM_REVISIONS | - Retrofitted |
| 57 | INVBV_PHYSICAL_ADJUSTMENTS | - Retrofitted |
| 58 | INVBV_PHYSICAL_INVENTORIES | - Retrofitted |
| 59 | INVBV_PHYSICAL_INV_COUNTS | - Retrofitted |
| 60 | INVBV_PRODUCT_FAMILY_MEMBERS | - Retrofitted |
| 61 | INVBV_SERIAL_NUMBERS | - Retrofitted |
| 62 | INVBV_SERIAL_NUMBER_TXNS | - Retrofitted |
| 63 | INVBV_SHIP_METHODS | - Retrofitted |
| 64 | INVBV_SUBINVENTORIES | - Retrofitted |
| 65 | INVBV_SUB_REPLENISH_COUNTS | - Retrofitted |
| 66 | INVBV_TRANSACTION_SOURCE_TYPES | - Retrofitted |
| 67 | INVBV_UNITS_OF_MEASURE | - Retrofitted |
| 68 | INVBV_UOM_CLASSES | - Retrofitted |
| 69 | INVBV_UOM_CLASS_CONVERSIONS | - Retrofitted |
| 70 | INVBV_UOM_CONVERSIONS | - Retrofitted |
| 71 | INVFV_ABC_ASSGN_GROUP_CLASSES | - Retrofitted |
| 72 | INVFV_ABC_ASSIGNMENTS | - Retrofitted |
| 73 | INVFV_ABC_ASSIGNMENT_GROUPS | - Retrofitted |
| 74 | INVFV_ABC_CLASSES | - Retrofitted |
| 75 | INVFV_CUSTOMER_ITEMS | |
| 76 | INVFV_CUSTOMER_ITEM_XREFS | |
| 77 | INVFV_CYCLE_COUNTS | - Retrofitted |
| 78 | INVFV_CYCLE_COUNT_ADJUSTMENTS | - Retrofitted |
| 79 | INVFV_CYCLE_COUNT_CLASSES | - Retrofitted |
| 80 | INVFV_CYCLE_COUNT_ITEMS | - Retrofitted |
| 81 | INVFV_DESCRIPTIVE_ELEMENTS | |
| 82 | INVFV_EXTERNAL_ITEM_XREFS | |
| 83 | INVFV_EXT_ITEM_XREF_TYPES | |
| 84 | INVFV_FREIGHT_CARRIERS | |
| 85 | INVFV_FUTURE_ITEM_STATUSES | |
| 86 | INVFV_GL_ACCOUNT_ALIASES | - Retrofitted |
| 87 | INVFV_INTERORG_LEAD_TIMES | - Retrofitted |
| 88 | INVFV_INTERORG_SHIPPING_INFO | - Retrofitted |
| 89 | INVFV_INVENTORY_DEMANDS | - Retrofitted |
| 90 | INVFV_INVENTORY_LOCATORS | - Retrofitted |
| 91 | INVFV_INVENTORY_ORGANIZATIONS | - Retrofitted |
| 92 | INVFV_INVENTORY_RESERVATIONS | - Retrofitted |
| 93 | INVFV_INVENTORY_SUPPLIES | - Retrofitted |
| 94 | INVFV_INVENTORY_TXN_TYPES | - Retrofitted |
| 95 | INVFV_INV_BY_PERIOD_AND_ITEM | |
| 96 | INVFV_ITEMS | |
| 97 | INVFV_ITEM_CATALOG_GROUPS | |
| 98 | INVFV_ITEM_CATEGORIES | |
| 99 | INVFV_ITEM_CATEGORY_ASGNS | |
| 100 | INVFV_ITEM_CATEGORY_TYPES | |
| 101 | INVFV_ITEM_CATEGORY_TYPE_ASGNS | |
| 102 | INVFV_ITEM_DESC_ELEMENT_VALUES | |
| 103 | INVFV_ITEM_RELATIONS | |
| 104 | INVFV_ITEM_REPLENISH_COUNTS | - Retrofitted |
| 105 | INVFV_ITEM_REVISIONS | |
| 106 | INVFV_ITEM_STATUS_ATTR_VALUES | |
| 107 | INVFV_ITEM_STATUS_CODES | |
| 108 | INVFV_KANBAN_CARDS | - Retrofitted |
| 109 | INVFV_KANBAN_CARD_ACTIVITIES | - Retrofitted |
| 110 | INVFV_KANBAN_LOCATION_ITEMS | - Retrofitted |
| 111 | INVFV_LOTS | - Retrofitted |
| 112 | INVFV_LOT_TRANSACTIONS | - Retrofitted |
| 113 | INVFV_MANUFACTURERS | |
| 114 | INVFV_MATERIAL_TRANSACTIONS | - Retrofitted |
| 115 | INVFV_MFG_PART_NUMBERS | |
| 116 | INVFV_MOVEMENT_PARAMETERS | - Retrofitted |
| 117 | INVFV_MOVEMENT_STATISTICS | - Retrofitted |
| 118 | INVFV_MOVE_ORDERS_HEADERS | |
| 119 | INVFV_MOVE_ORDERS_LINES | |
| 120 | INVFV_ONHAND_BALANCES | - Retrofitted |
| 121 | INVFV_ORGANIZATION_ITEMS | |
| 122 | INVFV_ORG_ITEM_REVISIONS | |
| 123 | INVFV_PHYSICAL_ADJUSTMENTS | - Retrofitted |
| 124 | INVFV_PHYSICAL_INVENTORIES | - Retrofitted |
| 125 | INVFV_PHYSICAL_INV_COUNTS | - Retrofitted |
| 126 | INVFV_PRODUCT_FAMILY_MEMBERS | |
| 127 | INVFV_SERIAL_NUMBERS | - Retrofitted |
| 128 | INVFV_SERIAL_NUMBER_TXNS | - Retrofitted |
| 129 | INVFV_SHIP_METHODS | - Retrofitted |
| 130 | INVFV_SUBINVENTORIES | - Retrofitted |
| 131 | INVFV_SUB_REPLENISH_COUNTS | - Retrofitted |
| 132 | INVFV_TRANSACTION_SOURCE_TYPES | - Retrofitted |
| 133 | INVFV_UNITS_OF_MEASURE | - Retrofitted |
| 134 | INVFV_UOM_CLASSES | - Retrofitted |
| 135 | INVFV_UOM_CLASS_CONVERSIONS | - Retrofitted |
| 136 | INVFV_UOM_CONVERSIONS | - Retrofitted |
| 137 | INV_3PL_CLIENTS_V | View for 3PL Client Information |
| 138 | INV_3PL_CONTRACTS_V | View Contains 3PL Contract info |
| 139 | INV_BIS_ITEM_COSTS | Cost for Inventory Items with standard cost, and items with average cost using |
| 140 | INV_BIS_SUPPLY_CHAIN_INVENTORY | Supply Chain Inventory Information |
| 141 | INV_EID_LOCATORS_V | |
| 142 | INV_EID_MTL_TRANSACTIONS_V | |
| 143 | INV_EID_ONHAND_DETAILS_V | |
| 144 | INV_EID_RESERVATIONS_V | |
| 145 | INV_EID_UNPICKED_DETAILS_V | |
| 146 | INV_EID_UNPICKED_DET_INCR_V | |
| 147 | INV_LOT_SERIAL_COLUMNS_V | View of Lot and Serial Descriptive Flex Field Column |
| 148 | INV_LOT_SERIAL_CONTEXT_V | View of Lot and Serial Descriptive Flex Field Context |
| 149 | INV_ORGANIZATION_INFO_V | View of Inventory Organization information |
| 150 | INV_ORGANIZATION_NAME_V | View of Inventory Organization Names |
| 151 | MFG_LOOKUPS | MFG_LOOKUPS is a view of selected columns from the table FND_LOOKUP_VALUES. |
| 152 | MFG_LOOKUPS_V | MFG_LOOKUPS_V is a view of selected columns from the table FND_LOOKUP_VALUES. |
| 153 | MTL_ABC_ASSGNMNT_GROUPS_ALL_V | 10SC ONLY |
| 154 | MTL_ABC_ASSGN_GROUP_CLASSES_V | 10SC ONLY |
| 155 | MTL_ABC_ASSIGNMENTS_V | 10SC ONLY |
| 156 | MTL_ABC_ASSIGNMENT_GROUPS_V | 10SC ONLY |
| 157 | MTL_ABC_CLASSES_ALL_V | 10SC ONLY |
| 158 | MTL_ABC_CLASSES_V | 10SC ONLY |
| 159 | MTL_ABC_CLASSES_VAL_V | 10SC ONLY |
| 160 | MTL_ABC_COMPILES_V | - Retrofitted |
| 161 | MTL_ABC_COMPILE_HEADERS_V | - Retrofitted |
| 162 | MTL_ACTIONS_VL | Actions Code View |
| 163 | MTL_ADJUSTMENT_LOTSERIAL_V | View of Lot and Serial Adjustment |
| 164 | MTL_ADJ_SYNC_WRAPPER_V | View of Adjustment sync Wrapper |
| 165 | MTL_AGREEMENT_DETAILS_V | View of Agreement details |
| 166 | MTL_ALL_PRIMARY_UOMS_VV | 10SC ONLY |
| 167 | MTL_ATT_QTY_V | No longer used |
| 168 | MTL_AVAILABLE_INVENTORY_V | View of select available inventory |
| 169 | MTL_BILLING_RULE_HEADERS_VL | |
| 170 | MTL_BILLING_RULE_LINES_V | View of Billing rule at line level |
| 171 | MTL_BILLING_SOURCES_VL | |
| 172 | MTL_BIS_INV_VALUE_V | Stores Onhand/Intransit quantity and value for Inventory items at organization and intransit owning organizations respectively. |
| 173 | MTL_CATALOG_SEARCH_ITEMS_ALL_V | 10SC ONLY |
| 174 | MTL_CATEGORIES_B_KFV | Categories Key Flexfield View |
| 175 | MTL_CATEGORIES_V | 10SC ONLY |
| 176 | MTL_CATEGORIES_VL | Categories multilingual view |
| 177 | MTL_CATEGORY_ACCOUNTS_V | - Retrofitted |
| 178 | MTL_CATEGORY_GRANTS_V | Provides information regarding parties and roles on categories |
| 179 | MTL_CATEGORY_SETS_ALL_V | 10SC ONLY |
| 180 | MTL_CATEGORY_SETS_V | 10SC ONLY |
| 181 | MTL_CATEGORY_SETS_VL | Category Sets multilingual view |
| 182 | MTL_CATEGORY_SET_VALID_CATS_V | 10SC ONLY |
| 183 | MTL_CC_ENTRIES_INTERFACE_V | Cycle Count Entries Interface View |
| 184 | MTL_CC_GRAPH_DAY_V | 10SC ONLY |
| 185 | MTL_CC_GRAPH_MONTH_V | 10SC ONLY |
| 186 | MTL_CC_GRAPH_PERIOD_V | 10SC ONLY |
| 187 | MTL_CC_GRAPH_QTR_V | 10SC ONLY |
| 188 | MTL_CC_GRAPH_V | 10SC ONLY |
| 189 | MTL_CC_GRAPH_WK_V | 10SC ONLY |
| 190 | MTL_CC_INTERFACE_ERRORS_V | Cycle Count Entries Interface Errors View |
| 191 | MTL_CC_SCHEDULES_V | 10SC ONLY |
| 192 | MTL_CC_SUBINVENTORIES_ALL_V | 10SC ONLY |
| 193 | MTL_CLIENT_ITEMS_VL | |
| 194 | MTL_CLIENT_PARAMETERS_V | View of Client parameters |
| 195 | MTL_COMMODITY_CODES_ACTIVE_V | 10SC ONLY |
| 196 | MTL_COMMODITY_CODES_ALL_V | 10SC ONLY |
| 197 | MTL_CONSUMPTION_DEFINITION_V | For Consumption setup forms |
| 198 | MTL_COUNTRY_ASSIGNMENTS_V | View joins territories and country assignments |
| 199 | MTL_CROSS_REFERENCES_SRW_V | 10SC ONLY |
| 200 | MTL_CROSS_REFERENCES_V | 10SC ONLY |
| 201 | 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 |
| 202 | MTL_CST_TXN_COST_DETAILS_V | |
| 203 | MTL_CUSTOMER_ITEMS_ACTIVE_V | 10SC ONLY |
| 204 | MTL_CUSTOMER_ITEMS_ALL_V | 10SC ONLY |
| 205 | MTL_CUSTOMER_ITEM_XREFS_V | 10SC ONLY |
| 206 | MTL_CYCLE_COUNT_CLASSES_ALL_V | 10SC ONLY |
| 207 | MTL_CYCLE_COUNT_CLASSES_V | 10SC ONLY |
| 208 | MTL_CYCLE_COUNT_ENTRIES_ALL_V | 10SC ONLY |
| 209 | MTL_CYCLE_COUNT_ENTRIES_V | 10SC ONLY |
| 210 | MTL_CYCLE_COUNT_HEADERS_ALL_V | 10SC ONLY |
| 211 | MTL_CYCLE_COUNT_HEADERS_V | 10SC ONLY |
| 212 | MTL_CYCLE_COUNT_HEADERS_VAL_V | 10SC ONLY |
| 213 | MTL_CYCLE_COUNT_ITEMS_ALL_V | 10SC ONLY |
| 214 | MTL_CYCLE_COUNT_ITEMS_V | 10SC ONLY |
| 215 | MTL_CYCLE_COUNT_SERIALS_V | |
| 216 | MTL_DEFAULT_CATEGORY_SETS_FK_V | 10SC ONLY |
| 217 | MTL_DEFAULT_SETS_VIEW | Required to get around SRS's 240 char limit when defaulting category sets |
| 218 | MTL_DEMAND_HISTORY_ITEMS_V | 10SC ONLY |
| 219 | MTL_DEMAND_HISTORY_V | 10SC ONLY |
| 220 | MTL_DEMAND_INTERFACE_V | 10SC ONLY |
| 221 | MTL_DEMAND_INTERFACE_VIEW | A view for demand interface table. |
| 222 | MTL_DEMAND_OM_VIEW | |
| 223 | MTL_DEMAND_V | 10SC ONLY |
| 224 | MTL_DESCR_ELEMENT_VALUES_V | 10SC ONLY |
| 225 | MTL_DESCR_ELEM_VAL_V | 10SC ONLY |
| 226 | MTL_EAM_ASSET_ACTIVITIES_V | View for Asset Activities |
| 227 | MTL_EAM_ASSET_ACTIVITIES_WB_V | View for Activity Workbench |
| 228 | MTL_EAM_ASSET_ATTR_GROUPS_V | View for Asset Attribute Groups |
| 229 | MTL_EAM_ASSET_ATTR_VALUES_V | View for Asset Attribute Values |
| 230 | MTL_EAM_ASSET_NUMBERS_ALL_V | View for Asset Number details |
| 231 | MTL_EAM_ASSET_NUMBERS_V | View for Asset Numbers |
| 232 | MTL_EAM_ASSET_NUM_INTERFACE_V | Asset Number Interface View |
| 233 | MTL_EAM_ASSET_REBUILDS_DTLS_V | View shows the details of Assets and Rebuilds. |
| 234 | MTL_EAM_ASSET_REBUILDS_V | View for Asset and Rebuild information. |
| 235 | MTL_EAM_EQUIP_RESOURCES_V | View for EAM equipment resources |
| 236 | MTL_EAM_ITEMS_V | View of all EAM items. |
| 237 | MTL_EAM_JOBS_RESOURCES_V | Job resources for EAM (Enterprise Asset management) |
| 238 | MTL_EAM_NETWORK_ASSETS_V | View for EAM Asset Routes |
| 239 | MTL_ECONOMIC_ZONES_VL | Joins the base economic zone table and translated economic zone table |
| 240 | MTL_EMPLOYEES_CURRENT_VIEW | View of employees currently assigned to a given organization |
| 241 | MTL_EMPLOYEES_VIEW | View of employees |
| 242 | MTL_FETCH_AGREEMENT_LINES | View of agreement lines fetch |
| 243 | MTL_FISCAL_CAT_ACCOUNTS_V | PAC Category Accounts |
| 244 | MTL_FORECAST_DATES_COST_V | - Retrofitted |
| 245 | MTL_GENEALOGY_QA_DATA | View to query the Quality data on Genealogy form |
| 246 | MTL_GENERIC_DISPOSITIONS_KFV | Account Alias Key Flexfield View |
| 247 | MTL_GRADES_VL | Grade Code View |
| 248 | MTL_GRADE_CHANGE_ERV | Grade Change History View |
| 249 | MTL_GRD_STS_HISTORY_V | Grade , Status Change History View |
| 250 | MTL_GROSS_REQ_COST_V | - Retrofitted |
| 251 | MTL_GROUP_ATPS_VIEW | This view is used for ATP and derived from MTL_DEMAND_INTERFACE |
| 252 | MTL_GROUP_ITEM_ATPS_VIEW | This view is used for ATP and derived from MTL_DEMAND_INTERFACE |
| 253 | MTL_INTERCOMPANY_PARAMETERS_V | 10SC ONLY |
| 254 | MTL_INTERFACE_PROC_CONTROLS_V | 10SC ONLY |
| 255 | MTL_INV_TXNS_MFG_LOTS_V | View of Inventory transactions Lots |
| 256 | MTL_ITEM_ATTRIBUTES_V | 10SC ONLY |
| 257 | MTL_ITEM_ATTRIBUTE_NAMES_V | 10SC ONLY |
| 258 | MTL_ITEM_ATTRIBUTE_VALUES_V | 10SC ONLY |
| 259 | MTL_ITEM_ATTR_APPL_INST_V | |
| 260 | MTL_ITEM_ATTR_FIELDS_V | 10SC ONLY |
| 261 | MTL_ITEM_CATALOG_GROUPS_B_KFV | Item Catalog Groups dummy key flexfield view |
| 262 | MTL_ITEM_CATALOG_GROUPS_KFV | Item Catalog Key Flexfield View |
| 263 | MTL_ITEM_CATALOG_GROUPS_V | 10SC ONLY |
| 264 | MTL_ITEM_CATALOG_GROUPS_VL | Item Catalog Groups multilingual view |
| 265 | MTL_ITEM_CATEGORIES_V | 10SC ONLY |
| 266 | MTL_ITEM_CATEGORIES_VIEW | 10SC ONLY |
| 267 | MTL_ITEM_ENDECA_CATEGORIES_V | |
| 268 | MTL_ITEM_ENDECA_CROSS_REF_V | |
| 269 | MTL_ITEM_ENDECA_CUSTOMERS_V | |
| 270 | MTL_ITEM_ENDECA_DESC_ELEM_V | |
| 271 | MTL_ITEM_ENDECA_MANF_V | |
| 272 | MTL_ITEM_ENDECA_ONHAND_V | |
| 273 | MTL_ITEM_ENDECA_REL_ITEMS_IV1 | |
| 274 | MTL_ITEM_ENDECA_REL_ITEMS_IV2 | |
| 275 | MTL_ITEM_ENDECA_REL_ITEMS_V | |
| 276 | MTL_ITEM_ENDECA_REVISIONS_V | |
| 277 | MTL_ITEM_ENDECA_SUPPLIERS_V | |
| 278 | 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 an item number. |
| 279 | MTL_ITEM_FLEXFIELDS_OLD | Contains concatenated item segments, inventory_item_id |
| 280 | MTL_ITEM_LOCATIONS_KFV | Item Locations Key Flexfield View |
| 281 | MTL_ITEM_LOCATIONS_VIEW | View of item quantities by locator |
| 282 | MTL_ITEM_LOT_QUANTITIES_VIEW | Item lot quantities under subinventory and locator |
| 283 | MTL_ITEM_LOT_UOM_CONV_ERV | |
| 284 | MTL_ITEM_ORG_CATEG_V | 10SC ONLY |
| 285 | MTL_ITEM_ORG_REV_V | 10SC ONLY |
| 286 | MTL_ITEM_QUANTITIES_VIEW | Item onhand quantities view |
| 287 | MTL_ITEM_REVISIONS_ALL_V | 10SC ONLY |
| 288 | MTL_ITEM_REVISIONS_ORG_VAL_V | 10SC ONLY |
| 289 | MTL_ITEM_REVISIONS_VL | Item Revisions multilingual view |
| 290 | MTL_ITEM_REV_HIGHDATE_V | 10SC ONLY |
| 291 | MTL_ITEM_STATUS_VAL_V | 10SC ONLY |
| 292 | MTL_ITEM_STATUS_VL | This table contains the columns of MTL_ITEM_STATUS_TL a for current user's language settings |
| 293 | MTL_ITEM_SUB_AST_TRK_VAL_V | - Retrofitted |
| 294 | MTL_ITEM_SUB_AST_VAL_V | - Retrofitted |
| 295 | MTL_ITEM_SUB_EXP_TRK_VAL_V | - Retrofitted |
| 296 | MTL_ITEM_SUB_EXP_VAL_V | - Retrofitted |
| 297 | MTL_ITEM_SUB_INVENTORIES_ALL_V | 10SC ONLY |
| 298 | MTL_ITEM_SUB_TRK_ALL_V | - Retrofitted |
| 299 | MTL_ITEM_SUB_TRK_VAL_V | - Retrofitted |
| 300 | MTL_ITEM_SUB_VAL_V | - Retrofitted |
| 301 | MTL_ITEM_TEMPLATES_ALL_V | 10SC ONLY |
| 302 | 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 |
| 303 | MTL_ITEM_TEMPL_ATTRIBUTES_V | 10SC ONLY |
| 304 | MTL_ITEM_UOMS_VIEW | Holds valid UOMs for items, considering the conversions that are defined |
| 305 | MTL_KANBAN_CARDS_V | - Retrofitted |
| 306 | MTL_KANBAN_CARD_ACTIVITY_V | - Retrofitted |
| 307 | MTL_KANBAN_PULL_SEQUENCES_V | retrofitted |
| 308 | MTL_LE_ECONOMIC_ZONES_V | Join between the table MTL_Le_Economic_Zones, the view MTL_Economic_Zones_VL and HR_Legal_Entities |
| 309 | MTL_LOT_CONV_AUDITDETAILS_ERV | View of Lot convergence Audit Details |
| 310 | MTL_LOT_CONV_AUDIT_DETAILS_V | Lot Specific UOM Conversions Audit Details |
| 311 | MTL_LOT_DEMAND_VAL_V | view of lot demand value |
| 312 | MTL_LOT_ISSUES_VAL_V | 10SC ONLY |
| 313 | MTL_LOT_NUMBERS_ALL_V | 10SC ONLYCHANGES DONE AS VIEW IS NON MERGEABLE DUE TO JOIN ON MTL_MATERIAL_STATUSES_VL |
| 314 | MTL_LOT_NUMBERS_ERV | View of Lot number ERV |
| 315 | MTL_LOT_NUMBERS_SRW_V | 10SC ONLY |
| 316 | MTL_LOT_NUMBERS_VAL_V | 10SC ONLY |
| 317 | MTL_LOT_ONHAND_SUM_V | Quantity view for Lot uom conversion use |
| 318 | MTL_LOT_SERIAL_DFF_ERV | Required for electronic records. Selects the lot and serial attributes out of the description flexfield data model. |
| 319 | MTL_LOT_UOM_CLASS_CONV_V | Lot Specific UOM Conversions |
| 320 | MTL_MATERIAL_STATUSES_VL | Multilingual view for material status tables. - Used by WMS only |
| 321 | MTL_MATERIAL_STATUS_HIST_ERV | View for Material Status history |
| 322 | MTL_MATERIAL_TXNS_TEMP_VIEW | A View of MTL_MATERIAL_TRANSACTIONS_TEMP used in an Inquiry form |
| 323 | MTL_MATERIAL_TXNS_VAL_V | - Retrofitted |
| 324 | MTL_MFG_BATCHES_SECURITY_V | View of gme batches with securities for genealogy |
| 325 | MTL_MFG_BATCHES_V | View of gme batches for Genealogy |
| 326 | MTL_MFG_COMPONENTS_V | View of gme components for Genealogy |
| 327 | MTL_MFG_GENEALOGY_LOTATTR_V | View of gme components for Genealogy |
| 328 | MTL_MFG_LOTS_TRANS_V | View of gme for lot transactions |
| 329 | MTL_MFG_PART_NUMBERS_ALL_V | 10SC ONLY |
| 330 | MTL_MFG_PRODUCTS_V | View of gme products |
| 331 | MTL_MGD_INVPOS_DATA_SETS_V | This view lists the names of the existing data sets created by the Inventory Position View feature. |
| 332 | MTL_MOVEMENT_PARAMETERS_V | 10SC ONLY |
| 333 | MTL_MOVEMENT_STATISTICS_V | |
| 334 | MTL_MOVE_ORDER_HEADERS_V | - Retrofitted |
| 335 | MTL_MOVE_ORDER_LINES_V | - Retrofitted |
| 336 | MTL_MVT_STATS_RULE_SETS_VL | Multilingual view for Rule Sets tables. |
| 337 | MTL_MWB_GTMP_V | Material Workbench Global Temporary Table View |
| 338 | MTL_NEGATIVE_VIEW | View of onhand negative inventory |
| 339 | MTL_OBJECT_GRANTS_V | |
| 340 | MTL_OBJECT_NUMBERS_V | View of the genealogy object numbers |
| 341 | MTL_ONHAND_ATP | This view would be used by Planning to calculate the ATPable quantity for an item. |
| 342 | MTL_ONHAND_DUMMY_V | View for Onhand dummy records |
| 343 | MTL_ONHAND_ITEMS_V | 10SC ONLY |
| 344 | MTL_ONHAND_LOCATOR_LOT_V | 10SC ONLY |
| 345 | MTL_ONHAND_LOCATOR_V | 10SC ONLY |
| 346 | MTL_ONHAND_LOT_V | 10SC ONLY |
| 347 | MTL_ONHAND_LPN_MWB_V | LPN content view for Material Workbench |
| 348 | MTL_ONHAND_LPN_V | This view contains information about packed material that resides in LPNs. |
| 349 | MTL_ONHAND_NET | View for net Onhand Quantity |
| 350 | MTL_ONHAND_NEW_LPN_MWB_V | LPN content view for Material Workbench |
| 351 | MTL_ONHAND_NEW_LPN_V | LPN content view |
| 352 | MTL_ONHAND_QTY_COST_V | - Retrofitted |
| 353 | MTL_ONHAND_QUANTITIES | View of items owned, planned and physically belonging to the same inventory organization |
| 354 | MTL_ONHAND_REV_V | 10SC ONLY |
| 355 | MTL_ONHAND_SERIAL_MWB_V | Onhand Serial View for the Material Work Bench |
| 356 | MTL_ONHAND_SERIAL_V | |
| 357 | MTL_ONHAND_STATUS_HIST_ERV | View for On-hand status of Exchange Rate Variance. |
| 358 | MTL_ONHAND_SUB_V | 10SC ONLY |
| 359 | MTL_ONHAND_SYNC_V | View for onhand Synchronization |
| 360 | MTL_ONHAND_TOTAL_MWB_V | Onhand Total View for the Material Work Bench |
| 361 | MTL_ONHAND_TOTAL_V | |
| 362 | MTL_OPSM_LOT_EXPORT_V | |
| 363 | MTL_OPSM_SYSTEM_ITEMS_V | |
| 364 | MTL_ORGANIZATIONS | View of organizations |
| 365 | MTL_ORG_ASSIGN_V | 10SC ONLY |
| 366 | MTL_ORG_REPORT_TEMP_FK_V | 10SC ONLY |
| 367 | MTL_PAC_TXN_COST_DETAILS_V | |
| 368 | MTL_PARAMETERS_ALL_V | - Retrofitted |
| 369 | MTL_PARAMETERS_VIEW | - Retrofitted |
| 370 | MTL_PENDING_TXNS_MFG_LOTS_V | View for pending transactions for MFG Lots |
| 371 | MTL_PENDING_TXN_DETAILS_V | View for pending transaction details |
| 372 | MTL_PERIODS | View of period dates and inventory value for open periods |
| 373 | MTL_PERIOD_SUMMARY_V | 10SC ONLY |
| 374 | MTL_PHYSICAL_ADJUSTMENTS_V | 10SC ONLY |
| 375 | MTL_PHYSICAL_ADJUSTMENTS_VIEW | Physical inventory adjustments created by Item Counts. |
| 376 | MTL_PHYSICAL_INVENTORIES_V | View based on table MTL_PHYSICAL_INVENTORIES. Has all the Physical Inventory Setup Information. |
| 377 | MTL_PHYSICAL_INVENTORY_TAGS_V | View based on table MTL_PHYSICAL_INVENTORY_TAGS. Has information for all the Physical Inventory tags. |
| 378 | MTL_PHYSICAL_SUBINVENTORIES_V | 10SC ONLY |
| 379 | MTL_PHY_ADJ_COST_V | - Retrofitted |
| 380 | MTL_PHY_INV_TAGS_COST_V | - Retrofitted |
| 381 | MTL_PRIMARY_UOMS_VV | 10SC ONLY |
| 382 | MTL_PROCURING_TXN_FLOW_HDRS_V | MTL_PROCURING_TXN_FLOW_HDRS_V is a view of transaction flow headres for procuring flow. |
| 383 | 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 transaction flow lines information for each header. |
| 384 | MTL_PROJECT_DEMAND_VIEW | - Retrofitted |
| 385 | MTL_PROJECT_V | - Retrofitted |
| 386 | MTL_QOH_ITEM_ALL_V | 10SC ONLY |
| 387 | MTL_QOH_ITEM_V | 10SC ONLY |
| 388 | MTL_QOH_LOCATOR_V | 10SC ONLY |
| 389 | MTL_QOH_LOC_ALL_V | 10SC ONLY |
| 390 | MTL_QOH_LOT_ALL_V | 10SC ONLY |
| 391 | MTL_QOH_LOT_V | 10SC ONLY |
| 392 | MTL_QOH_REV_ALL_V | 10SC ONLY |
| 393 | MTL_QOH_REV_V | 10SC ONLY |
| 394 | MTL_QOH_SUB_ALL_V | 10SC ONLY |
| 395 | MTL_QOH_SUB_V | 10SC ONLY |
| 396 | MTL_RCV_MWB_NEW_OH_V | View for receiving at material workbench of new onhand |
| 397 | 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. |
| 398 | 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 has entered serials and grade code in the Find window, or has entered grade in the Find window and |
| 399 | 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 controlled. |
| 400 | MTL_RELATED_ITEMS_ALL_V | 10SC ONLY |
| 401 | MTL_RELATED_ITEMS_CUST_REF_V | |
| 402 | MTL_RELATED_ITEMS_PLN_INFO_V | |
| 403 | MTL_RELATED_ITEMS_VIEW | View of MTL_RELATED_ITEMS with reciprocal item relationships appearing twice |
| 404 | MTL_REPLENISH_HEADERS_VIEW | - Retrofitted |
| 405 | MTL_REPLENISH_LINES_VIEW | - Retrofitted |
| 406 | MTL_RESERVATIONS_ALL_V | |
| 407 | MTL_RESERVATIONS_INTERFACE_V | |
| 408 | MTL_RESERVATIONS_V | 10SC ONLY |
| 409 | MTL_RESERVATIONS_VIEW | Not used |
| 410 | MTL_ROUTING_REV_HIGHDATE_V | 10SC ONLY |
| 411 | MTL_SAFETY_STOCKS_VIEW | - Retrofitted |
| 412 | MTL_SALES_ORDERS_KFV | Sales Orders Key Flexfield View |
| 413 | MTL_SECINV_QUANTITIES_VIEW | View of Item subinventory |
| 414 | MTL_SECONDARY_INVENTORIES_FK_V | - Retrofitted |
| 415 | MTL_SECONDARY_LOCATORS_ALL_V | 10SC ONLY |
| 416 | MTL_SERIAL_NUMBERS_ALL_V | 10SC ONLY |
| 417 | MTL_SERIAL_NUMBERS_SRW_V | 10SC ONLY |
| 418 | MTL_SERIAL_NUMBERS_TEMP_ERV | Required by electronic records to snapshot serial numbers. |
| 419 | MTL_SERIAL_NUMBERS_VAL_V | 10SC ONLY |
| 420 | MTL_SERIAL_NUMBER_GEN_V | |
| 421 | MTL_SERVICE_CONTRACTS_V | View for Service contracts |
| 422 | MTL_SHIPPING_NETWORK_VIEW | - Retrofitted |
| 423 | MTL_SHORT_SUMMARY_V | Summary view of the material shortages temp table |
| 424 | MTL_STATUS_CONTROL_V | |
| 425 | MTL_STAT_ATTRIB_VALUES_ALL_V | 10SC ONLY |
| 426 | MTL_STAT_TYPE_USAGES_V | Join of Stat_Type_Usages, Hr Legal Entities, Category Sets, Economic Zones View and Hr Locations |
| 427 | MTL_SUBINVENTORIES_ALL_V | - Retrofitted |
| 428 | MTL_SUBINVENTORIES_TRK_VAL_V | - Retrofitted |
| 429 | MTL_SUBINVENTORIES_VAL_V | - Retrofitted |
| 430 | MTL_SUB_AST_TRK_VAL_V | - Retrofitted |
| 431 | MTL_SUB_AST_VAL_V | - Retrofitted |
| 432 | MTL_SUB_EXP_TRK_VAL_V | - Retrofitted |
| 433 | MTL_SUB_EXP_VAL_V | - Retrofitted |
| 434 | MTL_SUB_TRK_ALL_V | - Retrofitted |
| 435 | MTL_SUMMARY_TEMP_V | 10SC ONLY |
| 436 | MTL_SUPPLIER_SITES_V | - Retrofitted |
| 437 | MTL_SYSTEM_ITEMS_B_KFV | System Items Key Flexfield View |
| 438 | MTL_SYSTEM_ITEMS_ER1_V | ERES : View to support ERES framework for Items |
| 439 | MTL_SYSTEM_ITEMS_ER2_V | ERES : View to support ERES framework for Items Catalog Group Assignment |
| 440 | MTL_SYSTEM_ITEMS_ER3_V | ERES : View to support ERES framework for Items Catalog Group Assignment(Summary View) |
| 441 | MTL_SYSTEM_ITEMS_ER4_V | ERES : View to support ERES framework for Items Organization Assignment |
| 442 | MTL_SYSTEM_ITEMS_FKEYS_V | 10SC ONLY |
| 443 | MTL_SYSTEM_ITEMS_FVL | Base view for the Define System Items (INVIDITM) form MTL_SYSTEM_ITEMS block. This view is MLS enabled. |
| 444 | MTL_SYSTEM_ITEMS_VL | System Items multilingual view with concatenated segments column |
| 445 | MTL_TASK_V | - Retrofitted |
| 446 | MTL_TRANSACTIONS_INTERFACE_V | - Retrofitted |
| 447 | MTL_TRANSACTIONS_TEMP_ALL_V | - Retrofitted |
| 448 | MTL_TRANSACTION_DETAILS_V | |
| 449 | MTL_TRANSACTION_FLOWS_V | MTL_TRANSACTION_FLOWS_V is a view for Intercompany transaction flows of type shipping and procuring flows. |
| 450 | MTL_TRANSACTION_FLOW_HEADERS_V | MTL_TRANSACTION_FLOW_HEADERS_V is a view for Intercompany transaction flow headers of type shipping and procuring flows. |
| 451 | 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. |
| 452 | MTL_TRANSACTION_LOTS_TEMP_V | |
| 453 | MTL_TRANSACTION_LOTS_VIEW | A view showing all material lot number transactions. |
| 454 | MTL_TRANSACTION_LOT_VAL_V | 10SC ONLY |
| 455 | MTL_TRANSACTION_REASONS_ALL_V | 10SC ONLY |
| 456 | MTL_TRANSACTION_REASONS_VAL_V | 10SC ONLY |
| 457 | MTL_TRANSACT_INTERFACE_VIEW | Transaction interface status view |
| 458 | MTL_TRAN_TYPES_SYS_VAL_VIEW | - Retrofitted |
| 459 | MTL_TRAN_TYPES_USER_VAL_VIEW | - Retrofitted |
| 460 | MTL_TRX_TYPES_VIEW | - Retrofitted |
| 461 | MTL_TXN_BACKORDERS_V | |
| 462 | MTL_TXN_REQUEST_HEADERS_V | |
| 463 | MTL_TXN_REQUEST_LINES_V | |
| 464 | MTL_TXN_SOURCE_TYPES_ALL_V | 10SC ONLY |
| 465 | MTL_TXN_SRC_FOR_TRAN_TYPE_VIEW | - Retrofitted |
| 466 | MTL_UNITS_OF_MEASURE_AV | 10SC ONLY |
| 467 | MTL_UNITS_OF_MEASURE_VL | MTL_UNITS_OF_MEASURE_VL is a view of selected columns from the table MTL_UNITS_OF_MEASURE_TL. |
| 468 | MTL_UNITS_OF_MEASURE_VV | 10SC ONLY |
| 469 | MTL_UNIT_TRANSACTIONS_ALL_V | 10SC ONLY |
| 470 | MTL_UOM_CLASSES_AV | 10SC ONLY |
| 471 | MTL_UOM_CLASSES_VL | |
| 472 | MTL_UOM_CLASSES_VV | 10SC ONLY |
| 473 | MTL_UOM_CLASS_CONV_VAL_V | 10SC ONLY |
| 474 | MTL_UOM_CONVERSIONS_VAL_V | 10SC ONLY |
| 475 | MTL_UOM_CONVERSIONS_VIEW | View giving unit of measure conversion rates between the primary unit of measure and another unit of measure |
| 476 | MTL_VENDOR_LOT_VIEW | Supplier information |
| 477 | MTL_WORK_ORDER_HEADER_V | View for work order header |
| 478 | ORG_ACCESS_V | 10SC ONLY |
| 479 | ORG_ACCESS_VIEW | Organization access view resolving all organizations available for each responsibility |
| 480 | ORG_ACCT_PERIODS_V | 10SC ONLY |
| 481 | ORG_ENABLED_FREIGHT_VAL_V | - Retrofitted |
| 482 | ORG_FREIGHT_CODE_ALL_V | 10SC ONLY |
| 483 | ORG_FREIGHT_CODE_VAL_V | 10SC ONLY |
| 484 | ORG_FREIGHT_VL | This view contains information about the available Freight Carriers in the current session language. |
| 485 | ORG_GL_BATCHES_V | 10SC ONLY |
| 486 | ORG_ORGANIZATION_DEFINITIONS | Inventory organizations |
| 487 | ORG_ORGANIZATION_DEFINITIONS2 | Inventory organizations and organizations "claiming" to be inventory organizations but do not have inventory parameters |
| 488 | ORG_ORGANIZATION_DEF_MRC_V | - Retrofitted |
| 489 | ORG_ORG_DEFINITIONS_ALL_V | 10SC ONLY |
| 490 | RCV_RECEIPT_CONFIRMATION_V |
Comments
Post a Comment