410: FROM DUAL
411: WHERE NOT EXISTS(
412: SELECT NULL
413: FROM BOM_OPERATION_SEQUENCES bos
414: , BOM_DEPARTMENT_RESOURCES bdr
415: , BOM_RESOURCES br
416: WHERE NVL(br.disable_date, bos.effectivity_date + 1)
417: > bos.effectivity_date
418: AND NVL(br.disable_date, sysdate + 1)