701: old_task_id
702: FROM
703: mtl_system_items msi,
704: bom_inventory_components bic,
705: bom_bill_of_materials bbom
706: WHERE bbom.assembly_item_id = item_id
707: AND NVL(bbom.alternate_bom_designator, '@$!') =
708: NVL(new_bill_desig, '@$!')
709: AND bbom.organization_id = org_id
798: old_task_id
799: FROM
800: mtl_system_items msi,
801: bom_inventory_components bic,
802: bom_bill_of_materials bbom
803: WHERE bbom.assembly_item_id = item_id
804: AND NVL(bbom.alternate_bom_designator, '@$!') =
805: NVL(new_bill_desig, '@$!')
806: AND bbom.organization_id = org_id
885: old_task_id
886: FROM
887: mtl_system_items msi,
888: bom_inventory_components bic,
889: bom_bill_of_materials bbom
890: WHERE bbom.assembly_item_id = item_id
891: AND NVL(bbom.alternate_bom_designator, '@$!') =
892: NVL(old_bill_desig, '@$!')
893: AND bbom.organization_id = org_id