VIEW: APPS.EAM_FORECAST_WORK_ORDER_V

Source

View Text - Preformatted

SELECT job.forecast_id, job.wip_entity_id, entity.wip_entity_name, job.organization_id, cii.instance_number, cii.instance_description, msi.concatenated_segments, msi2.concatenated_segments, loc.location_codes, woType.meaning, job.description, job.scheduled_start_date, job.scheduled_completion_date, actType.meaning, actCause.meaning, bd.department_code, job.class_code, job.plan_maintenance, ppv.project_name, actSource.meaning, job.pm_schedule_id, ppv.task_name FROM eam_forecast_wdj job, wip_entities entity, mtl_system_items_kfv msi, csi_item_instances cii, mtl_eam_locations loc, mtl_system_items_kfv msi2, bom_departments bd, mtl_parameters mp, eam_org_maint_defaults eomd, pjm_tasks_v ppv, mfg_lookups woType, mfg_lookups actCause, mfg_lookups actSource, mfg_lookups actType WHERE entity.wip_entity_id (+) = job.wip_entity_id AND entity.entity_type (+) = DECODE(job.status_type,12,7,6) AND job.maintenance_object_type = 3 AND job.maintenance_object_id = cii.instance_id AND msi.inventory_item_id = cii.inventory_item_id AND msi.organization_id = mp.organization_id AND msi.organization_id = mp.organization_id AND msi.organization_id = cii.last_vld_organization_id AND eomd.object_id(+) = cii.instance_id AND (eomd.organization_id IS NULL OR eomd.organization_id = job.organization_id) AND eomd.object_type (+) = 50 AND loc.location_id (+) = eomd.area_id AND msi2.inventory_item_id (+) = job.primary_item_id AND msi2.organization_id (+) = job.organization_id AND bd.department_id (+) = job.owning_department AND bd.organization_id = job.organization_id AND ppv.project_id (+) = job.project_id AND ppv.task_id (+) = job.task_id AND actCause.lookup_type (+) = 'MTL_EAM_ACTIVITY_CAUSE' AND actCause.lookup_code (+) = TO_NUMBER(job.activity_cause) AND actSource.lookup_type (+) = 'MTL_EAM_ACTIVITY_SOURCE' AND actSource.lookup_code (+) = TO_NUMBER(job.activity_source) AND actType.lookup_type (+) = 'MTL_EAM_ACTIVITY_TYPE' AND actType.lookup_code (+) = TO_NUMBER(job.activity_type) AND woType.lookup_type (+) = 'WIP_EAM_WORK_ORDER_TYPE' AND woType.lookup_code (+) = TO_NUMBER(job.work_order_type) UNION SELECT job.forecast_id, job.wip_entity_id, entity.wip_entity_name, job.organization_id, NULL, NULL, msi.concatenated_segments, msi2.concatenated_segments, NULL, woType.meaning, job.description, job.scheduled_start_date, job.scheduled_completion_date, actType.meaning, actCause.meaning, bd.department_code, job.class_code, job.plan_maintenance, ppv.project_name, actSource.meaning, job.pm_schedule_id, ppv.task_name FROM eam_forecast_wdj job, wip_entities entity, mtl_system_items_kfv msi, mtl_system_items_kfv msi2, mtl_parameters mp, bom_departments bd, pjm_tasks_v ppv, mfg_lookups woType, mfg_lookups actCause, mfg_lookups actSource, mfg_lookups actType WHERE entity.wip_entity_id (+) = job.wip_entity_id AND entity.entity_type(+) = 6 AND msi.eam_item_type = 3 AND job.maintenance_object_type = 2 AND job.maintenance_object_id = msi.inventory_item_id AND msi.organization_id = mp.organization_id AND mp.maint_organization_id = job.organization_id AND msi2.inventory_item_id (+) = job.primary_item_id AND msi2.organization_id (+) = job.organization_id AND bd.department_id (+) = job.owning_department AND bd.organization_id = job.organization_id AND ppv.project_id (+) = job.project_id AND ppv.task_id = job.task_id AND actCause.lookup_type (+) = 'MTL_EAM_ACTIVITY_CAUSE' AND actCause.lookup_code (+) = TO_NUMBER(job.activity_cause) AND actSource.lookup_type (+) = 'MTL_EAM_ACTIVITY_SOURCE' AND actSource.lookup_code (+) = TO_NUMBER(job.activity_source) AND actType.lookup_type (+) = 'MTL_EAM_ACTIVITY_TYPE' AND actType.lookup_code (+) = TO_NUMBER(job.activity_type) AND woType.lookup_type (+) = 'WIP_EAM_WORK_ORDER_TYPE' AND woType.lookup_code (+) = TO_NUMBER(job.work_order_type)

