[Home] [Help] [Dependency Information]
Object Name: | WIP_PARAMETERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | WIP.WIP_PARAMETERS_V |
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) | ROWID from WIP_PARAMETERS | |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
DEFAULT_PULL_SUPPLY_SUBINV | VARCHAR2 | (10) | Yes | Default subinventory used for pull requirements when no pull subinventory has been specified in the bill of materials or as a default WIP supply subinventory in Inventory |
SUBINV_LOCATOR_TYPE | NUMBER | Subinventory-level stock locator control type | ||
STOCK_LOCATOR_CONTROL_CODE | NUMBER | Yes | Stock locator control code | |
DEFAULT_PULL_SUPPLY_LOCATOR_ID | NUMBER | Default locator used for pull requirements when no pull locator has been specified the bill of materials or as a default WIP supply locator in Inventory | ||
LOT_NUMBER_DEFAULT_TYPE | NUMBER | Yes | Method used to determine default lot number for a discrete job | |
BACKFLUSH_LOT_ENTRY_TYPE | NUMBER | Yes | Method of entering lot numbers during a backflush transaction | |
LOT_SELECTION_METHOD | NUMBER | Method for selecting lot numbers for backflushing | ||
LOT_VERIFICATION | NUMBER | Method for verifying lot numbers during backflushing | ||
INCLUDE_COMPONENT_YIELD | NUMBER | Flag indicating whether component yield will be included in material transactions | ||
DEFAULT_DISCRETE_CLASS | VARCHAR2 | (10) | Default accounting class for discrete jobs | |
DYNAMIC_OPERATION_INSERT_FLAG | NUMBER | Yes | Whether or not operations can be added to a routing from the WIP Shop Floor Transaction form | |
MANDATORY_SCRAP_FLAG | NUMBER | Yes | Used to mandate entering a scrap account on moving assemblies to the Scrap intraoperation | |
SO_CHANGE_RESPONSE_TYPE | NUMBER | Yes | Manner in which WIP responds to changes made by Oracle Order Entry to sales order lines linked to WIP | |
REPETITIVE_VARIANCE_TYPE | NUMBER | Yes | Controls wheather variances are relieved for all or completed and cancelled schedules | |
AUTORELEASE_DAYS | NUMBER | Yes | On completion of a schedule a subsequent schedule gets released if it's start date is within the autorelease days. | |
OSP_SHOP_FLOOR_STATUS | VARCHAR2 | (10) | Shop floor status for outside processing | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
QUEUE_ENABLED_FLAG | NUMBER | Indicates whether the Queue step is enabled | ||
RUN_ENABLED_FLAG | NUMBER | Indicates whether the Run step is enabled | ||
TO_MOVE_ENABLED_FLAG | NUMBER | Indicates whether the To Move step is enabled | ||
REJECT_ENABLED_FLAG | NUMBER | Indicates whether the Reject step is enabled | ||
SCRAP_ENABLED_FLAG | NUMBER | Indicates whether the Scrap step is enabled | ||
COMPLETION_COST_SOURCE | NUMBER | Default completion cost source for average costing | ||
COMPLETION_COST_SOURCE_MEANING | VARCHAR2 | (80) | Meaning of default completion cost source | |
COST_TYPE_ID | NUMBER | Default cost type identifier for average costing | ||
COST_TYPE | VARCHAR2 | (10) | Cost type meaning | |
AUTO_COMPUTE_FINAL_COMPLETION | NUMBER | Flag to indicate whether or not the final completion is automatically calculated; used for average costing | ||
MOVES_OVER_NO_MOVE_STATUSES | NUMBER | Allow skipping of No Move shop floor statuses during move transactions | ||
SYSTEM_OPTION | VARCHAR2 | (80) | ||
COMPONENT_ATP_RULE_ID | NUMBER | Component ATP Rule identifier | ||
COMPONENT_ATP_RULE_NAME | VARCHAR2 | (80) | Component ATP Rule name | |
PO_CREATION_TIME | NUMBER | Yes | ||
DEFAULT_OVERCOMPL_TOLERANCE | NUMBER | |||
PRODUCTION_SCHEDULER_ID | NUMBER | Production Scheduler Id | ||
SHIPPING_MANAGER_ID | NUMBER | Shipping Manager Id | ||
PRODUCTION_SCHEDULER | VARCHAR2 | (240) | Production Scheduler Name | |
SHIPPING_MANAGER | VARCHAR2 | (240) | shipping Manager Name | |
USE_FINITE_SCHEDULER | NUMBER | |||
MATERIAL_CONSTRAINED | NUMBER | |||
HORIZON_LENGTH | NUMBER | |||
DEFAULT_SCRAP_ACCOUNT_ID | NUMBER | The scrap account id for mobile scrap transactions | ||
SIMULATION_SET | VARCHAR2 | (10) | ||
OPTIMIZATION | NUMBER | |||
DUE_DATE_PENALTY | NUMBER | |||
DUE_DATE_TOLERANCE | NUMBER | |||
MAXIMUM_PENALTY | NUMBER | |||
ALLOCATE_BACKFLUSH_COMPONENTS | VARCHAR2 | (1) | ||
MOBILE_TRANSACTION_MODE | NUMBER | |||
DEFAULT_SERIALIZATION_START_OP | NUMBER | |||
DEFAULT_WIP_AUTO_ASSOC_SN | NUMBER | |||
DEFAULT_MOVE_TO_STEP_TYPE | NUMBER | |||
DEFAULT_MOVE_TO_STEP | VARCHAR2 | (80) | ||
INCLUDE_RESOURCE_UTILIZATION | NUMBER | |||
INCLUDE_RESOURCE_EFFICIENCY | NUMBER | |||
PICKSLIP_GROUPING_RULE_ID | NUMBER | |||
PICKSLIP_GROUPING_RULE_NAME | VARCHAR2 | (30) | ||
DEFAULT_PLAN_TASKS | VARCHAR2 | (1) | ||
PROPAGATE_JOB_CHANGE_TO_PO | NUMBER | Propagate job changes to purchasing order | ||
EARLY_NEED_BY_DATE_TOLERANCE | NUMBER | Early need-by date tolerance | ||
LATE_NEED_BY_DATE_TOLERANCE | NUMBER | Late need-by date tolerance | ||
ALLOW_BACKFLUSH_QTY_CHANGE | NUMBER | Allow backflush quantity change | ||
ALTERNATE_LOT_SELECTION_METHOD | NUMBER | Used to default lots, if lots cannot be derived using transaction history |
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
, DEFAULT_PULL_SUPPLY_SUBINV
, SUBINV_LOCATOR_TYPE
, STOCK_LOCATOR_CONTROL_CODE
, DEFAULT_PULL_SUPPLY_LOCATOR_ID
, LOT_NUMBER_DEFAULT_TYPE
, BACKFLUSH_LOT_ENTRY_TYPE
, LOT_SELECTION_METHOD
, LOT_VERIFICATION
, INCLUDE_COMPONENT_YIELD
, DEFAULT_DISCRETE_CLASS
, DYNAMIC_OPERATION_INSERT_FLAG
, MANDATORY_SCRAP_FLAG
, SO_CHANGE_RESPONSE_TYPE
, REPETITIVE_VARIANCE_TYPE
, AUTORELEASE_DAYS
, OSP_SHOP_FLOOR_STATUS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, QUEUE_ENABLED_FLAG
, RUN_ENABLED_FLAG
, TO_MOVE_ENABLED_FLAG
, REJECT_ENABLED_FLAG
, SCRAP_ENABLED_FLAG
, COMPLETION_COST_SOURCE
, COMPLETION_COST_SOURCE_MEANING
, COST_TYPE_ID
, COST_TYPE
, AUTO_COMPUTE_FINAL_COMPLETION
, MOVES_OVER_NO_MOVE_STATUSES
, SYSTEM_OPTION
, COMPONENT_ATP_RULE_ID
, COMPONENT_ATP_RULE_NAME
, PO_CREATION_TIME
, DEFAULT_OVERCOMPL_TOLERANCE
, PRODUCTION_SCHEDULER_ID
, SHIPPING_MANAGER_ID
, PRODUCTION_SCHEDULER
, SHIPPING_MANAGER
, USE_FINITE_SCHEDULER
, MATERIAL_CONSTRAINED
, HORIZON_LENGTH
, DEFAULT_SCRAP_ACCOUNT_ID
, SIMULATION_SET
, OPTIMIZATION
, DUE_DATE_PENALTY
, DUE_DATE_TOLERANCE
, MAXIMUM_PENALTY
, ALLOCATE_BACKFLUSH_COMPONENTS
, MOBILE_TRANSACTION_MODE
, DEFAULT_SERIALIZATION_START_OP
, DEFAULT_WIP_AUTO_ASSOC_SN
, DEFAULT_MOVE_TO_STEP_TYPE
, DEFAULT_MOVE_TO_STEP
, INCLUDE_RESOURCE_UTILIZATION
, INCLUDE_RESOURCE_EFFICIENCY
, PICKSLIP_GROUPING_RULE_ID
, PICKSLIP_GROUPING_RULE_NAME
, DEFAULT_PLAN_TASKS
, PROPAGATE_JOB_CHANGE_TO_PO
, EARLY_NEED_BY_DATE_TOLERANCE
, LATE_NEED_BY_DATE_TOLERANCE
, ALLOW_BACKFLUSH_QTY_CHANGE
, ALTERNATE_LOT_SELECTION_METHOD
FROM APPS.WIP_PARAMETERS_V;
|
|
|