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_DISPATCHED_TASKS_HISTORY

Line 466: wms_dispatched_tasks_history wdth,

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
469: where milk2.subinventory_code = msi.secondary_inventory_name
470: and milk2.organization_id = msi.organization_id

Line 527: wms_dispatched_tasks_history wdth,

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
530: where milk2.subinventory_code = msi.secondary_inventory_name
531: and milk2.organization_id = msi.organization_id

Line 638: wms_dispatched_tasks_history wdth,

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
642: where milk2.subinventory_code = msi.secondary_inventory_name

Line 696: wms_dispatched_tasks_history wdth,

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
700: where milk2.subinventory_code = msi.secondary_inventory_name

Line 810: wms_dispatched_tasks_history wdth,

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,
812: wms_op_plan_instances_hist wopih
813: where milk2.subinventory_code = msi.secondary_inventory_name
814: and milk2.organization_id = msi.organization_id

Line 872: wms_dispatched_tasks_history wdth,

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,
874: wms_op_plan_instances_hist wopih
875: where milk2.subinventory_code = msi.secondary_inventory_name
876: and milk2.organization_id = msi.organization_id

Line 983: wms_dispatched_tasks_history wdth,

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
987: where milk2.subinventory_code = msi.secondary_inventory_name

Line 1039: wms_dispatched_tasks_history wdth,

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
1043: where milk2.subinventory_code = msi.secondary_inventory_name

Line 1148: wms_dispatched_tasks_history wdth,

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,
1150: mtl_item_locations milk1,
1151: mtl_item_locations milk2
1152: where milk2.subinventory_code = msi.secondary_inventory_name

Line 1205: wms_dispatched_tasks_history wdth,

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,
1207: mtl_item_locations milk1,
1208: mtl_item_locations milk2
1209: where milk2.subinventory_code = msi.secondary_inventory_name

Line 1308: wms_dispatched_tasks_history wdth,

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,
1310: mtl_item_locations milk1,
1311: mtl_item_locations milk2
1312: where milk2.subinventory_code = msi.secondary_inventory_name

Line 1358: wms_dispatched_tasks_history wdth,

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,
1360: mtl_item_locations milk1,
1361: mtl_item_locations milk2
1362: where milk2.subinventory_code = msi.secondary_inventory_name