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

TABLE: BOM.BOM_INVENTORY_COMPS_ARCHIVE

Object Details
Object Name: BOM_INVENTORY_COMPS_ARCHIVE
Object Type: TABLE
Owner: BOM
FND Design Data: TableBOM.BOM_INVENTORY_COMPS_ARCHIVE
Subobject Name:
Status: VALID


Used by Delete Group program to archive deleted components.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 35
PCT Used:
Columns
Name Datatype Length Mandatory Comments
OPERATION_SEQ_NUM NUMBER
Yes Operation sequence number
COMPONENT_ITEM_ID NUMBER
Yes Component item 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
ITEM_NUM NUMBER

Item sequence within bill of material structure
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
COMPONENT_REMARKS VARCHAR2 (240)
Component remarks
EFFECTIVITY_DATE DATE
Yes Effective date
CHANGE_NOTICE VARCHAR2 (10)
Engineering change order number
IMPLEMENTATION_DATE DATE

Date on which engineering change order was implemented
DISABLE_DATE DATE

Disable date
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
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
INCLUDE_ON_BILL_DOCS NUMBER

(not currently used)
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 affects
COMPONENT_SEQUENCE_ID NUMBER
Yes Component unique identifier
BILL_SEQUENCE_ID NUMBER
Yes Bill of material unique identifier
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
WIP_SUPPLY_TYPE NUMBER

WIP supply type code
PICK_COMPONENTS NUMBER

(not currently used)
SUPPLY_SUBINVENTORY VARCHAR2 (10)
Supply subinventory
SUPPLY_LOCATOR_ID NUMBER

Supply locator identifier
OPERATION_LEAD_TIME_PERCENT NUMBER

Operation offset from first operation in routing (Denormalized from corresponding column in BOM_OPERATION_SEQUNCES)
REVISED_ITEM_SEQUENCE_ID NUMBER

Engineering change order revised item identifier
COST_FACTOR NUMBER

(not currently used)
BOM_ITEM_TYPE NUMBER
Yes Type of item (denormalized from BOM Item Type in MTL_SYSTEM_ITEMS)
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

Indicates if this component on an Engineering Change Order is only for WIP jobs
COMPONENT_ITEM_REVISION_ID NUMBER

Item revision Identifier
DELETE_GROUP_NAME VARCHAR2 (10)
Delete group name for the entity type you are deleting
DG_DESCRIPTION VARCHAR2 (240)
Description of the delete group
ENFORCE_INT_REQUIREMENTS NUMBER

Enforce Integer Requirements
OPTIONAL_ON_MODEL NUMBER

Flag indicating if component is optional on model bill (for ATO)
PARENT_BILL_SEQ_ID NUMBER

Common bill sequence id of the 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)
FROM_BILL_REVISION_ID NUMBER

From Bill Revision Identifier
TO_BILL_REVISION_ID NUMBER

To Bill Revision Identifier
AUTO_REQUEST_MATERIAL VARCHAR2 (1)
Auto Request Material
SUGGESTED_VENDOR_NAME VARCHAR2 (240)
Suggested vendor name will be used for direct items for EAM BOMs
VENDOR_ID NUMBER

Suggested Vendor ID column
UNIT_PRICE NUMBER

Unit Price for direct items used by EAM BOMs
OBJ_NAME VARCHAR2 (30)
Object Name
PK1_VALUE VARCHAR2 (240)
Primary Key value
PK2_VALUE VARCHAR2 (240)
Primary Key value
PK3_VALUE VARCHAR2 (240)
Primary Key value
PK4_VALUE VARCHAR2 (240)
Primary Key value
PK5_VALUE VARCHAR2 (240)
Primary Key value
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_STRC_REV_ID NUMBER

From End Item Structure Revision Id
TO_END_ITEM_STRC_REV_ID NUMBER

To End Item Structure Revision Id
OVERLAPPING_CHANGES NUMBER

