[Home] [Help]
[Dependency Information]
Object Name: | MTL_PARAMETERS# |
---|---|
Object Type: | VIEW |
Owner: | INV |
Subobject Name: | |
Status: | VALID |
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 | |||
PROJECT_COST_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 | |||
ORG_MAX_WEIGHT | NUMBER | |||
ORG_MAX_WEIGHT_UOM_CODE | VARCHAR2 | (3) | ||
ORG_MAX_VOLUME | NUMBER | |||
ORG_MAX_VOLUME_UOM_CODE | VARCHAR2 | (3) | ||
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) | ||
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 | |||
TXN_APPROVAL_TIMEOUT_PERIOD | NUMBER | |||
MO_SOURCE_REQUIRED | NUMBER | |||
MO_PICK_CONFIRM_REQUIRED | NUMBER | |||
MO_APPROVAL_TIMEOUT_ACTION | NUMBER | |||
BORRPAY_MATL_VAR_ACCOUNT | NUMBER | |||
BORRPAY_MOH_VAR_ACCOUNT | NUMBER | |||
BORRPAY_RES_VAR_ACCOUNT | NUMBER | |||
BORRPAY_OSP_VAR_ACCOUNT | NUMBER | |||
BORRPAY_OVH_VAR_ACCOUNT | NUMBER | |||
PROCESS_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
PROCESS_ORGN_CODE | VARCHAR2 | (4) | ||
WSM_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
DEFAULT_COST_GROUP_ID | NUMBER | Yes | ||
LPN_PREFIX | VARCHAR2 | (10) | ||
LPN_SUFFIX | VARCHAR2 | (10) | ||
LPN_STARTING_NUMBER | NUMBER | |||
WMS_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
PREGEN_PUTAWAY_TASKS_FLAG | NUMBER | |||
REGENERATION_INTERVAL | NUMBER | |||
TIMEZONE_ID | NUMBER | |||
MAX_PICKS_BATCH | NUMBER | |||
DEFAULT_WMS_PICKING_RULE_ID | NUMBER | |||
DEFAULT_PUT_AWAY_RULE_ID | NUMBER | |||
DEFAULT_TASK_ASSIGN_RULE_ID | NUMBER | |||
DEFAULT_LABEL_COMP_RULE_ID | NUMBER | |||
DEFAULT_CARTON_RULE_ID | NUMBER | |||
DEFAULT_CYC_COUNT_HEADER_ID | NUMBER | |||
CROSSDOCK_FLAG | NUMBER | |||
CARTONIZATION_FLAG | NUMBER | |||
COST_CUTOFF_DATE | DATE | |||
ENABLE_COSTING_BY_CATEGORY | VARCHAR2 | (1) | ||
COST_GROUP_ACCOUNTING | NUMBER | |||
ALLOCATE_SERIAL_FLAG | VARCHAR2 | (1) | ||
DEFAULT_PICK_TASK_TYPE_ID | NUMBER | |||
DEFAULT_CC_TASK_TYPE_ID | NUMBER | |||
DEFAULT_PUTAWAY_TASK_TYPE_ID | NUMBER | |||
DEFAULT_REPL_TASK_TYPE_ID | NUMBER | |||
EAM_ENABLED_FLAG | VARCHAR2 | (1) | ||
MAINT_ORGANIZATION_ID | NUMBER | |||
PRIORITIZE_WIP_JOBS | NUMBER | |||
DEFAULT_CROSSDOCK_SUBINVENTORY | VARCHAR2 | (10) | ||
SKIP_TASK_WAITING_MINUTES | NUMBER | |||
QA_SKIPPING_INSP_FLAG | VARCHAR2 | (1) | Yes | |
DEFAULT_CROSSDOCK_LOCATOR_ID | NUMBER | |||
DEFAULT_MOXFER_TASK_TYPE_ID | NUMBER | |||
DEFAULT_MOISSUE_TASK_TYPE_ID | NUMBER | |||
DEFAULT_MATL_OVHD_COST_ID | NUMBER | |||
DISTRIBUTED_ORGANIZATION_FLAG | VARCHAR2 | (1) | ||
CARRIER_MANIFESTING_FLAG | VARCHAR2 | (1) | ||
DISTRIBUTION_ACCOUNT_ID | NUMBER | |||
DIRECT_SHIPPING_ALLOWED | VARCHAR2 | (1) | ||
DEFAULT_PICK_OP_PLAN_ID | NUMBER | |||
MAX_CLUSTERS_ALLOWED | NUMBER | |||
CONSIGNED_FLAG | VARCHAR2 | (1) | ||
CARTONIZE_SALES_ORDERS | VARCHAR2 | (1) | ||
CARTONIZE_MANUFACTURING | VARCHAR2 | (1) | ||
DEFER_LOGICAL_TRANSACTIONS | NUMBER | |||
WIP_OVERPICK_ENABLED | VARCHAR2 | (1) | ||
OVPK_TRANSFER_ORDERS_ENABLED | VARCHAR2 | (1) | ||
TOTAL_LPN_LENGTH | NUMBER | |||
UCC_128_SUFFIX_FLAG | VARCHAR2 | (1) | ||
WCS_ENABLED | VARCHAR2 | (1) | ||
ALLOW_DIFFERENT_STATUS | NUMBER | |||
CHILD_LOT_ALPHA_PREFIX | VARCHAR2 | (30) | ||
CHILD_LOT_NUMBER_LENGTH | NUMBER | |||
CHILD_LOT_VALIDATION_FLAG | VARCHAR2 | (1) | ||
CHILD_LOT_ZERO_PADDING_FLAG | VARCHAR2 | (1) | ||
COPY_LOT_ATTRIBUTE_FLAG | VARCHAR2 | (1) | ||
CREATE_LOT_UOM_CONVERSION | NUMBER | |||
GENEALOGY_FORMULA_SECURITY | VARCHAR2 | (1) | ||
PARENT_CHILD_GENERATION_FLAG | VARCHAR2 | (1) | ||
RULES_OVERRIDE_LOT_RESERVATION | VARCHAR2 | (1) | ||
AUTO_DEL_ALLOC_FLAG | VARCHAR2 | (1) | ||
RFID_VERIF_PCNT_THRESHOLD | NUMBER | |||
YARD_MANAGEMENT_ENABLED_FLAG | VARCHAR2 | (1) | ||
TRADING_PARTNER_ORG_FLAG | VARCHAR2 | (1) | ||
DEFERRED_COGS_ACCOUNT | NUMBER | |||
DEFAULT_CROSSDOCK_CRITERIA_ID | NUMBER | |||
ENFORCE_LOCATOR_ALIS_UNQ_FLAG | VARCHAR2 | (1) | ||
EPC_GENERATION_ENABLED_FLAG | VARCHAR2 | (1) | ||
COMPANY_PREFIX | VARCHAR2 | (30) | ||
COMPANY_PREFIX_INDEX | VARCHAR2 | (30) | ||
COMMERCIAL_GOVT_ENTITY_NUMBER | VARCHAR2 | (30) | ||
LABOR_MANAGEMENT_ENABLED_FLAG | VARCHAR2 | (1) | ||
DEFAULT_STATUS_ID | NUMBER | |||
LCM_ENABLED_FLAG | VARCHAR2 | (1) | ||
LCM_VAR_ACCOUNT | NUMBER | |||
OPSM_ENABLED_FLAG | VARCHAR2 | (1) | ||
ALLOCATE_LOT_FLAG | VARCHAR2 | (1) | ||
CAT_WT_ACCOUNT | NUMBER |
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#;
|
|
|