[Home] [Help] [Dependency Information]
Object Name: | MTL_PARAMETERS_ALL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | INV.MTL_PARAMETERS_ALL_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
ORGANIZATION_CODE | VARCHAR2 | (3) | ||
MASTER_ORGANIZATION_ID | NUMBER | Yes | ||
PRIMARY_COST_METHOD | NUMBER | Yes | ||
COST_ORGANIZATION_ID | NUMBER | Yes | ||
DEFAULT_MATERIAL_COST_ID | NUMBER | |||
CALENDAR_EXCEPTION_SET_ID | NUMBER | |||
CALENDAR_CODE | VARCHAR2 | (10) | ||
GENERAL_LEDGER_UPDATE_CODE | NUMBER | Yes | ||
DEFAULT_ATP_RULE_ID | NUMBER | |||
DEFAULT_PICKING_RULE_ID | NUMBER | |||
DEFAULT_LOCATOR_ORDER_VALUE | NUMBER | |||
DEFAULT_SUBINV_ORDER_VALUE | NUMBER | |||
NEGATIVE_INV_RECEIPT_CODE | NUMBER | Yes | ||
STOCK_LOCATOR_CONTROL_CODE | NUMBER | Yes | ||
MATERIAL_ACCOUNT | NUMBER | |||
MATERIAL_OVERHEAD_ACCOUNT | NUMBER | |||
MATL_OVHD_ABSORPTION_ACCT | NUMBER | |||
RESOURCE_ACCOUNT | NUMBER | |||
PURCHASE_PRICE_VAR_ACCOUNT | NUMBER | |||
AP_ACCRUAL_ACCOUNT | NUMBER | |||
OVERHEAD_ACCOUNT | NUMBER | |||
OUTSIDE_PROCESSING_ACCOUNT | NUMBER | |||
INTRANSIT_INV_ACCOUNT | NUMBER | |||
INTERORG_RECEIVABLES_ACCOUNT | NUMBER | |||
INTERORG_PRICE_VAR_ACCOUNT | NUMBER | |||
INTERORG_PAYABLES_ACCOUNT | NUMBER | |||
COST_OF_SALES_ACCOUNT | NUMBER | |||
ENCUMBRANCE_ACCOUNT | NUMBER | |||
INTERORG_TRANSFER_CR_ACCOUNT | NUMBER | |||
MATL_INTERORG_TRANSFER_CODE | NUMBER | Yes | ||
INTERORG_TRNSFR_CHARGE_PERCENT | NUMBER | |||
SOURCE_ORGANIZATION_ID | NUMBER | |||
SOURCE_SUBINVENTORY | VARCHAR2 | (10) | ||
SOURCE_TYPE | NUMBER | |||
SERIAL_NUMBER_TYPE | NUMBER | |||
AUTO_SERIAL_ALPHA_PREFIX | VARCHAR2 | (30) | ||
START_AUTO_SERIAL_NUMBER | VARCHAR2 | (30) | ||
AUTO_LOT_ALPHA_PREFIX | VARCHAR2 | (30) | ||
LOT_NUMBER_UNIQUENESS | NUMBER | Yes | ||
LOT_NUMBER_GENERATION | NUMBER | Yes | ||
LOT_NUMBER_ZERO_PADDING | NUMBER | |||
LOT_NUMBER_LENGTH | NUMBER | |||
STARTING_REVISION | VARCHAR2 | (3) | Yes | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
DEFAULT_DEMAND_CLASS | VARCHAR2 | (30) | ||
ENCUMBRANCE_REVERSAL_FLAG | NUMBER | |||
MAINTAIN_FIFO_QTY_STACK_TYPE | NUMBER | |||
INVOICE_PRICE_VAR_ACCOUNT | NUMBER | |||
AVERAGE_COST_VAR_ACCOUNT | NUMBER | |||
SALES_ACCOUNT | NUMBER | |||
EXPENSE_ACCOUNT | NUMBER | |||
SERIAL_NUMBER_GENERATION | NUMBER | Yes | ||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | ||
MAT_OVHD_COST_TYPE_ID | NUMBER | |||
PROJECT_REFERENCE_ENABLED | NUMBER | |||
PM_COST_COLLECTION_ENABLED | NUMBER | |||
PROJECT_CONTROL_LEVEL | NUMBER | |||
AVG_RATES_COST_TYPE_ID | NUMBER | |||
ORG_MAX_WEIGHT | NUMBER | |||
ORG_MAX_WEIGHT_UOM_CODE | VARCHAR2 | (3) | ||
ORG_MAX_VOLUME | NUMBER | |||
ORG_MAX_VOLUME_UOM_CODE | VARCHAR2 | (3) | ||
MO_APPROVAL_TIMEOUT_ACTION | NUMBER | |||
MO_SOURCE_REQUIRED | NUMBER | |||
MO_PICK_CONFIRM_REQUIRED | NUMBER | |||
PROJECT_COST_ACCOUNT | NUMBER | |||
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 | |
LPN_PREFIX | VARCHAR2 | (10) | ||
LPN_SUFFIX | VARCHAR2 | (10) | ||
LPN_STARTING_NUMBER | NUMBER | |||
WMS_ENABLED_FLAG | VARCHAR2 | (1) | Yes | WMS(Warehouse Management System) Organization |
PREGEN_PUTAWAY_TASKS_FLAG | NUMBER | |||
REGENERATION_INTERVAL | NUMBER | |||
TIMEZONE_ID | NUMBER | |||
DEFAULT_WMS_PICKING_RULE_ID | NUMBER | |||
DEFAULT_PUT_AWAY_RULE_ID | NUMBER | |||
DEFAULT_CARTON_RULE_ID | NUMBER | |||
DEFAULT_CYC_COUNT_HEADER_ID | NUMBER | |||
DISTRIBUTION_ACCOUNT_ID | NUMBER | Distribution Account ID | ||
TOTAL_LPN_LENGTH | NUMBER | Total Length of License Plate Number | ||
UCC_128_SUFFIX_FLAG | VARCHAR2 | (1) | Indicate Suffix generation using modulo-10 is used when enable | |
DEFER_LOGICAL_TRANSACTIONS | NUMBER | Flag to check if the creation of logical transactions should be defer | ||
ENFORCE_LOCATOR_ALIS_UNQ_FLAG | VARCHAR2 | (1) |
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
, INTERORG_TRANSFER_CR_ACCOUNT
, MATL_INTERORG_TRANSFER_CODE
, INTERORG_TRNSFR_CHARGE_PERCENT
, SOURCE_ORGANIZATION_ID
, SOURCE_SUBINVENTORY
, SOURCE_TYPE
, 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
, ORG_MAX_WEIGHT
, ORG_MAX_WEIGHT_UOM_CODE
, ORG_MAX_VOLUME
, ORG_MAX_VOLUME_UOM_CODE
, MO_APPROVAL_TIMEOUT_ACTION
, MO_SOURCE_REQUIRED
, MO_PICK_CONFIRM_REQUIRED
, PROJECT_COST_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
, DEFAULT_WMS_PICKING_RULE_ID
, DEFAULT_PUT_AWAY_RULE_ID
, DEFAULT_CARTON_RULE_ID
, DEFAULT_CYC_COUNT_HEADER_ID
, DISTRIBUTION_ACCOUNT_ID
, TOTAL_LPN_LENGTH
, UCC_128_SUFFIX_FLAG
, DEFER_LOGICAL_TRANSACTIONS
, ENFORCE_LOCATOR_ALIS_UNQ_FLAG
FROM APPS.MTL_PARAMETERS_ALL_V;
APPS.MTL_PARAMETERS_ALL_V is not referenced by any database object
|
|
|