View: MTL_PARAMETERS_ALL_V

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.MTL_PARAMETERS_ALL_V

View Text

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 MTL_PARAMETERS

Columns