153: FROM
154: BOM_OPERATION_RESOURCES BOR,
155: WIP_FLOW_SCHEDULES wfs,
156: BOM_DEPARTMENTS BD,
157: BOM_RESOURCES BR,
158: CST_ACTIVITIES CA,
159: BOM_OPERATION_SEQUENCES BOS,
160: BOM_OPERATIONAL_ROUTINGS ROUT,
161: mtl_material_transactions_temp MMTT
606: BOS.department_id,
607: BOR.schedule_flag
608: FROM
609: MTL_UOM_CONVERSIONS CON,
610: BOM_RESOURCES BR,
611: BOM_OPERATION_RESOURCES BOR,
612: BOM_DEPARTMENT_RESOURCES BDR1,
613: BOM_DEPARTMENT_RESOURCES BDR2,
614: BOM_OPERATION_SEQUENCES BOS,
725:
726: /* get UOM_code */
727: select unit_of_measure
728: into x_uom_code
729: from BOM_RESOURCES
730: where resource_id = cur_resc.resource_id;
731:
732: /* Bug 1691488 */
733: