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 1628: wip_discrete_jobs wdj,

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

Line 1684: wip_discrete_jobs wdj,

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

Line 1741: wip_discrete_jobs wdj,

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

Line 1799: wip_discrete_jobs wdj,

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

Line 1876: wip_discrete_jobs wdj,

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

Line 1952: wip_discrete_jobs wdj,

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

Line 2514: FROM wip_discrete_jobs wdj

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

Line 3093: FROM wip_discrete_jobs wdj

3089: INTO l_wo_exists
3090: FROM DUAL
3091: WHERE EXISTS
3092: (SELECT wdj.wip_entity_id
3093: FROM wip_discrete_jobs wdj
3094: WHERE wdj.status_type not in (4, 5, 7, 12)
3095: AND wdj.maintenance_object_type = 3
3096: AND wdj.maintenance_object_id = p_maintenance_object_id
3097: )

Line 3145: from csi_item_instances cii, wip_discrete_jobs wdj

3141:
3142: begin
3143: select cii.instance_number
3144: into l_parent_asset_number
3145: from csi_item_instances cii, wip_discrete_jobs wdj
3146: where wdj.wip_entity_id = p_parent_job_id
3147: and wdj.organization_id = p_organization_id
3148: and wdj.maintenance_object_type = 3
3149: and wdj.maintenance_object_id = cii.instance_id;

Line 3667: FROM wip_discrete_jobs

3663: CURSOR get_wo_details IS
3664: SELECT organization_id,
3665: maintenance_object_type,
3666: maintenance_object_id
3667: FROM wip_discrete_jobs
3668: WHERE wip_entity_id = p_wip_entity_id;
3669:
3670: l_org_id wip_discrete_jobs.organization_id%TYPE;
3671: l_maint_object_id wip_discrete_jobs.maintenance_object_type%TYPE;

Line 3670: l_org_id wip_discrete_jobs.organization_id%TYPE;

3666: maintenance_object_id
3667: FROM wip_discrete_jobs
3668: WHERE wip_entity_id = p_wip_entity_id;
3669:
3670: l_org_id wip_discrete_jobs.organization_id%TYPE;
3671: l_maint_object_id wip_discrete_jobs.maintenance_object_type%TYPE;
3672: l_maint_object_type wip_discrete_jobs.maintenance_object_id%TYPE;
3673:
3674: l_obj_exists NUMBER := 0;

Line 3671: l_maint_object_id wip_discrete_jobs.maintenance_object_type%TYPE;

3667: FROM wip_discrete_jobs
3668: WHERE wip_entity_id = p_wip_entity_id;
3669:
3670: l_org_id wip_discrete_jobs.organization_id%TYPE;
3671: l_maint_object_id wip_discrete_jobs.maintenance_object_type%TYPE;
3672: l_maint_object_type wip_discrete_jobs.maintenance_object_id%TYPE;
3673:
3674: l_obj_exists NUMBER := 0;
3675: l_return_status VARCHAR2(1) := 'N';

Line 3672: l_maint_object_type wip_discrete_jobs.maintenance_object_id%TYPE;

3668: WHERE wip_entity_id = p_wip_entity_id;
3669:
3670: l_org_id wip_discrete_jobs.organization_id%TYPE;
3671: l_maint_object_id wip_discrete_jobs.maintenance_object_type%TYPE;
3672: l_maint_object_type wip_discrete_jobs.maintenance_object_id%TYPE;
3673:
3674: l_obj_exists NUMBER := 0;
3675: l_return_status VARCHAR2(1) := 'N';
3676: BEGIN

Line 3798: FROM WIP_DISCRETE_JOBS wdj_child

3794: SELECT MIN(scheduled_start_date)
3795: INTO l_scheduled_start_date
3796: FROM (
3797: select scheduled_start_date
3798: FROM WIP_DISCRETE_JOBS wdj_child
3799: WHERE wdj_child.wip_entity_id= p_wip_entity_id
3800: union all
3801: SELECT scheduled_start_date
3802: FROM WIP_DISCRETE_JOBS wdj_child

Line 3802: FROM WIP_DISCRETE_JOBS wdj_child

3798: FROM WIP_DISCRETE_JOBS wdj_child
3799: WHERE wdj_child.wip_entity_id= p_wip_entity_id
3800: union all
3801: SELECT scheduled_start_date
3802: FROM WIP_DISCRETE_JOBS wdj_child
3803: where wdj_child.wip_entity_id
3804: IN (SELECT child_object_id
3805: FROM eam_wo_relationships
3806: WHERE parent_relationship_type =1

Line 3826: FROM WIP_DISCRETE_JOBS wdj_child

3822: SELECT MAX(scheduled_completion_date)
3823: INTO l_scheduled_completion_date
3824: FROM (
3825: SELECT scheduled_completion_date
3826: FROM WIP_DISCRETE_JOBS wdj_child
3827: WHERE wdj_child.wip_entity_id=p_wip_entity_id
3828: union all
3829: Select Scheduled_completion_date
3830: from WIP_DISCRETE_JOBS wdj_child

Line 3830: from WIP_DISCRETE_JOBS wdj_child

3826: FROM WIP_DISCRETE_JOBS wdj_child
3827: WHERE wdj_child.wip_entity_id=p_wip_entity_id
3828: union all
3829: Select Scheduled_completion_date
3830: from WIP_DISCRETE_JOBS wdj_child
3831: where wdj_child.wip_entity_id
3832: IN (SELECT child_object_id
3833: FROM eam_wo_relationships
3834: WHERE parent_relationship_type =1