[Home] [Help]
View: 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
| 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 |
| Name |
APPS.GMP_EAM_EQUIP_RESOURCES_V