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 BOM_RESOURCE_EMPLOYEES

Line 491: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

487: (SELECT
488: x_utt_res1.standard_operation_id standard_operation_id,
489: x_utt_res1.resource_id resource_id,
490: x_emp_r.person_id
491: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
492: WHERE x_utt_res1.resource_id = r1.resource_id
493: AND r1.resource_type = 2
494: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp,
495: (SELECT

Line 840: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

836: (SELECT
837: x_utt_res1.standard_operation_id standard_operation_id,
838: x_utt_res1.resource_id resource_id,
839: x_emp_r.person_id
840: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
841: WHERE x_utt_res1.resource_id = r1.resource_id
842: AND r1.resource_type = 2
843: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp,
844: (SELECT

Line 1086: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

1082: (SELECT
1083: x_utt_res1.standard_operation_id standard_operation_id,
1084: x_utt_res1.resource_id resource_id,
1085: x_emp_r.person_id
1086: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
1087: WHERE x_utt_res1.resource_id = r1.resource_id
1088: AND r1.resource_type = 2
1089: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp,
1090: (SELECT

Line 1398: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

1394: (SELECT
1395: x_utt_res1.standard_operation_id standard_operation_id,
1396: x_utt_res1.resource_id resource_id,
1397: x_emp_r.person_id
1398: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
1399: WHERE x_utt_res1.resource_id = r1.resource_id
1400: AND r1.resource_type = 2
1401: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp,
1402: (SELECT

Line 1745: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

1741: (SELECT
1742: x_utt_res1.standard_operation_id standard_operation_id,
1743: x_utt_res1.resource_id resource_id,
1744: x_emp_r.person_id
1745: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
1746: WHERE x_utt_res1.resource_id = r1.resource_id
1747: AND r1.resource_type = 2
1748: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp,
1749: (SELECT

Line 1983: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

1979: (SELECT
1980: x_utt_res1.standard_operation_id standard_operation_id,
1981: x_utt_res1.resource_id resource_id,
1982: x_emp_r.person_id
1983: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
1984: WHERE x_utt_res1.resource_id = r1.resource_id
1985: AND r1.resource_type = 2
1986: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp,
1987: (SELECT

Line 2357: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

2353: x_utt_res1.resource_id resource_id,
2354: x_emp_r.person_id,
2355: x_emp_r.effective_start_date,
2356: x_emp_r.effective_end_date
2357: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
2358: WHERE x_utt_res1.resource_id = r1.resource_id
2359: AND r1.resource_type = 2
2360: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp,
2361: (SELECT

Line 2778: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

2774: x_utt_res1.resource_id resource_id,
2775: x_emp_r.person_id,
2776: x_emp_r.effective_start_date,
2777: x_emp_r.effective_end_date
2778: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
2779: WHERE x_utt_res1.resource_id = r1.resource_id
2780: AND r1.resource_type = 2
2781: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp,
2782: (SELECT

Line 3050: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

3046: x_utt_res1.resource_id resource_id,
3047: x_emp_r.person_id,
3048: x_emp_r.effective_start_date,
3049: x_emp_r.effective_end_date
3050: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
3051: WHERE x_utt_res1.resource_id = r1.resource_id
3052: AND r1.resource_type = 2
3053: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp,
3054: (SELECT

Line 4481: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

4477: , NULL eqp_srl /* removed for bug 2095237 */
4478: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
4479: , x_utt_res1.resource_id resource_id
4480: , x_emp_r.person_id
4481: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
4482: WHERE x_utt_res1.resource_id = r1.resource_id
4483: AND r1.resource_type = 2
4484: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
4485: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

Line 4635: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

4631: , NULL eqp_srl /* removed for bug 2095237 */
4632: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
4633: , x_utt_res1.resource_id resource_id
4634: , x_emp_r.person_id
4635: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
4636: WHERE x_utt_res1.resource_id = r1.resource_id
4637: AND r1.resource_type = 2
4638: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
4639: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

Line 4791: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

4787: , NULL eqp_srl /* removed for bug 2095237 */
4788: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
4789: , x_utt_res1.resource_id resource_id
4790: , x_emp_r.person_id
4791: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
4792: WHERE x_utt_res1.resource_id = r1.resource_id
4793: AND r1.resource_type = 2
4794: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
4795: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

Line 4944: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

4940: , NULL eqp_srl /* removed for bug 2095237 */
4941: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
4942: , x_utt_res1.resource_id resource_id
4943: , x_emp_r.person_id
4944: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
4945: WHERE x_utt_res1.resource_id = r1.resource_id
4946: AND r1.resource_type = 2
4947: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
4948: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

Line 5097: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

5093: , NULL eqp_srl /* removed for bug 2095237 */
5094: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
5095: , x_utt_res1.resource_id resource_id
5096: , x_emp_r.person_id
5097: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
5098: WHERE x_utt_res1.resource_id = r1.resource_id
5099: AND r1.resource_type = 2
5100: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
5101: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

Line 5251: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

5247: , NULL eqp_srl /* removed for bug 2095237 */
5248: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
5249: , x_utt_res1.resource_id resource_id
5250: , x_emp_r.person_id
5251: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
5252: WHERE x_utt_res1.resource_id = r1.resource_id
5253: AND r1.resource_type = 2
5254: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
5255: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

Line 5404: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

5400: , NULL eqp_srl /* removed for bug 2095237 */
5401: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
5402: , x_utt_res1.resource_id resource_id
5403: , x_emp_r.person_id
5404: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
5405: WHERE x_utt_res1.resource_id = r1.resource_id
5406: AND r1.resource_type = 2
5407: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
5408: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

Line 5555: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

5551: , NULL eqp_srl /* removed for bug 2095237 */
5552: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
5553: , x_utt_res1.resource_id resource_id
5554: , x_emp_r.person_id
5555: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
5556: WHERE x_utt_res1.resource_id = r1.resource_id
5557: AND r1.resource_type = 2
5558: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
5559: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

Line 5703: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

5699: , NULL eqp_srl /* removed for bug 2095237 */
5700: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
5701: , x_utt_res1.resource_id resource_id
5702: , x_emp_r.person_id
5703: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
5704: WHERE x_utt_res1.resource_id = r1.resource_id
5705: AND r1.resource_type = 2
5706: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
5707: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

Line 5854: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

5850: , NULL eqp_srl /* removed for bug 2095237 */
5851: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
5852: , x_utt_res1.resource_id resource_id
5853: , x_emp_r.person_id
5854: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
5855: WHERE x_utt_res1.resource_id = r1.resource_id
5856: AND r1.resource_type = 2
5857: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
5858: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

Line 6005: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

6001: , NULL eqp_srl /* removed for bug 2095237 */
6002: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
6003: , x_utt_res1.resource_id resource_id
6004: , x_emp_r.person_id
6005: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
6006: WHERE x_utt_res1.resource_id = r1.resource_id
6007: AND r1.resource_type = 2
6008: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
6009: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

Line 6155: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

6151: , NULL eqp_srl /* removed for bug 2095237 */
6152: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
6153: , x_utt_res1.resource_id resource_id
6154: , x_emp_r.person_id
6155: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
6156: WHERE x_utt_res1.resource_id = r1.resource_id
6157: AND r1.resource_type = 2
6158: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
6159: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

Line 7385: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

7381: , NULL eqp_srl /* removed for bug 2095237 */
7382: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
7383: , x_utt_res1.resource_id resource_id
7384: , x_emp_r.person_id
7385: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
7386: WHERE x_utt_res1.resource_id = r1.resource_id
7387: AND r1.resource_type = 2
7388: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
7389: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

Line 7546: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

7542: , NULL eqp_srl /* removed for bug 2095237 */
7543: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
7544: , x_utt_res1.resource_id resource_id
7545: , x_emp_r.person_id
7546: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
7547: WHERE x_utt_res1.resource_id = r1.resource_id
7548: AND r1.resource_type = 2
7549: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
7550: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

Line 7706: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

7702: , NULL eqp_srl /* removed for bug 2095237 */
7703: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
7704: , x_utt_res1.resource_id resource_id
7705: , x_emp_r.person_id
7706: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
7707: WHERE x_utt_res1.resource_id = r1.resource_id
7708: AND r1.resource_type = 2
7709: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
7710: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

Line 7866: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

7862: , NULL eqp_srl /* removed for bug 2095237 */
7863: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
7864: , x_utt_res1.resource_id resource_id
7865: , x_emp_r.person_id
7866: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
7867: WHERE x_utt_res1.resource_id = r1.resource_id
7868: AND r1.resource_type = 2
7869: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
7870: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

Line 8102: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

8098: , x_utt_res1.resource_id resource_id
8099: , x_emp_r.person_id
8100: , x_emp_r.effective_start_date
8101: , x_emp_r.effective_end_date
8102: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
8103: WHERE x_utt_res1.resource_id = r1.resource_id
8104: AND r1.resource_type = 2
8105: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
8106: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

Line 8334: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

8330: , x_utt_res1.resource_id resource_id
8331: , x_emp_r.person_id
8332: , x_emp_r.effective_start_date
8333: , x_emp_r.effective_end_date
8334: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
8335: WHERE x_utt_res1.resource_id = r1.resource_id
8336: AND r1.resource_type = 2
8337: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
8338: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

Line 8574: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

8570: , x_utt_res1.resource_id resource_id
8571: , x_emp_r.person_id
8572: , x_emp_r.effective_start_date
8573: , x_emp_r.effective_end_date
8574: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
8575: WHERE x_utt_res1.resource_id = r1.resource_id
8576: AND r1.resource_type = 2
8577: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
8578: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

Line 8798: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

8794: , x_utt_res1.resource_id resource_id
8795: , x_emp_r.person_id
8796: , x_emp_r.effective_start_date
8797: , x_emp_r.effective_end_date
8798: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
8799: WHERE x_utt_res1.resource_id = r1.resource_id
8800: AND r1.resource_type = 2
8801: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
8802: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

Line 9036: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

9032: , x_utt_res1.resource_id resource_id
9033: , x_emp_r.person_id
9034: , x_emp_r.effective_start_date
9035: , x_emp_r.effective_end_date
9036: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
9037: WHERE x_utt_res1.resource_id = r1.resource_id
9038: AND r1.resource_type = 2
9039: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
9040: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

Line 9266: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

9262: , x_utt_res1.resource_id resource_id
9263: , x_emp_r.person_id
9264: , x_emp_r.effective_start_date
9265: , x_emp_r.effective_end_date
9266: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
9267: WHERE x_utt_res1.resource_id = r1.resource_id
9268: AND r1.resource_type = 2
9269: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
9270: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

Line 9500: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

9496: , x_utt_res1.resource_id resource_id
9497: , x_emp_r.person_id
9498: , x_emp_r.effective_start_date
9499: , x_emp_r.effective_end_date
9500: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
9501: WHERE x_utt_res1.resource_id = r1.resource_id
9502: AND r1.resource_type = 2
9503: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
9504: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

Line 9722: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

9718: , x_utt_res1.resource_id resource_id
9719: , x_emp_r.person_id
9720: , x_emp_r.effective_start_date
9721: , x_emp_r.effective_end_date
9722: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
9723: WHERE x_utt_res1.resource_id = r1.resource_id
9724: AND r1.resource_type = 2
9725: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
9726: , (SELECT x_utt_res2.standard_operation_id standard_operation_id