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.

APPS.EAM_COMMON_UTILITIES_PVT dependencies on WIP_DISCRETE_JOBS

Line 1629: wip_discrete_jobs wdj,

1625: decode(SUM(res.usage), null,round(nvl(SUM(wor.completion_date - wor.start_date)*24,0),1),ROUND(SUM(res.usage)*24,1))
1626: INTO l_todays_work,
1627: l_todays_work_duration
1628: FROM wip_entities we,
1629: wip_discrete_jobs wdj,
1630: wip_operations wo,
1631: wip_operation_resources wor,
1632: wip_op_resource_instances wori,
1633: bom_resource_employees bre,

Line 1685: wip_discrete_jobs wdj,

1681: decode(SUM(res.usage), null,round(nvl(SUM(wor.completion_date - wor.start_date)*24,0),1),ROUND(SUM(res.usage)*24,1))
1682: INTO l_overdue_work,
1683: l_overdue_work_duration
1684: FROM wip_entities we,
1685: wip_discrete_jobs wdj,
1686: wip_operations wo,
1687: wip_operation_resources wor,
1688: wip_op_resource_instances wori,
1689: bom_resource_employees bre,

Line 1742: wip_discrete_jobs wdj,

1738: decode(SUM(res.usage), null,round(nvl(SUM(wor.completion_date - wor.start_date)*24,0),1),ROUND(SUM(res.usage)*24,1))
1739: INTO l_open_work,
1740: l_open_work_duration
1741: FROM wip_entities we,
1742: wip_discrete_jobs wdj,
1743: wip_operations wo,
1744: wip_operation_resources wor,
1745: wip_op_resource_instances wori,
1746: bom_resource_employees bre,

Line 1800: wip_discrete_jobs wdj,

