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

10929: , -- item volume UOM code
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

Line 12527: , bom_resource_equipments res_equip

12523: item.weight_uom_code item_w_uom -- item weight UOM code
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

Line 12564: , bom_resource_equipments res_equip

12560: item.weight_uom_code item_w_uom -- item weight UOM code
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