View: MTL_EAM_JOBS_RESOURCES_V

Product:	INV - Inventory
Description:	Job resources for EAM (Enterprise Asset management)
Implementation/DBA Data:	APPS.MTL_EAM_JOBS_RESOURCES_V

View Text

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

Columns