APPS.OPI_EDW_OPI_OPRN_M_SZ dependencies on STANDARD

Line 13: BOM_STANDARD_OPERATIONS bso

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 (+)
16: AND Greatest( bos.last_update_date, bor.last_update_date,
17: bso.last_update_date) between p_from_date and p_to_date

Line 15: AND bos.STANDARD_OPERATION_ID = BSO.STANDARD_OPERATION_ID (+)

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 (+)
16: AND Greatest( bos.last_update_date, bor.last_update_date,
17: bso.last_update_date) between p_from_date and p_to_date
18: UNION ALL
19: SELECT count(*) cnt

Line 59: FROM bom_standard_operations

55:
56: CURSOR c_bso IS
57: SELECT avg(nvl(vsize(OPERATION_CODE), 0)) code,
58: avg(nvl(vsize(OPERATION_DESCRIPTION), 0)) des
59: FROM bom_standard_operations
60: WHERE last_update_date between p_from_date and p_to_date;
61:
62:
63: x_instance_fk NUMBER;