[Home] [Help]
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,
1634: operation_seq_num,
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,
1690: operation_seq_num,
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,
1747: operation_seq_num,
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,
1805: resource_seq_num,
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,
1882: resource_seq_num,
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,
1958: resource_seq_num,
3399: l_stmt_num := 40;
3400:
3401: select wor.start_date, wor.completion_date
3402: into l_wor_start_date, l_wor_end_date
3403: from wip_operation_resources wor
3404: where wor.wip_entity_id = p_wip_entity_id
3405: and wor.operation_seq_num = p_operation_seq_num
3406: and wor.resource_seq_num = p_resource_seq_num
3407: and wor.organization_id = p_organization_id;