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_TASK_DISPATCH_ENGINE dependencies on WMS_DEVICE_ASSIGNMENT_TEMP

Line 625: FROM wms_device_assignment_temp

621: AND wbed.business_event_id = 10
622: AND wd.subinventory_code IS NOT NULL
623: AND wd.force_sign_on_flag = 'Y'
624: AND wd.device_id NOT IN (SELECT device_id
625: FROM wms_device_assignment_temp
626: WHERE employee_id = p_sign_on_emp_id)
627: )
628: ORDER BY
629: task_priority desc,

Line 974: FROM wms_device_assignment_temp

970: AND wbed.business_event_id = 10
971: AND wd.subinventory_code IS NOT NULL
972: AND wd.force_sign_on_flag = 'Y'
973: AND wd.device_id NOT IN (SELECT device_id
974: FROM wms_device_assignment_temp
975: WHERE employee_id = p_sign_on_emp_id)
976: )
977: ORDER BY
978: task_priority desc,

Line 1206: FROM wms_device_assignment_temp

1202: AND wbed.business_event_id = 10
1203: AND wd.subinventory_code IS NOT NULL
1204: AND wd.force_sign_on_flag = 'Y'
1205: AND wd.device_id NOT IN (SELECT device_id
1206: FROM wms_device_assignment_temp
1207: WHERE employee_id = p_sign_on_emp_id)
1208: )
1209: ORDER BY
1210: task_priority desc,

Line 1531: FROM wms_device_assignment_temp

1527: AND wbed.business_event_id = 10
1528: AND wd.subinventory_code IS NOT NULL
1529: AND wd.force_sign_on_flag = 'Y'
1530: AND wd.device_id NOT IN (SELECT device_id
1531: FROM wms_device_assignment_temp
1532: WHERE employee_id = p_sign_on_emp_id)
1533: )
1534:
1535: ORDER BY

Line 1878: FROM wms_device_assignment_temp

1874: AND wbed.business_event_id = 10
1875: AND wd.subinventory_code IS NOT NULL
1876: AND wd.force_sign_on_flag = 'Y'
1877: AND wd.device_id NOT IN (SELECT device_id
1878: FROM wms_device_assignment_temp
1879: WHERE employee_id = p_sign_on_emp_id)
1880: )
1881: ORDER BY
1882: task_priority desc,

Line 2104: FROM wms_device_assignment_temp

2100: AND wbed.business_event_id = 10
2101: AND wd.subinventory_code IS NOT NULL
2102: AND wd.force_sign_on_flag = 'Y'
2103: AND wd.device_id NOT IN (SELECT device_id
2104: FROM wms_device_assignment_temp
2105: WHERE employee_id = p_sign_on_emp_id)
2106: )
2107: ORDER BY
2108: task_priority desc,

Line 2535: FROM wms_device_assignment_temp

2531: AND wbed.business_event_id = 10
2532: AND wd.subinventory_code IS NOT NULL
2533: AND wd.force_sign_on_flag = 'Y'
2534: AND wd.device_id NOT IN (SELECT device_id
2535: FROM wms_device_assignment_temp
2536: WHERE employee_id = p_sign_on_emp_id)
2537: )
2538: ORDER BY
2539: sub_picking_order,

Line 3024: FROM wms_device_assignment_temp

3020: AND wbed.business_event_id = 10
3021: AND wd.subinventory_code IS NOT NULL
3022: AND wd.force_sign_on_flag = 'Y'
3023: AND wd.device_id NOT IN (SELECT device_id
3024: FROM wms_device_assignment_temp
3025: WHERE employee_id = p_sign_on_emp_id)
3026: )
3027: ORDER BY
3028: sub_picking_order,

Line 3270: FROM wms_device_assignment_temp

3266: AND wbed.business_event_id = 10
3267: AND wd.subinventory_code IS NOT NULL
3268: AND wd.force_sign_on_flag = 'Y'
3269: AND wd.device_id NOT IN (SELECT device_id
3270: FROM wms_device_assignment_temp
3271: WHERE employee_id = p_sign_on_emp_id)
3272: )
3273: ORDER BY
3274: sub_picking_order,

