979: AND bic2.effectivity_date > bic.effectivity_date
980: AND (bic2.implementation_date is not null OR
981: (bic2.implementation_date is null AND EXISTS
982: (SELECT NULL
983: FROM eng_revised_items eri
984: WHERE bic2.revised_item_sequence_id =
985: eri.revised_item_sequence_id
986: AND eri.mrp_active = 1 ))))
987: AND (bic.implementation_date is not null OR
986: AND eri.mrp_active = 1 ))))
987: AND (bic.implementation_date is not null OR
988: (bic.implementation_date is null AND EXISTS
989: (SELECT NULL
990: FROM eng_revised_items eri
991: WHERE bic.revised_item_sequence_id =
992: eri.revised_item_sequence_id
993: AND eri.mrp_active = 1 )))
994: AND mllc.plan_id = g_kanban_info_rec.kanban_plan_id
1548: AND bic2.effectivity_date > bic.effectivity_date
1549: AND (bic2.implementation_date is not null OR
1550: (bic2.implementation_date is null AND EXISTS
1551: (SELECT NULL
1552: FROM eng_revised_items eri
1553: WHERE bic2.revised_item_sequence_id =
1554: eri.revised_item_sequence_id
1555: AND eri.mrp_active = 1 ))))
1556: AND (bic.implementation_date is not null OR
1555: AND eri.mrp_active = 1 ))))
1556: AND (bic.implementation_date is not null OR
1557: (bic.implementation_date is null AND EXISTS
1558: (SELECT NULL
1559: FROM eng_revised_items eri
1560: WHERE bic.revised_item_sequence_id =
1561: eri.revised_item_sequence_id
1562: AND eri.mrp_active = 1 )))
1563: AND mllc.plan_id = g_kanban_info_rec.kanban_plan_id
2053: AND bic2.effectivity_date > bic.effectivity_date
2054: AND (bic2.implementation_date is not null OR
2055: (bic2.implementation_date is null AND EXISTS
2056: (SELECT NULL
2057: FROM eng_revised_items eri
2058: WHERE bic2.revised_item_sequence_id =
2059: eri.revised_item_sequence_id
2060: AND eri.mrp_active = 1 ))))
2061: AND (bic.implementation_date is not null OR
2060: AND eri.mrp_active = 1 ))))
2061: AND (bic.implementation_date is not null OR
2062: (bic.implementation_date is null AND EXISTS
2063: (SELECT NULL
2064: FROM eng_revised_items eri
2065: WHERE bic.revised_item_sequence_id =
2066: eri.revised_item_sequence_id
2067: AND eri.mrp_active = 1 )))
2068: AND mllc.plan_id = g_kanban_info_rec.kanban_plan_id