[Home] [Help]
207: mmtt.lpn_id
208: from wms_op_plan_instances wopi, -- after review on 07/30/03, replaced wms_op_plans_b table with wms_op_plan_instances.
209: wms_op_plan_details wopd,
210: -- wms_zones_b wzb, -- Removed after Code Review on Sept 11th 2003.
211: mtl_material_transactions_temp mmtt,
212: wms_op_operation_instances wooi -- Added after review on 07/30/03
213: where mmtt.organization_id = nvl(wopi.organization_id, mmtt.organization_id)
214: and wopd.operation_plan_detail_id = wooi.operation_plan_detail_id -- Added after review on 07/30/03
215: and wopi.op_plan_instance_id = wooi.op_plan_instance_id
237:
238: cursor c_subloc_pend_wozone_woitem is
239: select milk.subinventory_code, nvl(milk.physical_location_id, milk.inventory_location_id)
240: from mtl_item_locations milk,
241: mtl_material_transactions_temp mmtt,
242: wms_op_operation_instances wooi,
243: wms_op_plan_instances wopi,
244: wms_license_plate_numbers wlpn1,
245: wms_license_plate_numbers wlpn2
262: cursor c_subloc_pend_wzn_wosub_woitem is
263: select milk.subinventory_code, nvl(milk.physical_location_id, milk.inventory_location_id)
264: from mtl_item_locations milk,
265: wms_zone_locators wzl,
266: mtl_material_transactions_temp mmtt,
267: wms_op_operation_instances wooi,
268: wms_op_plan_instances wopi,
269: wms_license_plate_numbers wlpn1,
270: wms_license_plate_numbers wlpn2
290: cursor c_subloc_pend_wzn_wsub_woitem is
291: select milk.subinventory_code, nvl(milk.physical_location_id, milk.inventory_location_id)
292: from mtl_item_locations milk,
293: wms_zone_locators wzl,
294: mtl_material_transactions_temp mmtt,
295: wms_op_operation_instances wooi,
296: wms_op_plan_instances wopi,
297: wms_license_plate_numbers wlpn1,
298: wms_license_plate_numbers wlpn2
319:
320: cursor c_subloc_pend_wozone_witem is
321: select milk.subinventory_code, nvl(milk.physical_location_id, milk.inventory_location_id)
322: from mtl_item_locations milk,
323: mtl_material_transactions_temp mmtt,
324: wms_op_operation_instances wooi,
325: wms_op_plan_instances wopi,
326: wms_license_plate_numbers wlpn1,
327: wms_license_plate_numbers wlpn2
345: cursor c_subloc_pend_wzn_wosub_witem is
346: select milk.subinventory_code, nvl(milk.physical_location_id, milk.inventory_location_id)
347: from mtl_item_locations milk,
348: wms_zone_locators wzl,
349: mtl_material_transactions_temp mmtt,
350: wms_op_operation_instances wooi,
351: wms_op_plan_instances wopi,
352: wms_license_plate_numbers wlpn1,
353: wms_license_plate_numbers wlpn2
374: cursor c_subloc_pend_wzn_wsub_witem is
375: select milk.subinventory_code, nvl(milk.physical_location_id, milk.inventory_location_id)
376: from mtl_item_locations milk,
377: wms_zone_locators wzl,
378: mtl_material_transactions_temp mmtt,
379: wms_op_operation_instances wooi,
380: wms_op_plan_instances wopi,
381: wms_license_plate_numbers wlpn1,
382: wms_license_plate_numbers wlpn2
407: mtl_item_locations milk2,
408: mtl_secondary_inventories msi,
409: wms_zone_locators wzl,
410: -- ***** tables from the inner cursor *****
411: mtl_material_transactions_temp mmtt,
412: wms_op_operation_instances wooi,
413: wms_op_operation_instances wooi2,
414: wms_op_plan_instances wopi
415: where milk2.subinventory_code = msi.secondary_inventory_name
752: mtl_item_locations milk2,
753: mtl_secondary_inventories msi,
754: wms_zone_locators wzl,
755: -- ***** tables from the inner cursor *****
756: mtl_material_transactions_temp mmtt,
757: wms_op_operation_instances wooi,
758: wms_op_operation_instances wooi2,
759: wms_op_plan_instances wopi
760: where milk2.subinventory_code = msi.secondary_inventory_name
1094: mtl_item_locations milk2,
1095:
1096: mtl_secondary_inventories msi,
1097: -- ***** tables from the inner cursor *****
1098: mtl_material_transactions_temp mmtt,
1099: wms_op_operation_instances wooi,
1100: wms_op_operation_instances wooi2,
1101: wms_op_plan_instances wopi
1102: where