eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_ATF_DEST_LOC dependencies on WMS_ZONE_LOCATORS

Line 265: wms_zone_locators wzl,

261: --
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,

Line 293: wms_zone_locators wzl,

289: --
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,

Line 348: wms_zone_locators wzl,

344: --
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,

Line 377: wms_zone_locators wzl,

373: --
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,

Line 409: wms_zone_locators wzl,

405: select wooi.from_subinventory_code, milk2.inventory_location_id, wzl.zone_id
406: from mtl_item_locations milk1,
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,

Line 464: wms_zone_locators wzl,

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,
466: wms_dispatched_tasks_history wdth,
467: mtl_item_locations milk1,
468: mtl_item_locations milk2

Line 525: wms_zone_locators wzl,

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,
527: wms_dispatched_tasks_history wdth,
528: mtl_item_locations milk1,
529: mtl_item_locations milk2

Line 588: wms_zone_locators wzl,

584: from
585: mtl_item_locations milk1,
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

Line 637: wms_zone_locators wzl,

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,
639: wms_license_plate_numbers wlpn,
640: mtl_item_locations milk1,
641: mtl_item_locations milk2

Line 695: wms_zone_locators wzl,

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,
697: wms_license_plate_numbers wlpn,
698: mtl_item_locations milk1,
699: mtl_item_locations milk2

Line 754: wms_zone_locators wzl,

750: select wooi.from_subinventory_code, milk2.inventory_location_id, wzl.zone_id
751: from mtl_item_locations milk1,
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,

Line 807: wms_zone_locators wzl,

803: select wooih.to_subinventory_code, milk2.inventory_location_id, wzl.zone_id
804: from mtl_item_locations milk1,
805: mtl_item_locations milk2,
806: mtl_secondary_inventories msi,
807: wms_zone_locators wzl,
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,

Line 869: wms_zone_locators wzl,

865: select wooih.to_subinventory_code, milk2.inventory_location_id, wzl.zone_id
866: from mtl_item_locations milk1,
867: mtl_item_locations milk2,
868: mtl_secondary_inventories msi,
869: wms_zone_locators wzl,
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,

Line 932: wms_zone_locators wzl,

928: select wooi.from_subinventory_code, milk2.inventory_location_id, wzl.zone_id
929: from mtl_item_locations milk1,
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

Line 982: wms_zone_locators wzl,

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,
984: wms_license_plate_numbers wlpn,
985: mtl_item_locations milk1,
986: mtl_item_locations milk2

Line 1038: wms_zone_locators wzl,

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,
1040: wms_license_plate_numbers wlpn,
1041: mtl_item_locations milk1,
1042: mtl_item_locations milk2

Line 1408: wms_zone_locators wzl

1404: cursor c_aux_wzone_wsub is
1405: select milk.inventory_location_id, milk.subinventory_code, wzl.zone_id
1406: from mtl_secondary_inventories msi,
1407: mtl_item_locations milk,
1408: wms_zone_locators wzl
1409: where milk.subinventory_code = msi.secondary_inventory_name
1410: and milk.organization_id = msi.organization_id
1411: and ((milk.disable_date is null and msi.disable_date is null)
1412: or (not ( milk.disable_date < l_sys_date

Line 1437: wms_zone_locators wzl

1433: cursor c_aux_wzone_only is
1434: select milk.inventory_location_id, milk.subinventory_code, wzl.zone_id
1435: from mtl_secondary_inventories msi,
1436: mtl_item_locations milk,
1437: wms_zone_locators wzl
1438: where milk.subinventory_code = msi.secondary_inventory_name
1439: and milk.organization_id = msi.organization_id
1440: and ((milk.disable_date is null and msi.disable_date is null)
1441: or (not ( milk.disable_date < l_sys_date