eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: INV.MTL_PARAMETERS#

Source

View Text - Preformatted


select ORGANIZATION_ID ORGANIZATION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ORGANIZATION_CODE ORGANIZATION_CODE, MASTER_ORGANIZATION_ID MASTER_ORGANIZATION_ID, PRIMARY_COST_METHOD PRIMARY_COST_METHOD, COST_ORGANIZATION_ID COST_ORGANIZATION_ID, DEFAULT_MATERIAL_COST_ID DEFAULT_MATERIAL_COST_ID, CALENDAR_EXCEPTION_SET_ID CALENDAR_EXCEPTION_SET_ID, CALENDAR_CODE CALENDAR_CODE, GENERAL_LEDGER_UPDATE_CODE GENERAL_LEDGER_UPDATE_CODE, DEFAULT_ATP_RULE_ID DEFAULT_ATP_RULE_ID, DEFAULT_PICKING_RULE_ID DEFAULT_PICKING_RULE_ID, DEFAULT_LOCATOR_ORDER_VALUE DEFAULT_LOCATOR_ORDER_VALUE, DEFAULT_SUBINV_ORDER_VALUE DEFAULT_SUBINV_ORDER_VALUE, NEGATIVE_INV_RECEIPT_CODE NEGATIVE_INV_RECEIPT_CODE, STOCK_LOCATOR_CONTROL_CODE STOCK_LOCATOR_CONTROL_CODE, MATERIAL_ACCOUNT MATERIAL_ACCOUNT, MATERIAL_OVERHEAD_ACCOUNT MATERIAL_OVERHEAD_ACCOUNT, MATL_OVHD_ABSORPTION_ACCT MATL_OVHD_ABSORPTION_ACCT, RESOURCE_ACCOUNT RESOURCE_ACCOUNT, PURCHASE_PRICE_VAR_ACCOUNT PURCHASE_PRICE_VAR_ACCOUNT, AP_ACCRUAL_ACCOUNT AP_ACCRUAL_ACCOUNT, OVERHEAD_ACCOUNT OVERHEAD_ACCOUNT, OUTSIDE_PROCESSING_ACCOUNT OUTSIDE_PROCESSING_ACCOUNT, INTRANSIT_INV_ACCOUNT INTRANSIT_INV_ACCOUNT, INTERORG_RECEIVABLES_ACCOUNT INTERORG_RECEIVABLES_ACCOUNT, INTERORG_PRICE_VAR_ACCOUNT INTERORG_PRICE_VAR_ACCOUNT, INTERORG_PAYABLES_ACCOUNT INTERORG_PAYABLES_ACCOUNT, COST_OF_SALES_ACCOUNT COST_OF_SALES_ACCOUNT, ENCUMBRANCE_ACCOUNT ENCUMBRANCE_ACCOUNT, PROJECT_COST_ACCOUNT PROJECT_COST_ACCOUNT, INTERORG_TRANSFER_CR_ACCOUNT INTERORG_TRANSFER_CR_ACCOUNT, MATL_INTERORG_TRANSFER_CODE MATL_INTERORG_TRANSFER_CODE, INTERORG_TRNSFR_CHARGE_PERCENT INTERORG_TRNSFR_CHARGE_PERCENT, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, SOURCE_SUBINVENTORY SOURCE_SUBINVENTORY, SOURCE_TYPE SOURCE_TYPE, ORG_MAX_WEIGHT ORG_MAX_WEIGHT, ORG_MAX_WEIGHT_UOM_CODE ORG_MAX_WEIGHT_UOM_CODE, ORG_MAX_VOLUME ORG_MAX_VOLUME, ORG_MAX_VOLUME_UOM_CODE ORG_MAX_VOLUME_UOM_CODE, SERIAL_NUMBER_TYPE SERIAL_NUMBER_TYPE, AUTO_SERIAL_ALPHA_PREFIX AUTO_SERIAL_ALPHA_PREFIX, START_AUTO_SERIAL_NUMBER START_AUTO_SERIAL_NUMBER, AUTO_LOT_ALPHA_PREFIX AUTO_LOT_ALPHA_PREFIX, LOT_NUMBER_UNIQUENESS LOT_NUMBER_UNIQUENESS, LOT_NUMBER_GENERATION LOT_NUMBER_GENERATION, LOT_NUMBER_ZERO_PADDING LOT_NUMBER_ZERO_PADDING, LOT_NUMBER_LENGTH LOT_NUMBER_LENGTH, STARTING_REVISION STARTING_REVISION, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, DEFAULT_DEMAND_CLASS DEFAULT_DEMAND_CLASS, ENCUMBRANCE_REVERSAL_FLAG ENCUMBRANCE_REVERSAL_FLAG, MAINTAIN_FIFO_QTY_STACK_TYPE MAINTAIN_FIFO_QTY_STACK_TYPE, INVOICE_PRICE_VAR_ACCOUNT INVOICE_PRICE_VAR_ACCOUNT, AVERAGE_COST_VAR_ACCOUNT AVERAGE_COST_VAR_ACCOUNT, SALES_ACCOUNT SALES_ACCOUNT, EXPENSE_ACCOUNT EXPENSE_ACCOUNT, SERIAL_NUMBER_GENERATION SERIAL_NUMBER_GENERATION, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, MAT_OVHD_COST_TYPE_ID MAT_OVHD_COST_TYPE_ID, PROJECT_REFERENCE_ENABLED PROJECT_REFERENCE_ENABLED, PM_COST_COLLECTION_ENABLED PM_COST_COLLECTION_ENABLED, PROJECT_CONTROL_LEVEL PROJECT_CONTROL_LEVEL, AVG_RATES_COST_TYPE_ID AVG_RATES_COST_TYPE_ID, TXN_APPROVAL_TIMEOUT_PERIOD TXN_APPROVAL_TIMEOUT_PERIOD, MO_SOURCE_REQUIRED MO_SOURCE_REQUIRED, MO_PICK_CONFIRM_REQUIRED MO_PICK_CONFIRM_REQUIRED, MO_APPROVAL_TIMEOUT_ACTION MO_APPROVAL_TIMEOUT_ACTION, BORRPAY_MATL_VAR_ACCOUNT BORRPAY_MATL_VAR_ACCOUNT, BORRPAY_MOH_VAR_ACCOUNT BORRPAY_MOH_VAR_ACCOUNT, BORRPAY_RES_VAR_ACCOUNT BORRPAY_RES_VAR_ACCOUNT, BORRPAY_OSP_VAR_ACCOUNT BORRPAY_OSP_VAR_ACCOUNT, BORRPAY_OVH_VAR_ACCOUNT BORRPAY_OVH_VAR_ACCOUNT, PROCESS_ENABLED_FLAG PROCESS_ENABLED_FLAG, PROCESS_ORGN_CODE PROCESS_ORGN_CODE, WSM_ENABLED_FLAG WSM_ENABLED_FLAG, DEFAULT_COST_GROUP_ID DEFAULT_COST_GROUP_ID, LPN_PREFIX LPN_PREFIX, LPN_SUFFIX LPN_SUFFIX, LPN_STARTING_NUMBER LPN_STARTING_NUMBER, WMS_ENABLED_FLAG WMS_ENABLED_FLAG, PREGEN_PUTAWAY_TASKS_FLAG PREGEN_PUTAWAY_TASKS_FLAG, REGENERATION_INTERVAL REGENERATION_INTERVAL, TIMEZONE_ID TIMEZONE_ID, MAX_PICKS_BATCH MAX_PICKS_BATCH, DEFAULT_WMS_PICKING_RULE_ID DEFAULT_WMS_PICKING_RULE_ID, DEFAULT_PUT_AWAY_RULE_ID DEFAULT_PUT_AWAY_RULE_ID, DEFAULT_TASK_ASSIGN_RULE_ID DEFAULT_TASK_ASSIGN_RULE_ID, DEFAULT_LABEL_COMP_RULE_ID DEFAULT_LABEL_COMP_RULE_ID, DEFAULT_CARTON_RULE_ID DEFAULT_CARTON_RULE_ID, DEFAULT_CYC_COUNT_HEADER_ID DEFAULT_CYC_COUNT_HEADER_ID, CROSSDOCK_FLAG CROSSDOCK_FLAG, CARTONIZATION_FLAG CARTONIZATION_FLAG, COST_CUTOFF_DATE COST_CUTOFF_DATE, ENABLE_COSTING_BY_CATEGORY ENABLE_COSTING_BY_CATEGORY, COST_GROUP_ACCOUNTING COST_GROUP_ACCOUNTING, ALLOCATE_SERIAL_FLAG ALLOCATE_SERIAL_FLAG, DEFAULT_PICK_TASK_TYPE_ID DEFAULT_PICK_TASK_TYPE_ID, DEFAULT_CC_TASK_TYPE_ID DEFAULT_CC_TASK_TYPE_ID, DEFAULT_PUTAWAY_TASK_TYPE_ID DEFAULT_PUTAWAY_TASK_TYPE_ID, DEFAULT_REPL_TASK_TYPE_ID DEFAULT_REPL_TASK_TYPE_ID, EAM_ENABLED_FLAG EAM_ENABLED_FLAG, MAINT_ORGANIZATION_ID MAINT_ORGANIZATION_ID, PRIORITIZE_WIP_JOBS PRIORITIZE_WIP_JOBS, DEFAULT_CROSSDOCK_SUBINVENTORY DEFAULT_CROSSDOCK_SUBINVENTORY, SKIP_TASK_WAITING_MINUTES SKIP_TASK_WAITING_MINUTES, QA_SKIPPING_INSP_FLAG QA_SKIPPING_INSP_FLAG, DEFAULT_CROSSDOCK_LOCATOR_ID DEFAULT_CROSSDOCK_LOCATOR_ID, DEFAULT_MOXFER_TASK_TYPE_ID DEFAULT_MOXFER_TASK_TYPE_ID, DEFAULT_MOISSUE_TASK_TYPE_ID DEFAULT_MOISSUE_TASK_TYPE_ID, DEFAULT_MATL_OVHD_COST_ID DEFAULT_MATL_OVHD_COST_ID, DISTRIBUTED_ORGANIZATION_FLAG DISTRIBUTED_ORGANIZATION_FLAG, CARRIER_MANIFESTING_FLAG CARRIER_MANIFESTING_FLAG, DISTRIBUTION_ACCOUNT_ID DISTRIBUTION_ACCOUNT_ID, DIRECT_SHIPPING_ALLOWED DIRECT_SHIPPING_ALLOWED, DEFAULT_PICK_OP_PLAN_ID DEFAULT_PICK_OP_PLAN_ID, MAX_CLUSTERS_ALLOWED MAX_CLUSTERS_ALLOWED, CONSIGNED_FLAG CONSIGNED_FLAG, CARTONIZE_SALES_ORDERS CARTONIZE_SALES_ORDERS, CARTONIZE_MANUFACTURING CARTONIZE_MANUFACTURING, DEFER_LOGICAL_TRANSACTIONS DEFER_LOGICAL_TRANSACTIONS, WIP_OVERPICK_ENABLED WIP_OVERPICK_ENABLED, OVPK_TRANSFER_ORDERS_ENABLED OVPK_TRANSFER_ORDERS_ENABLED, TOTAL_LPN_LENGTH TOTAL_LPN_LENGTH, UCC_128_SUFFIX_FLAG UCC_128_SUFFIX_FLAG, WCS_ENABLED WCS_ENABLED, ALLOW_DIFFERENT_STATUS ALLOW_DIFFERENT_STATUS, CHILD_LOT_ALPHA_PREFIX CHILD_LOT_ALPHA_PREFIX, CHILD_LOT_NUMBER_LENGTH CHILD_LOT_NUMBER_LENGTH, CHILD_LOT_VALIDATION_FLAG CHILD_LOT_VALIDATION_FLAG, CHILD_LOT_ZERO_PADDING_FLAG CHILD_LOT_ZERO_PADDING_FLAG, COPY_LOT_ATTRIBUTE_FLAG COPY_LOT_ATTRIBUTE_FLAG, CREATE_LOT_UOM_CONVERSION CREATE_LOT_UOM_CONVERSION, GENEALOGY_FORMULA_SECURITY GENEALOGY_FORMULA_SECURITY, PARENT_CHILD_GENERATION_FLAG PARENT_CHILD_GENERATION_FLAG, RULES_OVERRIDE_LOT_RESERVATION RULES_OVERRIDE_LOT_RESERVATION, AUTO_DEL_ALLOC_FLAG AUTO_DEL_ALLOC_FLAG, RFID_VERIF_PCNT_THRESHOLD RFID_VERIF_PCNT_THRESHOLD, YARD_MANAGEMENT_ENABLED_FLAG YARD_MANAGEMENT_ENABLED_FLAG, TRADING_PARTNER_ORG_FLAG TRADING_PARTNER_ORG_FLAG, DEFERRED_COGS_ACCOUNT DEFERRED_COGS_ACCOUNT, DEFAULT_CROSSDOCK_CRITERIA_ID DEFAULT_CROSSDOCK_CRITERIA_ID, ENFORCE_LOCATOR_ALIS_UNQ_FLAG ENFORCE_LOCATOR_ALIS_UNQ_FLAG, EPC_GENERATION_ENABLED_FLAG EPC_GENERATION_ENABLED_FLAG, COMPANY_PREFIX COMPANY_PREFIX, COMPANY_PREFIX_INDEX COMPANY_PREFIX_INDEX, COMMERCIAL_GOVT_ENTITY_NUMBER COMMERCIAL_GOVT_ENTITY_NUMBER, LABOR_MANAGEMENT_ENABLED_FLAG LABOR_MANAGEMENT_ENABLED_FLAG, DEFAULT_STATUS_ID DEFAULT_STATUS_ID, LCM_ENABLED_FLAG LCM_ENABLED_FLAG, LCM_VAR_ACCOUNT LCM_VAR_ACCOUNT, OPSM_ENABLED_FLAG OPSM_ENABLED_FLAG, ALLOCATE_LOT_FLAG ALLOCATE_LOT_FLAG, CAT_WT_ACCOUNT CAT_WT_ACCOUNT from "INV"."MTL_PARAMETERS"

