298: AND plan_level > 0
299: AND extended_quantity > 0
300: AND TOP_BILL_SEQUENCE_ID =
301: (SELECT bill_sequence_id
302: FROM bom_bill_of_materials
303: WHERE assembly_item_id = g_atp_rec.inventory_item_id(i)
304: AND organization_id = p_organization_id
305: AND ALTERNATE_BOM_DESIGNATOR IS NULL)
306: AND EFFECTIVITY_DATE <= SYSDATE AND DISABLE_DATE > SYSDATE; -- AND check_atp = 1?