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

TABLE: BOM.BOM_COMP_OPTIONS_TEMP

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


BOM_COMP_OPTIONS_TEMP temporarily stores information about
bill of material components.
This table contains user friendly columns which allow you to easily
enter your data as well as their corresponding foreign keys.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BOM_COMP_OPTIONS_TEMP_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnTRANSACTION_ID
BOM_COMP_OPTIONS_TEMP_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnTRANSACTION_GROUP_ID
ColumnTRANSACTION_ID
ColumnASSEMBLY_ITEM_NAME
ColumnORGANIZATION_CODE
ColumnALTERNATE_BOM_CODE
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_GROUP_ID NUMBER

Transaction group identifier
TRANSACTION_ID NUMBER

Transaction identifier
ASSEMBLY_ITEM_NAME VARCHAR2 (81)
Concatenated bill item segments
ORGANIZATION_CODE VARCHAR2 (3)
Organization code
ALTERNATE_BOM_CODE VARCHAR2 (10)
Alternate designator code
START_EFFECTIVE_DATE DATE

Effective date
COMPONENT_ITEM_NAME VARCHAR2 (81)
Concatenated component item segments
OPERATION_SEQUENCE_NUMBER NUMBER

Operation sequence number
ITEM_SEQUENCE_NUMBER NUMBER

Item sequence within bill of material structure
DISABLE_DATE DATE

Disable date
SUPPLY_SUBINVENTORY VARCHAR2 (10)
Supply subinventory
LOCATION_NAME VARCHAR2 (81)
Supply location name
PLANNING_PERCENT NUMBER

Factor used to multiply component quantity with to obtain planning quantity
REQUIRED_FOR_REVENUE NUMBER

Flag indicating if component is required for revenue
REQUIRED_TO_SHIP NUMBER

Flag indicating if component is required to ship
MINIMUM_ALLOWED_QUANTITY NUMBER

Minimum quantity allowed on an order
MAXIMUM_ALLOWED_QUANTITY NUMBER

Maximum quantity allowed on an order
WIP_SUPPLY_TYPE NUMBER

WIP supply type code
QUANTITY_PER_ASSEMBLY NUMBER

Quantity of component in bill of material
PROJECTED_YIELD NUMBER

Factor used to multiply component quantity to obtain required component quantity
COMMENTS VARCHAR2 (240)
Component remarks
QUANTITY_RELATED NUMBER

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 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
INCLUDE_ON_SHIP_DOCS NUMBER

Flag indicating if component is displayed on shipping documents
NEW_EFFECTIVITY_DATE DATE

Updated value for the effectivity_date
NEW_OPERATION_SEQUENCE_NUMBER NUMBER

Updated value for the operation_seq_num
FROM_END_ITEM_UNIT_NUMBER VARCHAR2 (30)
From End Item Unit Number
TO_END_ITEM_UNIT_NUMBER VARCHAR2 (30)
To End Item Unit Number
TRANSACTION_TYPE VARCHAR2 (10)
Type of action: CREATE, UPDATE or DELETE
RETURN_STATUS VARCHAR2 (1)
Return Status
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
DELETE_GROUP_NAME VARCHAR2 (10)
Delete group name
DG_DESCRIPTION VARCHAR2 (240)
Delete group description
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)
Original system that data for the current record has come from.
Query Text

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


SELECT TRANSACTION_GROUP_ID
,      TRANSACTION_ID
,      ASSEMBLY_ITEM_NAME
,      ORGANIZATION_CODE
,      ALTERNATE_BOM_CODE
,      START_EFFECTIVE_DATE
,      COMPONENT_ITEM_NAME
,      OPERATION_SEQUENCE_NUMBER
,      ITEM_SEQUENCE_NUMBER
,      DISABLE_DATE
,      SUPPLY_SUBINVENTORY
,      LOCATION_NAME
,      PLANNING_PERCENT
,      REQUIRED_FOR_REVENUE
,      REQUIRED_TO_SHIP
,      MINIMUM_ALLOWED_QUANTITY
,      MAXIMUM_ALLOWED_QUANTITY
,      WIP_SUPPLY_TYPE
,      QUANTITY_PER_ASSEMBLY
,      PROJECTED_YIELD
,      COMMENTS
,      QUANTITY_RELATED
,      SO_BASIS
,      OPTIONAL
,      MUTUALLY_EXCLUSIVE
,      INCLUDE_IN_COST_ROLLUP
,      CHECK_ATP
,      SHIPPING_ALLOWED
,      INCLUDE_ON_SHIP_DOCS
,      NEW_EFFECTIVITY_DATE
,      NEW_OPERATION_SEQUENCE_NUMBER
,      FROM_END_ITEM_UNIT_NUMBER
,      TO_END_ITEM_UNIT_NUMBER
,      TRANSACTION_TYPE
,      RETURN_STATUS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DELETE_GROUP_NAME
,      DG_DESCRIPTION
,      ORIGINAL_SYSTEM_REFERENCE
FROM BOM.BOM_COMP_OPTIONS_TEMP;

Dependencies

[top of page]

BOM.BOM_COMP_OPTIONS_TEMP does not reference any database object

BOM.BOM_COMP_OPTIONS_TEMP is referenced by following:

SchemaAPPS
SynonymBOM_COMP_OPTIONS_TEMP