View Text - HTML Formatted

SELECT ORGANIZATION_ID ORGANIZATION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ORGANIZATION_CODE ORGANIZATION_CODE
, MASTER_ORGANIZATION_ID MASTER_ORGANIZATION_ID
, PRIMARY_COST_METHOD PRIMARY_COST_METHOD
, COST_ORGANIZATION_ID COST_ORGANIZATION_ID
, DEFAULT_MATERIAL_COST_ID DEFAULT_MATERIAL_COST_ID
, CALENDAR_EXCEPTION_SET_ID CALENDAR_EXCEPTION_SET_ID
, CALENDAR_CODE CALENDAR_CODE
, GENERAL_LEDGER_UPDATE_CODE GENERAL_LEDGER_UPDATE_CODE
, DEFAULT_ATP_RULE_ID DEFAULT_ATP_RULE_ID
, DEFAULT_PICKING_RULE_ID DEFAULT_PICKING_RULE_ID
, DEFAULT_LOCATOR_ORDER_VALUE DEFAULT_LOCATOR_ORDER_VALUE
, DEFAULT_SUBINV_ORDER_VALUE DEFAULT_SUBINV_ORDER_VALUE
, NEGATIVE_INV_RECEIPT_CODE NEGATIVE_INV_RECEIPT_CODE
, STOCK_LOCATOR_CONTROL_CODE STOCK_LOCATOR_CONTROL_CODE
, MATERIAL_ACCOUNT MATERIAL_ACCOUNT
, MATERIAL_OVERHEAD_ACCOUNT MATERIAL_OVERHEAD_ACCOUNT
, MATL_OVHD_ABSORPTION_ACCT MATL_OVHD_ABSORPTION_ACCT
, RESOURCE_ACCOUNT RESOURCE_ACCOUNT
, PURCHASE_PRICE_VAR_ACCOUNT PURCHASE_PRICE_VAR_ACCOUNT
, AP_ACCRUAL_ACCOUNT AP_ACCRUAL_ACCOUNT
, OVERHEAD_ACCOUNT OVERHEAD_ACCOUNT
, OUTSIDE_PROCESSING_ACCOUNT OUTSIDE_PROCESSING_ACCOUNT
, INTRANSIT_INV_ACCOUNT INTRANSIT_INV_ACCOUNT
, INTERORG_RECEIVABLES_ACCOUNT INTERORG_RECEIVABLES_ACCOUNT
, INTERORG_PRICE_VAR_ACCOUNT INTERORG_PRICE_VAR_ACCOUNT
, INTERORG_PAYABLES_ACCOUNT INTERORG_PAYABLES_ACCOUNT
, COST_OF_SALES_ACCOUNT COST_OF_SALES_ACCOUNT
, ENCUMBRANCE_ACCOUNT ENCUMBRANCE_ACCOUNT
, PROJECT_COST_ACCOUNT PROJECT_COST_ACCOUNT
, INTERORG_TRANSFER_CR_ACCOUNT INTERORG_TRANSFER_CR_ACCOUNT
, MATL_INTERORG_TRANSFER_CODE MATL_INTERORG_TRANSFER_CODE
, INTERORG_TRNSFR_CHARGE_PERCENT INTERORG_TRNSFR_CHARGE_PERCENT
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, SOURCE_SUBINVENTORY SOURCE_SUBINVENTORY
, SOURCE_TYPE SOURCE_TYPE
, ORG_MAX_WEIGHT ORG_MAX_WEIGHT
, ORG_MAX_WEIGHT_UOM_CODE ORG_MAX_WEIGHT_UOM_CODE
, ORG_MAX_VOLUME ORG_MAX_VOLUME
, ORG_MAX_VOLUME_UOM_CODE ORG_MAX_VOLUME_UOM_CODE
, SERIAL_NUMBER_TYPE SERIAL_NUMBER_TYPE
, AUTO_SERIAL_ALPHA_PREFIX AUTO_SERIAL_ALPHA_PREFIX
, START_AUTO_SERIAL_NUMBER START_AUTO_SERIAL_NUMBER
, AUTO_LOT_ALPHA_PREFIX AUTO_LOT_ALPHA_PREFIX
, LOT_NUMBER_UNIQUENESS LOT_NUMBER_UNIQUENESS
, LOT_NUMBER_GENERATION LOT_NUMBER_GENERATION
, LOT_NUMBER_ZERO_PADDING LOT_NUMBER_ZERO_PADDING
, LOT_NUMBER_LENGTH LOT_NUMBER_LENGTH
, STARTING_REVISION STARTING_REVISION
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, DEFAULT_DEMAND_CLASS DEFAULT_DEMAND_CLASS
, ENCUMBRANCE_REVERSAL_FLAG ENCUMBRANCE_REVERSAL_FLAG
, MAINTAIN_FIFO_QTY_STACK_TYPE MAINTAIN_FIFO_QTY_STACK_TYPE
, INVOICE_PRICE_VAR_ACCOUNT INVOICE_PRICE_VAR_ACCOUNT
, AVERAGE_COST_VAR_ACCOUNT AVERAGE_COST_VAR_ACCOUNT
, SALES_ACCOUNT SALES_ACCOUNT
, EXPENSE_ACCOUNT EXPENSE_ACCOUNT
, SERIAL_NUMBER_GENERATION SERIAL_NUMBER_GENERATION
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, MAT_OVHD_COST_TYPE_ID MAT_OVHD_COST_TYPE_ID
, PROJECT_REFERENCE_ENABLED PROJECT_REFERENCE_ENABLED
, PM_COST_COLLECTION_ENABLED PM_COST_COLLECTION_ENABLED
, PROJECT_CONTROL_LEVEL PROJECT_CONTROL_LEVEL
, AVG_RATES_COST_TYPE_ID AVG_RATES_COST_TYPE_ID
, TXN_APPROVAL_TIMEOUT_PERIOD TXN_APPROVAL_TIMEOUT_PERIOD
, MO_SOURCE_REQUIRED MO_SOURCE_REQUIRED
, MO_PICK_CONFIRM_REQUIRED MO_PICK_CONFIRM_REQUIRED
, MO_APPROVAL_TIMEOUT_ACTION MO_APPROVAL_TIMEOUT_ACTION
, BORRPAY_MATL_VAR_ACCOUNT BORRPAY_MATL_VAR_ACCOUNT
, BORRPAY_MOH_VAR_ACCOUNT BORRPAY_MOH_VAR_ACCOUNT
, BORRPAY_RES_VAR_ACCOUNT BORRPAY_RES_VAR_ACCOUNT
, BORRPAY_OSP_VAR_ACCOUNT BORRPAY_OSP_VAR_ACCOUNT
, BORRPAY_OVH_VAR_ACCOUNT BORRPAY_OVH_VAR_ACCOUNT
, PROCESS_ENABLED_FLAG PROCESS_ENABLED_FLAG
, PROCESS_ORGN_CODE PROCESS_ORGN_CODE
, WSM_ENABLED_FLAG WSM_ENABLED_FLAG
, DEFAULT_COST_GROUP_ID DEFAULT_COST_GROUP_ID
, LPN_PREFIX LPN_PREFIX
, LPN_SUFFIX LPN_SUFFIX
, LPN_STARTING_NUMBER LPN_STARTING_NUMBER
, WMS_ENABLED_FLAG WMS_ENABLED_FLAG
, PREGEN_PUTAWAY_TASKS_FLAG PREGEN_PUTAWAY_TASKS_FLAG
, REGENERATION_INTERVAL REGENERATION_INTERVAL
, TIMEZONE_ID TIMEZONE_ID
, MAX_PICKS_BATCH MAX_PICKS_BATCH
, DEFAULT_WMS_PICKING_RULE_ID DEFAULT_WMS_PICKING_RULE_ID
, DEFAULT_PUT_AWAY_RULE_ID DEFAULT_PUT_AWAY_RULE_ID
, DEFAULT_TASK_ASSIGN_RULE_ID DEFAULT_TASK_ASSIGN_RULE_ID
, DEFAULT_LABEL_COMP_RULE_ID DEFAULT_LABEL_COMP_RULE_ID
, DEFAULT_CARTON_RULE_ID DEFAULT_CARTON_RULE_ID
, DEFAULT_CYC_COUNT_HEADER_ID DEFAULT_CYC_COUNT_HEADER_ID
, CROSSDOCK_FLAG CROSSDOCK_FLAG
, CARTONIZATION_FLAG CARTONIZATION_FLAG
, COST_CUTOFF_DATE COST_CUTOFF_DATE
, ENABLE_COSTING_BY_CATEGORY ENABLE_COSTING_BY_CATEGORY
, COST_GROUP_ACCOUNTING COST_GROUP_ACCOUNTING
, ALLOCATE_SERIAL_FLAG ALLOCATE_SERIAL_FLAG
, DEFAULT_PICK_TASK_TYPE_ID DEFAULT_PICK_TASK_TYPE_ID
, DEFAULT_CC_TASK_TYPE_ID DEFAULT_CC_TASK_TYPE_ID
, DEFAULT_PUTAWAY_TASK_TYPE_ID DEFAULT_PUTAWAY_TASK_TYPE_ID
, DEFAULT_REPL_TASK_TYPE_ID DEFAULT_REPL_TASK_TYPE_ID
, EAM_ENABLED_FLAG EAM_ENABLED_FLAG
, MAINT_ORGANIZATION_ID MAINT_ORGANIZATION_ID
, PRIORITIZE_WIP_JOBS PRIORITIZE_WIP_JOBS
, DEFAULT_CROSSDOCK_SUBINVENTORY DEFAULT_CROSSDOCK_SUBINVENTORY
, SKIP_TASK_WAITING_MINUTES SKIP_TASK_WAITING_MINUTES
, QA_SKIPPING_INSP_FLAG QA_SKIPPING_INSP_FLAG
, DEFAULT_CROSSDOCK_LOCATOR_ID DEFAULT_CROSSDOCK_LOCATOR_ID
, DEFAULT_MOXFER_TASK_TYPE_ID DEFAULT_MOXFER_TASK_TYPE_ID
, DEFAULT_MOISSUE_TASK_TYPE_ID DEFAULT_MOISSUE_TASK_TYPE_ID
, DEFAULT_MATL_OVHD_COST_ID DEFAULT_MATL_OVHD_COST_ID
, DISTRIBUTED_ORGANIZATION_FLAG DISTRIBUTED_ORGANIZATION_FLAG
, CARRIER_MANIFESTING_FLAG CARRIER_MANIFESTING_FLAG
, DISTRIBUTION_ACCOUNT_ID DISTRIBUTION_ACCOUNT_ID
, DIRECT_SHIPPING_ALLOWED DIRECT_SHIPPING_ALLOWED
, DEFAULT_PICK_OP_PLAN_ID DEFAULT_PICK_OP_PLAN_ID
, MAX_CLUSTERS_ALLOWED MAX_CLUSTERS_ALLOWED
, CONSIGNED_FLAG CONSIGNED_FLAG
, CARTONIZE_SALES_ORDERS CARTONIZE_SALES_ORDERS
, CARTONIZE_MANUFACTURING CARTONIZE_MANUFACTURING
, DEFER_LOGICAL_TRANSACTIONS DEFER_LOGICAL_TRANSACTIONS
, WIP_OVERPICK_ENABLED WIP_OVERPICK_ENABLED
, OVPK_TRANSFER_ORDERS_ENABLED OVPK_TRANSFER_ORDERS_ENABLED
, TOTAL_LPN_LENGTH TOTAL_LPN_LENGTH
, UCC_128_SUFFIX_FLAG UCC_128_SUFFIX_FLAG
, WCS_ENABLED WCS_ENABLED
, ALLOW_DIFFERENT_STATUS ALLOW_DIFFERENT_STATUS
, CHILD_LOT_ALPHA_PREFIX CHILD_LOT_ALPHA_PREFIX
, CHILD_LOT_NUMBER_LENGTH CHILD_LOT_NUMBER_LENGTH
, CHILD_LOT_VALIDATION_FLAG CHILD_LOT_VALIDATION_FLAG
, CHILD_LOT_ZERO_PADDING_FLAG CHILD_LOT_ZERO_PADDING_FLAG
, COPY_LOT_ATTRIBUTE_FLAG COPY_LOT_ATTRIBUTE_FLAG
, CREATE_LOT_UOM_CONVERSION CREATE_LOT_UOM_CONVERSION
, GENEALOGY_FORMULA_SECURITY GENEALOGY_FORMULA_SECURITY
, PARENT_CHILD_GENERATION_FLAG PARENT_CHILD_GENERATION_FLAG
, RULES_OVERRIDE_LOT_RESERVATION RULES_OVERRIDE_LOT_RESERVATION
, AUTO_DEL_ALLOC_FLAG AUTO_DEL_ALLOC_FLAG
, RFID_VERIF_PCNT_THRESHOLD RFID_VERIF_PCNT_THRESHOLD
, YARD_MANAGEMENT_ENABLED_FLAG YARD_MANAGEMENT_ENABLED_FLAG
, TRADING_PARTNER_ORG_FLAG TRADING_PARTNER_ORG_FLAG
, DEFERRED_COGS_ACCOUNT DEFERRED_COGS_ACCOUNT
, DEFAULT_CROSSDOCK_CRITERIA_ID DEFAULT_CROSSDOCK_CRITERIA_ID
, ENFORCE_LOCATOR_ALIS_UNQ_FLAG ENFORCE_LOCATOR_ALIS_UNQ_FLAG
, EPC_GENERATION_ENABLED_FLAG EPC_GENERATION_ENABLED_FLAG
, COMPANY_PREFIX COMPANY_PREFIX
, COMPANY_PREFIX_INDEX COMPANY_PREFIX_INDEX
, COMMERCIAL_GOVT_ENTITY_NUMBER COMMERCIAL_GOVT_ENTITY_NUMBER
, LABOR_MANAGEMENT_ENABLED_FLAG LABOR_MANAGEMENT_ENABLED_FLAG
, DEFAULT_STATUS_ID DEFAULT_STATUS_ID
, LCM_ENABLED_FLAG LCM_ENABLED_FLAG
, LCM_VAR_ACCOUNT LCM_VAR_ACCOUNT
, OPSM_ENABLED_FLAG OPSM_ENABLED_FLAG
, ALLOCATE_LOT_FLAG ALLOCATE_LOT_FLAG
, CAT_WT_ACCOUNT CAT_WT_ACCOUNT
FROM "INV"."MTL_PARAMETERS"