Line 4885: FROM wms_device_assignment_temp

4881: AND wbed.business_event_id = 10
4882: AND wd.subinventory_code IS NOT NULL
4883: AND wd.force_sign_on_flag = 'Y'
4884: AND wd.device_id NOT IN (SELECT device_id
4885: FROM wms_device_assignment_temp
4886: WHERE employee_id = p_sign_on_emp_id)
4887: )
4888: ORDER BY nvl(wdtv.task_priority, 0)
4889: , -- removed order by segments for bug 2657909

Line 5041: FROM wms_device_assignment_temp

5037: AND wbed.business_event_id = 10
5038: AND wd.subinventory_code IS NOT NULL
5039: AND wd.force_sign_on_flag = 'Y'
5040: AND wd.device_id NOT IN (SELECT device_id
5041: FROM wms_device_assignment_temp
5042: WHERE employee_id = p_sign_on_emp_id)
5043: )
5044: ORDER BY nvl(wdtv.task_priority, 0)
5045: , -- removed order by segments for bug 2657909

Line 5194: FROM wms_device_assignment_temp

5190: AND wbed.business_event_id = 10
5191: AND wd.subinventory_code IS NOT NULL
5192: AND wd.force_sign_on_flag = 'Y'
5193: AND wd.device_id NOT IN (SELECT device_id
5194: FROM wms_device_assignment_temp
5195: WHERE employee_id = p_sign_on_emp_id)
5196: )
5197: ORDER BY nvl(wdtv.task_priority, 0)
5198: , -- removed order by segments for bug 2657909

Line 5348: FROM wms_device_assignment_temp

5344: AND wbed.business_event_id = 10
5345: AND wd.subinventory_code IS NOT NULL
5346: AND wd.force_sign_on_flag = 'Y'
5347: AND wd.device_id NOT IN (SELECT device_id
5348: FROM wms_device_assignment_temp
5349: WHERE employee_id = p_sign_on_emp_id)
5350: )
5351: ORDER BY nvl(wdtv.task_priority, 0)
5352: , -- removed order by segments for bug 2657909

Line 5503: FROM wms_device_assignment_temp

5499: AND wbed.business_event_id = 10
5500: AND wd.subinventory_code IS NOT NULL
5501: AND wd.force_sign_on_flag = 'Y'
5502: AND wd.device_id NOT IN (SELECT device_id
5503: FROM wms_device_assignment_temp
5504: WHERE employee_id = p_sign_on_emp_id)
5505: )
5506: ORDER BY nvl(wdtv.task_priority, 0)
5507: , -- removed order by segments for bug 2657909

Line 5656: FROM wms_device_assignment_temp

5652: AND wbed.business_event_id = 10
5653: AND wd.subinventory_code IS NOT NULL
5654: AND wd.force_sign_on_flag = 'Y'
5655: AND wd.device_id NOT IN (SELECT device_id
5656: FROM wms_device_assignment_temp
5657: WHERE employee_id = p_sign_on_emp_id)
5658: )
5659: ORDER BY nvl(wdtv.task_priority, 0)
5660: , -- removed order by segments for bug 2657909

Line 5807: FROM wms_device_assignment_temp

5803: AND wbed.business_event_id = 10
5804: AND wd.subinventory_code IS NOT NULL
5805: AND wd.force_sign_on_flag = 'Y'
5806: AND wd.device_id NOT IN (SELECT device_id
5807: FROM wms_device_assignment_temp
5808: WHERE employee_id = p_sign_on_emp_id)
5809: )
5810: ORDER BY nvl(wdtv.task_priority, 0)
5811: , -- removed order by segments for bug 2657909

Line 5959: FROM wms_device_assignment_temp

