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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.WIP_PARAMETERS_V

Object Details

Object Name:	WIP_PARAMETERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WIP.WIP_PARAMETERS_V
Subobject Name:
Status:	VALID

View Type

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.

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

APPS.WIP_PARAMETERS_V references the following:

APPS: CST_COST_TYPES; MFG_LOOKUPS; MTL_ATP_RULES; MTL_PARAMETERS; MTL_SECONDARY_INVENTORIES; PER_ALL_PEOPLE_F; WIP_PARAMETERS; WIP_VALID_INTRAOPERATION_STEPS; WSH_PICK_GROUPING_RULES

APPS.WIP_PARAMETERS_V is referenced by following:

APPS: WIP_DIAG_DATA_COLL - show dependent code