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.

[Home] [Help]

APPS.WMS_TASK_DISPATCH_ENGINE dependencies on WMS_DEVICE_ASSIGNMENT_TEMP

Line 587: FROM wms_device_assignment_temp

583: AND wbed.business_event_id = 10
584: AND wd.subinventory_code IS NOT NULL
585: AND wd.force_sign_on_flag = 'Y'
586: AND wd.device_id NOT IN (SELECT device_id
587: FROM wms_device_assignment_temp
588: WHERE employee_id = p_sign_on_emp_id)
589: )
590: ORDER BY
591: task_priority desc,

Line 936: FROM wms_device_assignment_temp

932: AND wbed.business_event_id = 10
933: AND wd.subinventory_code IS NOT NULL
934: AND wd.force_sign_on_flag = 'Y'
935: AND wd.device_id NOT IN (SELECT device_id
936: FROM wms_device_assignment_temp
937: WHERE employee_id = p_sign_on_emp_id)
938: )
939: ORDER BY
940: task_priority desc,

Line 1168: FROM wms_device_assignment_temp

1164: AND wbed.business_event_id = 10
1165: AND wd.subinventory_code IS NOT NULL
1166: AND wd.force_sign_on_flag = 'Y'
1167: AND wd.device_id NOT IN (SELECT device_id
1168: FROM wms_device_assignment_temp
1169: WHERE employee_id = p_sign_on_emp_id)
1170: )
1171: ORDER BY
1172: task_priority desc,

Line 1493: FROM wms_device_assignment_temp

1489: AND wbed.business_event_id = 10
1490: AND wd.subinventory_code IS NOT NULL
1491: AND wd.force_sign_on_flag = 'Y'
1492: AND wd.device_id NOT IN (SELECT device_id
1493: FROM wms_device_assignment_temp
1494: WHERE employee_id = p_sign_on_emp_id)
1495: )
1496:
1497: ORDER BY

Line 1840: FROM wms_device_assignment_temp

1836: AND wbed.business_event_id = 10
1837: AND wd.subinventory_code IS NOT NULL
1838: AND wd.force_sign_on_flag = 'Y'
1839: AND wd.device_id NOT IN (SELECT device_id
1840: FROM wms_device_assignment_temp
1841: WHERE employee_id = p_sign_on_emp_id)
1842: )
1843: ORDER BY
1844: task_priority desc,

Line 2064: FROM wms_device_assignment_temp

2060: AND wbed.business_event_id = 10
2061: AND wd.subinventory_code IS NOT NULL
2062: AND wd.force_sign_on_flag = 'Y'
2063: AND wd.device_id NOT IN (SELECT device_id
2064: FROM wms_device_assignment_temp
2065: WHERE employee_id = p_sign_on_emp_id)
2066: )
2067: ORDER BY
2068: task_priority desc,

Line 2443: FROM wms_device_assignment_temp

2439: AND wbed.business_event_id = 10
2440: AND wd.subinventory_code IS NOT NULL
2441: AND wd.force_sign_on_flag = 'Y'
2442: AND wd.device_id NOT IN (SELECT device_id
2443: FROM wms_device_assignment_temp
2444: WHERE employee_id = p_sign_on_emp_id)
2445: )
2446: ORDER BY
2447: sub_picking_order,

Line 2864: FROM wms_device_assignment_temp

2860: AND wbed.business_event_id = 10
2861: AND wd.subinventory_code IS NOT NULL
2862: AND wd.force_sign_on_flag = 'Y'
2863: AND wd.device_id NOT IN (SELECT device_id
2864: FROM wms_device_assignment_temp
2865: WHERE employee_id = p_sign_on_emp_id)
2866: )
2867: ORDER BY
2868: sub_picking_order,

Line 3108: FROM wms_device_assignment_temp

3104: AND wbed.business_event_id = 10
3105: AND wd.subinventory_code IS NOT NULL
3106: AND wd.force_sign_on_flag = 'Y'
3107: AND wd.device_id NOT IN (SELECT device_id
3108: FROM wms_device_assignment_temp
3109: WHERE employee_id = p_sign_on_emp_id)
3110: )
3111: ORDER BY
3112: sub_picking_order,

