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.

VIEW: APPS.MTL_EAM_JOBS_RESOURCES_V

Source

View Text - Preformatted


SELECT distinct wdj.rowid row_id, wor.resource_id, nvl(wor.department_id, wo.department_id), we.wip_entity_id, we.wip_entity_name, we.description, wdj.scheduled_start_date, wdj.scheduled_completion_date, wdj.status_type, ml1.meaning status_type_meaning, wdj.job_type, ml2.meaning job_type_meaning, wdj.class_code, wdj.rebuild_item_id, we.entity_type, ml2.meaning entity_type_code from wip_operation_resources wor, wip_operations wo, wip_entities we, wip_discrete_jobs wdj, mfg_lookups ml1, mfg_lookups ml2 WHERE wor.wip_entity_id = we.wip_entity_id and we.wip_entity_id = wdj.wip_entity_id and wdj.organization_id = we.organization_id and wor.organization_id = wo.organization_id and wor.wip_entity_id = wo.wip_entity_id and wor.operation_seq_num = wo.operation_seq_num and sysdate between wdj.scheduled_start_date and wdj.scheduled_completion_date and (wdj.status_type = 1 or wdj.status_type = 3 or wdj.status_type = 6) and ml1.lookup_type = 'WIP_JOB_STATUS' and ml1.lookup_code = wdj.status_type and ml2.lookup_type = 'WIP_ENTITY' and ml2.lookup_code = entity_type union select row_id, resource_id, department_id, wip_entity_id, wip_entity_name, description, scheduled_start_date, scheduled_completion_date, status_type, status_type_meaning, job_type, job_type_meaning, class_code, rebuild_item_id, job_type entity_type, job_type_meaning entity_type_code from gmp_eam_jobs_resources_v

View Text - HTML Formatted

SELECT DISTINCT WDJ.ROWID ROW_ID
, WOR.RESOURCE_ID
, NVL(WOR.DEPARTMENT_ID
, WO.DEPARTMENT_ID)
, WE.WIP_ENTITY_ID
, WE.WIP_ENTITY_NAME
, WE.DESCRIPTION
, WDJ.SCHEDULED_START_DATE
, WDJ.SCHEDULED_COMPLETION_DATE
, WDJ.STATUS_TYPE
, ML1.MEANING STATUS_TYPE_MEANING
, WDJ.JOB_TYPE
, ML2.MEANING JOB_TYPE_MEANING
, WDJ.CLASS_CODE
, WDJ.REBUILD_ITEM_ID
, WE.ENTITY_TYPE
, ML2.MEANING ENTITY_TYPE_CODE
FROM WIP_OPERATION_RESOURCES WOR
, WIP_OPERATIONS WO
, WIP_ENTITIES WE
, WIP_DISCRETE_JOBS WDJ
, MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
WHERE WOR.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
AND WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
AND WDJ.ORGANIZATION_ID = WE.ORGANIZATION_ID
AND WOR.ORGANIZATION_ID = WO.ORGANIZATION_ID
AND WOR.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
AND WOR.OPERATION_SEQ_NUM = WO.OPERATION_SEQ_NUM
AND SYSDATE BETWEEN WDJ.SCHEDULED_START_DATE
AND WDJ.SCHEDULED_COMPLETION_DATE
AND (WDJ.STATUS_TYPE = 1 OR WDJ.STATUS_TYPE = 3 OR WDJ.STATUS_TYPE = 6)
AND ML1.LOOKUP_TYPE = 'WIP_JOB_STATUS'
AND ML1.LOOKUP_CODE = WDJ.STATUS_TYPE
AND ML2.LOOKUP_TYPE = 'WIP_ENTITY'
AND ML2.LOOKUP_CODE = ENTITY_TYPE UNION SELECT ROW_ID
, RESOURCE_ID
, DEPARTMENT_ID
, WIP_ENTITY_ID
, WIP_ENTITY_NAME
, DESCRIPTION
, SCHEDULED_START_DATE
, SCHEDULED_COMPLETION_DATE
, STATUS_TYPE
, STATUS_TYPE_MEANING
, JOB_TYPE
, JOB_TYPE_MEANING
, CLASS_CODE
, REBUILD_ITEM_ID
, JOB_TYPE ENTITY_TYPE
, JOB_TYPE_MEANING ENTITY_TYPE_CODE
FROM GMP_EAM_JOBS_RESOURCES_V