5955: AND wbed.business_event_id = 10
5956: AND wd.subinventory_code IS NOT NULL
5957: AND wd.force_sign_on_flag = 'Y'
5958: AND wd.device_id NOT IN (SELECT device_id
5959: FROM wms_device_assignment_temp
5960: WHERE employee_id = p_sign_on_emp_id)
5961: )
5962: ORDER BY nvl(wdtv.task_priority, 0)
5963: , -- removed order by segments for bug 2657909

Line 6109: FROM wms_device_assignment_temp

6105: AND wbed.business_event_id = 10
6106: AND wd.subinventory_code IS NOT NULL
6107: AND wd.force_sign_on_flag = 'Y'
6108: AND wd.device_id NOT IN (SELECT device_id
6109: FROM wms_device_assignment_temp
6110: WHERE employee_id = p_sign_on_emp_id)
6111: )
6112: ORDER BY nvl(wdtv.task_priority, 0)
6113: , -- removed order by segments for bug 2657909

Line 6263: FROM wms_device_assignment_temp

6259: AND wbed.business_event_id = 10
6260: AND wd.subinventory_code IS NOT NULL
6261: AND wd.force_sign_on_flag = 'Y'
6262: AND wd.device_id NOT IN (SELECT device_id
6263: FROM wms_device_assignment_temp
6264: WHERE employee_id = p_sign_on_emp_id)
6265: )
6266: ORDER BY nvl(wdtv.task_priority, 0)
6267: , -- removed order by segments for bug 2657909

Line 6411: FROM wms_device_assignment_temp

6407: AND wbed.business_event_id = 10
6408: AND wd.subinventory_code IS NOT NULL
6409: AND wd.force_sign_on_flag = 'Y'
6410: AND wd.device_id NOT IN (SELECT device_id
6411: FROM wms_device_assignment_temp
6412: WHERE employee_id = p_sign_on_emp_id)
6413: )
6414:
6415: ORDER BY nvl(wdtv.task_priority, 0)

Line 6562: FROM wms_device_assignment_temp

6558: AND wbed.business_event_id = 10
6559: AND wd.subinventory_code IS NOT NULL
6560: AND wd.force_sign_on_flag = 'Y'
6561: AND wd.device_id NOT IN (SELECT device_id
6562: FROM wms_device_assignment_temp
6563: WHERE employee_id = p_sign_on_emp_id)
6564: )
6565: ORDER BY nvl(wdtv.task_priority, 0)
6566: , -- removed order by segments for bug 2657909

Line 7802: FROM wms_device_assignment_temp

7798: AND wbed.business_event_id = 10
7799: AND wd.subinventory_code IS NOT NULL
7800: AND wd.force_sign_on_flag = 'Y'
7801: AND wd.device_id NOT IN (SELECT device_id
7802: FROM wms_device_assignment_temp
7803: WHERE employee_id = p_sign_on_emp_id)
7804: )
7805:
7806: --*****************

Line 7957: FROM wms_device_assignment_temp

7953: AND wbed.business_event_id = 10
7954: AND wd.subinventory_code IS NOT NULL
7955: AND wd.force_sign_on_flag = 'Y'
7956: AND wd.device_id NOT IN (SELECT device_id
7957: FROM wms_device_assignment_temp
7958: WHERE employee_id = p_sign_on_emp_id)
7959: )
7960: ORDER BY wdtv_task_priority
7961: , sub_picking_order

Line 8123: FROM wms_device_assignment_temp

8119: AND wbed.business_event_id = 10
8120: AND wd.subinventory_code IS NOT NULL
8121: AND wd.force_sign_on_flag = 'Y'
8122: AND wd.device_id NOT IN (SELECT device_id
8123: FROM wms_device_assignment_temp
8124: WHERE employee_id = p_sign_on_emp_id)
8125: )
8126:
8127: UNION ALL

Line 8275: FROM wms_device_assignment_temp

8271: AND wbed.business_event_id = 10
8272: AND wd.subinventory_code IS NOT NULL
8273: AND wd.force_sign_on_flag = 'Y'
8274: AND wd.device_id NOT IN (SELECT device_id
8275: FROM wms_device_assignment_temp
8276: WHERE employee_id = p_sign_on_emp_id)
8277: )
8278: ORDER BY wdtv_task_priority
8279: , sub_picking_order

