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

TABLE: ENG.ENG_REVISED_COMPONENTS

Object Details
Object Name: ENG_REVISED_COMPONENTS
Object Type: TABLE
Owner: ENG
FND Design Data: TableENG.ENG_REVISED_COMPONENTS
Subobject Name:
Status: VALID


ENG_REVISED_COMPONENTS stores information about the implemented and
cancelled revised components on an engineering change order. When an
ECO or revised item is implemented or cancelled, the revised component
records in BOM_INVENTORY_COMPONENTS are copied into
ENG_REVISED_COMPONENTS to maintain a history of the ECO.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ENG_REVISED_COMPONENTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCOMPONENT_SEQUENCE_ID
ENG_REVISED_COMPONENTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCHANGE_NOTICE
ColumnBILL_SEQUENCE_ID
ENG_REVISED_COMPONENTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCOMPONENT_ITEM_ID
ENG_REVISED_COMPONENTS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnREVISED_ITEM_SEQUENCE_ID
Columns
Name Datatype Length Mandatory Comments
COMPONENT_SEQUENCE_ID NUMBER
Yes Component unique identifier
COMPONENT_ITEM_ID NUMBER
Yes Component item identifier
OPERATION_SEQUENCE_NUM NUMBER
Yes Operation sequence number
BILL_SEQUENCE_ID NUMBER
Yes Bill of material unique identifier
CHANGE_NOTICE VARCHAR2 (10) Yes Engineering change order number
EFFECTIVITY_DATE DATE
Yes Effective date
COMPONENT_QUANTITY NUMBER
Yes Quantity of component in bill of material
COMPONENT_YIELD_FACTOR NUMBER
Yes Factor used to multiply component quantity with to obtain required component quantity
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
CANCELLATION_DATE DATE

Date when the ECO, revised item, or revised component was cancelled
CANCEL_COMMENTS VARCHAR2 (240)
Cancellation comments
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
COMPONENT_REMARKS VARCHAR2 (240)
Component comments
SUPPLY_SUBINVENTORY VARCHAR2 (10)
Supply subinventory
SUPPLY_LOCATOR_ID NUMBER

Supply locator identifier
IMPLEMENTATION_DATE DATE

Date on which engineering change order was implemented
DISABLE_DATE DATE

Disable date
ACD_TYPE NUMBER

Code indicating whether component is being added, changed, or disabled
PLANNING_FACTOR NUMBER
Yes Factor used to multiply component quantity with to obtain required planning quantity
QUANTITY_RELATED NUMBER
Yes Code to indicate if this component has quantity related reference designators
SO_BASIS NUMBER

Quantity basis used by Oracle Order Management to overide the default quantity for an option class in a sales order
OPTIONAL NUMBER

Flag indicating if component is optional in bill
MUTUALLY_EXCLUSIVE_OPTIONS NUMBER

Flag indicating if one or more children of a 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
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)
REVISED_ITEM_SEQUENCE_ID NUMBER

Engineering change order revised item identifier
COST_FACTOR NUMBER

(not currently used)
FROM_END_ITEM_UNIT_NUMBER VARCHAR2 (30)
From End Item Unit Number
TO_END_ITEM_UNIT_NUMBER VARCHAR2 (30)
To End Item Unit Number
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)
Original system that data for the current record has come from.
ECO_FOR_PRODUCTION NUMBER

WIP Only ECO
ENFORCE_INT_REQUIREMENTS NUMBER

Enforce internal requirements
OPTIONAL_ON_MODEL NUMBER

OPTIONAL_ON_MODELS
PLAN_LEVEL NUMBER

Plan level
AUTO_REQUEST_MATERIAL VARCHAR2 (1)
Autorequest material
FROM_OBJECT_REVISION_ID NUMBER

From object revision id
TO_OBJECT_REVISION_ID NUMBER

To object revision id
COMPONENT_ITEM_REVISION_ID NUMBER

Component item revision id
VENDOR_ID NUMBER

Supplier id
SUGGESTED_VENDOR_NAME VARCHAR2 (240)
Suggested vendor name
UNIT_PRICE NUMBER

Unit price
FROM_END_ITEM_REV_ID NUMBER

From end item revision id
TO_END_ITEM_REV_ID NUMBER

To end item revision id
FROM_END_ITEM_MINOR_REV_ID NUMBER

From end item minor revision id
TO_END_ITEM_MINOR_REV_ID NUMBER

To end item minor revision id
MODEL_COMP_SEQ_ID NUMBER

Model component sequence id
PARENT_BILL_SEQ_ID NUMBER

Parent bill of material sequence id
BASIS_TYPE NUMBER

Basis type
COMMON_COMPONENT_SEQUENCE_ID NUMBER

Common component sequence id
Query Text

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


SELECT COMPONENT_SEQUENCE_ID
,      COMPONENT_ITEM_ID
,      OPERATION_SEQUENCE_NUM
,      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
,      CANCELLATION_DATE
,      CANCEL_COMMENTS
,      OLD_COMPONENT_SEQUENCE_ID
,      ITEM_NUM
,      WIP_SUPPLY_TYPE
,      COMPONENT_REMARKS
,      SUPPLY_SUBINVENTORY
,      SUPPLY_LOCATOR_ID
,      IMPLEMENTATION_DATE
,      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
,      REVISED_ITEM_SEQUENCE_ID
,      COST_FACTOR
,      FROM_END_ITEM_UNIT_NUMBER
,      TO_END_ITEM_UNIT_NUMBER
,      ORIGINAL_SYSTEM_REFERENCE
,      ECO_FOR_PRODUCTION
,      ENFORCE_INT_REQUIREMENTS
,      OPTIONAL_ON_MODEL
,      PLAN_LEVEL
,      AUTO_REQUEST_MATERIAL
,      FROM_OBJECT_REVISION_ID
,      TO_OBJECT_REVISION_ID
,      COMPONENT_ITEM_REVISION_ID
,      VENDOR_ID
,      SUGGESTED_VENDOR_NAME
,      UNIT_PRICE
,      FROM_END_ITEM_REV_ID
,      TO_END_ITEM_REV_ID
,      FROM_END_ITEM_MINOR_REV_ID
,      TO_END_ITEM_MINOR_REV_ID
,      MODEL_COMP_SEQ_ID
,      PARENT_BILL_SEQ_ID
,      BASIS_TYPE
,      COMMON_COMPONENT_SEQUENCE_ID
FROM ENG.ENG_REVISED_COMPONENTS;

Dependencies

[top of page]

ENG.ENG_REVISED_COMPONENTS does not reference any database object

ENG.ENG_REVISED_COMPONENTS is referenced by following:

SchemaAPPS
SynonymENG_REVISED_COMPONENTS