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_RESOURCES

Line 359: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre

355: (SELECT
356: bsor.standard_operation_id,
357: bre.resource_id,
358: bre.inventory_item_id equipment_id
359: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
360: WHERE bsor.resource_id = bre.resource_id
361: AND br.resource_type = 1
362: AND bsor.resource_id = br.resource_id) e
363: WHERE wdt.transaction_temp_id = qt.task_id

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 499: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

495: (SELECT
496: x_utt_res2.standard_operation_id standard_operation_id,
497: x_utt_res2.resource_id,
498: x_eqp_r.inventory_item_id
499: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
500: WHERE x_utt_res2.resource_id = r2.resource_id
501: AND r2.resource_type = 1
502: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
503: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,

Line 662: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre

658: (SELECT
659: bsor.standard_operation_id,
660: bre.resource_id,
661: bre.inventory_item_id equipment_id
662: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
663: WHERE bsor.resource_id = bre.resource_id
664: AND br.resource_type = 1
665: AND bsor.resource_id = br.resource_id) e
666: WHERE wdt.transaction_temp_id = qt.task_id

Line 740: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre

736: (SELECT
737: bsor.standard_operation_id,
738: bre.resource_id,
739: bre.inventory_item_id equipment_id
740: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
741: WHERE bsor.resource_id = bre.resource_id
742: AND br.resource_type = 1
743: AND bsor.resource_id = br.resource_id) e
744: WHERE wdt.transaction_temp_id = qt.task_id

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 848: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

844: (SELECT
845: x_utt_res2.standard_operation_id standard_operation_id,
846: x_utt_res2.resource_id,
847: x_eqp_r.inventory_item_id
848: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
849: WHERE x_utt_res2.resource_id = r2.resource_id
850: AND r2.resource_type = 1
851: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
852: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,

Line 1003: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre

999: (SELECT
1000: bsor.standard_operation_id,
1001: bre.resource_id,
1002: bre.inventory_item_id equipment_id
1003: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
1004: WHERE bsor.resource_id = bre.resource_id
1005: AND br.resource_type = 1
1006: AND bsor.resource_id = br.resource_id) e
1007: WHERE wdt.transaction_temp_id = qt.task_id

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 1094: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

1090: (SELECT
1091: x_utt_res2.standard_operation_id standard_operation_id,
1092: x_utt_res2.resource_id,
1093: x_eqp_r.inventory_item_id
1094: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
1095: WHERE x_utt_res2.resource_id = r2.resource_id
1096: AND r2.resource_type = 1
1097: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
1098: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,

Line 1267: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre

1263: (SELECT
1264: bsor.standard_operation_id,
1265: bre.resource_id,
1266: bre.inventory_item_id equipment_id
1267: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
1268: WHERE bsor.resource_id = bre.resource_id
1269: AND br.resource_type = 1
1270: AND bsor.resource_id = br.resource_id) e
1271: WHERE wdt.transaction_temp_id = qt.task_id

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 1406: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

1402: (SELECT
1403: x_utt_res2.standard_operation_id standard_operation_id,
1404: x_utt_res2.resource_id,
1405: x_eqp_r.inventory_item_id
1406: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
1407: WHERE x_utt_res2.resource_id = r2.resource_id
1408: AND r2.resource_type = 1
1409: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
1410: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,

Line 1569: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre

1565: (SELECT
1566: bsor.standard_operation_id,
1567: bre.resource_id,
1568: bre.inventory_item_id equipment_id
1569: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
1570: WHERE bsor.resource_id = bre.resource_id
1571: AND br.resource_type = 1
1572: AND bsor.resource_id = br.resource_id) e
1573: WHERE wdt.transaction_temp_id = qt.task_id

Line 1646: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre

1642: (SELECT
1643: bsor.standard_operation_id,
1644: bre.resource_id,
1645: bre.inventory_item_id equipment_id
1646: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
1647: WHERE bsor.resource_id = bre.resource_id
1648: AND br.resource_type = 1
1649: AND bsor.resource_id = br.resource_id) e
1650: WHERE wdt.transaction_temp_id = qt.task_id

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 1753: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

1749: (SELECT
1750: x_utt_res2.standard_operation_id standard_operation_id,
1751: x_utt_res2.resource_id,
1752: x_eqp_r.inventory_item_id
1753: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
1754: WHERE x_utt_res2.resource_id = r2.resource_id
1755: AND r2.resource_type = 1
1756: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
1757: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,

Line 1900: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre

1896: (SELECT
1897: bsor.standard_operation_id,
1898: bre.resource_id,
1899: bre.inventory_item_id equipment_id
1900: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
1901: WHERE bsor.resource_id = bre.resource_id
1902: AND br.resource_type = 1
1903: AND bsor.resource_id = br.resource_id) e
1904: WHERE wdt.transaction_temp_id = qt.task_id

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 1991: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

1987: (SELECT
1988: x_utt_res2.standard_operation_id standard_operation_id,
1989: x_utt_res2.resource_id,
1990: x_eqp_r.inventory_item_id
1991: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
1992: WHERE x_utt_res2.resource_id = r2.resource_id
1993: AND r2.resource_type = 1
1994: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
1995: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,

Line 2195: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre

2191: (SELECT
2192: bsor.standard_operation_id,
2193: bre.resource_id,
2194: bre.inventory_item_id equipment_id
2195: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
2196: WHERE bsor.resource_id = bre.resource_id
2197: AND br.resource_type = 1
2198: AND bsor.resource_id = br.resource_id) e
2199: WHERE wdt.transaction_temp_id = qt.task_id

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 2365: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

2361: (SELECT
2362: x_utt_res2.standard_operation_id standard_operation_id,
2363: x_utt_res2.resource_id,
2364: x_eqp_r.inventory_item_id
2365: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
2366: WHERE x_utt_res2.resource_id = r2.resource_id
2367: AND r2.resource_type = 1
2368: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
2369: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,

Line 2540: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre

2536: (SELECT
2537: bsor.standard_operation_id,
2538: bre.resource_id,
2539: bre.inventory_item_id equipment_id
2540: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
2541: WHERE bsor.resource_id = bre.resource_id
2542: AND br.resource_type = 1
2543: AND bsor.resource_id = br.resource_id) e
2544: WHERE wdt.transaction_temp_id = qt.task_id

Line 2649: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre

2645: (SELECT
2646: bsor.standard_operation_id,
2647: bre.resource_id,
2648: bre.inventory_item_id equipment_id
2649: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
2650: WHERE bsor.resource_id = bre.resource_id
2651: AND br.resource_type = 1
2652: AND bsor.resource_id = br.resource_id) e
2653: WHERE wdt.transaction_temp_id = qt.task_id

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 2786: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

2782: (SELECT
2783: x_utt_res2.standard_operation_id standard_operation_id,
2784: x_utt_res2.resource_id,
2785: x_eqp_r.inventory_item_id
2786: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
2787: WHERE x_utt_res2.resource_id = r2.resource_id
2788: AND r2.resource_type = 1
2789: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
2790: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,

Line 2949: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre

2945: (SELECT
2946: bsor.standard_operation_id,
2947: bre.resource_id,
2948: bre.inventory_item_id equipment_id
2949: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
2950: WHERE bsor.resource_id = bre.resource_id
2951: AND br.resource_type = 1
2952: AND bsor.resource_id = br.resource_id) e
2953: WHERE wdt.transaction_temp_id = qt.task_id

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 3058: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

3054: (SELECT
3055: x_utt_res2.standard_operation_id standard_operation_id,
3056: x_utt_res2.resource_id,
3057: x_eqp_r.inventory_item_id
3058: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
3059: WHERE x_utt_res2.resource_id = r2.resource_id
3060: AND r2.resource_type = 1
3061: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
3062: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,

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 4488: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

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
4486: , x_utt_res2.resource_id resource_id
4487: , x_eqp_r.inventory_item_id inventory_item_id
4488: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
4489: WHERE x_utt_res2.resource_id = r2.resource_id
4490: AND r2.resource_type = 1
4491: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
4492: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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 4642: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

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
4640: , x_utt_res2.resource_id resource_id
4641: , x_eqp_r.inventory_item_id inventory_item_id
4642: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
4643: WHERE x_utt_res2.resource_id = r2.resource_id
4644: AND r2.resource_type = 1
4645: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
4646: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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 4798: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

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
4796: , x_utt_res2.resource_id resource_id
4797: , x_eqp_r.inventory_item_id inventory_item_id
4798: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
4799: WHERE x_utt_res2.resource_id = r2.resource_id
4800: AND r2.resource_type = 1
4801: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
4802: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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 4951: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

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
4949: , x_utt_res2.resource_id resource_id
4950: , x_eqp_r.inventory_item_id inventory_item_id
4951: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
4952: WHERE x_utt_res2.resource_id = r2.resource_id
4953: AND r2.resource_type = 1
4954: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
4955: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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 5104: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

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
5102: , x_utt_res2.resource_id resource_id
5103: , x_eqp_r.inventory_item_id inventory_item_id
5104: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
5105: WHERE x_utt_res2.resource_id = r2.resource_id
5106: AND r2.resource_type = 1
5107: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
5108: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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 5258: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

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
5256: , x_utt_res2.resource_id resource_id
5257: , x_eqp_r.inventory_item_id inventory_item_id
5258: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
5259: WHERE x_utt_res2.resource_id = r2.resource_id
5260: AND r2.resource_type = 1
5261: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
5262: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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 5411: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

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
5409: , x_utt_res2.resource_id resource_id
5410: , x_eqp_r.inventory_item_id inventory_item_id
5411: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
5412: WHERE x_utt_res2.resource_id = r2.resource_id
5413: AND r2.resource_type = 1
5414: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
5415: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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 5562: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

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
5560: , x_utt_res2.resource_id resource_id
5561: , x_eqp_r.inventory_item_id inventory_item_id
5562: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
5563: WHERE x_utt_res2.resource_id = r2.resource_id
5564: AND r2.resource_type = 1
5565: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
5566: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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 5710: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

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
5708: , x_utt_res2.resource_id resource_id
5709: , x_eqp_r.inventory_item_id inventory_item_id
5710: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
5711: WHERE x_utt_res2.resource_id = r2.resource_id
5712: AND r2.resource_type = 1
5713: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
5714: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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 5861: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

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
5859: , x_utt_res2.resource_id resource_id
5860: , x_eqp_r.inventory_item_id inventory_item_id
5861: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
5862: WHERE x_utt_res2.resource_id = r2.resource_id
5863: AND r2.resource_type = 1
5864: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
5865: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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 6012: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

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
6010: , x_utt_res2.resource_id resource_id
6011: , x_eqp_r.inventory_item_id inventory_item_id
6012: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
6013: WHERE x_utt_res2.resource_id = r2.resource_id
6014: AND r2.resource_type = 1
6015: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
6016: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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 6162: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

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
6160: , x_utt_res2.resource_id resource_id
6161: , x_eqp_r.inventory_item_id inventory_item_id
6162: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
6163: WHERE x_utt_res2.resource_id = r2.resource_id
6164: AND r2.resource_type = 1
6165: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
6166: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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 7392: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

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
7390: , x_utt_res2.resource_id resource_id
7391: , x_eqp_r.inventory_item_id inventory_item_id
7392: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
7393: WHERE x_utt_res2.resource_id = r2.resource_id
7394: AND r2.resource_type = 1
7395: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
7396: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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 7553: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

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
7551: , x_utt_res2.resource_id resource_id
7552: , x_eqp_r.inventory_item_id inventory_item_id
7553: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
7554: WHERE x_utt_res2.resource_id = r2.resource_id
7555: AND r2.resource_type = 1
7556: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
7557: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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 7713: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

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
7711: , x_utt_res2.resource_id resource_id
7712: , x_eqp_r.inventory_item_id inventory_item_id
7713: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
7714: WHERE x_utt_res2.resource_id = r2.resource_id
7715: AND r2.resource_type = 1
7716: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
7717: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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 7873: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

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
7871: , x_utt_res2.resource_id resource_id
7872: , x_eqp_r.inventory_item_id inventory_item_id
7873: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
7874: WHERE x_utt_res2.resource_id = r2.resource_id
7875: AND r2.resource_type = 1
7876: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
7877: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

Line 8004: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre

8000: , (SELECT
8001: bsor.standard_operation_id,
8002: bre.resource_id,
8003: bre.inventory_item_id equipment_id
8004: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
8005: WHERE bsor.resource_id = bre.resource_id
8006: AND br.resource_type = 1
8007: AND bsor.resource_id = br.resource_id) e
8008: , mtl_item_locations_kfv loc

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 8109: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

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
8107: , x_utt_res2.resource_id resource_id
8108: , x_eqp_r.inventory_item_id inventory_item_id
8109: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
8110: WHERE x_utt_res2.resource_id = r2.resource_id
8111: AND r2.resource_type = 1
8112: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
8113: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

Line 8246: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre

8242: , (SELECT
8243: bsor.standard_operation_id,
8244: bre.resource_id,
8245: bre.inventory_item_id equipment_id
8246: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
8247: WHERE bsor.resource_id = bre.resource_id
8248: AND br.resource_type = 1
8249: AND bsor.resource_id = br.resource_id) e
8250: , mtl_item_locations_kfv loc

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 8341: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

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
8339: , x_utt_res2.resource_id resource_id
8340: , x_eqp_r.inventory_item_id inventory_item_id
8341: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
8342: WHERE x_utt_res2.resource_id = r2.resource_id
8343: AND r2.resource_type = 1
8344: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
8345: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

Line 8476: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre

8472: , (SELECT
8473: bsor.standard_operation_id,
8474: bre.resource_id,
8475: bre.inventory_item_id equipment_id
8476: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
8477: WHERE bsor.resource_id = bre.resource_id
8478: AND br.resource_type = 1
8479: AND bsor.resource_id = br.resource_id) e
8480: , mtl_item_locations_kfv loc

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 8581: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

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
8579: , x_utt_res2.resource_id resource_id
8580: , x_eqp_r.inventory_item_id inventory_item_id
8581: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
8582: WHERE x_utt_res2.resource_id = r2.resource_id
8583: AND r2.resource_type = 1
8584: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
8585: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

Line 8708: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre

8704: , (SELECT
8705: bsor.standard_operation_id,
8706: bre.resource_id,
8707: bre.inventory_item_id equipment_id
8708: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
8709: WHERE bsor.resource_id = bre.resource_id
8710: AND br.resource_type = 1
8711: AND bsor.resource_id = br.resource_id) e
8712: , mtl_item_locations_kfv loc

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 8805: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

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
8803: , x_utt_res2.resource_id resource_id
8804: , x_eqp_r.inventory_item_id inventory_item_id
8805: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
8806: WHERE x_utt_res2.resource_id = r2.resource_id
8807: AND r2.resource_type = 1
8808: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
8809: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

Line 8940: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre

8936: , (SELECT
8937: bsor.standard_operation_id,
8938: bre.resource_id,
8939: bre.inventory_item_id equipment_id
8940: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
8941: WHERE bsor.resource_id = bre.resource_id
8942: AND br.resource_type = 1
8943: AND bsor.resource_id = br.resource_id) e
8944: , mtl_item_locations_kfv loc

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 9043: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

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
9041: , x_utt_res2.resource_id resource_id
9042: , x_eqp_r.inventory_item_id inventory_item_id
9043: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
9044: WHERE x_utt_res2.resource_id = r2.resource_id
9045: AND r2.resource_type = 1
9046: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
9047: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

Line 9177: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre

9173: , (SELECT
9174: bsor.standard_operation_id,
9175: bre.resource_id,
9176: bre.inventory_item_id equipment_id
9177: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
9178: WHERE bsor.resource_id = bre.resource_id
9179: AND br.resource_type = 1
9180: AND bsor.resource_id = br.resource_id) e
9181: , mtl_item_locations_kfv loc

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 9273: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

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
9271: , x_utt_res2.resource_id resource_id
9272: , x_eqp_r.inventory_item_id inventory_item_id
9273: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
9274: WHERE x_utt_res2.resource_id = r2.resource_id
9275: AND r2.resource_type = 1
9276: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
9277: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

Line 9404: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre

9400: , (SELECT
9401: bsor.standard_operation_id,
9402: bre.resource_id,
9403: bre.inventory_item_id equipment_id
9404: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
9405: WHERE bsor.resource_id = bre.resource_id
9406: AND br.resource_type = 1
9407: AND bsor.resource_id = br.resource_id) e
9408: , mtl_item_locations_kfv loc

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 9507: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

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
9505: , x_utt_res2.resource_id resource_id
9506: , x_eqp_r.inventory_item_id inventory_item_id
9507: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
9508: WHERE x_utt_res2.resource_id = r2.resource_id
9509: AND r2.resource_type = 1
9510: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
9511: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

Line 9633: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre

9629: , (SELECT
9630: bsor.standard_operation_id,
9631: bre.resource_id,
9632: bre.inventory_item_id equipment_id
9633: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
9634: WHERE bsor.resource_id = bre.resource_id
9635: AND br.resource_type = 1
9636: AND bsor.resource_id = br.resource_id) e
9637: , mtl_item_locations_kfv loc

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

Line 9729: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r

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
9727: , x_utt_res2.resource_id resource_id
9728: , x_eqp_r.inventory_item_id inventory_item_id
9729: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
9730: WHERE x_utt_res2.resource_id = r2.resource_id
9731: AND r2.resource_type = 1
9732: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
9733: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

Line 10934: , bom_resources res

10930: item.weight_uom_code item_w_uom -- item weight UOM code
10931: FROM mtl_system_items equip
10932: , mtl_system_items item
10933: , bom_resource_equipments res_equip
10934: , bom_resources res
10935: , bom_std_op_resources tt_x_res
10936: WHERE tt_x_res.standard_operation_id = p_standard_operation_id --join task with task_type-resource x-ref
10937: AND tt_x_res.resource_id = res.resource_id -- join with resource
10938: AND res.resource_type = 1 -- resource type for equipment

Line 12528: , bom_resources res

12524: FROM mtl_system_items equip
12525: , mtl_system_items item
12526: , wms_cartonization_temp mmtt
12527: , bom_resource_equipments res_equip
12528: , bom_resources res
12529: , bom_std_op_resources tt_x_res
12530: WHERE mmtt.transaction_temp_id = p_task_id -- the task in question
12531: AND mmtt.standard_operation_id = tt_x_res.standard_operation_id --join task with task_type-resource x-ref
12532: AND tt_x_res.resource_id = res.resource_id -- join with resource

Line 12565: , bom_resources res

12561: FROM mtl_system_items equip
12562: , mtl_system_items item
12563: , mtl_material_transactions_temp mmtt
12564: , bom_resource_equipments res_equip
12565: , bom_resources res
12566: , bom_std_op_resources tt_x_res
12567: WHERE mmtt.transaction_temp_id = p_task_id -- the task in question
12568: AND mmtt.standard_operation_id = tt_x_res.standard_operation_id --join task with task_type-resource x-ref
12569: AND tt_x_res.resource_id = res.resource_id -- join with resource