132: wdth.transaction_uom_code
133: from
134: wms_dispatched_tasks_history wdth,
135: mtl_system_items msi,
136: poa_dbi_rtx_f rtx,
137: wms_op_plans_b oplan,
138: mtl_secondary_inventories sinv
139: where
140: nvl(wdth.is_parent, 'N') = 'Y'
182: wdth.transaction_uom_code
183: from
184: wms_dispatched_tasks_history wdth,
185: mtl_system_items msi,
186: poa_dbi_rtx_f rtx,
187: wms_op_plans_b oplan,
188: mtl_secondary_inventories sinv
189: where
190: nvl(wdth.is_parent, 'N') = 'Y'
289: l_start_time current_time,
290: l_login login_id,
291: l_user user_id
292: FROM wms_dispatched_tasks_history wdth,
293: poa_dbi_rtx_f rtx,
294: wms_op_plans_b oplan,
295: mtl_secondary_inventories sinv,
296: mtl_system_items msi,
297: opi_dbi_wms_uom_rates rat
334: l_start_time current_time,
335: l_login login_id,
336: l_user user_id
337: FROM wms_dispatched_tasks_history wdth,
338: poa_dbi_rtx_f rtx,
339: wms_op_plans_b oplan,
340: mtl_secondary_inventories sinv,
341: mtl_system_items msi,
342: opi_dbi_wms_uom_rates rat