Line 4546: FROM wms_device_assignment_temp

4542: AND wbed.business_event_id = 10
4543: AND wd.subinventory_code IS NOT NULL
4544: AND wd.force_sign_on_flag = 'Y'
4545: AND wd.device_id NOT IN (SELECT device_id
4546: FROM wms_device_assignment_temp
4547: WHERE employee_id = p_sign_on_emp_id)
4548: )
4549: ORDER BY nvl(wdtv.task_priority, 0)
4550: , -- removed order by segments for bug 2657909

Line 4702: FROM wms_device_assignment_temp

4698: AND wbed.business_event_id = 10
4699: AND wd.subinventory_code IS NOT NULL
4700: AND wd.force_sign_on_flag = 'Y'
4701: AND wd.device_id NOT IN (SELECT device_id
4702: FROM wms_device_assignment_temp
4703: WHERE employee_id = p_sign_on_emp_id)
4704: )
4705: ORDER BY nvl(wdtv.task_priority, 0)
4706: , -- removed order by segments for bug 2657909

Line 4855: FROM wms_device_assignment_temp

4851: AND wbed.business_event_id = 10
4852: AND wd.subinventory_code IS NOT NULL
4853: AND wd.force_sign_on_flag = 'Y'
4854: AND wd.device_id NOT IN (SELECT device_id
4855: FROM wms_device_assignment_temp
4856: WHERE employee_id = p_sign_on_emp_id)
4857: )
4858: ORDER BY nvl(wdtv.task_priority, 0)
4859: , -- removed order by segments for bug 2657909

Line 5009: FROM wms_device_assignment_temp

5005: AND wbed.business_event_id = 10
5006: AND wd.subinventory_code IS NOT NULL
5007: AND wd.force_sign_on_flag = 'Y'
5008: AND wd.device_id NOT IN (SELECT device_id
5009: FROM wms_device_assignment_temp
5010: WHERE employee_id = p_sign_on_emp_id)
5011: )
5012: ORDER BY nvl(wdtv.task_priority, 0)
5013: , -- removed order by segments for bug 2657909

Line 5164: FROM wms_device_assignment_temp

5160: AND wbed.business_event_id = 10
5161: AND wd.subinventory_code IS NOT NULL
5162: AND wd.force_sign_on_flag = 'Y'
5163: AND wd.device_id NOT IN (SELECT device_id
5164: FROM wms_device_assignment_temp
5165: WHERE employee_id = p_sign_on_emp_id)
5166: )
5167: ORDER BY nvl(wdtv.task_priority, 0)
5168: , -- removed order by segments for bug 2657909

Line 5317: FROM wms_device_assignment_temp

5313: AND wbed.business_event_id = 10
5314: AND wd.subinventory_code IS NOT NULL
5315: AND wd.force_sign_on_flag = 'Y'
5316: AND wd.device_id NOT IN (SELECT device_id
5317: FROM wms_device_assignment_temp
5318: WHERE employee_id = p_sign_on_emp_id)
5319: )
5320: ORDER BY nvl(wdtv.task_priority, 0)
5321: , -- removed order by segments for bug 2657909

Line 5468: FROM wms_device_assignment_temp

5464: AND wbed.business_event_id = 10
5465: AND wd.subinventory_code IS NOT NULL
5466: AND wd.force_sign_on_flag = 'Y'
5467: AND wd.device_id NOT IN (SELECT device_id
5468: FROM wms_device_assignment_temp
5469: WHERE employee_id = p_sign_on_emp_id)
5470: )
5471: ORDER BY nvl(wdtv.task_priority, 0)
5472: , -- removed order by segments for bug 2657909

Line 5620: FROM wms_device_assignment_temp

