DBA Data[Home] [Help] [Dependency Information]


VIEW: INV.MTL_PARAMETERS#

Object Details
Object Name: MTL_PARAMETERS#
Object Type: VIEW
Owner: INV
Subobject Name:
Status: VALID

[View Source]

Columns
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

Query Text

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#;

Dependencies

[top of page]

INV.MTL_PARAMETERS# references the following:

SchemaINV
TableMTL_PARAMETERS
INV.MTL_PARAMETERS# is referenced by following:

SchemaAPPS
SynonymMTL_PARAMETERS