[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MTL_PARAMETERS |
|---|---|
| Object Type: | TABLE |
| Owner: | INV |
| FND Design Data: |  INV.MTL_PARAMETERS
|
| Subobject Name: | |
| Status: | VALID |
MTL_PARAMETERS maintains a set of default options like general ledger
accounts; locator, lot, and serial controls; inter-organization
options; costing method; etc. for each organization defined in Oracle
Inventory.
.
Each organization's item master organization (MASTER_ORGANIZATION_ID)
and costing organization (COST_ORGANIZATION_ID) are maintained here.
.
You specify which manufacturing calendar the organization will use
(CALENDAR_CODE), as well as the set of exceptions to this calendar
(CALENDAR_EXCEPTION_SET_ID).
.
NEGATIVE_INV_RECEIPT_CODE indicates whether this organization will
allow negative balances in inventory. It is used in the transaction
system to ensure, for example, that you do not over-issue a particular
item (if you have indicated that negative balances are not allowed).
.
For lot number and serial number auto-generation, you can specify
whether you want the numbers generated from defaults defined at theorganization level or the item level (LOT_NUMBER_GENERATION,SERIAL_NUMBER_GENERATION). You can also specify uniqueness
constraints for lot numbers (LOT_NUMBER_UNIQUENESS) and serial numbers
(SERIAL_NUMBER_TYPE).
.
Among the accounting defaults that can be defined here are valuation
accounts, receiving accounts, profit and loss accounts, and inter-
organization transfer accounts.
| Tablespace: |  APPS_TS_SEED |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MTL_PARAMETERS_U1 | NORMAL | UNIQUE |
APPS_TS_SEED
|
 ORGANIZATION_ID
|
| MTL_PARAMETERS_N1 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
MASTER_ORGANIZATION_ID
|
| MTL_PARAMETERS_N2 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
COST_ORGANIZATION_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| ORGANIZATION_CODE | VARCHAR2 | (3) | Organization code | |
| MASTER_ORGANIZATION_ID | NUMBER | Yes | Item master organization identifier | |
| PRIMARY_COST_METHOD | NUMBER | Yes | Primary costing method | |
| COST_ORGANIZATION_ID | NUMBER | Yes | Cost organization identifier | |
| DEFAULT_MATERIAL_COST_ID | NUMBER | Default material sub-element | ||
| CALENDAR_EXCEPTION_SET_ID | NUMBER | Calendar exception set | ||
| CALENDAR_CODE | VARCHAR2 | (10) | Manufacturing calendar | |
| GENERAL_LEDGER_UPDATE_CODE | NUMBER | Yes | General ledger update code | |
| DEFAULT_ATP_RULE_ID | NUMBER | Default available to promise rule | ||
| DEFAULT_PICKING_RULE_ID | NUMBER | Default picking rule code | ||
| DEFAULT_LOCATOR_ORDER_VALUE | NUMBER | Default picking order of locators | ||
| DEFAULT_SUBINV_ORDER_VALUE | NUMBER | Default picking order for subinventories | ||
| NEGATIVE_INV_RECEIPT_CODE | NUMBER | Yes | Indicates whether negative balances are allowed | |
| STOCK_LOCATOR_CONTROL_CODE | NUMBER | Yes | Stock locator control code | |
| MATERIAL_ACCOUNT | NUMBER | Inventory material account | ||
| MATERIAL_OVERHEAD_ACCOUNT | NUMBER | Inventory material overhead account | ||
| MATL_OVHD_ABSORPTION_ACCT | NUMBER | Material overhead absorption account | ||
| RESOURCE_ACCOUNT | NUMBER | Resource labor account | ||
| PURCHASE_PRICE_VAR_ACCOUNT | NUMBER | Purchase price variance account | ||
| AP_ACCRUAL_ACCOUNT | NUMBER | Accounts payable accrual account | ||
| OVERHEAD_ACCOUNT | NUMBER | Inventory overhead account | ||
| OUTSIDE_PROCESSING_ACCOUNT | NUMBER | Outside processing account | ||
| INTRANSIT_INV_ACCOUNT | NUMBER | Inter-organization transfer debit account | ||
| INTERORG_RECEIVABLES_ACCOUNT | NUMBER | Inter-organization receivables account | ||
| INTERORG_PRICE_VAR_ACCOUNT | NUMBER | Inter-organization price variance account | ||
| INTERORG_PAYABLES_ACCOUNT | NUMBER | Inter-organization payables account | ||
| COST_OF_SALES_ACCOUNT | NUMBER | Cost of sales account | ||
| ENCUMBRANCE_ACCOUNT | NUMBER | Encumbrance account | ||
| PROJECT_COST_ACCOUNT | NUMBER | Project Cost Account | ||
| INTERORG_TRANSFER_CR_ACCOUNT | NUMBER | Inter-organization transfer credit account | ||
| MATL_INTERORG_TRANSFER_CODE | NUMBER | Yes | Material inter-organization transfer charge type | |
| INTERORG_TRNSFR_CHARGE_PERCENT | NUMBER | Inter-organization transfer charge percent | ||
| SOURCE_ORGANIZATION_ID | NUMBER | Organization to source items from | ||
| SOURCE_SUBINVENTORY | VARCHAR2 | (10) | Subinventory to source items from | |
| SOURCE_TYPE | NUMBER | Inventory or supplier source type | ||
| ORG_MAX_WEIGHT | NUMBER | Maximum weight allowed | ||
| ORG_MAX_WEIGHT_UOM_CODE | VARCHAR2 | (3) | UOM Code for Maximum weight allowed | |
| ORG_MAX_VOLUME | NUMBER | Maximum volume allowed | ||
| ORG_MAX_VOLUME_UOM_CODE | VARCHAR2 | (3) | UOM Code for Maximum volume allowed | |
| SERIAL_NUMBER_TYPE | NUMBER | Serial number uniqueness control | ||
| AUTO_SERIAL_ALPHA_PREFIX | VARCHAR2 | (30) | Organization-level serial number prefix | |
| START_AUTO_SERIAL_NUMBER | VARCHAR2 | (30) | Organization-level starting serial number | |
| AUTO_LOT_ALPHA_PREFIX | VARCHAR2 | (30) | Organization-level prefix for lot numbers | |
| LOT_NUMBER_UNIQUENESS | NUMBER | Yes | Lot number uniqueness control | |
| LOT_NUMBER_GENERATION | NUMBER | Yes | Lot number generation control | |
| LOT_NUMBER_ZERO_PADDING | NUMBER | Lot number padding control | ||
| LOT_NUMBER_LENGTH | NUMBER | Total lot number length | ||
| STARTING_REVISION | VARCHAR2 | (3) | Yes | Default starting item revision |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| DEFAULT_DEMAND_CLASS | VARCHAR2 | (30) | Default demand class | |
| ENCUMBRANCE_REVERSAL_FLAG | NUMBER | Reverse encumbrance flag | ||
| MAINTAIN_FIFO_QTY_STACK_TYPE | NUMBER | Maintain FIFO quantity stack | ||
| INVOICE_PRICE_VAR_ACCOUNT | NUMBER | Invoice price variance account | ||
| AVERAGE_COST_VAR_ACCOUNT | NUMBER | Average cost variance account | ||
| SALES_ACCOUNT | NUMBER | Sales account | ||
| EXPENSE_ACCOUNT | NUMBER | Expense account | ||
| SERIAL_NUMBER_GENERATION | NUMBER | Yes | Serial number generation control | |
| REQUEST_ID | NUMBER | Standard Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
| PROGRAM_ID | NUMBER | Standard Who column | ||
| PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Global descriptive flexfield structure defining column | |
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| MAT_OVHD_COST_TYPE_ID | NUMBER | Cost type that holds material overhead costs for an average costing organization | ||
| PROJECT_REFERENCE_ENABLED | NUMBER | Project Reference enabled flag that indicates whether project references are allowed in the organization or not | ||
| PM_COST_COLLECTION_ENABLED | NUMBER | Project Manufacturing Cost Collection Enabled flag that indicates whether costs will be collected for project references within the organization or not | ||
| PROJECT_CONTROL_LEVEL | NUMBER | Project Control Level that specifies whether project references are being tracked at the project or task level | ||
| AVG_RATES_COST_TYPE_ID | NUMBER | Average Rate Cost Type Identifier is used under average costing for resources and overhead rates | ||
| TXN_APPROVAL_TIMEOUT_PERIOD | NUMBER | Transfer Order Timeout Perod | ||
| MO_SOURCE_REQUIRED | NUMBER | Flag indicating that a source location is required before a move order can be approved | ||
| MO_PICK_CONFIRM_REQUIRED | NUMBER | Flag indicating whether pick confirmation is required | ||
| MO_APPROVAL_TIMEOUT_ACTION | NUMBER | Action to perform when move order approval timeout period has expired | ||
| BORRPAY_MATL_VAR_ACCOUNT | NUMBER | Material valuation account | ||
| BORRPAY_MOH_VAR_ACCOUNT | NUMBER | Material overhead valuation account | ||
| BORRPAY_RES_VAR_ACCOUNT | NUMBER | Resource valuation account | ||
| BORRPAY_OSP_VAR_ACCOUNT | NUMBER | Outside processing valuation account | ||
| BORRPAY_OVH_VAR_ACCOUNT | NUMBER | Overhead valuation account | ||
| PROCESS_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Process Enabled inventory Organization |
| PROCESS_ORGN_CODE | VARCHAR2 | (4) | OPM Warehouse Organization Code Mapped to the Process Inventory Organization | |
| WSM_ENABLED_FLAG | VARCHAR2 | (1) | Yes | WIP Shopfloor Management Organization |
| DEFAULT_COST_GROUP_ID | NUMBER | Yes | Default Cost Group ID - used by WMS only | |
| LPN_PREFIX | VARCHAR2 | (10) | LPN Prefix - used by WMS only | |
| LPN_SUFFIX | VARCHAR2 | (10) | LPN Suffix - used by WMS only | |
| LPN_STARTING_NUMBER | NUMBER | LPN Starting Number - used by WMS only | ||
| WMS_ENABLED_FLAG | VARCHAR2 | (1) | Yes | WMS (Warehouse Management System) Organization |
| PREGEN_PUTAWAY_TASKS_FLAG | NUMBER | used by WMS only | ||
| REGENERATION_INTERVAL | NUMBER | used by WMS only | ||
| TIMEZONE_ID | NUMBER | Identifier for Timezone | ||
| MAX_PICKS_BATCH | NUMBER | |||
| DEFAULT_WMS_PICKING_RULE_ID | NUMBER | Default picking rule for this organization - used by WMS only | ||
| DEFAULT_PUT_AWAY_RULE_ID | NUMBER | Default put away rule - used by WMS only | ||
| DEFAULT_TASK_ASSIGN_RULE_ID | NUMBER | |||
| DEFAULT_LABEL_COMP_RULE_ID | NUMBER | |||
| DEFAULT_CARTON_RULE_ID | NUMBER | Default cartonization rule for this organization - used by WMS only | ||
| DEFAULT_CYC_COUNT_HEADER_ID | NUMBER | Default cycle count header for this organization - used by WMS only | ||
| CROSSDOCK_FLAG | NUMBER | Flag indicates whether crossdocking occurs by default for this organization - used by WMS only | ||
| CARTONIZATION_FLAG | NUMBER | Flag indicates whether cartonization occurs by default in this organization - used for WMS only | ||
| COST_CUTOFF_DATE | DATE | Cost Cutoff Date | ||
| ENABLE_COSTING_BY_CATEGORY | VARCHAR2 | (1) | If costing is enabled by Category | |
| COST_GROUP_ACCOUNTING | NUMBER | Accounting for cost group | ||
| ALLOCATE_SERIAL_FLAG | VARCHAR2 | (1) | Indicates if allocation will happen at serial level for serial controlled items. | |
| DEFAULT_PICK_TASK_TYPE_ID | NUMBER | Default Pick Task type identifier | ||
| DEFAULT_CC_TASK_TYPE_ID | NUMBER | Default cycle count task type identifier | ||
| DEFAULT_PUTAWAY_TASK_TYPE_ID | NUMBER | Default Putaway task type identifier | ||
| DEFAULT_REPL_TASK_TYPE_ID | NUMBER | Default task type identofier for Replenishment | ||
| EAM_ENABLED_FLAG | VARCHAR2 | (1) | Organization is EAM enabled | |
| MAINT_ORGANIZATION_ID | NUMBER | Maintenance Organization Identifier | ||
| PRIORITIZE_WIP_JOBS | NUMBER | Purpose of prioritizing the WIP jobs. 1 = YES = Checked, 2 = NO = Unchecked | ||
| DEFAULT_CROSSDOCK_SUBINVENTORY | VARCHAR2 | (10) | Default subinventory for crossdocking purpose in an organization. | |
| SKIP_TASK_WAITING_MINUTES | NUMBER | Waiting time (unit - minutes) for the task which has been skipped by the user for any reason. The task becomes redispatchable after this time period expires. | ||
| QA_SKIPPING_INSP_FLAG | VARCHAR2 | (1) | Yes | Oracle Quality skipping inspection flag |
| DEFAULT_CROSSDOCK_LOCATOR_ID | NUMBER | Identifier for the Key_flex_field: Default_Crossdock_Locator, which acts as a default crossdock for the subinventory. | ||
| DEFAULT_MOXFER_TASK_TYPE_ID | NUMBER | Default task type identofier for MO Transfer | ||
| DEFAULT_MOISSUE_TASK_TYPE_ID | NUMBER | Default task type identofier for MO Issue | ||
| DEFAULT_MATL_OVHD_COST_ID | NUMBER | Default Material Overhead Sub-element | ||
| DISTRIBUTED_ORGANIZATION_FLAG | VARCHAR2 | (1) | Distributed Organization Flag | |
| CARRIER_MANIFESTING_FLAG | VARCHAR2 | (1) | Carrier Manifesting Flag | |
| DISTRIBUTION_ACCOUNT_ID | NUMBER | Distribution Account | ||
| DIRECT_SHIPPING_ALLOWED | VARCHAR2 | (1) | Direct Shipping Allowed | |
| DEFAULT_PICK_OP_PLAN_ID | NUMBER | Default operation plan ID for picking | ||
| MAX_CLUSTERS_ALLOWED | NUMBER | Max Clusters Allowed | ||
| CONSIGNED_FLAG | VARCHAR2 | (1) | Indicate whether Consigned/VMI Stock was ever received | |
| CARTONIZE_SALES_ORDERS | VARCHAR2 | (1) | Enable Cartonization for Sales Orders | |
| CARTONIZE_MANUFACTURING | VARCHAR2 | (1) | Enable Cartonization for WIP Jobs | |
| DEFER_LOGICAL_TRANSACTIONS | NUMBER | Defer Transaction Identifier | ||
| WIP_OVERPICK_ENABLED | VARCHAR2 | (1) | Overpick quantities for WIP | |
| OVPK_TRANSFER_ORDERS_ENABLED | VARCHAR2 | (1) | Overpick quantities for Replenishment and Requisition Move Orders | |
| TOTAL_LPN_LENGTH | NUMBER | Total Legnth of License Plate Number | ||
| UCC_128_SUFFIX_FLAG | VARCHAR2 | (1) | Indicate Suffix generation using modulo-10 is used when enable | |
| WCS_ENABLED | VARCHAR2 | (1) | Warehouse Control System Enabled | |
| ALLOW_DIFFERENT_STATUS | NUMBER | Indicates whether a transfer / receipt transaction is allowed where the default or lot status differs from the destination lot status. | ||
| CHILD_LOT_ALPHA_PREFIX | VARCHAR2 | (30) | Alphanumeric prefix for child lot number. Used where Generation is Parent + Child | |
| CHILD_LOT_NUMBER_LENGTH | NUMBER | Total length of the child lot number (including the prefix) | ||
| CHILD_LOT_VALIDATION_FLAG | VARCHAR2 | (1) | Indicates whether or not manually entered child lot numbers should be validated against the naming format | |
| CHILD_LOT_ZERO_PADDING_FLAG | VARCHAR2 | (1) | Indicates whether the child lot name should be padded with zeros (up to the total length) | |
| COPY_LOT_ATTRIBUTE_FLAG | VARCHAR2 | (1) | Indicates whether lot attributes for the child should be copied from the parent or the item master | |
| CREATE_LOT_UOM_CONVERSION | NUMBER | Indicates whether or not lot specific conversions should be created at receipt | ||
| GENEALOGY_FORMULA_SECURITY | VARCHAR2 | (1) | Genealogy formula security indicator. | |
| PARENT_CHILD_GENERATION_FLAG | VARCHAR2 | (1) | Indicates the sequence used for child lot name generation and the format used. Valid values are Parent and Parent + Child. | |
| RULES_OVERRIDE_LOT_RESERVATION | VARCHAR2 | (1) | Indicates whether a fully detailed reservation can take priority over allocation. | |
| AUTO_DEL_ALLOC_FLAG | VARCHAR2 | (1) | Delete Allocations after Source is cancelled | |
| RFID_VERIF_PCNT_THRESHOLD | NUMBER | RFID Verfication Percentage Threshold | ||
| YARD_MANAGEMENT_ENABLED_FLAG | VARCHAR2 | (1) | Yard Management Enabled Flag | |
| TRADING_PARTNER_ORG_FLAG | VARCHAR2 | (1) | Indicates if the organization is a trading partner to any original equipment manufacturer. | |
| DEFERRED_COGS_ACCOUNT | NUMBER | Deferred COGS account which holds the costs till revenue is recognized. | ||
| DEFAULT_CROSSDOCK_CRITERIA_ID | NUMBER | Used to determine the demand for opportunistic crossdocking. | ||
| ENFORCE_LOCATOR_ALIS_UNQ_FLAG | VARCHAR2 | (1) | Indicates whether the Locators alias should be unique or not in an organization. | |
| EPC_GENERATION_ENABLED_FLAG | VARCHAR2 | (1) | Flag to enable EPC for outbound documents. | |
| COMPANY_PREFIX | VARCHAR2 | (30) | Identifies the company prefix for EPC generation, used in 96-bit tags. | |
| COMPANY_PREFIX_INDEX | VARCHAR2 | (30) | Identifies the company prefix for EPC generation, used in 64-bit tags. | |
| COMMERCIAL_GOVT_ENTITY_NUMBER | VARCHAR2 | (30) | Identifies the company CAGE# for RFID tag generation for DoD specification | |
| LABOR_MANAGEMENT_ENABLED_FLAG | VARCHAR2 | (1) | Indicates whether the Labor Management processing has to be done or not. | |
| DEFAULT_STATUS_ID | NUMBER | Default material status identifier | ||
| LCM_ENABLED_FLAG | VARCHAR2 | (1) | Flag to determine if organization if LCM enabled or not | |
| LCM_VAR_ACCOUNT | NUMBER | LCM Variance account | ||
| OPSM_ENABLED_FLAG | VARCHAR2 | (1) | Flag to determine if organization if OPSM enabled or not | |
| ALLOCATE_LOT_FLAG | VARCHAR2 | (1) | Indicates if allocation will happen at lot level for lot | |
| CAT_WT_ACCOUNT | NUMBER | Catch Weight Account |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ORGANIZATION_CODE
, MASTER_ORGANIZATION_ID
, PRIMARY_COST_METHOD
, COST_ORGANIZATION_ID
, DEFAULT_MATERIAL_COST_ID
, CALENDAR_EXCEPTION_SET_ID
, CALENDAR_CODE
, GENERAL_LEDGER_UPDATE_CODE
, DEFAULT_ATP_RULE_ID
, DEFAULT_PICKING_RULE_ID
, DEFAULT_LOCATOR_ORDER_VALUE
, DEFAULT_SUBINV_ORDER_VALUE
, NEGATIVE_INV_RECEIPT_CODE
, STOCK_LOCATOR_CONTROL_CODE
, MATERIAL_ACCOUNT
, MATERIAL_OVERHEAD_ACCOUNT
, MATL_OVHD_ABSORPTION_ACCT
, RESOURCE_ACCOUNT
, PURCHASE_PRICE_VAR_ACCOUNT
, AP_ACCRUAL_ACCOUNT
, OVERHEAD_ACCOUNT
, OUTSIDE_PROCESSING_ACCOUNT
, INTRANSIT_INV_ACCOUNT
, INTERORG_RECEIVABLES_ACCOUNT
, INTERORG_PRICE_VAR_ACCOUNT
, INTERORG_PAYABLES_ACCOUNT
, COST_OF_SALES_ACCOUNT
, ENCUMBRANCE_ACCOUNT
, PROJECT_COST_ACCOUNT
, INTERORG_TRANSFER_CR_ACCOUNT
, MATL_INTERORG_TRANSFER_CODE
, INTERORG_TRNSFR_CHARGE_PERCENT
, SOURCE_ORGANIZATION_ID
, SOURCE_SUBINVENTORY
, SOURCE_TYPE
, ORG_MAX_WEIGHT
, ORG_MAX_WEIGHT_UOM_CODE
, ORG_MAX_VOLUME
, ORG_MAX_VOLUME_UOM_CODE
, SERIAL_NUMBER_TYPE
, AUTO_SERIAL_ALPHA_PREFIX
, START_AUTO_SERIAL_NUMBER
, AUTO_LOT_ALPHA_PREFIX
, LOT_NUMBER_UNIQUENESS
, LOT_NUMBER_GENERATION
, LOT_NUMBER_ZERO_PADDING
, LOT_NUMBER_LENGTH
, STARTING_REVISION
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, DEFAULT_DEMAND_CLASS
, ENCUMBRANCE_REVERSAL_FLAG
, MAINTAIN_FIFO_QTY_STACK_TYPE
, INVOICE_PRICE_VAR_ACCOUNT
, AVERAGE_COST_VAR_ACCOUNT
, SALES_ACCOUNT
, EXPENSE_ACCOUNT
, SERIAL_NUMBER_GENERATION
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, MAT_OVHD_COST_TYPE_ID
, PROJECT_REFERENCE_ENABLED
, PM_COST_COLLECTION_ENABLED
, PROJECT_CONTROL_LEVEL
, AVG_RATES_COST_TYPE_ID
, TXN_APPROVAL_TIMEOUT_PERIOD
, MO_SOURCE_REQUIRED
, MO_PICK_CONFIRM_REQUIRED
, MO_APPROVAL_TIMEOUT_ACTION
, BORRPAY_MATL_VAR_ACCOUNT
, BORRPAY_MOH_VAR_ACCOUNT
, BORRPAY_RES_VAR_ACCOUNT
, BORRPAY_OSP_VAR_ACCOUNT
, BORRPAY_OVH_VAR_ACCOUNT
, PROCESS_ENABLED_FLAG
, PROCESS_ORGN_CODE
, WSM_ENABLED_FLAG
, DEFAULT_COST_GROUP_ID
, LPN_PREFIX
, LPN_SUFFIX
, LPN_STARTING_NUMBER
, WMS_ENABLED_FLAG
, PREGEN_PUTAWAY_TASKS_FLAG
, REGENERATION_INTERVAL
, TIMEZONE_ID
, MAX_PICKS_BATCH
, DEFAULT_WMS_PICKING_RULE_ID
, DEFAULT_PUT_AWAY_RULE_ID
, DEFAULT_TASK_ASSIGN_RULE_ID
, DEFAULT_LABEL_COMP_RULE_ID
, DEFAULT_CARTON_RULE_ID
, DEFAULT_CYC_COUNT_HEADER_ID
, CROSSDOCK_FLAG
, CARTONIZATION_FLAG
, COST_CUTOFF_DATE
, ENABLE_COSTING_BY_CATEGORY
, COST_GROUP_ACCOUNTING
, ALLOCATE_SERIAL_FLAG
, DEFAULT_PICK_TASK_TYPE_ID
, DEFAULT_CC_TASK_TYPE_ID
, DEFAULT_PUTAWAY_TASK_TYPE_ID
, DEFAULT_REPL_TASK_TYPE_ID
, EAM_ENABLED_FLAG
, MAINT_ORGANIZATION_ID
, PRIORITIZE_WIP_JOBS
, DEFAULT_CROSSDOCK_SUBINVENTORY
, SKIP_TASK_WAITING_MINUTES
, QA_SKIPPING_INSP_FLAG
, DEFAULT_CROSSDOCK_LOCATOR_ID
, DEFAULT_MOXFER_TASK_TYPE_ID
, DEFAULT_MOISSUE_TASK_TYPE_ID
, DEFAULT_MATL_OVHD_COST_ID
, DISTRIBUTED_ORGANIZATION_FLAG
, CARRIER_MANIFESTING_FLAG
, DISTRIBUTION_ACCOUNT_ID
, DIRECT_SHIPPING_ALLOWED
, DEFAULT_PICK_OP_PLAN_ID
, MAX_CLUSTERS_ALLOWED
, CONSIGNED_FLAG
, CARTONIZE_SALES_ORDERS
, CARTONIZE_MANUFACTURING
, DEFER_LOGICAL_TRANSACTIONS
, WIP_OVERPICK_ENABLED
, OVPK_TRANSFER_ORDERS_ENABLED
, TOTAL_LPN_LENGTH
, UCC_128_SUFFIX_FLAG
, WCS_ENABLED
, ALLOW_DIFFERENT_STATUS
, CHILD_LOT_ALPHA_PREFIX
, CHILD_LOT_NUMBER_LENGTH
, CHILD_LOT_VALIDATION_FLAG
, CHILD_LOT_ZERO_PADDING_FLAG
, COPY_LOT_ATTRIBUTE_FLAG
, CREATE_LOT_UOM_CONVERSION
, GENEALOGY_FORMULA_SECURITY
, PARENT_CHILD_GENERATION_FLAG
, RULES_OVERRIDE_LOT_RESERVATION
, AUTO_DEL_ALLOC_FLAG
, RFID_VERIF_PCNT_THRESHOLD
, YARD_MANAGEMENT_ENABLED_FLAG
, TRADING_PARTNER_ORG_FLAG
, DEFERRED_COGS_ACCOUNT
, DEFAULT_CROSSDOCK_CRITERIA_ID
, ENFORCE_LOCATOR_ALIS_UNQ_FLAG
, EPC_GENERATION_ENABLED_FLAG
, COMPANY_PREFIX
, COMPANY_PREFIX_INDEX
, COMMERCIAL_GOVT_ENTITY_NUMBER
, LABOR_MANAGEMENT_ENABLED_FLAG
, DEFAULT_STATUS_ID
, LCM_ENABLED_FLAG
, LCM_VAR_ACCOUNT
, OPSM_ENABLED_FLAG
, ALLOCATE_LOT_FLAG
, CAT_WT_ACCOUNT
FROM INV.MTL_PARAMETERS;
INV.MTL_PARAMETERS does not reference any database object
INV.MTL_PARAMETERS is referenced by following:
APPS
OE_ITEMS_MV
INV
MTL_PARAMETERS#
|
|
|
|