[Home] [Help]
204: wopd.operation_type,
205: nvl(wopd.is_in_inventory, 'N'),
206: mmtt.organization_id,
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
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)
247: and wopi.orig_dest_sub_code = decode(l_loc_mtrl_grp_rule_id,2,l_orig_dest_sub_code,wopi.orig_dest_sub_code )
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)
272: and wopi.orig_dest_sub_code = decode(l_loc_mtrl_grp_rule_id,2,l_orig_dest_sub_code,wopi.orig_dest_sub_code )
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)
300: and wopi.orig_dest_sub_code = decode(l_loc_mtrl_grp_rule_id,2,l_orig_dest_sub_code,wopi.orig_dest_sub_code )
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)
329: and wopi.orig_dest_sub_code = decode(l_loc_mtrl_grp_rule_id,2,l_orig_dest_sub_code,wopi.orig_dest_sub_code )
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)
355: and wopi.orig_dest_sub_code = decode(l_loc_mtrl_grp_rule_id,2,l_orig_dest_sub_code,wopi.orig_dest_sub_code )
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)
384: and wopi.orig_dest_sub_code = decode(l_loc_mtrl_grp_rule_id,2,l_orig_dest_sub_code,wopi.orig_dest_sub_code )
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)
418: or (not ( milk2.disable_date < l_sys_date
457: --
458: --
459: cursor c_comp_wzone_wsub_witem is
460: select wooih.to_subinventory_code, milk2.inventory_location_id, wzl.zone_id
461: from wms_op_plan_instances_hist wopih,
462: wms_op_opertn_instances_hist wooih,
463: mtl_secondary_inventories msi,
464: wms_zone_locators wzl,
465: wms_license_plate_numbers wlpn,
518: --
519: --
520: cursor c_comp_wzonesubitem_destsub is
521: select wooih.to_subinventory_code, milk2.inventory_location_id, wzl.zone_id
522: from wms_op_plan_instances_hist wopih,
523: wms_op_opertn_instances_hist wooih,
524: mtl_secondary_inventories msi,
525: wms_zone_locators wzl,
526: wms_license_plate_numbers wlpn,
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
596: and ((milk2.disable_date is null and msi.disable_date is null)
630: --
631: --
632: cursor c_comp_wzone_wsub_woitem is
633: select wooih.to_subinventory_code, milk2.inventory_location_id, wzl.zone_id
634: from wms_op_plan_instances_hist wopih,
635: wms_op_opertn_instances_hist wooih,
636: mtl_secondary_inventories msi,
637: wms_zone_locators wzl,
638: wms_dispatched_tasks_history wdth,
688: --
689: --
690: cursor c_comp_wzonesub_woitem_destsub is
691: select wooih.to_subinventory_code, milk2.inventory_location_id, wzl.zone_id
692: from wms_op_plan_instances_hist wopih,
693: wms_op_opertn_instances_hist wooih,
694: mtl_secondary_inventories msi,
695: wms_zone_locators wzl,
696: wms_dispatched_tasks_history wdth,
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)
763: or (not ( milk2.disable_date < l_sys_date
808: -- ***** tables from the inner cursor *****
809: wms_license_plate_numbers wlpn,
810: wms_dispatched_tasks_history wdth,
811: wms_op_opertn_instances_hist wooih,
812: wms_op_plan_instances_hist wopih
813: where milk2.subinventory_code = msi.secondary_inventory_name
814: and milk2.organization_id = msi.organization_id
815: and ((milk2.disable_date is null and msi.disable_date is null)
816: or (not ( milk2.disable_date < l_sys_date
870: -- ***** tables from the inner cursor *****
871: wms_license_plate_numbers wlpn,
872: wms_dispatched_tasks_history wdth,
873: wms_op_opertn_instances_hist wooih,
874: wms_op_plan_instances_hist wopih
875: where milk2.subinventory_code = msi.secondary_inventory_name
876: and milk2.organization_id = msi.organization_id
877: and ((milk2.disable_date is null and msi.disable_date is null)
878: or (not ( milk2.disable_date < l_sys_date
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)
940: or (not ( milk2.disable_date < l_sys_date
975: --
976: --
977: cursor c_comp_wzone_only_woitem is
978: select wooih.to_subinventory_code, milk2.inventory_location_id, wzl.zone_id
979: from wms_op_plan_instances_hist wopih,
980: wms_op_opertn_instances_hist wooih,
981: mtl_secondary_inventories msi,
982: wms_zone_locators wzl,
983: wms_dispatched_tasks_history wdth,
1031: --
1032: --
1033: cursor c_comp_wzoneonlywoitem_destsub is
1034: select wooih.to_subinventory_code, milk2.inventory_location_id, wzl.zone_id
1035: from wms_op_plan_instances_hist wopih,
1036: wms_op_opertn_instances_hist wooih,
1037: mtl_secondary_inventories msi,
1038: wms_zone_locators wzl,
1039: wms_dispatched_tasks_history wdth,
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
1105: and ((milk2.disable_date is null and msi.disable_date is null)
1141: --
1142: --
1143: cursor c_comp_wozone_witem is
1144: select wlpn.subinventory_code, milk2.inventory_location_id
1145: from wms_op_plan_instances_hist wopih,
1146: wms_op_opertn_instances_hist wooih,
1147: mtl_secondary_inventories msi,
1148: wms_dispatched_tasks_history wdth,
1149: wms_license_plate_numbers wlpn,
1198: --
1199: --
1200: cursor c_comp_wozone_witem_destsub is
1201: select wlpn.subinventory_code, milk2.inventory_location_id
1202: from wms_op_plan_instances_hist wopih,
1203: wms_op_opertn_instances_hist wooih,
1204: mtl_secondary_inventories msi,
1205: wms_dispatched_tasks_history wdth,
1206: wms_license_plate_numbers wlpn,
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)
1271: or (not ( milk2.disable_date < l_sys_date
1301: --
1302: --
1303: cursor c_comp_wozone_woitem is
1304: select wlpn.subinventory_code, milk2.inventory_location_id
1305: from wms_op_plan_instances_hist wopih,
1306: wms_op_opertn_instances_hist wooih,
1307: mtl_secondary_inventories msi,
1308: wms_dispatched_tasks_history wdth,
1309: wms_license_plate_numbers wlpn,
1351: --
1352: --
1353: cursor c_comp_wozone_woitem_destsub is
1354: select wlpn.subinventory_code, milk2.inventory_location_id
1355: from wms_op_plan_instances_hist wopih,
1356: wms_op_opertn_instances_hist wooih,
1357: mtl_secondary_inventories msi,
1358: wms_dispatched_tasks_history wdth,
1359: wms_license_plate_numbers wlpn,