eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_TASK_DISPATCH_ENGINE dependencies on BOM_RESOURCE_EQUIPMENTS

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 11272: , bom_resource_equipments res_equip

11268: , -- item volume UOM code
11269: item.weight_uom_code item_w_uom -- item weight UOM code
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

Line 13052: , bom_resource_equipments res_equip

13048: item.weight_uom_code item_w_uom -- item weight UOM code
13049: FROM mtl_system_items equip
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

Line 13089: , bom_resource_equipments res_equip

13085: item.weight_uom_code item_w_uom -- item weight UOM code
13086: FROM mtl_system_items equip
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