258: Added condition to take into consideration bom effectivity dates. */
259: and comp.component_sequence_id = expl.component_sequence_id
260: /* Updated by Liye Ma. Mar.5th 2001
261: Fixed bug 1668713
262: Select only components whose type is standard */
263: and sys.bom_item_type = 4
264: /* End of Update */
265: and comp.component_item_id = expl.component_item_id
266: and comp.bill_sequence_id = expl.bill_sequence_id