1796: SELECT count(*) ,
1797: decode(SUM(res.usage), null,round(nvl(SUM(wor.completion_date - wor.start_date)*24,0),1),ROUND(SUM(res.usage)*24,1))
1798: INTO l_todays_work, l_todays_work_duration
1799: FROM wip_entities we,
1800: wip_discrete_jobs wdj,
1801: wip_operations wo,
1802: wip_operation_resources wor,
1803: bom_resources br,
1804: (SELECT wip_entity_id,

Line 1877: wip_discrete_jobs wdj,

1873: SELECT count(*) ,
1874: decode(SUM(res.usage), null,round(nvl(SUM(wor.completion_date - wor.start_date)*24,0),1),ROUND(SUM(res.usage)*24,1))
1875: INTO l_overdue_work, l_overdue_work_duration
1876: FROM wip_entities we,
1877: wip_discrete_jobs wdj,
1878: wip_operations wo,
1879: wip_operation_resources wor,
1880: bom_resources br,
1881: (SELECT wip_entity_id,

Line 1953: wip_discrete_jobs wdj,

1949: SELECT count(*) ,
1950: decode(SUM(res.usage), null,round(nvl(SUM(wor.completion_date - wor.start_date)*24,0),1),ROUND(SUM(res.usage)*24,1))
1951: INTO l_open_work, l_open_work_duration
1952: FROM wip_entities we,
1953: wip_discrete_jobs wdj,
1954: wip_operations wo,
1955: wip_operation_resources wor,
1956: bom_resources br,
1957: (SELECT wip_entity_id,

Line 2515: FROM wip_discrete_jobs wdj

2511: INTO l_wo_exists
2512: FROM DUAL
2513: WHERE EXISTS
2514: (SELECT wdj.wip_entity_id
2515: FROM wip_discrete_jobs wdj
2516: WHERE wdj.status_type not in (4, 5, 7, 12)
2517: AND wdj.maintenance_object_type = 3
2518: AND wdj.maintenance_object_id = l_instance_id
2519: AND wdj.organization_id = l_organization_id)

Line 3235: FROM wip_discrete_jobs wdj

3231: INTO l_wo_exists
3232: FROM DUAL
3233: WHERE EXISTS
3234: (SELECT wdj.wip_entity_id
3235: FROM wip_discrete_jobs wdj
3236: WHERE wdj.status_type not in (4, 5, 7, 12)
3237: AND wdj.maintenance_object_type = 3
3238: AND wdj.maintenance_object_id = p_maintenance_object_id
3239: )

Line 3289: from csi_item_instances cii, wip_discrete_jobs wdj

3285:
3286: begin
3287: select cii.instance_number
3288: into l_parent_asset_number
3289: from csi_item_instances cii, wip_discrete_jobs wdj
3290: where wdj.wip_entity_id = p_parent_job_id
3291: and wdj.organization_id = p_organization_id
3292: and wdj.maintenance_object_type = 3
3293: and wdj.maintenance_object_id = cii.instance_id;

Line 3811: FROM wip_discrete_jobs

3807: CURSOR get_wo_details IS
3808: SELECT organization_id,
3809: maintenance_object_type,
3810: maintenance_object_id
3811: FROM wip_discrete_jobs
3812: WHERE wip_entity_id = p_wip_entity_id;
3813:
3814: l_org_id wip_discrete_jobs.organization_id%TYPE;
3815: l_maint_object_id wip_discrete_jobs.maintenance_object_type%TYPE;

Line 3814: l_org_id wip_discrete_jobs.organization_id%TYPE;

3810: maintenance_object_id
3811: FROM wip_discrete_jobs
3812: WHERE wip_entity_id = p_wip_entity_id;
3813:
3814: l_org_id wip_discrete_jobs.organization_id%TYPE;
3815: l_maint_object_id wip_discrete_jobs.maintenance_object_type%TYPE;
3816: l_maint_object_type wip_discrete_jobs.maintenance_object_id%TYPE;
3817:
3818: l_obj_exists NUMBER := 0;

Line 3815: l_maint_object_id wip_discrete_jobs.maintenance_object_type%TYPE;

3811: FROM wip_discrete_jobs
3812: WHERE wip_entity_id = p_wip_entity_id;
3813:
3814: l_org_id wip_discrete_jobs.organization_id%TYPE;
3815: l_maint_object_id wip_discrete_jobs.maintenance_object_type%TYPE;
3816: l_maint_object_type wip_discrete_jobs.maintenance_object_id%TYPE;
3817:
3818: l_obj_exists NUMBER := 0;
3819: l_return_status VARCHAR2(1) := 'N';

Line 3816: l_maint_object_type wip_discrete_jobs.maintenance_object_id%TYPE;

3812: WHERE wip_entity_id = p_wip_entity_id;
3813:
3814: l_org_id wip_discrete_jobs.organization_id%TYPE;
3815: l_maint_object_id wip_discrete_jobs.maintenance_object_type%TYPE;
3816: l_maint_object_type wip_discrete_jobs.maintenance_object_id%TYPE;
3817:
3818: l_obj_exists NUMBER := 0;
3819: l_return_status VARCHAR2(1) := 'N';
3820: BEGIN

Line 3942: FROM WIP_DISCRETE_JOBS wdj_child

3938: SELECT MIN(scheduled_start_date)
3939: INTO l_scheduled_start_date
3940: FROM (
3941: select scheduled_start_date
3942: FROM WIP_DISCRETE_JOBS wdj_child
3943: WHERE wdj_child.wip_entity_id= p_wip_entity_id
3944: union all
3945: SELECT scheduled_start_date
3946: FROM WIP_DISCRETE_JOBS wdj_child

Line 3946: FROM WIP_DISCRETE_JOBS wdj_child

3942: FROM WIP_DISCRETE_JOBS wdj_child
3943: WHERE wdj_child.wip_entity_id= p_wip_entity_id
3944: union all
3945: SELECT scheduled_start_date
3946: FROM WIP_DISCRETE_JOBS wdj_child
3947: where wdj_child.wip_entity_id
3948: IN (SELECT child_object_id
3949: FROM eam_wo_relationships
3950: WHERE parent_relationship_type =1

Line 3970: FROM WIP_DISCRETE_JOBS wdj_child

3966: SELECT MAX(scheduled_completion_date)
3967: INTO l_scheduled_completion_date
3968: FROM (
3969: SELECT scheduled_completion_date
3970: FROM WIP_DISCRETE_JOBS wdj_child
3971: WHERE wdj_child.wip_entity_id=p_wip_entity_id
3972: union all
3973: Select Scheduled_completion_date
3974: from WIP_DISCRETE_JOBS wdj_child

Line 3974: from WIP_DISCRETE_JOBS wdj_child

3970: FROM WIP_DISCRETE_JOBS wdj_child
3971: WHERE wdj_child.wip_entity_id=p_wip_entity_id
3972: union all
3973: Select Scheduled_completion_date
3974: from WIP_DISCRETE_JOBS wdj_child
3975: where wdj_child.wip_entity_id
3976: IN (SELECT child_object_id
3977: FROM eam_wo_relationships
3978: WHERE parent_relationship_type =1