5616: AND wbed.business_event_id = 10
5617: AND wd.subinventory_code IS NOT NULL
5618: AND wd.force_sign_on_flag = 'Y'
5619: AND wd.device_id NOT IN (SELECT device_id
5620: FROM wms_device_assignment_temp
5621: WHERE employee_id = p_sign_on_emp_id)
5622: )
5623: ORDER BY nvl(wdtv.task_priority, 0)
5624: , -- removed order by segments for bug 2657909

Line 5770: FROM wms_device_assignment_temp

5766: AND wbed.business_event_id = 10
5767: AND wd.subinventory_code IS NOT NULL
5768: AND wd.force_sign_on_flag = 'Y'
5769: AND wd.device_id NOT IN (SELECT device_id
5770: FROM wms_device_assignment_temp
5771: WHERE employee_id = p_sign_on_emp_id)
5772: )
5773: ORDER BY nvl(wdtv.task_priority, 0)
5774: , -- removed order by segments for bug 2657909

Line 5924: FROM wms_device_assignment_temp

5920: AND wbed.business_event_id = 10
5921: AND wd.subinventory_code IS NOT NULL
5922: AND wd.force_sign_on_flag = 'Y'
5923: AND wd.device_id NOT IN (SELECT device_id
5924: FROM wms_device_assignment_temp
5925: WHERE employee_id = p_sign_on_emp_id)
5926: )
5927: ORDER BY nvl(wdtv.task_priority, 0)
5928: , -- removed order by segments for bug 2657909

Line 6072: FROM wms_device_assignment_temp

6068: AND wbed.business_event_id = 10
6069: AND wd.subinventory_code IS NOT NULL
6070: AND wd.force_sign_on_flag = 'Y'
6071: AND wd.device_id NOT IN (SELECT device_id
6072: FROM wms_device_assignment_temp
6073: WHERE employee_id = p_sign_on_emp_id)
6074: )
6075:
6076: ORDER BY nvl(wdtv.task_priority, 0)

Line 6223: FROM wms_device_assignment_temp

6219: AND wbed.business_event_id = 10
6220: AND wd.subinventory_code IS NOT NULL
6221: AND wd.force_sign_on_flag = 'Y'
6222: AND wd.device_id NOT IN (SELECT device_id
6223: FROM wms_device_assignment_temp
6224: WHERE employee_id = p_sign_on_emp_id)
6225: )
6226: ORDER BY nvl(wdtv.task_priority, 0)
6227: , -- removed order by segments for bug 2657909

Line 7463: FROM wms_device_assignment_temp

7459: AND wbed.business_event_id = 10
7460: AND wd.subinventory_code IS NOT NULL
7461: AND wd.force_sign_on_flag = 'Y'
7462: AND wd.device_id NOT IN (SELECT device_id
7463: FROM wms_device_assignment_temp
7464: WHERE employee_id = p_sign_on_emp_id)
7465: )
7466:
7467: --*****************

Line 7618: FROM wms_device_assignment_temp

7614: AND wbed.business_event_id = 10
7615: AND wd.subinventory_code IS NOT NULL
7616: AND wd.force_sign_on_flag = 'Y'
7617: AND wd.device_id NOT IN (SELECT device_id
7618: FROM wms_device_assignment_temp
7619: WHERE employee_id = p_sign_on_emp_id)
7620: )
7621: ORDER BY wdtv_task_priority
7622: , sub_picking_order

Line 7784: FROM wms_device_assignment_temp

7780: AND wbed.business_event_id = 10
7781: AND wd.subinventory_code IS NOT NULL
7782: AND wd.force_sign_on_flag = 'Y'
7783: AND wd.device_id NOT IN (SELECT device_id
7784: FROM wms_device_assignment_temp
7785: WHERE employee_id = p_sign_on_emp_id)
7786: )
7787:
7788: UNION ALL

Line 7936: FROM wms_device_assignment_temp

7932: AND wbed.business_event_id = 10
7933: AND wd.subinventory_code IS NOT NULL
7934: AND wd.force_sign_on_flag = 'Y'
7935: AND wd.device_id NOT IN (SELECT device_id
7936: FROM wms_device_assignment_temp
7937: WHERE employee_id = p_sign_on_emp_id)
7938: )
7939: ORDER BY wdtv_task_priority
7940: , sub_picking_order

