[Home] [Help] [Dependency Information]
Object Name: | BOM_OP_SEQUENCES_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | BOM |
FND Design Data: | BOM.BOM_OP_SEQUENCES_INTERFACE |
Subobject Name: | |
Status: | VALID |
BOM_OP_SEQUENCES_INTERFACE temporarily stores information about
routing operations. 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, you can enter ASSEMBLY_ITEM_ID, ORGANIZATION_ID and
ALTERNATE_ROUTING_DESIGNATOR instead of ROUTING_SEQUENCE_ID. Oracle
Bills of Material will fill in the corresponding ROUTING_SEQUENCE_ID.
.
In addition, you can enter three resources and three instructions for
each operation sequence. Oracle Bills of Material will insert these
records into the tables, BOM_OPERATION_RESOURCES and
BOM_OPERATION_INSTRUCTIONS, respectively.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BOM_OP_SEQUENCES_INTERFACE_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | TRANSACTION_ID |
BOM_OP_SEQUENCES_INTERFACE_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | OPERATION_SEQUENCE_ID |
BOM_OP_SEQUENCES_INTERFACE_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
ASSEMBLY_ITEM_ID
ORGANIZATION_ID ALTERNATE_ROUTING_DESIGNATOR |
BOM_OP_SEQUENCES_INTERFACE_N3 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
ROUTING_SEQUENCE_ID
OPERATION_SEQ_NUM EFFECTIVITY_DATE |
BOM_OP_SEQUENCES_INTERFACE_N4 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
ASSEMBLY_ITEM_NUMBER
ORGANIZATION_ID |
BOM_OP_SEQUENCES_INTERFACE_N5 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | ENG_CHANGES_IFCE_KEY |
BOM_OP_SEQUENCES_INTERFACE_N6 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
ASSEMBLY_ITEM_NUMBER
ORGANIZATION_CODE ALTERNATE_ROUTING_DESIGNATOR |
BOM_OP_SEQUENCES_INTERFACE_N7 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
PROCESS_FLAG
ORGANIZATION_ID TRANSACTION_ID |
BOM_OP_SEQUENCES_INTERFACE_N9 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | BATCH_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OPERATION_SEQUENCE_ID | NUMBER | Routing operation unique identifier | ||
ROUTING_SEQUENCE_ID | NUMBER | Routing unique identifier | ||
OPERATION_SEQ_NUM | NUMBER | Operation sequence number | ||
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 | ||
STANDARD_OPERATION_ID | NUMBER | Standard operation unique identifier | ||
DEPARTMENT_ID | NUMBER | Department unique identifier | ||
OPERATION_LEAD_TIME_PERCENT | NUMBER | Indicates the amount of overlap lead time this has with the parent's lead time | ||
RUN_TIME_OVERLAP_PERCENT | NUMBER | Not currently used | ||
MINIMUM_TRANSFER_QUANTITY | NUMBER | Minimum operation transfer quantity | ||
COUNT_POINT_TYPE | NUMBER | Count point | ||
OPERATION_DESCRIPTION | VARCHAR2 | (240) | Description of operation | |
EFFECTIVITY_DATE | DATE | Date operation is effective | ||
CHANGE_NOTICE | VARCHAR2 | (10) | Not currently used | |
IMPLEMENTATION_DATE | DATE | Not currently used | ||
DISABLE_DATE | DATE | Date operation is no longer effective - effectivity lasts until the end of the disable date | ||
BACKFLUSH_FLAG | NUMBER | Indicates whether operation requires backflushing | ||
OPTION_DEPENDENT_FLAG | NUMBER | Indicates whether to use this operation in all configuration routings, even if no components of the configuration are used in this routing | ||
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 | ||
MODEL_OP_SEQ_ID | NUMBER | Operation sequence identifier from model bill | ||
ASSEMBLY_ITEM_ID | NUMBER | Inventory item identifier of manufactured assembly | ||
ORGANIZATION_ID | NUMBER | Organization identifier | ||
ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | (10) | Alternate designator code | |
ORGANIZATION_CODE | VARCHAR2 | (3) | Abbreviation of organization name | |
ASSEMBLY_ITEM_NUMBER | VARCHAR2 | (240) | Concatenated item segments | |
DEPARTMENT_CODE | VARCHAR2 | (10) | Department name | |
OPERATION_CODE | VARCHAR2 | (4) | Standard operation code | |
RESOURCE_ID1 | NUMBER | First resource identifier | ||
RESOURCE_ID2 | NUMBER | Second resource identifier | ||
RESOURCE_ID3 | NUMBER | Third resource identifier | ||
RESOURCE_CODE1 | VARCHAR2 | (10) | First resource name | |
RESOURCE_CODE2 | VARCHAR2 | (10) | Second resource name | |
RESOURCE_CODE3 | VARCHAR2 | (10) | Third resource name | |
INSTRUCTION_CODE1 | VARCHAR2 | (10) | First standard instruction code | |
INSTRUCTION_CODE2 | VARCHAR2 | (10) | Second standard instruction code | |
INSTRUCTION_CODE3 | VARCHAR2 | (10) | Third standard instruction code | |
TRANSACTION_ID | NUMBER | Row identifier | ||
PROCESS_FLAG | NUMBER | Row status | ||
TRANSACTION_TYPE | VARCHAR2 | (10) | Create, Update or Delete | |
NEW_OPERATION_SEQ_NUM | NUMBER | Added to facilitate updates because it's part of the primary key | ||
NEW_EFFECTIVITY_DATE | DATE | Added to facilitate updates because it's part of the primary key | ||
ASSEMBLY_TYPE | NUMBER | Not used in open interface | ||
OPERATION_TYPE | NUMBER | Operation Type: process, line operation, or event | ||
REFERENCE_FLAG | NUMBER | If the Standard Operation is referenced or copied then the operation can not be updated | ||
PROCESS_OP_SEQ_ID | NUMBER | Operation sequence identifier of parent process (only applies to events) | ||
LINE_OP_SEQ_ID | NUMBER | Operation sequence identifier of the parent line operation (only applies to events) | ||
YIELD | NUMBER | Process yield at this operation | ||
CUMULATIVE_YIELD | NUMBER | Cumulative process yield from begining of routing to this operation | ||
REVERSE_CUMULATIVE_YIELD | NUMBER | Cumulative process yield from end of routing to comparable operation. For example, if this is the second operation out of 10 operations, the reverse cumulative yield would be the total yield from the tenth down to the ninth operation | ||
LABOR_TIME_CALC | NUMBER | System calculated run time attributable to labor | ||
MACHINE_TIME_CALC | NUMBER | System calculated run time attributable to machines | ||
TOTAL_TIME_CALC | NUMBER | System calculated run time attributable to both labor and machines | ||
LABOR_TIME_USER | NUMBER | User calculated run time attributable to labor | ||
MACHINE_TIME_USER | NUMBER | User calculated run time attributable to machines | ||
TOTAL_TIME_USER | NUMBER | User calculated run time attributable to both labor and machines | ||
NET_PLANNING_PERCENT | NUMBER | Cumulative planning percents derived from the operation network | ||
INCLUDE_IN_ROLLUP | NUMBER | Indicates whether operation yield is to be considered in cost rollup | ||
OPERATION_YIELD_ENABLED | NUMBER | Indicates whether operation yield is to be considered during costing. | ||
PROCESS_SEQ_NUMBER | NUMBER | Operation sequence identifier of parent process (applies only to events) | ||
PROCESS_CODE | VARCHAR2 | (4) | Parent process code (applies only to events) | |
LINE_OP_SEQ_NUMBER | NUMBER | Operation sequence identifier of the parent line operation - only applies to events | ||
LINE_OP_CODE | VARCHAR2 | (4) | Code of the parent line operation - only applies to events | |
ORIGINAL_SYSTEM_REFERENCE | VARCHAR2 | (50) | Original System Reference for the current record has come from | |
SHUTDOWN_TYPE | VARCHAR2 | (30) | Shutdown type | |
LONG_DESCRIPTION | VARCHAR2 | (4000) | Used by EAM routings | |
DELETE_GROUP_NAME | VARCHAR2 | (10) | Delete Group Name | |
DG_DESCRIPTION | VARCHAR2 | (240) | Delete Group Description | |
NEW_ROUTING_REVISION | VARCHAR2 | (3) | New Routing Revision | |
ACD_TYPE | NUMBER | ACD type | ||
OLD_START_EFFECTIVE_DATE | DATE | Old Effectivity Date | ||
CANCEL_COMMENTS | VARCHAR2 | (240) | Cancellation Comment | |
ENG_CHANGES_IFCE_KEY | NUMBER | Engineering changes IFCE key | ||
ENG_REVISED_ITEMS_IFCE_KEY | NUMBER | Engineering revised item IFCE key | ||
BOM_REV_OP_IFCE_KEY | NUMBER | BOM Rev operation IFCE key | ||
NEW_REVISED_ITEM_REVISION | VARCHAR2 | (3) | This column is used by the ECO BO for holding the information about the new revised item revision | |
BATCH_ID | NUMBER | BATCH_ID |
Cut, paste (and edit) the following text to query this object:
SELECT OPERATION_SEQUENCE_ID
, ROUTING_SEQUENCE_ID
, OPERATION_SEQ_NUM
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, STANDARD_OPERATION_ID
, DEPARTMENT_ID
, OPERATION_LEAD_TIME_PERCENT
, RUN_TIME_OVERLAP_PERCENT
, MINIMUM_TRANSFER_QUANTITY
, COUNT_POINT_TYPE
, OPERATION_DESCRIPTION
, EFFECTIVITY_DATE
, CHANGE_NOTICE
, IMPLEMENTATION_DATE
, DISABLE_DATE
, BACKFLUSH_FLAG
, OPTION_DEPENDENT_FLAG
, 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
, MODEL_OP_SEQ_ID
, ASSEMBLY_ITEM_ID
, ORGANIZATION_ID
, ALTERNATE_ROUTING_DESIGNATOR
, ORGANIZATION_CODE
, ASSEMBLY_ITEM_NUMBER
, DEPARTMENT_CODE
, OPERATION_CODE
, RESOURCE_ID1
, RESOURCE_ID2
, RESOURCE_ID3
, RESOURCE_CODE1
, RESOURCE_CODE2
, RESOURCE_CODE3
, INSTRUCTION_CODE1
, INSTRUCTION_CODE2
, INSTRUCTION_CODE3
, TRANSACTION_ID
, PROCESS_FLAG
, TRANSACTION_TYPE
, NEW_OPERATION_SEQ_NUM
, NEW_EFFECTIVITY_DATE
, ASSEMBLY_TYPE
, OPERATION_TYPE
, REFERENCE_FLAG
, PROCESS_OP_SEQ_ID
, LINE_OP_SEQ_ID
, YIELD
, CUMULATIVE_YIELD
, REVERSE_CUMULATIVE_YIELD
, LABOR_TIME_CALC
, MACHINE_TIME_CALC
, TOTAL_TIME_CALC
, LABOR_TIME_USER
, MACHINE_TIME_USER
, TOTAL_TIME_USER
, NET_PLANNING_PERCENT
, INCLUDE_IN_ROLLUP
, OPERATION_YIELD_ENABLED
, PROCESS_SEQ_NUMBER
, PROCESS_CODE
, LINE_OP_SEQ_NUMBER
, LINE_OP_CODE
, ORIGINAL_SYSTEM_REFERENCE
, SHUTDOWN_TYPE
, LONG_DESCRIPTION
, DELETE_GROUP_NAME
, DG_DESCRIPTION
, NEW_ROUTING_REVISION
, ACD_TYPE
, OLD_START_EFFECTIVE_DATE
, CANCEL_COMMENTS
, ENG_CHANGES_IFCE_KEY
, ENG_REVISED_ITEMS_IFCE_KEY
, BOM_REV_OP_IFCE_KEY
, NEW_REVISED_ITEM_REVISION
, BATCH_ID
FROM BOM.BOM_OP_SEQUENCES_INTERFACE;
BOM.BOM_OP_SEQUENCES_INTERFACE does not reference any database object
BOM.BOM_OP_SEQUENCES_INTERFACE is referenced by following:
|
|
|