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

Object Details

Object Name:	GMP_EAM_EQUIP_RESOURCES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMP.GMP_EAM_EQUIP_RESOURCES_V
Subobject Name:
Status:	VALID

View Type

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

OPM Resource to eAM equipment mapping view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Database rtow identifier
ORGANIZATION_ID	NUMBER		Yes	Organziation id of the ownr organization
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory Item Id for the equipment item associated with the resource instance
SERIAL_NUMBER	VARCHAR2	(30)		Serial Number of the resource instance
RESOURCE_ID	NUMBER	(10)	Yes	Unique identifier of the resource
RESOURCE_CODE	VARCHAR2	(16)	Yes	Code of the resource or its name
DESCRIPTION	VARCHAR2	(40)	Yes	Description of the resource
INSTANCE_ID	NUMBER		Yes	Unique identifier of the instance of the resource
DEPARTMENT_ID	NUMBER		Yes	Unique identifier of the owner department
DEPARTMENT_CODE	VARCHAR2	(3)		Code of the owner department
SHARE_FROM_DEPT_ID	NUMBER			Unique identifier of the department shared from
SHARE_FROM_DEPT_CODE	VARCHAR2	(0)		Unique identifier of the department shared from
OWNING_DEPARTMENT_CODE	VARCHAR2	(3)		Code of the owner department
CAPACITY_UNITS	NUMBER		Yes	Number of the resource instances.
AVAILABLE_24_HOURS_FLAG	NUMBER			Indicator if the resource is available all 24 hours of the day
RESOURCE_GROUP_NAME	VARCHAR2	(16)	Yes	Group to which the resource belongs
SHARE_CAPACITY_FLAG	NUMBER			Indicator if the resouce could share capacity
UNIT_OF_MEASURE	VARCHAR2	(3)		UOM for resource use measurement
AUTOCHARGE_TYPE	NUMBER			Indicator for auto-recharge
CTP_FLAG	NUMBER			Indicator to indicate whether to include in CTP calculations
SCHEDULE_TO_INSTANCE	NUMBER			Indicator showing if the resource is scheduled to instance level by scheduler

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.GMP_EAM_EQUIP_RESOURCES_V;

Dependencies

[top of page]

APPS.GMP_EAM_EQUIP_RESOURCES_V references the following:

APPS: CR_RSRC_DTL; CR_RSRC_MST; GMP_RESOURCE_EQUIPMENTS; GMP_RESOURCE_INSTANCES; MTL_PARAMETERS

APPS.GMP_EAM_EQUIP_RESOURCES_V is referenced by following:

APPS: MTL_EAM_EQUIP_RESOURCES_V