[Home] [Help] [Dependency Information]
Object Name: | BOM_INV_COMPONENTS_TEMP |
---|---|
Object Type: | TABLE |
Owner: | BOM |
FND Design Data: | BOM.BOM_INV_COMPONENTS_TEMP |
Subobject Name: | |
Status: | VALID |
BOM_INV_COMPONENTS_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.
This table is for future use.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BOM_INV_COMPONENTS_TEMP_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | TRANSACTION_ID |
BOM_INV_COMPONENTS_TEMP_N3 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
TRANSACTION_GROUP_ID
TRANSACTION_ID ASSEMBLY_ITEM_NAME ORGANIZATION_CODE ALTERNATE_BOM_CODE |
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. |
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_INV_COMPONENTS_TEMP;
BOM.BOM_INV_COMPONENTS_TEMP does not reference any database object
BOM.BOM_INV_COMPONENTS_TEMP is referenced by following:
|
|
|