View Text - HTML Formatted

SELECT JOB.FORECAST_ID
, JOB.WIP_ENTITY_ID
, ENTITY.WIP_ENTITY_NAME
, JOB.ORGANIZATION_ID
, CII.INSTANCE_NUMBER
, CII.INSTANCE_DESCRIPTION
, MSI.CONCATENATED_SEGMENTS
, MSI2.CONCATENATED_SEGMENTS
, LOC.LOCATION_CODES
, WOTYPE.MEANING
, JOB.DESCRIPTION
, JOB.SCHEDULED_START_DATE
, JOB.SCHEDULED_COMPLETION_DATE
, ACTTYPE.MEANING
, ACTCAUSE.MEANING
, BD.DEPARTMENT_CODE
, JOB.CLASS_CODE
, JOB.PLAN_MAINTENANCE
, PPV.PROJECT_NAME
, ACTSOURCE.MEANING
, JOB.PM_SCHEDULE_ID
, PPV.TASK_NAME
FROM EAM_FORECAST_WDJ JOB
, WIP_ENTITIES ENTITY
, MTL_SYSTEM_ITEMS_KFV MSI
, CSI_ITEM_INSTANCES CII
, MTL_EAM_LOCATIONS LOC
, MTL_SYSTEM_ITEMS_KFV MSI2
, BOM_DEPARTMENTS BD
, MTL_PARAMETERS MP
, EAM_ORG_MAINT_DEFAULTS EOMD
, PJM_TASKS_V PPV
, MFG_LOOKUPS WOTYPE
, MFG_LOOKUPS ACTCAUSE
, MFG_LOOKUPS ACTSOURCE
, MFG_LOOKUPS ACTTYPE
WHERE ENTITY.WIP_ENTITY_ID (+) = JOB.WIP_ENTITY_ID
AND ENTITY.ENTITY_TYPE (+) = DECODE(JOB.STATUS_TYPE
, 12
, 7
, 6)
AND JOB.MAINTENANCE_OBJECT_TYPE = 3
AND JOB.MAINTENANCE_OBJECT_ID = CII.INSTANCE_ID
AND MSI.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MSI.ORGANIZATION_ID = CII.LAST_VLD_ORGANIZATION_ID
AND EOMD.OBJECT_ID(+) = CII.INSTANCE_ID
AND (EOMD.ORGANIZATION_ID IS NULL OR EOMD.ORGANIZATION_ID = JOB.ORGANIZATION_ID)
AND EOMD.OBJECT_TYPE (+) = 50
AND LOC.LOCATION_ID (+) = EOMD.AREA_ID
AND MSI2.INVENTORY_ITEM_ID (+) = JOB.PRIMARY_ITEM_ID
AND MSI2.ORGANIZATION_ID (+) = JOB.ORGANIZATION_ID
AND BD.DEPARTMENT_ID (+) = JOB.OWNING_DEPARTMENT
AND BD.ORGANIZATION_ID = JOB.ORGANIZATION_ID
AND PPV.PROJECT_ID (+) = JOB.PROJECT_ID
AND PPV.TASK_ID (+) = JOB.TASK_ID
AND ACTCAUSE.LOOKUP_TYPE (+) = 'MTL_EAM_ACTIVITY_CAUSE'
AND ACTCAUSE.LOOKUP_CODE (+) = TO_NUMBER(JOB.ACTIVITY_CAUSE)
AND ACTSOURCE.LOOKUP_TYPE (+) = 'MTL_EAM_ACTIVITY_SOURCE'
AND ACTSOURCE.LOOKUP_CODE (+) = TO_NUMBER(JOB.ACTIVITY_SOURCE)
AND ACTTYPE.LOOKUP_TYPE (+) = 'MTL_EAM_ACTIVITY_TYPE'
AND ACTTYPE.LOOKUP_CODE (+) = TO_NUMBER(JOB.ACTIVITY_TYPE)
AND WOTYPE.LOOKUP_TYPE (+) = 'WIP_EAM_WORK_ORDER_TYPE'
AND WOTYPE.LOOKUP_CODE (+) = TO_NUMBER(JOB.WORK_ORDER_TYPE) UNION SELECT JOB.FORECAST_ID
, JOB.WIP_ENTITY_ID
, ENTITY.WIP_ENTITY_NAME
, JOB.ORGANIZATION_ID
, NULL
, NULL
, MSI.CONCATENATED_SEGMENTS
, MSI2.CONCATENATED_SEGMENTS
, NULL
, WOTYPE.MEANING
, JOB.DESCRIPTION
, JOB.SCHEDULED_START_DATE
, JOB.SCHEDULED_COMPLETION_DATE
, ACTTYPE.MEANING
, ACTCAUSE.MEANING
, BD.DEPARTMENT_CODE
, JOB.CLASS_CODE
, JOB.PLAN_MAINTENANCE
, PPV.PROJECT_NAME
, ACTSOURCE.MEANING
, JOB.PM_SCHEDULE_ID
, PPV.TASK_NAME
FROM EAM_FORECAST_WDJ JOB
, WIP_ENTITIES ENTITY
, MTL_SYSTEM_ITEMS_KFV MSI
, MTL_SYSTEM_ITEMS_KFV MSI2
, MTL_PARAMETERS MP
, BOM_DEPARTMENTS BD
, PJM_TASKS_V PPV
, MFG_LOOKUPS WOTYPE
, MFG_LOOKUPS ACTCAUSE
, MFG_LOOKUPS ACTSOURCE
, MFG_LOOKUPS ACTTYPE
WHERE ENTITY.WIP_ENTITY_ID (+) = JOB.WIP_ENTITY_ID
AND ENTITY.ENTITY_TYPE(+) = 6
AND MSI.EAM_ITEM_TYPE = 3
AND JOB.MAINTENANCE_OBJECT_TYPE = 2
AND JOB.MAINTENANCE_OBJECT_ID = MSI.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MP.MAINT_ORGANIZATION_ID = JOB.ORGANIZATION_ID
AND MSI2.INVENTORY_ITEM_ID (+) = JOB.PRIMARY_ITEM_ID
AND MSI2.ORGANIZATION_ID (+) = JOB.ORGANIZATION_ID
AND BD.DEPARTMENT_ID (+) = JOB.OWNING_DEPARTMENT
AND BD.ORGANIZATION_ID = JOB.ORGANIZATION_ID
AND PPV.PROJECT_ID (+) = JOB.PROJECT_ID
AND PPV.TASK_ID = JOB.TASK_ID
AND ACTCAUSE.LOOKUP_TYPE (+) = 'MTL_EAM_ACTIVITY_CAUSE'
AND ACTCAUSE.LOOKUP_CODE (+) = TO_NUMBER(JOB.ACTIVITY_CAUSE)
AND ACTSOURCE.LOOKUP_TYPE (+) = 'MTL_EAM_ACTIVITY_SOURCE'
AND ACTSOURCE.LOOKUP_CODE (+) = TO_NUMBER(JOB.ACTIVITY_SOURCE)
AND ACTTYPE.LOOKUP_TYPE (+) = 'MTL_EAM_ACTIVITY_TYPE'
AND ACTTYPE.LOOKUP_CODE (+) = TO_NUMBER(JOB.ACTIVITY_TYPE)
AND WOTYPE.LOOKUP_TYPE (+) = 'WIP_EAM_WORK_ORDER_TYPE'
AND WOTYPE.LOOKUP_CODE (+) = TO_NUMBER(JOB.WORK_ORDER_TYPE)