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
603: BOS.operation_seq_num phantom_op_seq_num,
604: BOS.department_id
605: FROM
606: MTL_UOM_CONVERSIONS CON,
607: BOM_RESOURCES BR,
608: BOM_OPERATION_RESOURCES BOR,
609: BOM_DEPARTMENT_RESOURCES BDR1,
610: BOM_DEPARTMENT_RESOURCES BDR2,
611: BOM_OPERATION_SEQUENCES BOS,
710:
711: /* get UOM_code */
712: select unit_of_measure
713: into x_uom_code
714: from BOM_RESOURCES
715: where resource_id = cur_resc.resource_id;
716:
717: /* Bug 1691488 */
718: