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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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