[Home] [Help]
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,
1633: (SELECT wip_entity_id,
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,
1689: (SELECT wip_entity_id,
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,
1746: (SELECT wip_entity_id,
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,
1804: operation_seq_num,
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,
1881: operation_seq_num,
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,
1957: operation_seq_num,