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.

Equipment to resource mapping view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Database row identifier
ORGANIZATION_ID	NUMBER		Yes	Organization ID
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory Item ID
SERIAL_NUMBER	VARCHAR2	(30)		Serial Number of the Resource Instance
RESOURCE_ID	NUMBER	(10)	Yes	Resource ID
RESOURCE_CODE	VARCHAR2	(16)	Yes	Resource Code
DESCRIPTION	VARCHAR2	(240)	Yes	Description Of resource
INSTANCE_ID	NUMBER		Yes	Instance ID
DEPARTMENT_ID	NUMBER		Yes	Department ID
DEPARTMENT_CODE	VARCHAR2	(3)		Department Code
SHARE_FROM_DEPT_ID	NUMBER			Shared Department ID
SHARE_FROM_DEPT_CODE	VARCHAR2	(0)		Shared department code
OWNING_DEPARTMENT_CODE	VARCHAR2	(3)		Resource owner department code
CAPACITY_UNITS	NUMBER		Yes	Number of resource units
AVAILABLE_24_HOURS_FLAG	NUMBER			Is the resource available for 24 hours (not used in OPM)
RESOURCE_GROUP_NAME	VARCHAR2	(16)	Yes	Resource group
SHARE_CAPACITY_FLAG	NUMBER			Can the capacity be shared
UNIT_OF_MEASURE	VARCHAR2	(3)		Unit Of measure
AUTOCHARGE_TYPE	NUMBER			Charge automatically
CTP_FLAG	NUMBER			CTP Flag (capable to promise)
SCHEDULE_TO_INSTANCE	NUMBER			Scheduling to instance

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