Line 8180: FROM wms_device_assignment_temp

8176: AND wbed.business_event_id = 10
8177: AND wd.subinventory_code IS NOT NULL
8178: AND wd.force_sign_on_flag = 'Y'
8179: AND wd.device_id NOT IN (SELECT device_id
8180: FROM wms_device_assignment_temp
8181: WHERE employee_id = p_sign_on_emp_id)
8182: )
8183:
8184: ORDER BY wdtv_task_priority DESC

Line 8406: FROM wms_device_assignment_temp

8402: AND wbed.business_event_id = 10
8403: AND wd.subinventory_code IS NOT NULL
8404: AND wd.force_sign_on_flag = 'Y'
8405: AND wd.device_id NOT IN (SELECT device_id
8406: FROM wms_device_assignment_temp
8407: WHERE employee_id = p_sign_on_emp_id)
8408: )
8409: ORDER BY wdtv_task_priority DESC
8410: , batch_id

Line 8653: FROM wms_device_assignment_temp

8649: AND wbed.business_event_id = 10
8650: AND wd.subinventory_code IS NOT NULL
8651: AND wd.force_sign_on_flag = 'Y'
8652: AND wd.device_id NOT IN (SELECT device_id
8653: FROM wms_device_assignment_temp
8654: WHERE employee_id = p_sign_on_emp_id)
8655: )
8656: UNION ALL
8657: SELECT DISTINCT

Line 8870: FROM wms_device_assignment_temp

8866: AND wbed.business_event_id = 10
8867: AND wd.subinventory_code IS NOT NULL
8868: AND wd.force_sign_on_flag = 'Y'
8869: AND wd.device_id NOT IN (SELECT device_id
8870: FROM wms_device_assignment_temp
8871: WHERE employee_id = p_sign_on_emp_id)
8872: )
8873: ORDER BY wdtv_task_priority DESC
8874: , batch_id

Line 9113: FROM wms_device_assignment_temp

9109: AND wbed.business_event_id = 10
9110: AND wd.subinventory_code IS NOT NULL
9111: AND wd.force_sign_on_flag = 'Y'
9112: AND wd.device_id NOT IN (SELECT device_id
9113: FROM wms_device_assignment_temp
9114: WHERE employee_id = p_sign_on_emp_id)
9115: )
9116: ORDER BY wdtv_task_priority DESC
9117: , batch_id

Line 9337: FROM wms_device_assignment_temp

9333: AND wbed.business_event_id = 10
9334: AND wd.subinventory_code IS NOT NULL
9335: AND wd.force_sign_on_flag = 'Y'
9336: AND wd.device_id NOT IN (SELECT device_id
9337: FROM wms_device_assignment_temp
9338: WHERE employee_id = p_sign_on_emp_id)
9339: )
9340: ORDER BY wdtv_task_priority DESC
9341: , batch_id

Line 9578: FROM wms_device_assignment_temp

9574: AND wbed.business_event_id = 10
9575: AND wd.subinventory_code IS NOT NULL
9576: AND wd.force_sign_on_flag = 'Y'
9577: AND wd.device_id NOT IN (SELECT device_id
9578: FROM wms_device_assignment_temp
9579: WHERE employee_id = p_sign_on_emp_id)
9580: )
9581: UNION ALL
9582: SELECT DISTINCT

Line 9793: FROM wms_device_assignment_temp

9789: AND wbed.business_event_id = 10
9790: AND wd.subinventory_code IS NOT NULL
9791: AND wd.force_sign_on_flag = 'Y'
9792: AND wd.device_id NOT IN (SELECT device_id
9793: FROM wms_device_assignment_temp
9794: WHERE employee_id = p_sign_on_emp_id)
9795: )
9796: ORDER BY wdtv_task_priority DESC
9797: , batch_id -- DECODE (L_SEQUENCE_PICKS_ACROSS_WAVES, 2, MOL.HEADER_ID, NULL)