DBA Data[Home] [Help]

APPS.OPI_EDW_OPI_OPRN_M_SZ dependencies on BOM_OPERATIONAL_ROUTINGS

Line 12: BOM_OPERATIONAL_ROUTINGS BOR,

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 (+)
16: AND Greatest( bos.last_update_date, bor.last_update_date,