1067: msi.eng_item_flag,
1068: 'N'))
1069: and ( ( mti.wip_entity_type in (1,5)
1070: and not exists(select 'X'
1071: from wip_requirement_operations wro
1072: where wro.organization_id = mti.organization_id
1073: and wro.wip_entity_id = mti.transaction_source_id
1074: and wro.inventory_item_id = mti.inventory_item_id
1075: and wro.operation_seq_num = mti.operation_seq_num))
1074: and wro.inventory_item_id = mti.inventory_item_id
1075: and wro.operation_seq_num = mti.operation_seq_num))
1076: or ( mti.wip_entity_type = 2
1077: and not exists(select 'X'
1078: from wip_requirement_operations wro,
1079: wip_repetitive_schedules wrs
1080: where wro.organization_id = mti.organization_id
1081: and wro.wip_entity_id = mti.transaction_source_id
1082: and wro.inventory_item_id = mti.inventory_item_id