eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: BOM.BOM_OP_RESOURCES_INTERFACE

Object Details

Object Name:	BOM_OP_RESOURCES_INTERFACE
Object Type:	TABLE
Owner:	BOM
FND Design Data:	BOM.BOM_OP_RESOURCES_INTERFACE
Subobject Name:
Status:	VALID

BOM_OP_RESOURCES_INTERFACE temporarily stores information about
resources that you require 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.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BOM_OP_RESOURCES_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	OPERATION_SEQUENCE_ID RESOURCE_SEQ_NUM
BOM_OP_RESOURCES_INTERFACE_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ASSEMBLY_ITEM_ID ORGANIZATION_ID ALTERNATE_ROUTING_DESIGNATOR
BOM_OP_RESOURCES_INTERFACE_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	TRANSACTION_ID
BOM_OP_RESOURCES_INTERFACE_N4	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ASSEMBLY_ITEM_NUMBER ORGANIZATION_ID
BOM_OP_RESOURCES_INTERFACE_N5	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ENG_CHANGES_IFCE_KEY
BOM_OP_RESOURCES_INTERFACE_N6	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ASSEMBLY_ITEM_NUMBER ORGANIZATION_CODE ALTERNATE_ROUTING_DESIGNATOR
BOM_OP_RESOURCES_INTERFACE_N8	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_ID

Columns

Name	Datatype	Length	Comments
OPERATION_SEQUENCE_ID	NUMBER		Routing operation unique identifier
RESOURCE_SEQ_NUM	NUMBER		Resource sequence number
RESOURCE_ID	NUMBER		Resource unique identifier
ACTIVITY_ID	NUMBER		Activity identifier
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
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_RESOURCE_SEQ_NUM	NUMBER		New resource sequence number. This column was added to facilitate updates because it's part of the primary key.
OPERATION_TYPE	NUMBER		Type of Operation
PRINCIPLE_FLAG	NUMBER		Principal flag
SCHEDULE_SEQ_NUM	NUMBER		Schedule sequence number
ORIGINAL_SYSTEM_REFERENCE	VARCHAR2	(50)	Original System Reference
SETUP_CODE	VARCHAR2	(30)	Setup Code
ECO_NAME	VARCHAR2	(10)	ECO Name
NEW_ROUTING_REVISION	VARCHAR2	(3)	New Routing Revision
ACD_TYPE	NUMBER		Add Change Delete Type
ENG_CHANGES_IFCE_KEY	NUMBER		Engineering Changes Interface key
ENG_REVISED_ITEMS_IFCE_KEY	NUMBER		Engineering Revised Items Interface key
BOM_REV_OP_IFCE_KEY	NUMBER		BOM revised op Interface key
BOM_REV_OP_RES_IFCE_KEY	NUMBER		BOM revised op resource Interface 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
SUBSTITUTE_GROUP_NUM	NUMBER		Substitute Group Number
BATCH_ID	NUMBER		Batch Id

Query Text

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


SELECT OPERATION_SEQUENCE_ID
,      RESOURCE_SEQ_NUM
,      RESOURCE_ID
,      ACTIVITY_ID
,      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
,      RESOURCE_CODE
,      ACTIVITY
,      TRANSACTION_ID
,      PROCESS_FLAG
,      TRANSACTION_TYPE
,      NEW_RESOURCE_SEQ_NUM
,      OPERATION_TYPE
,      PRINCIPLE_FLAG
,      SCHEDULE_SEQ_NUM
,      ORIGINAL_SYSTEM_REFERENCE
,      SETUP_CODE
,      ECO_NAME
,      NEW_ROUTING_REVISION
,      ACD_TYPE
,      ENG_CHANGES_IFCE_KEY
,      ENG_REVISED_ITEMS_IFCE_KEY
,      BOM_REV_OP_IFCE_KEY
,      BOM_REV_OP_RES_IFCE_KEY
,      NEW_REVISED_ITEM_REVISION
,      SUBSTITUTE_GROUP_NUM
,      BATCH_ID
FROM BOM.BOM_OP_RESOURCES_INTERFACE;

Dependencies

[top of page]

BOM.BOM_OP_RESOURCES_INTERFACE does not reference any database object

BOM.BOM_OP_RESOURCES_INTERFACE is referenced by following:

APPS: BOM_OP_RESOURCES_INTERFACE