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.ENG_REVISED_COMPONENTS_ERV

Object Details

Object Name:	ENG_REVISED_COMPONENTS_ERV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ENG.ENG_REVISED_COMPONENTS_ERV
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	Comments
ROW_ID	ROWID	(10)	Row identifier
COMPONENT_SEQUENCE_ID	NUMBER		Component unique identifier
COMPONENT_ITEM_ID	NUMBER		Component item identifier
BILL_SEQUENCE_ID	NUMBER		Bill of material unique identifier
CHANGE_NOTICE	VARCHAR2	(10)	Engineering change order number
EFFECTIVITY_DATE	DATE		Effective date
COMPONENT_QUANTITY	NUMBER		Quantity of component in bill of material
COMPONENT_YIELD_FACTOR	NUMBER		Factor used to multiply component quantity with to obtain component quantity
LAST_UPDATE_DATE	DATE		Standard who column
LAST_UPDATED_BY	NUMBER		Standard who column
CREATION_DATE	DATE		Standard who column
CREATED_BY	NUMBER		Standard who column
LAST_UPDATE_LOGIN	NUMBER		Standard who column
OLD_COMPONENT_SEQUENCE_ID	NUMBER		Identifier of component that is being disabled or changed
ITEM_NUM	NUMBER		Item sequence within bill of material structure
WIP_SUPPLY_TYPE	NUMBER		WIP supply type code
SUPPLY_TYPE	VARCHAR2	(80)	WIP supply type meaning
COMPONENT_REMARKS	VARCHAR2	(240)	Component comments
IMPLEMENTATION_DATE	DATE		Date on which engineering change order was implemented
IMPL_CB	NUMBER		Flag indicating if component is implemented
DISABLE_DATE	DATE		Disable date
ACD_TYPE	NUMBER		Code indicating that component is being added, changed, or disabled
PLANNING_FACTOR	NUMBER		Factor used to multiply component quantity with to obtain planning quantity
QUANTITY_RELATED	NUMBER		Code to indicate if this component has quantity related reference designators
SO_BASIS	NUMBER		Quantity basis used by Oracle Order Entry 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		Flag indicating if this component is to be used when rolling up costs
CHECK_ATP	NUMBER		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
INCLUDE_ON_BILL_DOCS	NUMBER		Flag indicating if component is included on billing documents
LOW_QUANTITY	NUMBER		Minimum quantity allowed on an order
HIGH_QUANTITY	NUMBER		Maximum quantity allowed on an order
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
REQUEST_ID	NUMBER		Concurrent Who column
PROGRAM_APPLICATION_ID	NUMBER		Concurrent Who column
PROGRAM_ID	NUMBER		Concurrent Who column
PROGRAM_UPDATE_DATE	DATE		Concurrent Who column
PICK_COMPONENTS	NUMBER		(not currently used)
OPERATION_SEQ_NUM	NUMBER		Operation sequence number
SUPPLY_SUBINVENTORY	VARCHAR2	(10)	Supply subinventory
SUPPLY_LOCATOR_ID	NUMBER		Supply locator identifier
SUPPLY_LOCATOR	CHAR	(1)
REVISED_ITEM_SEQUENCE_ID	NUMBER		Engineering change order revised item identifier
COST_FACTOR	NUMBER		(not currently used)
CANCELLATION_DATE	DATE		Date when the ECO, revised item, or revised component was cancelled
CANCEL_COMMENTS	VARCHAR2	(240)	Cancellation comments
BOM_ITEM_TYPE	NUMBER		Type of item
PRIMARY_UOM_CODE	VARCHAR2	(3)	Primary unit of measure code
COMPONENT_ITEM_NO	VARCHAR2	(40)
COMPONENT_ITEM_DESC	VARCHAR2	(240)
ENG_ITEM_FLAG	VARCHAR2	(1)	Flag indicating engineering item
INVENTORY_ITEM_STATUS_CODE	VARCHAR2	(10)	Material status code
SHIPPABLE_ITEM_FLAG	VARCHAR2	(1)	Flag indicating shippable item
ITEM_LOCATOR_CONTROL	NUMBER		Stock locator control code
RESTRICT_LOCATORS_FLAG	NUMBER		Locators restrictions type
RESTRICT_SUBINVENTORIES_FLAG	VARCHAR2	(1)	Subinventory restrictions type
BASE_ITEM_ID	NUMBER		Base item identifier
ITEM_TYPE	VARCHAR2	(80)	QuickCode meaning
REPLENISH_TO_ORDER_FLAG	VARCHAR2	(1)	Assemble to Order flag
ATP_COMPONENTS_FLAG	VARCHAR2	(1)	Flag indicating whether item may have components requiring ATP check
PICK_COMPONENTS_FLAG	VARCHAR2	(1)	Flag indicating all shippable components of should be picked
INVENTORY_ASSET_FLAG	VARCHAR2	(1)	Flag indicating item is an inventory asset
ATP_FLAG	VARCHAR2	(1)	Flag indicating ATP must be checked when item is ordered
FORECAST_CONTROL	NUMBER		Type of forecast control for ATO
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		WIP Only ECO
ENFORCE_INT_REQUIREMENTS	NUMBER		Enforce Integer Requirements
ENFORCE_INT_REQUIREMENTS_DESC	VARCHAR2	(80)	Enforce Integer Requirements Description
ORIGINAL_SYSTEM_REFERENCE	VARCHAR2	(50)	ORIGINAL_SYSTEM_REFERENCE
OLD_OPERATION_SEQ_NUM	NUMBER		Old component sequence number
OLD_COMPONENT_QUANTITY	NUMBER		Old component quantity
COMPONENT_ITEM_REVISION	VARCHAR2	(3)	Component item revision

