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_STD_OP_RESOURCES

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

393: (SELECT
394: bsor.standard_operation_id,
395: bre.resource_id,
396: bre.inventory_item_id equipment_id
397: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
398: WHERE bsor.resource_id = bre.resource_id
399: AND br.resource_type = 1
400: AND bsor.resource_id = br.resource_id) e
401: WHERE wdt.transaction_temp_id = qt.task_id

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

533: (SELECT
534: x_utt_res2.standard_operation_id standard_operation_id,
535: x_utt_res2.resource_id,
536: x_eqp_r.inventory_item_id
537: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
538: WHERE x_utt_res2.resource_id = r2.resource_id
539: AND r2.resource_type = 1
540: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
541: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,

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

696: (SELECT
697: bsor.standard_operation_id,
698: bre.resource_id,
699: bre.inventory_item_id equipment_id
700: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
701: WHERE bsor.resource_id = bre.resource_id
702: AND br.resource_type = 1
703: AND bsor.resource_id = br.resource_id) e
704: WHERE wdt.transaction_temp_id = qt.task_id

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

774: (SELECT
775: bsor.standard_operation_id,
776: bre.resource_id,
777: bre.inventory_item_id equipment_id
778: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
779: WHERE bsor.resource_id = bre.resource_id
780: AND br.resource_type = 1
781: AND bsor.resource_id = br.resource_id) e
782: WHERE wdt.transaction_temp_id = qt.task_id

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

882: (SELECT
883: x_utt_res2.standard_operation_id standard_operation_id,
884: x_utt_res2.resource_id,
885: x_eqp_r.inventory_item_id
886: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
887: WHERE x_utt_res2.resource_id = r2.resource_id
888: AND r2.resource_type = 1
889: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
890: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,

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

1037: (SELECT
1038: bsor.standard_operation_id,
1039: bre.resource_id,
1040: bre.inventory_item_id equipment_id
1041: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
1042: WHERE bsor.resource_id = bre.resource_id
1043: AND br.resource_type = 1
1044: AND bsor.resource_id = br.resource_id) e
1045: WHERE wdt.transaction_temp_id = qt.task_id

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

1128: (SELECT
1129: x_utt_res2.standard_operation_id standard_operation_id,
1130: x_utt_res2.resource_id,
1131: x_eqp_r.inventory_item_id
1132: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
1133: WHERE x_utt_res2.resource_id = r2.resource_id
1134: AND r2.resource_type = 1
1135: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
1136: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,

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

1301: (SELECT
1302: bsor.standard_operation_id,
1303: bre.resource_id,
1304: bre.inventory_item_id equipment_id
1305: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
1306: WHERE bsor.resource_id = bre.resource_id
1307: AND br.resource_type = 1
1308: AND bsor.resource_id = br.resource_id) e
1309: WHERE wdt.transaction_temp_id = qt.task_id

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

1440: (SELECT
1441: x_utt_res2.standard_operation_id standard_operation_id,
1442: x_utt_res2.resource_id,
1443: x_eqp_r.inventory_item_id
1444: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
1445: WHERE x_utt_res2.resource_id = r2.resource_id
1446: AND r2.resource_type = 1
1447: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
1448: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,

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

1603: (SELECT
1604: bsor.standard_operation_id,
1605: bre.resource_id,
1606: bre.inventory_item_id equipment_id
1607: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
1608: WHERE bsor.resource_id = bre.resource_id
1609: AND br.resource_type = 1
1610: AND bsor.resource_id = br.resource_id) e
1611: WHERE wdt.transaction_temp_id = qt.task_id

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

1680: (SELECT
1681: bsor.standard_operation_id,
1682: bre.resource_id,
1683: bre.inventory_item_id equipment_id
1684: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
1685: WHERE bsor.resource_id = bre.resource_id
1686: AND br.resource_type = 1
1687: AND bsor.resource_id = br.resource_id) e
1688: WHERE wdt.transaction_temp_id = qt.task_id

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

1787: (SELECT
1788: x_utt_res2.standard_operation_id standard_operation_id,
1789: x_utt_res2.resource_id,
1790: x_eqp_r.inventory_item_id
1791: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
1792: WHERE x_utt_res2.resource_id = r2.resource_id
1793: AND r2.resource_type = 1
1794: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
1795: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,

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

1936: (SELECT
1937: bsor.standard_operation_id,
1938: bre.resource_id,
1939: bre.inventory_item_id equipment_id
1940: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
1941: WHERE bsor.resource_id = bre.resource_id
1942: AND br.resource_type = 1
1943: AND bsor.resource_id = br.resource_id) e
1944: WHERE wdt.transaction_temp_id = qt.task_id

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

2027: (SELECT
2028: x_utt_res2.standard_operation_id standard_operation_id,
2029: x_utt_res2.resource_id,
2030: x_eqp_r.inventory_item_id
2031: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
2032: WHERE x_utt_res2.resource_id = r2.resource_id
2033: AND r2.resource_type = 1
2034: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
2035: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,

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

2233: (SELECT
2234: bsor.standard_operation_id,
2235: bre.resource_id,
2236: bre.inventory_item_id equipment_id
2237: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
2238: WHERE bsor.resource_id = bre.resource_id
2239: AND br.resource_type = 1
2240: AND bsor.resource_id = br.resource_id) e
2241: WHERE wdt.transaction_temp_id = qt.task_id

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

2422: (SELECT
2423: x_utt_res2.standard_operation_id standard_operation_id,
2424: x_utt_res2.resource_id,
2425: x_eqp_r.inventory_item_id
2426: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
2427: WHERE x_utt_res2.resource_id = r2.resource_id
2428: AND r2.resource_type = 1
2429: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
2430: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)

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

2629: (SELECT
2630: bsor.standard_operation_id,
2631: bre.resource_id,
2632: bre.inventory_item_id equipment_id
2633: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
2634: WHERE bsor.resource_id = bre.resource_id
2635: AND br.resource_type = 1
2636: AND bsor.resource_id = br.resource_id) e
2637: WHERE wdt.transaction_temp_id = qt.task_id

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

2756: (SELECT
2757: bsor.standard_operation_id,
2758: bre.resource_id,
2759: bre.inventory_item_id equipment_id
2760: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
2761: WHERE bsor.resource_id = bre.resource_id
2762: AND br.resource_type = 1
2763: AND bsor.resource_id = br.resource_id) e
2764: WHERE wdt.transaction_temp_id = qt.task_id

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

2911: (SELECT
2912: x_utt_res2.standard_operation_id standard_operation_id,
2913: x_utt_res2.resource_id,
2914: x_eqp_r.inventory_item_id
2915: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
2916: WHERE x_utt_res2.resource_id = r2.resource_id
2917: AND r2.resource_type = 1
2918: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
2919: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)

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

3105: (SELECT
3106: bsor.standard_operation_id,
3107: bre.resource_id,
3108: bre.inventory_item_id equipment_id
3109: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
3110: WHERE bsor.resource_id = bre.resource_id
3111: AND br.resource_type = 1
3112: AND bsor.resource_id = br.resource_id) e
3113: WHERE wdt.transaction_temp_id = qt.task_id

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

3214: (SELECT
3215: x_utt_res2.standard_operation_id standard_operation_id,
3216: x_utt_res2.resource_id,
3217: x_eqp_r.inventory_item_id
3218: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
3219: WHERE x_utt_res2.resource_id = r2.resource_id
3220: AND r2.resource_type = 1
3221: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
3222: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)

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

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
4825: , x_utt_res2.resource_id resource_id
4826: , x_eqp_r.inventory_item_id inventory_item_id
4827: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
4828: WHERE x_utt_res2.resource_id = r2.resource_id
4829: AND r2.resource_type = 1
4830: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
4831: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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

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
4979: , x_utt_res2.resource_id resource_id
4980: , x_eqp_r.inventory_item_id inventory_item_id
4981: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
4982: WHERE x_utt_res2.resource_id = r2.resource_id
4983: AND r2.resource_type = 1
4984: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
4985: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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

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
5135: , x_utt_res2.resource_id resource_id
5136: , x_eqp_r.inventory_item_id inventory_item_id
5137: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
5138: WHERE x_utt_res2.resource_id = r2.resource_id
5139: AND r2.resource_type = 1
5140: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
5141: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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

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
5288: , x_utt_res2.resource_id resource_id
5289: , x_eqp_r.inventory_item_id inventory_item_id
5290: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
5291: WHERE x_utt_res2.resource_id = r2.resource_id
5292: AND r2.resource_type = 1
5293: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
5294: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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

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
5441: , x_utt_res2.resource_id resource_id
5442: , x_eqp_r.inventory_item_id inventory_item_id
5443: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
5444: WHERE x_utt_res2.resource_id = r2.resource_id
5445: AND r2.resource_type = 1
5446: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
5447: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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

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
5595: , x_utt_res2.resource_id resource_id
5596: , x_eqp_r.inventory_item_id inventory_item_id
5597: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
5598: WHERE x_utt_res2.resource_id = r2.resource_id
5599: AND r2.resource_type = 1
5600: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
5601: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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

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
5748: , x_utt_res2.resource_id resource_id
5749: , x_eqp_r.inventory_item_id inventory_item_id
5750: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
5751: WHERE x_utt_res2.resource_id = r2.resource_id
5752: AND r2.resource_type = 1
5753: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
5754: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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

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
5899: , x_utt_res2.resource_id resource_id
5900: , x_eqp_r.inventory_item_id inventory_item_id
5901: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
5902: WHERE x_utt_res2.resource_id = r2.resource_id
5903: AND r2.resource_type = 1
5904: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
5905: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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

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
6047: , x_utt_res2.resource_id resource_id
6048: , x_eqp_r.inventory_item_id inventory_item_id
6049: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
6050: WHERE x_utt_res2.resource_id = r2.resource_id
6051: AND r2.resource_type = 1
6052: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
6053: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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

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
6198: , x_utt_res2.resource_id resource_id
6199: , x_eqp_r.inventory_item_id inventory_item_id
6200: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
6201: WHERE x_utt_res2.resource_id = r2.resource_id
6202: AND r2.resource_type = 1
6203: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
6204: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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

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
6349: , x_utt_res2.resource_id resource_id
6350: , x_eqp_r.inventory_item_id inventory_item_id
6351: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
6352: WHERE x_utt_res2.resource_id = r2.resource_id
6353: AND r2.resource_type = 1
6354: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
6355: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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

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
6499: , x_utt_res2.resource_id resource_id
6500: , x_eqp_r.inventory_item_id inventory_item_id
6501: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
6502: WHERE x_utt_res2.resource_id = r2.resource_id
6503: AND r2.resource_type = 1
6504: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
6505: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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

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
7729: , x_utt_res2.resource_id resource_id
7730: , x_eqp_r.inventory_item_id inventory_item_id
7731: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
7732: WHERE x_utt_res2.resource_id = r2.resource_id
7733: AND r2.resource_type = 1
7734: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
7735: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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

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
7890: , x_utt_res2.resource_id resource_id
7891: , x_eqp_r.inventory_item_id inventory_item_id
7892: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
7893: WHERE x_utt_res2.resource_id = r2.resource_id
7894: AND r2.resource_type = 1
7895: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
7896: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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

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
8050: , x_utt_res2.resource_id resource_id
8051: , x_eqp_r.inventory_item_id inventory_item_id
8052: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
8053: WHERE x_utt_res2.resource_id = r2.resource_id
8054: AND r2.resource_type = 1
8055: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
8056: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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

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
8210: , x_utt_res2.resource_id resource_id
8211: , x_eqp_r.inventory_item_id inventory_item_id
8212: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
8213: WHERE x_utt_res2.resource_id = r2.resource_id
8214: AND r2.resource_type = 1
8215: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
8216: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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

8339: , (SELECT
8340: bsor.standard_operation_id,
8341: bre.resource_id,
8342: bre.inventory_item_id equipment_id
8343: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
8344: WHERE bsor.resource_id = bre.resource_id
8345: AND br.resource_type = 1
8346: AND bsor.resource_id = br.resource_id) e
8347: , mtl_item_locations_kfv loc

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

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
8446: , x_utt_res2.resource_id resource_id
8447: , x_eqp_r.inventory_item_id inventory_item_id
8448: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
8449: WHERE x_utt_res2.resource_id = r2.resource_id
8450: AND r2.resource_type = 1
8451: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
8452: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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

8581: , (SELECT
8582: bsor.standard_operation_id,
8583: bre.resource_id,
8584: bre.inventory_item_id equipment_id
8585: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
8586: WHERE bsor.resource_id = bre.resource_id
8587: AND br.resource_type = 1
8588: AND bsor.resource_id = br.resource_id) e
8589: , mtl_item_locations_kfv loc

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

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
8678: , x_utt_res2.resource_id resource_id
8679: , x_eqp_r.inventory_item_id inventory_item_id
8680: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
8681: WHERE x_utt_res2.resource_id = r2.resource_id
8682: AND r2.resource_type = 1
8683: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
8684: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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

8811: , (SELECT
8812: bsor.standard_operation_id,
8813: bre.resource_id,
8814: bre.inventory_item_id equipment_id
8815: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
8816: WHERE bsor.resource_id = bre.resource_id
8817: AND br.resource_type = 1
8818: AND bsor.resource_id = br.resource_id) e
8819: , mtl_item_locations_kfv loc

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

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
8918: , x_utt_res2.resource_id resource_id
8919: , x_eqp_r.inventory_item_id inventory_item_id
8920: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
8921: WHERE x_utt_res2.resource_id = r2.resource_id
8922: AND r2.resource_type = 1
8923: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
8924: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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

9043: , (SELECT
9044: bsor.standard_operation_id,
9045: bre.resource_id,
9046: bre.inventory_item_id equipment_id
9047: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
9048: WHERE bsor.resource_id = bre.resource_id
9049: AND br.resource_type = 1
9050: AND bsor.resource_id = br.resource_id) e
9051: , mtl_item_locations_kfv loc

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

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
9142: , x_utt_res2.resource_id resource_id
9143: , x_eqp_r.inventory_item_id inventory_item_id
9144: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
9145: WHERE x_utt_res2.resource_id = r2.resource_id
9146: AND r2.resource_type = 1
9147: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
9148: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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

9275: , (SELECT
9276: bsor.standard_operation_id,
9277: bre.resource_id,
9278: bre.inventory_item_id equipment_id
9279: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
9280: WHERE bsor.resource_id = bre.resource_id
9281: AND br.resource_type = 1
9282: AND bsor.resource_id = br.resource_id) e
9283: , mtl_item_locations_kfv loc

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

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
9380: , x_utt_res2.resource_id resource_id
9381: , x_eqp_r.inventory_item_id inventory_item_id
9382: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
9383: WHERE x_utt_res2.resource_id = r2.resource_id
9384: AND r2.resource_type = 1
9385: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
9386: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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

9512: , (SELECT
9513: bsor.standard_operation_id,
9514: bre.resource_id,
9515: bre.inventory_item_id equipment_id
9516: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
9517: WHERE bsor.resource_id = bre.resource_id
9518: AND br.resource_type = 1
9519: AND bsor.resource_id = br.resource_id) e
9520: , mtl_item_locations_kfv loc

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

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
9610: , x_utt_res2.resource_id resource_id
9611: , x_eqp_r.inventory_item_id inventory_item_id
9612: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
9613: WHERE x_utt_res2.resource_id = r2.resource_id
9614: AND r2.resource_type = 1
9615: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
9616: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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

9739: , (SELECT
9740: bsor.standard_operation_id,
9741: bre.resource_id,
9742: bre.inventory_item_id equipment_id
9743: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
9744: WHERE bsor.resource_id = bre.resource_id
9745: AND br.resource_type = 1
9746: AND bsor.resource_id = br.resource_id) e
9747: , mtl_item_locations_kfv loc

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

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
9844: , x_utt_res2.resource_id resource_id
9845: , x_eqp_r.inventory_item_id inventory_item_id
9846: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
9847: WHERE x_utt_res2.resource_id = r2.resource_id
9848: AND r2.resource_type = 1
9849: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
9850: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

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

9968: , (SELECT
9969: bsor.standard_operation_id,
9970: bre.resource_id,
9971: bre.inventory_item_id equipment_id
9972: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
9973: WHERE bsor.resource_id = bre.resource_id
9974: AND br.resource_type = 1
9975: AND bsor.resource_id = br.resource_id) e
9976: , mtl_item_locations_kfv loc

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

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

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
10066: , x_utt_res2.resource_id resource_id
10067: , x_eqp_r.inventory_item_id inventory_item_id
10068: FROM bom_std_op_resources x_utt_res2, bom_resources r2, bom_resource_equipments x_eqp_r
10069: WHERE x_utt_res2.resource_id = r2.resource_id
10070: AND r2.resource_type = 1
10071: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
10072: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v

Line 11274: , bom_std_op_resources tt_x_res

11270: FROM mtl_system_items equip
11271: , mtl_system_items item
11272: , bom_resource_equipments res_equip
11273: , bom_resources res
11274: , bom_std_op_resources tt_x_res
11275: WHERE tt_x_res.standard_operation_id = p_standard_operation_id --join task with task_type-resource x-ref
11276: AND tt_x_res.resource_id = res.resource_id -- join with resource
11277: AND res.resource_type = 1 -- resource type for equipment
11278: AND res_equip.resource_id = tt_x_res.resource_id -- join with resource-equip x-ref

Line 13054: , bom_std_op_resources tt_x_res

13050: , mtl_system_items item
13051: , wms_cartonization_temp mmtt
13052: , bom_resource_equipments res_equip
13053: , bom_resources res
13054: , bom_std_op_resources tt_x_res
13055: WHERE mmtt.transaction_temp_id = p_task_id -- the task in question
13056: AND mmtt.standard_operation_id = tt_x_res.standard_operation_id --join task with task_type-resource x-ref
13057: AND tt_x_res.resource_id = res.resource_id -- join with resource
13058: AND res.resource_type = 1 -- resource type for equipment

Line 13091: , bom_std_op_resources tt_x_res

13087: , mtl_system_items item
13088: , mtl_material_transactions_temp mmtt
13089: , bom_resource_equipments res_equip
13090: , bom_resources res
13091: , bom_std_op_resources tt_x_res
13092: WHERE mmtt.transaction_temp_id = p_task_id -- the task in question
13093: AND mmtt.standard_operation_id = tt_x_res.standard_operation_id --join task with task_type-resource x-ref
13094: AND tt_x_res.resource_id = res.resource_id -- join with resource
13095: AND res.resource_type = 1 -- resource type for equipment