DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_ENGINE dependencies on WMS_BUS_EVENT_DEVICES

Line 615: , wms_bus_event_devices wbed

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
619: AND wd.enabled_flag = 'Y'

Line 964: , wms_bus_event_devices wbed

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
968: AND wd.enabled_flag = 'Y'

Line 1196: , wms_bus_event_devices wbed

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
1200: AND wd.enabled_flag = 'Y'

Line 1521: , wms_bus_event_devices wbed

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
1525: AND wd.enabled_flag = 'Y'

Line 1868: , wms_bus_event_devices wbed

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
1872: AND wd.enabled_flag = 'Y'

Line 2094: , wms_bus_event_devices wbed

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
2098: AND wd.enabled_flag = 'Y'

Line 2525: , wms_bus_event_devices wbed

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
2529: AND wd.enabled_flag = 'Y'

Line 3014: , wms_bus_event_devices wbed

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
3018: AND wd.enabled_flag = 'Y'

Line 3260: , wms_bus_event_devices wbed

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
3264: AND wd.enabled_flag = 'Y'

Line 4875: , wms_bus_event_devices wbed

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
4879: AND wd.enabled_flag = 'Y'

Line 5031: , wms_bus_event_devices wbed

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
5035: AND wd.enabled_flag = 'Y'

Line 5184: , wms_bus_event_devices wbed

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
5188: AND wd.enabled_flag = 'Y'

Line 5338: , wms_bus_event_devices wbed

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
5342: AND wd.enabled_flag = 'Y'

Line 5493: , wms_bus_event_devices wbed

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
5497: AND wd.enabled_flag = 'Y'

Line 5646: , wms_bus_event_devices wbed

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
5650: AND wd.enabled_flag = 'Y'

Line 5797: , wms_bus_event_devices wbed

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
5801: AND wd.enabled_flag = 'Y'

Line 5949: , wms_bus_event_devices wbed

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
5953: AND wd.enabled_flag = 'Y'

Line 6099: , wms_bus_event_devices wbed

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
6103: AND wd.enabled_flag = 'Y'

Line 6253: , wms_bus_event_devices wbed

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
6257: AND wd.enabled_flag = 'Y'

Line 6401: , wms_bus_event_devices wbed

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
6405: AND wd.enabled_flag = 'Y'

Line 6552: , wms_bus_event_devices wbed

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
6556: AND wd.enabled_flag = 'Y'

Line 7792: , wms_bus_event_devices wbed

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
7796: AND wd.enabled_flag = 'Y'

Line 7947: , wms_bus_event_devices wbed

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
7951: AND wd.enabled_flag = 'Y'

Line 8113: , wms_bus_event_devices wbed

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
8117: AND wd.enabled_flag = 'Y'

Line 8265: , wms_bus_event_devices wbed

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
8269: AND wd.enabled_flag = 'Y'

Line 8509: , wms_bus_event_devices wbed

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
8513: AND wd.enabled_flag = 'Y'

Line 8735: , wms_bus_event_devices wbed

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
8739: AND wd.enabled_flag = 'Y'

Line 8982: , wms_bus_event_devices wbed

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
8986: AND wd.enabled_flag = 'Y'

Line 9199: , wms_bus_event_devices wbed

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
9203: AND wd.enabled_flag = 'Y'

Line 9442: , wms_bus_event_devices wbed

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
9446: AND wd.enabled_flag = 'Y'

Line 9666: , wms_bus_event_devices wbed

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
9670: AND wd.enabled_flag = 'Y'

Line 9907: , wms_bus_event_devices wbed

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
9911: AND wd.enabled_flag = 'Y'

Line 10122: , wms_bus_event_devices wbed

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
10126: AND wd.enabled_flag = 'Y'