[Home] [Help]
[Dependency Information]
| Object Name: | MTL_PARAMETERS_VIEW |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | INV.MTL_PARAMETERS_VIEW
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| 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 | |||
| 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 | |||
| INTERORG_TRANSFER_CR_ACCOUNT | NUMBER | |||
| MATL_INTERORG_TRANSFER_CODE | NUMBER | Yes | ||
| INTERORG_TRNSFR_CHARGE_PERCENT | NUMBER | |||
| MAINTAIN_FIFO_QTY_STACK_TYPE | NUMBER | |||
| SOURCE_ORGANIZATION_ID | NUMBER | |||
| SOURCE_SUBINVENTORY | VARCHAR2 | (10) | ||
| SOURCE_TYPE | NUMBER | |||
| 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) | Descriptive flexfield segment | |
| 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) | ||
| INVOICE_PRICE_VAR_ACCOUNT | NUMBER | |||
| ENCUMBRANCE_REVERSAL_FLAG | NUMBER | |||
| AVERAGE_COST_VAR_ACCOUNT | NUMBER | |||
| ORGANIZATION_CODE | VARCHAR2 | (3) | ||
| 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 | |||
| PROJECT_REFERENCE_ENABLED | NUMBER | |||
| PM_COST_COLLECTION_ENABLED | NUMBER | |||
| PROJECT_CONTROL_LEVEL | NUMBER | |||
| AVG_RATES_COST_TYPE_ID | NUMBER | |||
| TXN_APPROVAL_TIMEOUT_PERIOD | NUMBER | |||
| DEF_DEMAND_DUMMY | VARCHAR2 | (80) | ||
| PRIMARY_COST_DUMMY | VARCHAR2 | (80) | Yes | |
| DEFAULT_MATERIAL_SUB | VARCHAR2 | (10) | ||
| DEFAULT_ATP_RULE | VARCHAR2 | (80) | ||
| DEFAULT_PICKING_RULE | VARCHAR2 | (80) | ||
| SOURCE_ORGANIZATION_CODE | VARCHAR2 | (3) | ||
| SOURCE_ORGANIZATION_NAME | VARCHAR2 | (240) | ||
| MASTER_ORG | VARCHAR2 | (240) | Yes | |
| 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 | |||
| MO_SOURCE_REQUIRED | NUMBER | |||
| MO_APPROVAL_TIMEOUT_ACTION | NUMBER | |||
| MO_PICK_CONFIRM_REQUIRED | NUMBER | |||
| ORG_MAX_WEIGHT | NUMBER | |||
| ORG_MAX_WEIGHT_UOM_CODE | VARCHAR2 | (3) | ||
| ORG_MAX_VOLUME | NUMBER | |||
| ORG_MAX_VOLUME_UOM_CODE | VARCHAR2 | (3) | ||
| PROJECT_COST_ACCOUNT | NUMBER | |||
| PROCESS_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Process Enabled inventory Organization |
| PROCESS_ORGN_CODE | VARCHAR2 | (4) | OPM Warehouse Organization Code Mapped to the Process Inventory Organization | |
| WSM_ENABLED_FLAG | VARCHAR2 | (1) | Yes | WIP Shopfloor Management Organization |
| DEFAULT_COST_GROUP_ID | NUMBER | Yes | Default Cost Group ID | |
| LPN_PREFIX | VARCHAR2 | (10) | ||
| LPN_SUFFIX | VARCHAR2 | (10) | ||
| LPN_STARTING_NUMBER | NUMBER | |||
| WMS_ENABLED_FLAG | VARCHAR2 | (1) | Yes | WMS(Warehouse Management System) Organization |
| PREGEN_PUTAWAY_TASKS_FLAG | NUMBER | |||
| REGENERATION_INTERVAL | NUMBER | |||
| TIMEZONE_ID | NUMBER | |||
| DEFAULT_WMS_PICKING_RULE_ID | NUMBER | |||
| DEFAULT_PUT_AWAY_RULE_ID | NUMBER | |||
| DEFAULT_CARTON_RULE_ID | NUMBER | |||
| DEFAULT_CYC_COUNT_HEADER_ID | NUMBER | |||
| CROSSDOCK_FLAG | NUMBER | |||
| CARTONIZATION_FLAG | NUMBER | |||
| 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) | ||
| COST_CUTOFF_DATE | DATE | |||
| 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) | EAM Enabled Flag | |
| DEFAULT_MOISSUE_TASK_TYPE_ID | NUMBER | Default task type identifier for MO Issue | ||
| DEFAULT_MOXFER_TASK_TYPE_ID | NUMBER | Default task type identifier for MO Transfer | ||
| MAINT_ORGANIZATION_ID | NUMBER | Maint Organization Id | ||
| PRIORITIZE_WIP_JOBS | NUMBER | |||
| DEFAULT_CROSSDOCK_SUBINVENTORY | VARCHAR2 | (10) | ||
| SKIP_TASK_WAITING_MINUTES | NUMBER | |||
| QA_SKIPPING_INSP_FLAG | VARCHAR2 | (1) | Yes | Oracle Quality skipping inspection flag |
| DEFAULT_CROSSDOCK_LOCATOR_ID | NUMBER | This acts an id for the Key_Flex_Field Default_Crossdock_Locator, which acts as a default crossdock locator for the subinventory | ||
| DEFAULT_MATL_OVHD_COST_ID | NUMBER | |||
| DISTRIBUTED_ORGANIZATION_FLAG | VARCHAR2 | (1) | Distributed Organization Flag | |
| CARRIER_MANIFESTING_FLAG | VARCHAR2 | (1) | Carrier Manifesting Flag | |
| DISTRIBUTION_ACCOUNT_ID | NUMBER | Distribution Account | ||
| DIRECT_SHIPPING_ALLOWED | VARCHAR2 | (1) | Direct Shipping Allowed | |
| DEFAULT_PICK_OP_PLAN_ID | NUMBER | Outbound Consolidation Plan | ||
| MAX_CLUSTERS_ALLOWED | NUMBER | Maximum Number of Clusters allowed for Cluster Picking | ||
| CARTONIZE_SALES_ORDERS | VARCHAR2 | (1) | Enable Cartonization for Sales Orders | |
| CARTONIZE_MANUFACTURING | VARCHAR2 | (1) | Enable Cartonization for WIP Jobs | |
| WIP_OVERPICK_ENABLED | VARCHAR2 | (1) | Enable Overpicking quantities for WIP | |
| OVPK_TRANSFER_ORDERS_ENABLED | VARCHAR2 | (1) | Enable Overpicking quantities for Replenishment and Requisition Move Orders | |
| TOTAL_LPN_LENGTH | NUMBER | Total Length of License Plate Number (XXXX) | ||
| UCC_128_SUFFIX_FLAG | VARCHAR2 | (1) | Indicate Suffix generation using modulo-10 is used when enable | |
| DEFER_LOGICAL_TRANSACTIONS | NUMBER | Flag to check if the creation of logical transactions should be defer | ||
| AUTO_DEL_ALLOC_FLAG | VARCHAR2 | (1) | Delete Allocationat Source cancel | |
| PARENT_CHILD_GENERATION_FLAG | VARCHAR2 | (1) | ||
| CHILD_LOT_ZERO_PADDING_FLAG | VARCHAR2 | (1) | ||
| CHILD_LOT_ALPHA_PREFIX | VARCHAR2 | (30) | ||
| CHILD_LOT_NUMBER_LENGTH | NUMBER | |||
| CHILD_LOT_VALIDATION_FLAG | VARCHAR2 | (1) | ||
| COPY_LOT_ATTRIBUTE_FLAG | VARCHAR2 | (1) | ||
| CREATE_LOT_UOM_CONVERSION | NUMBER | |||
| ALLOW_DIFFERENT_STATUS | NUMBER | |||
| RULES_OVERRIDE_LOT_RESERVATION | VARCHAR2 | (1) | ||
| GENEALOGY_FORMULA_SECURITY | VARCHAR2 | (1) | ||
| RFID_VERIF_PCNT_THRESHOLD | NUMBER | RFID Verification Percentage Threshold | ||
| WCS_ENABLED | VARCHAR2 | (1) | ||
| YARD_MANAGEMENT_ENABLED_FLAG | VARCHAR2 | (1) | Yard Management Enabled Flag | |
| TRADING_PARTNER_ORG_FLAG | VARCHAR2 | (1) | Indicates if the organization is a trading partner to any original equipment manufacturer. | |
| DEFERRED_COGS_ACCOUNT | NUMBER | Deferred COGS account which holds the costs till revenue is recognized. | ||
| DEFAULT_CROSSDOCK_CRITERIA_ID | NUMBER | Used to determine the demand for opportunistic crossdocking. | ||
| ENFORCE_LOCATOR_ALIS_UNQ_FLAG | VARCHAR2 | (1) | Indicates whether the Locators alias should be unique or not in an organization. | |
| EPC_GENERATION_ENABLED_FLAG | VARCHAR2 | (1) | Flag to enable EPC for outbound documents. | |
| COMPANY_PREFIX | VARCHAR2 | (30) | Identifies the company prefix for EPC generation, used in 96-bit tags. | |
| COMPANY_PREFIX_INDEX | VARCHAR2 | (30) | Identifies the company prefix for EPC generation, used in 64-bit tags. | |
| COMMERCIAL_GOVT_ENTITY_NUMBER | VARCHAR2 | (30) | Identifies the company CAGE# for RFID tag generation for DoD specification | |
| LABOR_MANAGEMENT_ENABLED_FLAG | VARCHAR2 | (1) | Indicates whether the Labor Management processing has to be done or not. | |
| CRITERION_NAME | VARCHAR2 | (80) | Default Crossdock criteria name | |
| DEFAULT_STATUS_ID | NUMBER | |||
| LCM_ENABLED_FLAG | VARCHAR2 | (1) | Flag to check if an Org is LCM Enabled or not | |
| LCM_VAR_ACCOUNT | NUMBER | LCM Variance Account |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ORGANIZATION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, 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
, MAINTAIN_FIFO_QTY_STACK_TYPE
, 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
, INVOICE_PRICE_VAR_ACCOUNT
, ENCUMBRANCE_REVERSAL_FLAG
, AVERAGE_COST_VAR_ACCOUNT
, ORGANIZATION_CODE
, SALES_ACCOUNT
, EXPENSE_ACCOUNT
, SERIAL_NUMBER_GENERATION
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PROJECT_REFERENCE_ENABLED
, PM_COST_COLLECTION_ENABLED
, PROJECT_CONTROL_LEVEL
, AVG_RATES_COST_TYPE_ID
, TXN_APPROVAL_TIMEOUT_PERIOD
, DEF_DEMAND_DUMMY
, PRIMARY_COST_DUMMY
, DEFAULT_MATERIAL_SUB
, DEFAULT_ATP_RULE
, DEFAULT_PICKING_RULE
, SOURCE_ORGANIZATION_CODE
, SOURCE_ORGANIZATION_NAME
, MASTER_ORG
, BORRPAY_MATL_VAR_ACCOUNT
, BORRPAY_MOH_VAR_ACCOUNT
, BORRPAY_RES_VAR_ACCOUNT
, BORRPAY_OSP_VAR_ACCOUNT
, BORRPAY_OVH_VAR_ACCOUNT
, MO_SOURCE_REQUIRED
, MO_APPROVAL_TIMEOUT_ACTION
, MO_PICK_CONFIRM_REQUIRED
, ORG_MAX_WEIGHT
, ORG_MAX_WEIGHT_UOM_CODE
, ORG_MAX_VOLUME
, ORG_MAX_VOLUME_UOM_CODE
, 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
, CROSSDOCK_FLAG
, CARTONIZATION_FLAG
, 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
, COST_CUTOFF_DATE
, 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
, DEFAULT_MOISSUE_TASK_TYPE_ID
, DEFAULT_MOXFER_TASK_TYPE_ID
, MAINT_ORGANIZATION_ID
, PRIORITIZE_WIP_JOBS
, DEFAULT_CROSSDOCK_SUBINVENTORY
, SKIP_TASK_WAITING_MINUTES
, QA_SKIPPING_INSP_FLAG
, DEFAULT_CROSSDOCK_LOCATOR_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
, CARTONIZE_SALES_ORDERS
, CARTONIZE_MANUFACTURING
, WIP_OVERPICK_ENABLED
, OVPK_TRANSFER_ORDERS_ENABLED
, TOTAL_LPN_LENGTH
, UCC_128_SUFFIX_FLAG
, DEFER_LOGICAL_TRANSACTIONS
, AUTO_DEL_ALLOC_FLAG
, PARENT_CHILD_GENERATION_FLAG
, CHILD_LOT_ZERO_PADDING_FLAG
, CHILD_LOT_ALPHA_PREFIX
, CHILD_LOT_NUMBER_LENGTH
, CHILD_LOT_VALIDATION_FLAG
, COPY_LOT_ATTRIBUTE_FLAG
, CREATE_LOT_UOM_CONVERSION
, ALLOW_DIFFERENT_STATUS
, RULES_OVERRIDE_LOT_RESERVATION
, GENEALOGY_FORMULA_SECURITY
, RFID_VERIF_PCNT_THRESHOLD
, WCS_ENABLED
, 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
, CRITERION_NAME
, DEFAULT_STATUS_ID
, LCM_ENABLED_FLAG
, LCM_VAR_ACCOUNT
FROM APPS.MTL_PARAMETERS_VIEW;
APPS
BOM_RESOURCES
CST_COST_GROUPS
FND_COMMON_LOOKUPS
FND_GLOBAL
- show dependent code
HR_ALL_ORGANIZATION_UNITS
HR_ALL_ORGANIZATION_UNITS_TL
HR_GENERAL
- show dependent code
HR_ORG_UNITS_NO_JOIN
HR_SECURITY
- show dependent code
MFG_LOOKUPS
MTL_ATP_RULES
MTL_PARAMETERS
WMS_CROSSDOCK_CRITERIA_VL
WMS_RULES_VL
APPS
JAI_RCV_DELIVER_RTR_PKG
- show dependent code
JAI_RCV_RT_TRIGGER_PKG
- show dependent code
|
|
|
|