Query Text

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


SELECT ROW_ID
,      COMPONENT_SEQUENCE_ID
,      COMPONENT_ITEM_ID
,      BILL_SEQUENCE_ID
,      CHANGE_NOTICE
,      EFFECTIVITY_DATE
,      COMPONENT_QUANTITY
,      COMPONENT_YIELD_FACTOR
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OLD_COMPONENT_SEQUENCE_ID
,      ITEM_NUM
,      WIP_SUPPLY_TYPE
,      SUPPLY_TYPE
,      COMPONENT_REMARKS
,      IMPLEMENTATION_DATE
,      IMPL_CB
,      DISABLE_DATE
,      ACD_TYPE
,      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
,      INCLUDE_ON_BILL_DOCS
,      LOW_QUANTITY
,      HIGH_QUANTITY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PICK_COMPONENTS
,      OPERATION_SEQ_NUM
,      SUPPLY_SUBINVENTORY
,      SUPPLY_LOCATOR_ID
,      SUPPLY_LOCATOR
,      REVISED_ITEM_SEQUENCE_ID
,      COST_FACTOR
,      CANCELLATION_DATE
,      CANCEL_COMMENTS
,      BOM_ITEM_TYPE
,      PRIMARY_UOM_CODE
,      COMPONENT_ITEM_NO
,      COMPONENT_ITEM_DESC
,      ENG_ITEM_FLAG
,      INVENTORY_ITEM_STATUS_CODE
,      SHIPPABLE_ITEM_FLAG
,      ITEM_LOCATOR_CONTROL
,      RESTRICT_LOCATORS_FLAG
,      RESTRICT_SUBINVENTORIES_FLAG
,      BASE_ITEM_ID
,      ITEM_TYPE
,      REPLENISH_TO_ORDER_FLAG
,      ATP_COMPONENTS_FLAG
,      PICK_COMPONENTS_FLAG
,      INVENTORY_ASSET_FLAG
,      ATP_FLAG
,      FORECAST_CONTROL
,      FROM_END_ITEM_UNIT_NUMBER
,      TO_END_ITEM_UNIT_NUMBER
,      ECO_FOR_PRODUCTION
,      ENFORCE_INT_REQUIREMENTS
,      ENFORCE_INT_REQUIREMENTS_DESC
,      ORIGINAL_SYSTEM_REFERENCE
,      OLD_OPERATION_SEQ_NUM
,      OLD_COMPONENT_QUANTITY
,      COMPONENT_ITEM_REVISION
FROM APPS.ENG_REVISED_COMPONENTS_ERV;

Dependencies

[top of page]

APPS.ENG_REVISED_COMPONENTS_ERV references the following:

APPS: BOM_BILL_OF_MATERIALS; BOM_INVENTORY_COMPONENTS; ENG_REVISED_COMPONENTS; ENG_REVISED_ITEMS; FND_COMMON_LOOKUPS; FND_GLOBAL - show dependent code; MFG_LOOKUPS; MTL_ITEM_LOCATIONS_KFV; MTL_ITEM_REVISIONS; MTL_SYSTEM_ITEMS_VL

APPS.ENG_REVISED_COMPONENTS_ERV is not referenced by any database object