DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_ENGINE dependencies on WMS_DEVICES_B

Line 614: FROM wms_devices_b wd

610: AND wste.organization_id = mp.organization_id)
611: --J Addition
612: AND wdtv.zone not in (
613: SELECT wd.subinventory_code
614: FROM wms_devices_b wd
615: , wms_bus_event_devices wbed
616: WHERE 1 = 1
617: and wd.device_id = wbed.device_id
618: AND wbed.organization_id = wd.organization_id

Line 963: FROM wms_devices_b wd

959: AND wste.organization_id = mp.organization_id)
960: --J Addition
961: AND wdtv.zone not in (
962: SELECT wd.subinventory_code
963: FROM wms_devices_b wd
964: , wms_bus_event_devices wbed
965: WHERE 1 = 1
966: and wd.device_id = wbed.device_id
967: AND wbed.organization_id = wd.organization_id

Line 1195: FROM wms_devices_b wd

1191: AND wste.organization_id = mp.organization_id)
1192: --J Addition
1193: AND wdtv.zone not in (
1194: SELECT wd.subinventory_code
1195: FROM wms_devices_b wd
1196: , wms_bus_event_devices wbed
1197: WHERE 1 = 1
1198: and wd.device_id = wbed.device_id
1199: AND wbed.organization_id = wd.organization_id

Line 1520: FROM wms_devices_b wd

1516: AND wste.organization_id = mp.organization_id)
1517: --J Addition
1518: AND wdtv.zone not in (
1519: SELECT wd.subinventory_code
1520: FROM wms_devices_b wd
1521: , wms_bus_event_devices wbed
1522: WHERE 1 = 1
1523: and wd.device_id = wbed.device_id
1524: AND wbed.organization_id = wd.organization_id

Line 1867: FROM wms_devices_b wd

1863: AND wste.organization_id = mp.organization_id)
1864: --J Addition
1865: AND wdtv.zone not in (
1866: SELECT wd.subinventory_code
1867: FROM wms_devices_b wd
1868: , wms_bus_event_devices wbed
1869: WHERE 1 = 1
1870: and wd.device_id = wbed.device_id
1871: AND wbed.organization_id = wd.organization_id

Line 2093: FROM wms_devices_b wd

2089: AND wste.organization_id = mp.organization_id)
2090: --J Addition
2091: AND wdtv.zone not in (
2092: SELECT wd.subinventory_code
2093: FROM wms_devices_b wd
2094: , wms_bus_event_devices wbed
2095: WHERE 1 = 1
2096: and wd.device_id = wbed.device_id
2097: AND wbed.organization_id = wd.organization_id

Line 2524: FROM wms_devices_b wd

2520: AND wste.organization_id = mp.organization_id)
2521: --J Addition
2522: AND wdtv.subinventory_code not in (
2523: SELECT wd.subinventory_code
2524: FROM wms_devices_b wd
2525: , wms_bus_event_devices wbed
2526: WHERE 1 = 1
2527: and wd.device_id = wbed.device_id
2528: AND wbed.organization_id = wd.organization_id

Line 3013: FROM wms_devices_b wd

3009: AND wste.organization_id = mp.organization_id)
3010: --J Addition
3011: AND wdtv.subinventory_code not in (
3012: SELECT wd.subinventory_code
3013: FROM wms_devices_b wd
3014: , wms_bus_event_devices wbed
3015: WHERE 1 = 1
3016: and wd.device_id = wbed.device_id
3017: AND wbed.organization_id = wd.organization_id

Line 3259: FROM wms_devices_b wd

3255: AND wste.organization_id = mp.organization_id)
3256: --J Addition
3257: AND wdtv.subinventory_code not in (
3258: SELECT wd.subinventory_code
3259: FROM wms_devices_b wd
3260: , wms_bus_event_devices wbed
3261: WHERE 1 = 1
3262: and wd.device_id = wbed.device_id
3263: AND wbed.organization_id = wd.organization_id

Line 4874: FROM wms_devices_b wd

4870: --*****************
4871: --J Addition
4872: AND wdtv.ZONE not in (
4873: SELECT wd.subinventory_code
4874: FROM wms_devices_b wd
4875: , wms_bus_event_devices wbed
4876: WHERE 1 = 1
4877: and wd.device_id = wbed.device_id
4878: AND wbed.organization_id = wd.organization_id

Line 5030: FROM wms_devices_b wd

5026: --*****************
5027: --J Addition
5028: AND wdtv.ZONE not in (
5029: SELECT wd.subinventory_code
5030: FROM wms_devices_b wd
5031: , wms_bus_event_devices wbed
5032: WHERE 1 = 1
5033: and wd.device_id = wbed.device_id
5034: AND wbed.organization_id = wd.organization_id

Line 5183: FROM wms_devices_b wd

5179: --*****************
5180: --J Addition
5181: AND wdtv.ZONE not in (
5182: SELECT wd.subinventory_code
5183: FROM wms_devices_b wd
5184: , wms_bus_event_devices wbed
5185: WHERE 1 = 1
5186: and wd.device_id = wbed.device_id
5187: AND wbed.organization_id = wd.organization_id

Line 5337: FROM wms_devices_b wd

5333: --*****************
5334: --J Addition
5335: AND wdtv.ZONE not in (
5336: SELECT wd.subinventory_code
5337: FROM wms_devices_b wd
5338: , wms_bus_event_devices wbed
5339: WHERE 1 = 1
5340: and wd.device_id = wbed.device_id
5341: AND wbed.organization_id = wd.organization_id

Line 5492: FROM wms_devices_b wd

5488: --*****************
5489: --J Addition
5490: AND wdtv.ZONE not in (
5491: SELECT wd.subinventory_code
5492: FROM wms_devices_b wd
5493: , wms_bus_event_devices wbed
5494: WHERE 1 = 1
5495: and wd.device_id = wbed.device_id
5496: AND wbed.organization_id = wd.organization_id

Line 5645: FROM wms_devices_b wd

5641: --*****************
5642: --J Addition
5643: AND wdtv.ZONE not in (
5644: SELECT wd.subinventory_code
5645: FROM wms_devices_b wd
5646: , wms_bus_event_devices wbed
5647: WHERE 1 = 1
5648: and wd.device_id = wbed.device_id
5649: AND wbed.organization_id = wd.organization_id

Line 5796: FROM wms_devices_b wd

5792: --*****************
5793: --J Addition
5794: AND wdtv.ZONE not in (
5795: SELECT wd.subinventory_code
5796: FROM wms_devices_b wd
5797: , wms_bus_event_devices wbed
5798: WHERE 1 = 1
5799: and wd.device_id = wbed.device_id
5800: AND wbed.organization_id = wd.organization_id

Line 5948: FROM wms_devices_b wd

5944: --*****************
5945: --J Addition
5946: AND wdtv.ZONE not in (
5947: SELECT wd.subinventory_code
5948: FROM wms_devices_b wd
5949: , wms_bus_event_devices wbed
5950: WHERE 1 = 1
5951: and wd.device_id = wbed.device_id
5952: AND wbed.organization_id = wd.organization_id

Line 6098: FROM wms_devices_b wd

6094: --*****************
6095: --J Addition
6096: AND wdtv.ZONE not in (
6097: SELECT wd.subinventory_code
6098: FROM wms_devices_b wd
6099: , wms_bus_event_devices wbed
6100: WHERE 1 = 1
6101: and wd.device_id = wbed.device_id
6102: AND wbed.organization_id = wd.organization_id

Line 6252: FROM wms_devices_b wd

6248: --*****************
6249: --J Addition
6250: AND wdtv.ZONE not in (
6251: SELECT wd.subinventory_code
6252: FROM wms_devices_b wd
6253: , wms_bus_event_devices wbed
6254: WHERE 1 = 1
6255: and wd.device_id = wbed.device_id
6256: AND wbed.organization_id = wd.organization_id

Line 6400: FROM wms_devices_b wd

6396: --*****************
6397: --J Addition
6398: AND wdtv.ZONE not in (
6399: SELECT wd.subinventory_code
6400: FROM wms_devices_b wd
6401: , wms_bus_event_devices wbed
6402: WHERE 1 = 1
6403: and wd.device_id = wbed.device_id
6404: AND wbed.organization_id = wd.organization_id

Line 6551: FROM wms_devices_b wd

6547: --*****************
6548: --J Addition
6549: AND wdtv.ZONE not in (
6550: SELECT wd.subinventory_code
6551: FROM wms_devices_b wd
6552: , wms_bus_event_devices wbed
6553: WHERE 1 = 1
6554: and wd.device_id = wbed.device_id
6555: AND wbed.organization_id = wd.organization_id

Line 7791: FROM wms_devices_b wd

7787: AND wste.organization_id = mp.organization_id)
7788: --J Addition
7789: AND wdtv.ZONE not in (
7790: SELECT wd.subinventory_code
7791: FROM wms_devices_b wd
7792: , wms_bus_event_devices wbed
7793: WHERE 1 = 1
7794: and wd.device_id = wbed.device_id
7795: AND wbed.organization_id = wd.organization_id

Line 7946: FROM wms_devices_b wd

7942: --*****************
7943: --J Addition
7944: AND wdtv.ZONE not in (
7945: SELECT wd.subinventory_code
7946: FROM wms_devices_b wd
7947: , wms_bus_event_devices wbed
7948: WHERE 1 = 1
7949: and wd.device_id = wbed.device_id
7950: AND wbed.organization_id = wd.organization_id

Line 8112: FROM wms_devices_b wd

8108: --*****************
8109: --J Addition
8110: AND wdtv.ZONE not in (
8111: SELECT wd.subinventory_code
8112: FROM wms_devices_b wd
8113: , wms_bus_event_devices wbed
8114: WHERE 1 = 1
8115: and wd.device_id = wbed.device_id
8116: AND wbed.organization_id = wd.organization_id

Line 8264: FROM wms_devices_b wd

8260: AND wste.organization_id = mp.organization_id)
8261: --*****************
8262: --J Addition
8263: AND wdtv.ZONE not in ( SELECT wd.subinventory_code
8264: FROM wms_devices_b wd
8265: , wms_bus_event_devices wbed
8266: WHERE 1 = 1
8267: and wd.device_id = wbed.device_id
8268: AND wbed.organization_id = wd.organization_id

Line 8508: FROM wms_devices_b wd

8504: AND wste.organization_id = mp.organization_id)
8505: --J Addition
8506: AND wdtv.ZONE not in (
8507: SELECT wd.subinventory_code
8508: FROM wms_devices_b wd
8509: , wms_bus_event_devices wbed
8510: WHERE 1 = 1
8511: and wd.device_id = wbed.device_id
8512: AND wbed.organization_id = wd.organization_id

Line 8734: FROM wms_devices_b wd

8730: --*****************
8731: --J Addition
8732: AND wdtv.ZONE not in (
8733: SELECT wd.subinventory_code
8734: FROM wms_devices_b wd
8735: , wms_bus_event_devices wbed
8736: WHERE 1 = 1
8737: and wd.device_id = wbed.device_id
8738: AND wbed.organization_id = wd.organization_id

Line 8981: FROM wms_devices_b wd

8977: --*****************
8978: --J Addition
8979: AND wdtv.ZONE not in (
8980: SELECT wd.subinventory_code
8981: FROM wms_devices_b wd
8982: , wms_bus_event_devices wbed
8983: WHERE 1 = 1
8984: and wd.device_id = wbed.device_id
8985: AND wbed.organization_id = wd.organization_id

Line 9198: FROM wms_devices_b wd

9194: --*****************
9195: --J Addition
9196: AND wdtv.ZONE not in (
9197: SELECT wd.subinventory_code
9198: FROM wms_devices_b wd
9199: , wms_bus_event_devices wbed
9200: WHERE 1 = 1
9201: and wd.device_id = wbed.device_id
9202: AND wbed.organization_id = wd.organization_id

Line 9441: FROM wms_devices_b wd

9437:
9438: --J Addition
9439: AND wdtv.ZONE not in (
9440: SELECT wd.subinventory_code
9441: FROM wms_devices_b wd
9442: , wms_bus_event_devices wbed
9443: WHERE 1 = 1
9444: and wd.device_id = wbed.device_id
9445: AND wbed.organization_id = wd.organization_id

Line 9665: FROM wms_devices_b wd

9661: --*****************
9662: --J Addition
9663: AND wdtv.ZONE not in (
9664: SELECT wd.subinventory_code
9665: FROM wms_devices_b wd
9666: , wms_bus_event_devices wbed
9667: WHERE 1 = 1
9668: and wd.device_id = wbed.device_id
9669: AND wbed.organization_id = wd.organization_id

Line 9906: FROM wms_devices_b wd

9902: --*****************
9903: --J Addition
9904: AND wdtv.ZONE not in (
9905: SELECT wd.subinventory_code
9906: FROM wms_devices_b wd
9907: , wms_bus_event_devices wbed
9908: WHERE 1 = 1
9909: and wd.device_id = wbed.device_id
9910: AND wbed.organization_id = wd.organization_id

Line 10121: FROM wms_devices_b wd

10117: --*****************
10118: --J Addition
10119: AND wdtv.ZONE not in (
10120: SELECT wd.subinventory_code
10121: FROM wms_devices_b wd
10122: , wms_bus_event_devices wbed
10123: WHERE 1 = 1
10124: and wd.device_id = wbed.device_id
10125: AND wbed.organization_id = wd.organization_id