VIEW: APPS.GMP_EAM_EQUIP_RESOURCES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'