[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | BOM_SUB_OP_RESOURCES_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | BOM |
| FND Design Data: |  BOM.BOM_SUB_OP_RESOURCES_INTERFACE
|
| Subobject Name: | |
| Status: | VALID |
BOM_SUB_OP_RESOURCES_INTERFACE temporarily stores information about
substitute resources that may be required to complete operations on routings. 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 ROUTING_SEQUENCE_ID, OPERATION_SEQ_NUM, and
EFFECTIVITY_DATE instead of OPERATION_SEQUENCE_ID. Oracle Bills of
Material will fill in the corresponding OPERATION_SEQUENCE_ID.
.
In addition, 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.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| BOM_SUB_OP_RESOURCES_INTFC_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
 BATCH_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| OPERATION_SEQUENCE_ID | NUMBER | Routing operation unique identifier | ||
| SUBSTITUTE_GROUP_NUM | NUMBER | Resource sequence number | ||
| SCHEDULE_SEQ_NUM | NUMBER | Schedule sequence number | ||
| REPLACEMENT_GROUP_NUM | NUMBER | Replacement group number | ||
| RESOURCE_ID | NUMBER | Resource unique identifier | ||
| ACTIVITY_ID | NUMBER | Activity identifier | ||
| OPERATION_TYPE | NUMBER | Process, Line Operation or Event | ||
| STANDARD_RATE_FLAG | NUMBER | Use standard rate for shop floor transactions | ||
| ASSIGNED_UNITS | NUMBER | Resource units assigned | ||
| USAGE_RATE_OR_AMOUNT | NUMBER | Resource usage rate | ||
| USAGE_RATE_OR_AMOUNT_INVERSE | NUMBER | Resource usage rate inverse | ||
| BASIS_TYPE | NUMBER | Basis type identifier | ||
| SCHEDULE_FLAG | NUMBER | Schedule the resource | ||
| 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 | ||
| RESOURCE_OFFSET_PERCENT | NUMBER | Resource offset percent from the start of the routing | ||
| AUTOCHARGE_TYPE | NUMBER | Autocharge type for shop floor moves | ||
| 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 | ||
| ASSEMBLY_ITEM_ID | NUMBER | Inventory item identifier of manufactured assembly | ||
| ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | (10) | Alternate designator code | |
| ORGANIZATION_ID | NUMBER | Organization identifier | ||
| OPERATION_SEQ_NUM | NUMBER | Operation sequence number | ||
| EFFECTIVITY_DATE | DATE | Effective date | ||
| ROUTING_SEQUENCE_ID | NUMBER | Routing unique identifier | ||
| ORGANIZATION_CODE | VARCHAR2 | (3) | Abbreviation of organization name | |
| ASSEMBLY_ITEM_NUMBER | VARCHAR2 | (240) | Concatenated item segments | |
| SUB_RESOURCE_CODE | VARCHAR2 | (10) | Resource name | |
| ACTIVITY | VARCHAR2 | (10) | Activity name | |
| TRANSACTION_ID | NUMBER | Row identifier | ||
| PROCESS_FLAG | NUMBER | Row status | ||
| TRANSACTION_TYPE | VARCHAR2 | (10) | Create, Update, or Delete | |
| NEW_SUB_RESOURCE_CODE | VARCHAR2 | (10) | New resource sequence number. This column was added to facilitate updates because it's part of the primary key. | |
| PRINCIPLE_FLAG | NUMBER | Principal flag | ||
| ORIGINAL_SYSTEM_REFERENCE | VARCHAR2 | (50) | Original system reference | |
| SETUP_CODE | VARCHAR2 | (30) | Setup type code | |
| ECO_NAME | VARCHAR2 | (10) | Used by Engineering Change Order Process | |
| NEW_REVISED_ITEM_REVISION | VARCHAR2 | (3) | New revised item revision | |
| NEW_ROUTING_REVISION | VARCHAR2 | (3) | New routing revision | |
| ACD_TYPE | NUMBER | ACD type | ||
| NEW_REPLACEMENT_GROUP_NUM | NUMBER | The new value the user would want to update the replacement group number with | ||
| ENG_CHANGES_IFCE_KEY | NUMBER | Engineering changes IFCE key | ||
| BATCH_ID | NUMBER | BATCH_ID | ||
| NEW_BASIS_TYPE | NUMBER | New basis type |
Cut, paste (and edit) the following text to query this object:
SELECT OPERATION_SEQUENCE_ID
, SUBSTITUTE_GROUP_NUM
, SCHEDULE_SEQ_NUM
, REPLACEMENT_GROUP_NUM
, RESOURCE_ID
, ACTIVITY_ID
, OPERATION_TYPE
, STANDARD_RATE_FLAG
, ASSIGNED_UNITS
, USAGE_RATE_OR_AMOUNT
, USAGE_RATE_OR_AMOUNT_INVERSE
, BASIS_TYPE
, SCHEDULE_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, RESOURCE_OFFSET_PERCENT
, AUTOCHARGE_TYPE
, 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
, ASSEMBLY_ITEM_ID
, ALTERNATE_ROUTING_DESIGNATOR
, ORGANIZATION_ID
, OPERATION_SEQ_NUM
, EFFECTIVITY_DATE
, ROUTING_SEQUENCE_ID
, ORGANIZATION_CODE
, ASSEMBLY_ITEM_NUMBER
, SUB_RESOURCE_CODE
, ACTIVITY
, TRANSACTION_ID
, PROCESS_FLAG
, TRANSACTION_TYPE
, NEW_SUB_RESOURCE_CODE
, PRINCIPLE_FLAG
, ORIGINAL_SYSTEM_REFERENCE
, SETUP_CODE
, ECO_NAME
, NEW_REVISED_ITEM_REVISION
, NEW_ROUTING_REVISION
, ACD_TYPE
, NEW_REPLACEMENT_GROUP_NUM
, ENG_CHANGES_IFCE_KEY
, BATCH_ID
, NEW_BASIS_TYPE
FROM BOM.BOM_SUB_OP_RESOURCES_INTERFACE;
BOM.BOM_SUB_OP_RESOURCES_INTERFACE does not reference any database object
BOM.BOM_SUB_OP_RESOURCES_INTERFACE is referenced by following:
APPS
BOM_SUB_OP_RESOURCES_INTERFACE
|
|
|
|