[Home] [Help]
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,
1634: (SELECT wip_entity_id,
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,
1690: (SELECT wip_entity_id,
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,
1747: (SELECT wip_entity_id,
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,
1805: operation_seq_num,
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,
1882: operation_seq_num,
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,
1958: operation_seq_num,