[Home] [Help]
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
216: and wopi.operation_plan_id = mmtt.operation_plan_id
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
246: where wopi.plan_type_id = decode(l_loc_mtrl_grp_rule_id,1,l_plan_type_id,wopi.plan_type_id)
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
271: where wopi.plan_type_id = decode(l_loc_mtrl_grp_rule_id,1,l_plan_type_id,wopi.plan_type_id)
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
299: where wopi.plan_type_id = decode(l_loc_mtrl_grp_rule_id,1,l_plan_type_id,wopi.plan_type_id)
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
328: where wopi.plan_type_id = decode(l_loc_mtrl_grp_rule_id,1,l_plan_type_id,wopi.plan_type_id)
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
354: where wopi.plan_type_id = decode(l_loc_mtrl_grp_rule_id,1,l_plan_type_id,wopi.plan_type_id)
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
383: where wopi.plan_type_id = decode(l_loc_mtrl_grp_rule_id,1,l_plan_type_id,wopi.plan_type_id)
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
416: and milk2.organization_id = msi.organization_id
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
416: and milk2.organization_id = msi.organization_id
417: and ((milk2.disable_date is null and msi.disable_date is null)
586: mtl_item_locations milk2,
587: mtl_secondary_inventories msi,
588: wms_zone_locators wzl,
589: -- ***** tables from the inner cursor *****
590: wms_op_operation_instances wooi,
591: wms_op_operation_instances wooi2,
592: wms_op_plan_instances wopi
593: where
594: milk2.subinventory_code = msi.secondary_inventory_name
587: mtl_secondary_inventories msi,
588: wms_zone_locators wzl,
589: -- ***** tables from the inner cursor *****
590: wms_op_operation_instances wooi,
591: wms_op_operation_instances wooi2,
592: wms_op_plan_instances wopi
593: where
594: milk2.subinventory_code = msi.secondary_inventory_name
595: and milk2.organization_id = msi.organization_id
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
761: and milk2.organization_id = msi.organization_id
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
761: and milk2.organization_id = msi.organization_id
762: and ((milk2.disable_date is null and msi.disable_date is null)
930: mtl_item_locations milk2,
931: mtl_secondary_inventories msi,
932: wms_zone_locators wzl,
933: -- ***** tables from the inner cursor *****
934: wms_op_operation_instances wooi,
935: wms_op_operation_instances wooi2,
936: wms_op_plan_instances wopi
937: where milk2.subinventory_code = msi.secondary_inventory_name
938: and milk2.organization_id = msi.organization_id
931: mtl_secondary_inventories msi,
932: wms_zone_locators wzl,
933: -- ***** tables from the inner cursor *****
934: wms_op_operation_instances wooi,
935: wms_op_operation_instances wooi2,
936: wms_op_plan_instances wopi
937: where milk2.subinventory_code = msi.secondary_inventory_name
938: and milk2.organization_id = msi.organization_id
939: and ((milk2.disable_date is null and msi.disable_date is null)
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
1103: milk2.subinventory_code = msi.secondary_inventory_name
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
1103: milk2.subinventory_code = msi.secondary_inventory_name
1104: and milk2.organization_id = msi.organization_id
1261: mtl_item_locations milk1,
1262: mtl_item_locations milk2,
1263: mtl_secondary_inventories msi,
1264: -- ***** tables from the inner cursor *****
1265: wms_op_operation_instances wooi,
1266: wms_op_operation_instances wooi2,
1267: wms_op_plan_instances wopi
1268: where milk2.subinventory_code = msi.secondary_inventory_name
1269: and milk2.organization_id = msi.organization_id
1262: mtl_item_locations milk2,
1263: mtl_secondary_inventories msi,
1264: -- ***** tables from the inner cursor *****
1265: wms_op_operation_instances wooi,
1266: wms_op_operation_instances wooi2,
1267: wms_op_plan_instances wopi
1268: where milk2.subinventory_code = msi.secondary_inventory_name
1269: and milk2.organization_id = msi.organization_id
1270: and ((milk2.disable_date is null and msi.disable_date is null)