Line 8519: FROM wms_device_assignment_temp

8515: AND wbed.business_event_id = 10
8516: AND wd.subinventory_code IS NOT NULL
8517: AND wd.force_sign_on_flag = 'Y'
8518: AND wd.device_id NOT IN (SELECT device_id
8519: FROM wms_device_assignment_temp
8520: WHERE employee_id = p_sign_on_emp_id)
8521: )
8522:
8523: ORDER BY wdtv_task_priority DESC

Line 8745: FROM wms_device_assignment_temp

8741: AND wbed.business_event_id = 10
8742: AND wd.subinventory_code IS NOT NULL
8743: AND wd.force_sign_on_flag = 'Y'
8744: AND wd.device_id NOT IN (SELECT device_id
8745: FROM wms_device_assignment_temp
8746: WHERE employee_id = p_sign_on_emp_id)
8747: )
8748: ORDER BY wdtv_task_priority DESC
8749: , batch_id

Line 8992: FROM wms_device_assignment_temp

8988: AND wbed.business_event_id = 10
8989: AND wd.subinventory_code IS NOT NULL
8990: AND wd.force_sign_on_flag = 'Y'
8991: AND wd.device_id NOT IN (SELECT device_id
8992: FROM wms_device_assignment_temp
8993: WHERE employee_id = p_sign_on_emp_id)
8994: )
8995: UNION ALL
8996: SELECT DISTINCT

Line 9209: FROM wms_device_assignment_temp

9205: AND wbed.business_event_id = 10
9206: AND wd.subinventory_code IS NOT NULL
9207: AND wd.force_sign_on_flag = 'Y'
9208: AND wd.device_id NOT IN (SELECT device_id
9209: FROM wms_device_assignment_temp
9210: WHERE employee_id = p_sign_on_emp_id)
9211: )
9212: ORDER BY wdtv_task_priority DESC
9213: , batch_id

Line 9452: FROM wms_device_assignment_temp

9448: AND wbed.business_event_id = 10
9449: AND wd.subinventory_code IS NOT NULL
9450: AND wd.force_sign_on_flag = 'Y'
9451: AND wd.device_id NOT IN (SELECT device_id
9452: FROM wms_device_assignment_temp
9453: WHERE employee_id = p_sign_on_emp_id)
9454: )
9455: ORDER BY wdtv_task_priority DESC
9456: , batch_id

Line 9676: FROM wms_device_assignment_temp

9672: AND wbed.business_event_id = 10
9673: AND wd.subinventory_code IS NOT NULL
9674: AND wd.force_sign_on_flag = 'Y'
9675: AND wd.device_id NOT IN (SELECT device_id
9676: FROM wms_device_assignment_temp
9677: WHERE employee_id = p_sign_on_emp_id)
9678: )
9679: ORDER BY wdtv_task_priority DESC
9680: , batch_id

Line 9917: FROM wms_device_assignment_temp

9913: AND wbed.business_event_id = 10
9914: AND wd.subinventory_code IS NOT NULL
9915: AND wd.force_sign_on_flag = 'Y'
9916: AND wd.device_id NOT IN (SELECT device_id
9917: FROM wms_device_assignment_temp
9918: WHERE employee_id = p_sign_on_emp_id)
9919: )
9920: UNION ALL
9921: SELECT DISTINCT

Line 10132: FROM wms_device_assignment_temp

10128: AND wbed.business_event_id = 10
10129: AND wd.subinventory_code IS NOT NULL
10130: AND wd.force_sign_on_flag = 'Y'
10131: AND wd.device_id NOT IN (SELECT device_id
10132: FROM wms_device_assignment_temp
10133: WHERE employee_id = p_sign_on_emp_id)
10134: )
10135: ORDER BY wdtv_task_priority DESC
10136: , batch_id -- DECODE (L_SEQUENCE_PICKS_ACROSS_WAVES, 2, MOL.HEADER_ID, NULL)