[Home] [Help] [Dependency Information]
Object Name: | BOM_BILL_OF_MTLS_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | BOM |
FND Design Data: | BOM.BOM_BILL_OF_MTLS_INTERFACE |
Subobject Name: | |
Status: | VALID |
BOM_BILL_OF_MTLS_INTERFACE temporarily stores bills of material
before loading information into Oracle Bills of Material. This
table contains user friendly columns which allow you to easily enter
your data as well as their corresponding foreign keys. Oracle Bills
of Material will derive column values you do not enter, after
performing the proper validation. For example, you enter the
ORGANIZATION_CODE and Oracle Bills of Material will fill in the
corresponding ORGANIZATION_ID for you.
.
Also, if you enter REVISION, Oracle Bills of Material will insert a
record into MTL_ITEM_REVISIONS for your bill item.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BOM_BILL_OF_MTLS_INTERFACE_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | TRANSACTION_ID |
BOM_BILL_OF_MTLS_INTERFACE_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
ASSEMBLY_ITEM_ID
ORGANIZATION_ID ALTERNATE_BOM_DESIGNATOR |
BOM_BILL_OF_MTLS_INTERFACE_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | BILL_SEQUENCE_ID |
BOM_BILL_OF_MTLS_INTERFACE_N3 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | COMMON_BILL_SEQUENCE_ID |
BOM_BILL_OF_MTLS_INTERFACE_N4 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | SET_ID |
BOM_BILL_OF_MTLS_INTERFACE_N5 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
PROCESS_FLAG
ORGANIZATION_ID TRANSACTION_ID |
BOM_BILL_OF_MTLS_INTERFACE_N6 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
ITEM_NUMBER
ORGANIZATION_CODE ALTERNATE_BOM_DESIGNATOR |
BOM_BILL_OF_MTLS_INTERFACE_N7 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
BATCH_ID
SOURCE_SYSTEM_REFERENCE PROCESS_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSEMBLY_ITEM_ID | NUMBER | Inventory item identifier of manufactured assembly | ||
ORGANIZATION_ID | NUMBER | Organization identifier | ||
ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | (10) | Alternate designator code | |
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 | ||
COMMON_ASSEMBLY_ITEM_ID | NUMBER | Inventory item identifier of common assembly | ||
SPECIFIC_ASSEMBLY_COMMENT | VARCHAR2 | (240) | Specific bill of material comment | |
PENDING_FROM_ECN | VARCHAR2 | (10) | Change notice that created this bill | |
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 | |
ASSEMBLY_TYPE | NUMBER | Assembly Type: 1=Manufacturing bill 2=Engineering bill | ||
COMMON_BILL_SEQUENCE_ID | NUMBER | Unique bill identifier for common bill | ||
BILL_SEQUENCE_ID | NUMBER | 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 | ||
DEMAND_SOURCE_LINE | VARCHAR2 | (30) | Demand source line - used for ATO | |
SET_ID | VARCHAR2 | (10) | Set identifier - used for ATO | |
COMMON_ORGANIZATION_ID | NUMBER | Organization identifier of common organization | ||
DEMAND_SOURCE_TYPE | NUMBER | Demand source type - used for ATO | ||
DEMAND_SOURCE_HEADER_ID | NUMBER | Demand source header identifier - used for ATO | ||
TRANSACTION_ID | NUMBER | Row identifier | ||
PROCESS_FLAG | NUMBER | Row status | ||
ORGANIZATION_CODE | VARCHAR2 | (3) | Abbreviation of organization name | |
COMMON_ORG_CODE | VARCHAR2 | (3) | Abbreviation of common organization name | |
ITEM_NUMBER | VARCHAR2 | (240) | Concatenated bill item segments | |
COMMON_ITEM_NUMBER | VARCHAR2 | (240) | Concatenated common bill item segments | |
NEXT_EXPLODE_DATE | DATE | Next date when pre-explosion will be refreshed | ||
REVISION | VARCHAR2 | (3) | Bill revision | |
TRANSACTION_TYPE | VARCHAR2 | (10) | Type of action: CREATE, UPDATE, or DELETE | |
DELETE_GROUP_NAME | VARCHAR2 | (10) | Delete group name for the entity type you are deleting | |
DG_DESCRIPTION | VARCHAR2 | (240) | Description of the delete group | |
ORIGINAL_SYSTEM_REFERENCE | VARCHAR2 | (50) | Original system that data for the current record has come from. | |
IMPLEMENTATION_DATE | DATE | Implementation Date | ||
OBJ_NAME | VARCHAR2 | (30) | Object name | |
PK1_VALUE | VARCHAR2 | (240) | Primary key of the object | |
PK2_VALUE | VARCHAR2 | (240) | Primary key of the object | |
PK3_VALUE | VARCHAR2 | (240) | Primary key of the object | |
PK4_VALUE | VARCHAR2 | (240) | Primary key of the object | |
PK5_VALUE | VARCHAR2 | (240) | Primary key of the object | |
STRUCTURE_TYPE_NAME | VARCHAR2 | (80) | Structure type name | |
STRUCTURE_TYPE_ID | NUMBER | Structure type identifier | ||
EFFECTIVITY_CONTROL | NUMBER | Effectivity control | ||
RETURN_STATUS | VARCHAR2 | (1) | Return status | |
IS_PREFERRED | VARCHAR2 | (1) | Determines whether this structure is preferred or not. | |
SOURCE_SYSTEM_REFERENCE | VARCHAR2 | (240) | Source system item name for import | |
SOURCE_SYSTEM_REFERENCE_DESC | VARCHAR2 | (240) | Source system reference description | |
BATCH_ID | NUMBER | Batch Identifier for Data Load | ||
CHANGE_ID | NUMBER | Change Identifier | ||
CATALOG_CATEGORY_NAME | VARCHAR2 | (240) | Item Catalog Category Name | |
ITEM_CATALOG_GROUP_ID | NUMBER | Item Catalog Category Identifier | ||
PRIMARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | Primary unit of measure | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description | |
TEMPLATE_NAME | VARCHAR2 | (240) | Item Template Name | |
SOURCE_BILL_SEQUENCE_ID | NUMBER | Source bill sequence id | ||
ENABLE_ATTRS_UPDATE | VARCHAR2 | (1) | Indicates whether attributes of a Common BOM need to be updated. Possible values are 'Y'/'N'. | |
INTERFACE_TABLE_UNIQUE_ID | NUMBER | Interface Table Unique Id for Merge | ||
BUNDLE_ID | NUMBER | Bundle Id |
Cut, paste (and edit) the following text to query this object:
SELECT ASSEMBLY_ITEM_ID
, ORGANIZATION_ID
, ALTERNATE_BOM_DESIGNATOR
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, COMMON_ASSEMBLY_ITEM_ID
, SPECIFIC_ASSEMBLY_COMMENT
, PENDING_FROM_ECN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ASSEMBLY_TYPE
, COMMON_BILL_SEQUENCE_ID
, BILL_SEQUENCE_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, DEMAND_SOURCE_LINE
, SET_ID
, COMMON_ORGANIZATION_ID
, DEMAND_SOURCE_TYPE
, DEMAND_SOURCE_HEADER_ID
, TRANSACTION_ID
, PROCESS_FLAG
, ORGANIZATION_CODE
, COMMON_ORG_CODE
, ITEM_NUMBER
, COMMON_ITEM_NUMBER
, NEXT_EXPLODE_DATE
, REVISION
, TRANSACTION_TYPE
, DELETE_GROUP_NAME
, DG_DESCRIPTION
, ORIGINAL_SYSTEM_REFERENCE
, IMPLEMENTATION_DATE
, OBJ_NAME
, PK1_VALUE
, PK2_VALUE
, PK3_VALUE
, PK4_VALUE
, PK5_VALUE
, STRUCTURE_TYPE_NAME
, STRUCTURE_TYPE_ID
, EFFECTIVITY_CONTROL
, RETURN_STATUS
, IS_PREFERRED
, SOURCE_SYSTEM_REFERENCE
, SOURCE_SYSTEM_REFERENCE_DESC
, BATCH_ID
, CHANGE_ID
, CATALOG_CATEGORY_NAME
, ITEM_CATALOG_GROUP_ID
, PRIMARY_UNIT_OF_MEASURE
, ITEM_DESCRIPTION
, TEMPLATE_NAME
, SOURCE_BILL_SEQUENCE_ID
, ENABLE_ATTRS_UPDATE
, INTERFACE_TABLE_UNIQUE_ID
, BUNDLE_ID
FROM BOM.BOM_BILL_OF_MTLS_INTERFACE;
BOM.BOM_BILL_OF_MTLS_INTERFACE does not reference any database object
BOM.BOM_BILL_OF_MTLS_INTERFACE is referenced by following:
|
|
|