[Home] [Help]
[Dependency Information]
Object Name: | MTL_PARAMETERS |
---|---|
Object Type: | TABLE |
Owner: | INV |
FND Design Data: | ![]() |
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: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MTL_PARAMETERS_U1 | NORMAL | UNIQUE |
![]() |
![]() |
MTL_PARAMETERS_N1 | NORMAL | NONUNIQUE |
![]() |
![]() |
MTL_PARAMETERS_N2 | NORMAL | NONUNIQUE |
![]() |
![]() |
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:
|
|
|