692: new_task_id,
693: old_task_id
694: FROM
695: mtl_system_items msi,
696: bom_inventory_components bic,
697: bom_bill_of_materials bbom
698: WHERE bbom.assembly_item_id = item_id
699: AND NVL(bbom.alternate_bom_designator, '@$!') =
700: NVL(new_bill_desig, '@$!')
789: new_task_id,
790: old_task_id
791: FROM
792: mtl_system_items msi,
793: bom_inventory_components bic,
794: bom_bill_of_materials bbom
795: WHERE bbom.assembly_item_id = item_id
796: AND NVL(bbom.alternate_bom_designator, '@$!') =
797: NVL(new_bill_desig, '@$!')
876: new_task_id,
877: old_task_id
878: FROM
879: mtl_system_items msi,
880: bom_inventory_components bic,
881: bom_bill_of_materials bbom
882: WHERE bbom.assembly_item_id = item_id
883: AND NVL(bbom.alternate_bom_designator, '@$!') =
884: NVL(old_bill_desig, '@$!')