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.

[Home] [Help]

View: GMP_EAM_EQUIP_RESOURCES_V

Product:	GMP - Process Manufacturing Process Planning
Description:	Equipment to resource mapping view
Implementation/DBA Data:	APPS.GMP_EAM_EQUIP_RESOURCES_V

View Text

SELECT DISTINCT CRD.ROWID
, MP.ORGANIZATION_ID
, GRE.EQUIPMENT_ITEM_ID
, TO_CHAR(GRI.EQP_SERIAL_NUMBER)
, CRD.RESOURCE_ID
, CRM.RESOURCES
, CRM.RESOURCE_DESC
, GRI.INSTANCE_ID
, MP.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, MP.ORGANIZATION_CODE
, CRD.ASSIGNED_QTY
, TO_NUMBER(NULL)
, CRD.GROUP_RESOURCE
, TO_NUMBER(NULL)
, CRD.USAGE_UOM
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM CR_RSRC_MST CRM
, CR_RSRC_DTL CRD
, GMP_RESOURCE_EQUIPMENTS GRE
, GMP_RESOURCE_INSTANCES GRI
, MTL_PARAMETERS MP
WHERE GRI.RESOURCE_ID = GRE.RESOURCE_ID
AND GRE.RESOURCE_ID = CRD.RESOURCE_ID
AND CRD.RESOURCES = CRM.RESOURCES
AND CRD.DELETE_MARK = 0
AND CRD.INACTIVE_IND = 0
AND CRD.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MP.PROCESS_ENABLED_FLAG = 'Y'

Columns

Name
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