APPS.EAM_COMMON_UTILITIES_PVT dependencies on WIP_ENTITIES

Line 1627: FROM wip_entities we,

1623: SELECT count(*) ,
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,

Line 1683: FROM wip_entities we,

1679: SELECT count(*) ,
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,

Line 1740: FROM wip_entities we,

1736: SELECT count(*) ,
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,

Line 1798: FROM wip_entities we,

1794:
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,

Line 1875: FROM wip_entities we,

1871:
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,

Line 1951: FROM wip_entities we,

1947:
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,

Line 2208: from wip_entities

2204: -- Obtain the work order name and return it back
2205:
2206: select wip_entity_name
2207: into l_wip_entity_name
2208: from wip_entities
2209: where wip_entity_id = l_eam_res_inst_rec.WIP_ENTITY_ID
2210: and organization_id = l_eam_res_inst_rec.ORGANIZATION_ID;
2211:
2212: x_wip_entity_name := l_wip_entity_name;