VIEW: APPS.MTL_PARAMETERS_ALL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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