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]

VIEW: APPS.BOM_OP_RESOURCES_VIEW

Object Details

Object Name:	BOM_OP_RESOURCES_VIEW
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.BOM_OP_RESOURCES_VIEW
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

The BOM_OP_RESOURCES_VIEW contains information about resources used on
routings.
.
BOM_OP_RESOURCES_VIEW resolves the foreign key information of
BOM_OPERATION_RESOURCES from MFG_LOOKUPS, MTL_ITEM_FLEXFIELDS,
BOM_OPERATION_SEQUENCES, CST_ACTIVITIES, BOM_OPERATIONAL_ROUTINGS,
BOM_DEPARTMENTS, and BOM_RESOURCES.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
ROUTING_TYPE	NUMBER		Yes	Indicates if routing is engineering or manufacturing
ALTERNATE_ROUTING_DESIGNATOR	VARCHAR2	(10)		Alternate designator code
ASSEMBLY_ITEM_ID	NUMBER		Yes	Assembly item identifier
COMMON_ASSEMBLY_ITEM_ID	NUMBER			Assembly item identifier of the common assembly
ITEM_NUMBER	VARCHAR2	(40)		Concatenated item flex segments
PADDED_ITEM_NUMBER	VARCHAR2	(40)		Padded concatenated item flex segments
DESCRIPTION	VARCHAR2	(240)		Description
DEPARTMENT_CODE	VARCHAR2	(10)	Yes	Department
OPERATION_SEQ_NUM	NUMBER		Yes	Operation sequence number
OPERATION_DESCRIPTION	VARCHAR2	(240)		Operation description
EFFECTIVITY_DATE	DATE		Yes	Effective date
DISABLE_DATE	DATE			Disable date
RESOURCE_CODE	VARCHAR2	(10)	Yes	Resource
RESOURCE_SEQ_NUM	NUMBER		Yes	Resource sequence number
ACTIVITY	VARCHAR2	(10)		Activity for which resource is used
AUTOCHARGE	VARCHAR2	(4000)		Autocharge type for shopfloor transactions
STANDARD_RATE	VARCHAR2	(4000)		Use standard rate for costing
ASSIGNED_UNITS	NUMBER		Yes	Resource units assigned
USAGE_RATE_OR_AMOUNT	NUMBER		Yes	Usage rate
USAGE_RATE_OR_AMOUNT_INVERSE	NUMBER		Yes	Usage rate inverse
BASIS	VARCHAR2	(4000)		Indicates whether resources are used per item or per lot
SCHEDULE_FLAG	VARCHAR2	(4000)		Indicates how resource is scheduled
RESOURCE_OFFSET_PERCENT	NUMBER			Lead time offset percent
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
ACD_TYPE	NUMBER			Acd type

Query Text

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


SELECT ORGANIZATION_ID
,      ROUTING_TYPE
,      ALTERNATE_ROUTING_DESIGNATOR
,      ASSEMBLY_ITEM_ID
,      COMMON_ASSEMBLY_ITEM_ID
,      ITEM_NUMBER
,      PADDED_ITEM_NUMBER
,      DESCRIPTION
,      DEPARTMENT_CODE
,      OPERATION_SEQ_NUM
,      OPERATION_DESCRIPTION
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      RESOURCE_CODE
,      RESOURCE_SEQ_NUM
,      ACTIVITY
,      AUTOCHARGE
,      STANDARD_RATE
,      ASSIGNED_UNITS
,      USAGE_RATE_OR_AMOUNT
,      USAGE_RATE_OR_AMOUNT_INVERSE
,      BASIS
,      SCHEDULE_FLAG
,      RESOURCE_OFFSET_PERCENT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ACD_TYPE
FROM APPS.BOM_OP_RESOURCES_VIEW;

Dependencies

[top of page]

APPS.BOM_OP_RESOURCES_VIEW references the following:

APPS: BOM_DEPARTMENTS; BOM_OPERATIONAL_ROUTINGS; BOM_OPERATION_RESOURCES; BOM_OPERATION_SEQUENCES; BOM_RESOURCES; CST_ACTIVITIES; INV_MEANING_SEL - show dependent code; MTL_ITEM_FLEXFIELDS

APPS.BOM_OP_RESOURCES_VIEW is not referenced by any database object