APPS.EAM_COMMON_UTILITIES_PVT dependencies on WIP_ENTITIES

Line 1628: FROM wip_entities we,

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

Line 1684: FROM wip_entities we,

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

Line 1741: FROM wip_entities we,

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

Line 1799: FROM wip_entities we,

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

Line 1876: FROM wip_entities we,

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

Line 1952: FROM wip_entities we,

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

Line 2209: from wip_entities

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