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.MTL_EAM_EQUIP_RESOURCES_V

Object Details

Object Name:	MTL_EAM_EQUIP_RESOURCES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INV.MTL_EAM_EQUIP_RESOURCES_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
ROW_ID	ROWID	(10)	Row identifier (for internal use only)
ORGANIZATION_ID	NUMBER		Organization identifier
INVENTORY_ITEM_ID	NUMBER		Inventory item identifier of equipment
SERIAL_NUMBER	VARCHAR2	(30)	Serial number of equipment
RESOURCE_ID	NUMBER		Resource identifier
RESOURCE_CODE	VARCHAR2	(16)	Resource code
DESCRIPTION	VARCHAR2	(240)	Description of resource
INSTANCE_ID	NUMBER		Unique instance identifier for resource
DEPARTMENT_ID	NUMBER		Department identifier of department where resource is defined
DEPARTMENT_CODE	VARCHAR2	(10)	Department code of department where resource is defined
SHARE_FROM_DEPT_ID	NUMBER		Department identifier of the department which shares capacity of a resource
SHARE_FROM_DEPT_CODE	VARCHAR2	(10)	Department code of the department which shares capacity of a resource
OWNING_DEPARTMENT_CODE	VARCHAR2	(10)	Department code of department owning resource
CAPACITY_UNITS	NUMBER		Total units of machines or equipment instances available
AVAILABLE_24_HOURS_FLAG	NUMBER		Resource is available twenty four hours or by shifts flag
RESOURCE_GROUP_NAME	VARCHAR2	(30)	Resource group name
SHARE_CAPACITY_FLAG	NUMBER		Allow sharing of capacity with other departments flag
UNIT_OF_MEASURE	VARCHAR2	(3)	Unit of Measure
AUTOCHARGE_TYPE	NUMBER		Autocharge type for shopfloor transaction
CTP_FLAG	NUMBER		Flag to check for capacity when resource is ordered
SCHEDULE_TO_INSTANCE	NUMBER		Flag to indicate if resource is to be scheduled at instance level

Query Text

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


SELECT ROW_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      SERIAL_NUMBER
,      RESOURCE_ID
,      RESOURCE_CODE
,      DESCRIPTION
,      INSTANCE_ID
,      DEPARTMENT_ID
,      DEPARTMENT_CODE
,      SHARE_FROM_DEPT_ID
,      SHARE_FROM_DEPT_CODE
,      OWNING_DEPARTMENT_CODE
,      CAPACITY_UNITS
,      AVAILABLE_24_HOURS_FLAG
,      RESOURCE_GROUP_NAME
,      SHARE_CAPACITY_FLAG
,      UNIT_OF_MEASURE
,      AUTOCHARGE_TYPE
,      CTP_FLAG
,      SCHEDULE_TO_INSTANCE
FROM APPS.MTL_EAM_EQUIP_RESOURCES_V;

Dependencies

[top of page]

APPS.MTL_EAM_EQUIP_RESOURCES_V references the following:

APPS: BOM_DEPARTMENTS; BOM_DEPARTMENT_RESOURCES; BOM_DEPT_RES_INSTANCES; BOM_RESOURCES; BOM_RESOURCE_EQUIPMENTS; GMP_EAM_EQUIP_RESOURCES_V

APPS.MTL_EAM_EQUIP_RESOURCES_V is not referenced by any database object