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]

TABLE: WSM.WSM_COPY_REQUIREMENT_OPS

Object Details

Object Name:	WSM_COPY_REQUIREMENT_OPS
Object Type:	TABLE
Owner:	WSM
Subobject Name:
Status:	VALID

COPY table for primary and substitute components of effective operations for lot based jobs

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WSM_COPY_REQUIREMENT_OPS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	WIP_ENTITY_ID OPERATION_SEQ_NUM COMPONENT_ITEM_ID PRIMARY_COMPONENT_ID COMPONENT_SEQUENCE_ID SOURCE_PHANTOM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
WIP_ENTITY_ID	NUMBER		Yes	Lot Based Job Identifier
OPERATION_SEQ_NUM	NUMBER		Yes	Operation sequence number within a routing
COMPONENT_ITEM_ID	NUMBER		Yes	Component item identifier
PRIMARY_COMPONENT_ID	NUMBER		Yes	Component Identifier of the Primary Component for the current Component Item
COMPONENT_SEQUENCE_ID	NUMBER		Yes	Component unique identifier. In case of phantom exploded components, this will contain the sequence identifier of the component in the phantoms Bill
SOURCE_PHANTOM_ID	NUMBER		Yes	Top level Phantom Component Item identifier
RECOMMENDED	VARCHAR2	(1)	Yes	Recommended by planning or user preferred
RECO_DATE_REQUIRED	DATE			Component Requirement Start Date recommended by planning or user preferred
BILL_SEQUENCE_ID	NUMBER		Yes	Bill of material unique identifier
DEPARTMENT_ID	NUMBER			Department unique identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
WIP_SUPPLY_TYPE	NUMBER			WIP supply type code
SUPPLY_SUBINVENTORY	VARCHAR2	(10)		Supply subinventory
SUPPLY_LOCATOR_ID	NUMBER			Supply locator identifier
BILL_QUANTITY_PER_ASSEMBLY	NUMBER		Yes	Quantity of component in bill of material
QUANTITY_PER_ASSEMBLY	NUMBER		Yes	Required component quantity per unit of Assembly Item in its bill of material
COMPONENT_YIELD_FACTOR	NUMBER		Yes	Factor used to multiply component quantity with to obtain required component quantity
EFFECTIVITY_DATE	DATE		Yes	Effective date
DISABLE_DATE	DATE			Disable date
COMPONENT_PRIORITY	VARCHAR2	(150)		Priority of Component
PARENT_BILL_SEQ_ID	NUMBER			Common bill sequence id of the model bill (for ATO)
ITEM_NUM	NUMBER			Item sequence within bill of material structure
COMPONENT_REMARKS	VARCHAR2	(240)		Component remarks
CHANGE_NOTICE	VARCHAR2	(10)		Engineering change order number
IMPLEMENTATION_DATE	DATE			Date on which engineering change order was implemented
PLANNING_FACTOR	NUMBER		Yes	Factor used to multiply component quantity with to obtain planning quantity
QUANTITY_RELATED	NUMBER		Yes	Identifier to indicate if this component has quantity related reference designators
SO_BASIS	NUMBER			Quantity basis used by Oracle Order Management to determine how many units of component to put on an order
OPTIONAL	NUMBER			Flag indicating if component is optional in bill
MUTUALLY_EXCLUSIVE_OPTIONS	NUMBER			Flag indicating if one or more children of component can be picked when taking an order
INCLUDE_IN_COST_ROLLUP	NUMBER		Yes	Flag indicating if this component is to be used when rolling up costs
CHECK_ATP	NUMBER		Yes	Flag indicating if ATP check is required
SHIPPING_ALLOWED	NUMBER			Flag indicating if component is allowed to ship
REQUIRED_TO_SHIP	NUMBER			Flag indicating if component is required to ship
REQUIRED_FOR_REVENUE	NUMBER			Flag indicating if component is required for revenue
INCLUDE_ON_SHIP_DOCS	NUMBER			Flag indicating if component is displayed on shipping documents
LOW_QUANTITY	NUMBER			Minimum quantity allowed on an order
HIGH_QUANTITY	NUMBER			Maximum quantity allowed on an order
ACD_TYPE	NUMBER			Add, change, or disable code for component on an engineering change order
OLD_COMPONENT_SEQUENCE_ID	NUMBER			Identifier of original component row an ECO effects
OPERATION_LEAD_TIME_PERCENT	NUMBER			Operation offset from first operation in routing
REVISED_ITEM_SEQUENCE_ID	NUMBER			Engineering change order revised item identifier
BOM_ITEM_TYPE	NUMBER		Yes	Type of item
FROM_END_ITEM_UNIT_NUMBER	VARCHAR2	(30)		From End Item Unit Number
TO_END_ITEM_UNIT_NUMBER	VARCHAR2	(30)		To End Item Unit Number
ECO_FOR_PRODUCTION	NUMBER			Indicates if this component on an Engineering Change Order is only for WIP jobs
ENFORCE_INT_REQUIREMENTS	NUMBER			Enforce Integer Requirements
DELETE_GROUP_NAME	VARCHAR2	(10)		Delete group name for the entity type you are deleting
DG_DESCRIPTION	VARCHAR2	(240)		Description of the delete group
OPTIONAL_ON_MODEL	NUMBER			Flag indicating if component is optional on model bill (for ATO)
MODEL_COMP_SEQ_ID	NUMBER			Component sequence identifier from model bill (for ATO)
PLAN_LEVEL	NUMBER			Plan level based on model bill (for ATO)
AUTO_REQUEST_MATERIAL	VARCHAR2	(1)		Auto Request Material
COMPONENT_ITEM_REVISION_ID	NUMBER			Item revision Identifier
FROM_BILL_REVISION_ID	NUMBER			From Bill Revision identifier
TO_BILL_REVISION_ID	NUMBER			To Bill Revision identifier
PICK_COMPONENTS	NUMBER			Not used
INCLUDE_ON_BILL_DOCS	NUMBER			Not used
COST_FACTOR	NUMBER			Not used
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER			Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition 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
ORIGINAL_SYSTEM_REFERENCE	VARCHAR2	(50)		Original system that data for the current record has come from
BASIS_TYPE	NUMBER			Component Basis Type

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT WIP_ENTITY_ID
,      OPERATION_SEQ_NUM
,      COMPONENT_ITEM_ID
,      PRIMARY_COMPONENT_ID
,      COMPONENT_SEQUENCE_ID
,      SOURCE_PHANTOM_ID
,      RECOMMENDED
,      RECO_DATE_REQUIRED
,      BILL_SEQUENCE_ID
,      DEPARTMENT_ID
,      ORGANIZATION_ID
,      WIP_SUPPLY_TYPE
,      SUPPLY_SUBINVENTORY
,      SUPPLY_LOCATOR_ID
,      BILL_QUANTITY_PER_ASSEMBLY
,      QUANTITY_PER_ASSEMBLY
,      COMPONENT_YIELD_FACTOR
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      COMPONENT_PRIORITY
,      PARENT_BILL_SEQ_ID
,      ITEM_NUM
,      COMPONENT_REMARKS
,      CHANGE_NOTICE
,      IMPLEMENTATION_DATE
,      PLANNING_FACTOR
,      QUANTITY_RELATED
,      SO_BASIS
,      OPTIONAL
,      MUTUALLY_EXCLUSIVE_OPTIONS
,      INCLUDE_IN_COST_ROLLUP
,      CHECK_ATP
,      SHIPPING_ALLOWED
,      REQUIRED_TO_SHIP
,      REQUIRED_FOR_REVENUE
,      INCLUDE_ON_SHIP_DOCS
,      LOW_QUANTITY
,      HIGH_QUANTITY
,      ACD_TYPE
,      OLD_COMPONENT_SEQUENCE_ID
,      OPERATION_LEAD_TIME_PERCENT
,      REVISED_ITEM_SEQUENCE_ID
,      BOM_ITEM_TYPE
,      FROM_END_ITEM_UNIT_NUMBER
,      TO_END_ITEM_UNIT_NUMBER
,      ECO_FOR_PRODUCTION
,      ENFORCE_INT_REQUIREMENTS
,      DELETE_GROUP_NAME
,      DG_DESCRIPTION
,      OPTIONAL_ON_MODEL
,      MODEL_COMP_SEQ_ID
,      PLAN_LEVEL
,      AUTO_REQUEST_MATERIAL
,      COMPONENT_ITEM_REVISION_ID
,      FROM_BILL_REVISION_ID
,      TO_BILL_REVISION_ID
,      PICK_COMPONENTS
,      INCLUDE_ON_BILL_DOCS
,      COST_FACTOR
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORIGINAL_SYSTEM_REFERENCE
,      BASIS_TYPE
FROM WSM.WSM_COPY_REQUIREMENT_OPS;

Dependencies

[top of page]

WSM.WSM_COPY_REQUIREMENT_OPS does not reference any database object

WSM.WSM_COPY_REQUIREMENT_OPS is referenced by following:

WSM: WSM_COPY_REQUIREMENT_OPS#