[Home] [Help]
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,
1635: operation_seq_num,
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,
1691: operation_seq_num,
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,
1748: operation_seq_num,
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,
1806: resource_seq_num,
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,
1883: resource_seq_num,
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,
1959: resource_seq_num,
3543: l_stmt_num := 40;
3544:
3545: select wor.start_date, wor.completion_date
3546: into l_wor_start_date, l_wor_end_date
3547: from wip_operation_resources wor
3548: where wor.wip_entity_id = p_wip_entity_id
3549: and wor.operation_seq_num = p_operation_seq_num
3550: and wor.resource_seq_num = p_resource_seq_num
3551: and wor.organization_id = p_organization_id;