7: CURSOR c_cnt_rows IS
8: select sum(cnt)
9: from (select count(*) cnt
10: FROM
11: BOM_OPERATION_SEQUENCES BOS,
12: BOM_OPERATIONAL_ROUTINGS BOR,
13: BOM_STANDARD_OPERATIONS bso
14: WHERE BOS.ROUTING_SEQUENCE_ID = BOR.ROUTING_SEQUENCE_ID
15: AND bos.STANDARD_OPERATION_ID = BSO.STANDARD_OPERATION_ID (+)
49:
50: CURSOR c_bos IS
51: SELECT avg(nvl(vsize(operation_sequence_id), 0)) seq_id,
52: avg(nvl(vsize(DEPARTMENT_ID), 0)) dept_id
53: FROM bom_operation_sequences
54: WHERE last_update_date between p_from_date and p_to_date;
55:
56: CURSOR c_bso IS
57: SELECT avg(nvl(vsize(OPERATION_CODE), 0)) code,