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 529: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r

525: (SELECT
526: x_utt_res1.standard_operation_id standard_operation_id,
527: x_utt_res1.resource_id resource_id,
528: x_emp_r.person_id
529: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
530: WHERE x_utt_res1.resource_id = r1.resource_id
531: AND r1.resource_type = 2
532: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp,
533: (SELECT

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

874: (SELECT
875: x_utt_res1.standard_operation_id standard_operation_id,
876: x_utt_res1.resource_id resource_id,
877: x_emp_r.person_id
878: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
879: WHERE x_utt_res1.resource_id = r1.resource_id
880: AND r1.resource_type = 2
881: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp,
882: (SELECT

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

1120: (SELECT
1121: x_utt_res1.standard_operation_id standard_operation_id,
1122: x_utt_res1.resource_id resource_id,
1123: x_emp_r.person_id
1124: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
1125: WHERE x_utt_res1.resource_id = r1.resource_id
1126: AND r1.resource_type = 2
1127: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp,
1128: (SELECT

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

1432: (SELECT
1433: x_utt_res1.standard_operation_id standard_operation_id,
1434: x_utt_res1.resource_id resource_id,
1435: x_emp_r.person_id
1436: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
1437: WHERE x_utt_res1.resource_id = r1.resource_id
1438: AND r1.resource_type = 2
1439: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp,
1440: (SELECT

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

1779: (SELECT
1780: x_utt_res1.standard_operation_id standard_operation_id,
1781: x_utt_res1.resource_id resource_id,
1782: x_emp_r.person_id
1783: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
1784: WHERE x_utt_res1.resource_id = r1.resource_id
1785: AND r1.resource_type = 2
1786: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp,
1787: (SELECT

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

2019: (SELECT
2020: x_utt_res1.standard_operation_id standard_operation_id,
2021: x_utt_res1.resource_id resource_id,
2022: x_emp_r.person_id
2023: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
2024: WHERE x_utt_res1.resource_id = r1.resource_id
2025: AND r1.resource_type = 2
2026: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp,
2027: (SELECT

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

2414: x_utt_res1.resource_id resource_id,
2415: x_emp_r.person_id,
2416: x_emp_r.effective_start_date,
2417: x_emp_r.effective_end_date
2418: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
2419: WHERE x_utt_res1.resource_id = r1.resource_id
2420: AND r1.resource_type = 2
2421: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp,
2422: (SELECT

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

2903: x_utt_res1.resource_id resource_id,
2904: x_emp_r.person_id,
2905: x_emp_r.effective_start_date,
2906: x_emp_r.effective_end_date
2907: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
2908: WHERE x_utt_res1.resource_id = r1.resource_id
2909: AND r1.resource_type = 2
2910: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp,
2911: (SELECT

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

3206: x_utt_res1.resource_id resource_id,
3207: x_emp_r.person_id,
3208: x_emp_r.effective_start_date,
3209: x_emp_r.effective_end_date
3210: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
3211: WHERE x_utt_res1.resource_id = r1.resource_id
3212: AND r1.resource_type = 2
3213: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp,
3214: (SELECT

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

4816: , NULL eqp_srl /* removed for bug 2095237 */
4817: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
4818: , x_utt_res1.resource_id resource_id
4819: , x_emp_r.person_id
4820: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
4821: WHERE x_utt_res1.resource_id = r1.resource_id
4822: AND r1.resource_type = 2
4823: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
4824: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

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

4970: , NULL eqp_srl /* removed for bug 2095237 */
4971: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
4972: , x_utt_res1.resource_id resource_id
4973: , x_emp_r.person_id
4974: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
4975: WHERE x_utt_res1.resource_id = r1.resource_id
4976: AND r1.resource_type = 2
4977: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
4978: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

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

5126: , NULL eqp_srl /* removed for bug 2095237 */
5127: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
5128: , x_utt_res1.resource_id resource_id
5129: , x_emp_r.person_id
5130: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
5131: WHERE x_utt_res1.resource_id = r1.resource_id
5132: AND r1.resource_type = 2
5133: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
5134: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

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

5279: , NULL eqp_srl /* removed for bug 2095237 */
5280: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
5281: , x_utt_res1.resource_id resource_id
5282: , x_emp_r.person_id
5283: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
5284: WHERE x_utt_res1.resource_id = r1.resource_id
5285: AND r1.resource_type = 2
5286: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
5287: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

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

5432: , NULL eqp_srl /* removed for bug 2095237 */
5433: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
5434: , x_utt_res1.resource_id resource_id
5435: , x_emp_r.person_id
5436: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
5437: WHERE x_utt_res1.resource_id = r1.resource_id
5438: AND r1.resource_type = 2
5439: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
5440: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

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

5586: , NULL eqp_srl /* removed for bug 2095237 */
5587: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
5588: , x_utt_res1.resource_id resource_id
5589: , x_emp_r.person_id
5590: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
5591: WHERE x_utt_res1.resource_id = r1.resource_id
5592: AND r1.resource_type = 2
5593: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
5594: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

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

5739: , NULL eqp_srl /* removed for bug 2095237 */
5740: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
5741: , x_utt_res1.resource_id resource_id
5742: , x_emp_r.person_id
5743: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
5744: WHERE x_utt_res1.resource_id = r1.resource_id
5745: AND r1.resource_type = 2
5746: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
5747: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

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

5890: , NULL eqp_srl /* removed for bug 2095237 */
5891: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
5892: , x_utt_res1.resource_id resource_id
5893: , x_emp_r.person_id
5894: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
5895: WHERE x_utt_res1.resource_id = r1.resource_id
5896: AND r1.resource_type = 2
5897: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
5898: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

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

6038: , NULL eqp_srl /* removed for bug 2095237 */
6039: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
6040: , x_utt_res1.resource_id resource_id
6041: , x_emp_r.person_id
6042: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
6043: WHERE x_utt_res1.resource_id = r1.resource_id
6044: AND r1.resource_type = 2
6045: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
6046: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

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

6189: , NULL eqp_srl /* removed for bug 2095237 */
6190: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
6191: , x_utt_res1.resource_id resource_id
6192: , x_emp_r.person_id
6193: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
6194: WHERE x_utt_res1.resource_id = r1.resource_id
6195: AND r1.resource_type = 2
6196: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
6197: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

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

6340: , NULL eqp_srl /* removed for bug 2095237 */
6341: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
6342: , x_utt_res1.resource_id resource_id
6343: , x_emp_r.person_id
6344: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
6345: WHERE x_utt_res1.resource_id = r1.resource_id
6346: AND r1.resource_type = 2
6347: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
6348: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

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

6490: , NULL eqp_srl /* removed for bug 2095237 */
6491: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
6492: , x_utt_res1.resource_id resource_id
6493: , x_emp_r.person_id
6494: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
6495: WHERE x_utt_res1.resource_id = r1.resource_id
6496: AND r1.resource_type = 2
6497: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
6498: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

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

7720: , NULL eqp_srl /* removed for bug 2095237 */
7721: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
7722: , x_utt_res1.resource_id resource_id
7723: , x_emp_r.person_id
7724: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
7725: WHERE x_utt_res1.resource_id = r1.resource_id
7726: AND r1.resource_type = 2
7727: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
7728: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

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

7881: , NULL eqp_srl /* removed for bug 2095237 */
7882: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
7883: , x_utt_res1.resource_id resource_id
7884: , x_emp_r.person_id
7885: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
7886: WHERE x_utt_res1.resource_id = r1.resource_id
7887: AND r1.resource_type = 2
7888: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
7889: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

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

8041: , NULL eqp_srl /* removed for bug 2095237 */
8042: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
8043: , x_utt_res1.resource_id resource_id
8044: , x_emp_r.person_id
8045: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
8046: WHERE x_utt_res1.resource_id = r1.resource_id
8047: AND r1.resource_type = 2
8048: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
8049: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

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

8201: , NULL eqp_srl /* removed for bug 2095237 */
8202: FROM (SELECT x_utt_res1.standard_operation_id standard_operation_id
8203: , x_utt_res1.resource_id resource_id
8204: , x_emp_r.person_id
8205: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
8206: WHERE x_utt_res1.resource_id = r1.resource_id
8207: AND r1.resource_type = 2
8208: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
8209: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

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

8437: , x_utt_res1.resource_id resource_id
8438: , x_emp_r.person_id
8439: , x_emp_r.effective_start_date
8440: , x_emp_r.effective_end_date
8441: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
8442: WHERE x_utt_res1.resource_id = r1.resource_id
8443: AND r1.resource_type = 2
8444: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
8445: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

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

8669: , x_utt_res1.resource_id resource_id
8670: , x_emp_r.person_id
8671: , x_emp_r.effective_start_date
8672: , x_emp_r.effective_end_date
8673: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
8674: WHERE x_utt_res1.resource_id = r1.resource_id
8675: AND r1.resource_type = 2
8676: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
8677: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

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

8909: , x_utt_res1.resource_id resource_id
8910: , x_emp_r.person_id
8911: , x_emp_r.effective_start_date
8912: , x_emp_r.effective_end_date
8913: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
8914: WHERE x_utt_res1.resource_id = r1.resource_id
8915: AND r1.resource_type = 2
8916: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
8917: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

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

9133: , x_utt_res1.resource_id resource_id
9134: , x_emp_r.person_id
9135: , x_emp_r.effective_start_date
9136: , x_emp_r.effective_end_date
9137: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
9138: WHERE x_utt_res1.resource_id = r1.resource_id
9139: AND r1.resource_type = 2
9140: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
9141: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

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

9371: , x_utt_res1.resource_id resource_id
9372: , x_emp_r.person_id
9373: , x_emp_r.effective_start_date
9374: , x_emp_r.effective_end_date
9375: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
9376: WHERE x_utt_res1.resource_id = r1.resource_id
9377: AND r1.resource_type = 2
9378: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
9379: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

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

9601: , x_utt_res1.resource_id resource_id
9602: , x_emp_r.person_id
9603: , x_emp_r.effective_start_date
9604: , x_emp_r.effective_end_date
9605: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
9606: WHERE x_utt_res1.resource_id = r1.resource_id
9607: AND r1.resource_type = 2
9608: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
9609: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

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

9835: , x_utt_res1.resource_id resource_id
9836: , x_emp_r.person_id
9837: , x_emp_r.effective_start_date
9838: , x_emp_r.effective_end_date
9839: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
9840: WHERE x_utt_res1.resource_id = r1.resource_id
9841: AND r1.resource_type = 2
9842: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
9843: , (SELECT x_utt_res2.standard_operation_id standard_operation_id

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

10057: , x_utt_res1.resource_id resource_id
10058: , x_emp_r.person_id
10059: , x_emp_r.effective_start_date
10060: , x_emp_r.effective_end_date
10061: FROM bom_std_op_resources x_utt_res1, bom_resources r1, bom_resource_employees x_emp_r
10062: WHERE x_utt_res1.resource_id = r1.resource_id
10063: AND r1.resource_type = 2
10064: AND x_utt_res1.resource_id = x_emp_r.resource_id) utt_emp
10065: , (SELECT x_utt_res2.standard_operation_id standard_operation_id