Overlapping Changes
FROM_END_ITEM_STRC_REV_CODE VARCHAR2 (30)
From end item structure revision code
TO_END_ITEM_STRC_REV_CODE VARCHAR2 (30)
To end item structure revision code
FROM_STRUCTURE_REVISION_CODE VARCHAR2 (30)
From structure revision code
TO_STRUCTURE_REVISION_CODE VARCHAR2 (30)
To structure revision code
FROM_MINOR_REVISION_ID NUMBER

From Minor Revision Id
TO_OBJECT_REVISION_ID NUMBER

To Object Revision Id
TO_MINOR_REVISION_ID NUMBER

To Minor Revision Id
FROM_END_ITEM_MINOR_REV_ID NUMBER

From End Item Minor Rev Id
TO_END_ITEM_MINOR_REV_ID NUMBER

To End Item Minor Rev Id
FROM_OBJECT_REVISION_ID NUMBER

From Object Revision Id
COMPONENT_MINOR_REVISION_ID NUMBER

Component Minor Revision Id
BASIS_TYPE NUMBER

Basis type identifier
COMMON_COMPONENT_SEQUENCE_ID NUMBER

Common Component Sequence Id
Query Text

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


SELECT OPERATION_SEQ_NUM
,      COMPONENT_ITEM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ITEM_NUM
,      COMPONENT_QUANTITY
,      COMPONENT_YIELD_FACTOR
,      COMPONENT_REMARKS
,      EFFECTIVITY_DATE
,      CHANGE_NOTICE
,      IMPLEMENTATION_DATE
,      DISABLE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      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
,      ACD_TYPE
,      OLD_COMPONENT_SEQUENCE_ID
,      COMPONENT_SEQUENCE_ID
,      BILL_SEQUENCE_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      WIP_SUPPLY_TYPE
,      PICK_COMPONENTS
,      SUPPLY_SUBINVENTORY
,      SUPPLY_LOCATOR_ID
,      OPERATION_LEAD_TIME_PERCENT
,      REVISED_ITEM_SEQUENCE_ID
,      COST_FACTOR
,      BOM_ITEM_TYPE
,      FROM_END_ITEM_UNIT_NUMBER
,      TO_END_ITEM_UNIT_NUMBER
,      ORIGINAL_SYSTEM_REFERENCE
,      ECO_FOR_PRODUCTION
,      COMPONENT_ITEM_REVISION_ID
,      DELETE_GROUP_NAME
,      DG_DESCRIPTION
,      ENFORCE_INT_REQUIREMENTS
,      OPTIONAL_ON_MODEL
,      PARENT_BILL_SEQ_ID
,      MODEL_COMP_SEQ_ID
,      PLAN_LEVEL
,      FROM_BILL_REVISION_ID
,      TO_BILL_REVISION_ID
,      AUTO_REQUEST_MATERIAL
,      SUGGESTED_VENDOR_NAME
,      VENDOR_ID
,      UNIT_PRICE
,      OBJ_NAME
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      FROM_END_ITEM_REV_ID
,      TO_END_ITEM_REV_ID
,      FROM_END_ITEM_STRC_REV_ID
,      TO_END_ITEM_STRC_REV_ID
,      OVERLAPPING_CHANGES
,      FROM_END_ITEM_STRC_REV_CODE
,      TO_END_ITEM_STRC_REV_CODE
,      FROM_STRUCTURE_REVISION_CODE
,      TO_STRUCTURE_REVISION_CODE
,      FROM_MINOR_REVISION_ID
,      TO_OBJECT_REVISION_ID
,      TO_MINOR_REVISION_ID
,      FROM_END_ITEM_MINOR_REV_ID
,      TO_END_ITEM_MINOR_REV_ID
,      FROM_OBJECT_REVISION_ID
,      COMPONENT_MINOR_REVISION_ID
,      BASIS_TYPE
,      COMMON_COMPONENT_SEQUENCE_ID
FROM BOM.BOM_INVENTORY_COMPS_ARCHIVE;

Dependencies

[top of page]

BOM.BOM_INVENTORY_COMPS_ARCHIVE does not reference any database object

BOM.BOM_INVENTORY_COMPS_ARCHIVE is referenced by following:

SchemaAPPS
SynonymBOM_INVENTORY_COMPS_ARCHIVE