350: AND NVL(mcch.disable_date,sysdate+1)> sysdate
351: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) qt,
352: mtl_txn_request_lines mol,
353: mtl_secondary_inventories sub,
354: mtl_item_locations loc,
355: (SELECT
356: bsor.standard_operation_id,
357: bre.resource_id,
358: bre.inventory_item_id equipment_id
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,
504: mtl_item_locations loc,
505: mtl_secondary_inventories sub,
506: mtl_txn_request_lines mol,
507: mtl_txn_request_headers moh
508: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
653: )
654: ) qt,
655: mtl_txn_request_lines mol,
656: mtl_secondary_inventories sub,
657: mtl_item_locations loc,
658: (SELECT
659: bsor.standard_operation_id,
660: bre.resource_id,
661: bre.inventory_item_id equipment_id
731: )
732: ) qt,
733: mtl_txn_request_lines mol,
734: mtl_secondary_inventories sub,
735: mtl_item_locations loc,
736: (SELECT
737: bsor.standard_operation_id,
738: bre.resource_id,
739: bre.inventory_item_id equipment_id
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,
853: mtl_item_locations loc,
854: mtl_secondary_inventories sub,
855: mtl_txn_request_lines mol,
856: mtl_txn_request_headers moh
857: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
994:
995: AND NVL(mcch.disable_date,sysdate+1)> sysdate
996: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) qt,
997: mtl_secondary_inventories sub,
998: mtl_item_locations loc,
999: (SELECT
1000: bsor.standard_operation_id,
1001: bre.resource_id,
1002: bre.inventory_item_id equipment_id
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,
1099: mtl_item_locations loc,
1100: mtl_secondary_inventories sub
1101: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
1102: AND wdtv.organization_id = p_sign_on_org_id
1103: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match
1258: AND NVL(mcch.disable_date,sysdate+1)> sysdate
1259: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) qt,
1260: mtl_txn_request_lines mol,
1261: mtl_secondary_inventories sub,
1262: mtl_item_locations loc,
1263: (SELECT
1264: bsor.standard_operation_id,
1265: bre.resource_id,
1266: bre.inventory_item_id equipment_id
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,
1411: mtl_item_locations loc,
1412: mtl_secondary_inventories sub,
1413: mtl_txn_request_lines mol,
1414: mtl_txn_request_headers moh
1415: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
1560: )
1561: ) qt,
1562: mtl_txn_request_lines mol,
1563: mtl_secondary_inventories sub,
1564: mtl_item_locations loc,
1565: (SELECT
1566: bsor.standard_operation_id,
1567: bre.resource_id,
1568: bre.inventory_item_id equipment_id
1637: )
1638: ) qt,
1639: mtl_txn_request_lines mol,
1640: mtl_secondary_inventories sub,
1641: mtl_item_locations loc,
1642: (SELECT
1643: bsor.standard_operation_id,
1644: bre.resource_id,
1645: bre.inventory_item_id equipment_id
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,
1758: mtl_item_locations loc,
1759: mtl_secondary_inventories sub,
1760: mtl_txn_request_lines mol,
1761: mtl_txn_request_headers moh
1762: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
1891: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
1892: AND NVL(mcch.disable_date,sysdate+1)> sysdate
1893: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) qt,
1894: mtl_secondary_inventories sub,
1895: mtl_item_locations loc,
1896: (SELECT
1897: bsor.standard_operation_id,
1898: bre.resource_id,
1899: bre.inventory_item_id equipment_id
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,
1996: mtl_item_locations loc,
1997: mtl_secondary_inventories sub
1998: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
1999: AND wdtv.organization_id = p_sign_on_org_id
2000: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match
2186: AND NVL(mcch.disable_date,sysdate+1)> sysdate
2187: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) qt,
2188: mtl_txn_request_lines mol,
2189: mtl_secondary_inventories sub,
2190: mtl_item_locations loc,
2191: (SELECT
2192: bsor.standard_operation_id,
2193: bre.resource_id,
2194: bre.inventory_item_id equipment_id
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,
2370: mtl_item_locations loc,
2371: mtl_secondary_inventories sub,
2372: mtl_txn_request_lines mol,
2373: mtl_txn_request_headers moh
2374: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
2531: )
2532: ) qt,
2533: mtl_txn_request_lines mol,
2534: mtl_secondary_inventories sub,
2535: mtl_item_locations loc,
2536: (SELECT
2537: bsor.standard_operation_id,
2538: bre.resource_id,
2539: bre.inventory_item_id equipment_id
2640: )
2641: ) qt,
2642: mtl_txn_request_lines mol,
2643: mtl_secondary_inventories sub,
2644: mtl_item_locations loc,
2645: (SELECT
2646: bsor.standard_operation_id,
2647: bre.resource_id,
2648: bre.inventory_item_id equipment_id
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,
2791: mtl_item_locations loc,
2792: mtl_secondary_inventories sub,
2793: mtl_txn_request_lines mol,
2794: mtl_txn_request_headers moh
2795: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
2940:
2941: AND NVL(mcch.disable_date,sysdate+1)> sysdate
2942: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) qt,
2943: mtl_secondary_inventories sub,
2944: mtl_item_locations loc,
2945: (SELECT
2946: bsor.standard_operation_id,
2947: bre.resource_id,
2948: bre.inventory_item_id equipment_id
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,
3063: mtl_item_locations loc,
3064: mtl_secondary_inventories sub
3065: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
3066: AND (wdtv.task_id = v_task_id AND wdtv.wms_task_type_id = v_task_type)
3067: AND wdtv.organization_id = p_sign_on_org_id
3365:
3366: -- use Nvl to make sure if coordinates not defined, use 0
3367: SELECT NVL(loc.x_coordinate, 0), NVL(loc.y_coordinate, 0), NVL(loc.z_coordinate, 0)
3368: INTO l_cur_x, l_cur_y, l_cur_z
3369: FROM mtl_item_locations loc,
3370: (SELECT
3371: transaction_temp_id task_id,
3372: standard_operation_id user_task_type_id,
3373: wms_task_type wms_task_type_id,
3440: , NVL(loc.z_coordinate, 0)
3441: INTO l_cur_x
3442: , l_cur_y
3443: , l_cur_z
3444: FROM mtl_item_locations loc, mtl_material_transactions mmt
3445: WHERE mmt.locator_id = loc.inventory_location_id
3446: AND mmt.organization_id = loc.organization_id
3447: AND mmt.transaction_set_id = l_last_task_id
3448: AND ROWNUM = 1;
3466: , NVL(loc.z_coordinate, 0)
3467: INTO l_cur_x
3468: , l_cur_y
3469: , l_cur_z
3470: FROM mtl_item_locations loc, mtl_cycle_count_entries mcce
3471: WHERE mcce.locator_id = loc.inventory_location_id
3472: AND mcce.organization_id = loc.organization_id
3473: AND mcce.cycle_count_entry_id = l_last_task_id;
3474:
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
4493: , -- inlined wms_person_resource_utt_v, bug 2648133
4494: mtl_item_locations loc
4495: , mtl_secondary_inventories sub
4496: , mtl_txn_request_lines mol
4497: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
4498: AND wdtv.organization_id = p_sign_on_org_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
4647: , -- inlined wms_person_resource_utt_v, bug 2648133
4648: mtl_item_locations loc
4649: , mtl_secondary_inventories sub
4650: , mtl_txn_request_lines mol
4651: -- mtl_system_items msi -- bug 2648133
4652: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
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
4803: , -- inlined wms_person_resource_utt_v, bug 2648133
4804: mtl_item_locations loc
4805: , mtl_secondary_inventories sub
4806: , mtl_txn_request_lines mol
4807: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
4808: AND wdtv.organization_id = p_sign_on_org_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
4956: , -- inlined wms_person_resource_utt_v, bug 2648133
4957: mtl_item_locations loc
4958: , mtl_secondary_inventories sub
4959: , mtl_txn_request_lines mol
4960: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
4961: AND wdtv.organization_id = p_sign_on_org_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
5109: , -- inlined wms_person_resource_utt_v, bug 2648133
5110: mtl_item_locations loc
5111: , mtl_secondary_inventories sub
5112: , mtl_txn_request_lines mol
5113: -- mtl_system_items msi -- bug 2648133
5114: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
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
5263: , -- inlined wms_person_resource_utt_v, bug 2648133
5264: mtl_item_locations loc
5265: , mtl_secondary_inventories sub
5266: , mtl_txn_request_lines mol
5267: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
5268: AND wdtv.organization_id = p_sign_on_org_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
5416: , -- inlined wms_person_resource_utt_v, bug 2648133
5417: mtl_item_locations loc
5418: , mtl_secondary_inventories sub
5419: , mtl_txn_request_lines mol
5420: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
5421: AND wdtv.organization_id = p_sign_on_org_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
5567: , -- inlined wms_person_resource_utt_v, bug 2648133
5568: mtl_item_locations loc
5569: , mtl_secondary_inventories sub
5570: , mtl_txn_request_lines mol
5571: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
5572: AND wdtv.organization_id = p_sign_on_org_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
5715: , -- inlined wms_person_resource_utt_v, bug 2648133
5716: mtl_item_locations loc
5717: , mtl_secondary_inventories sub
5718: , mtl_txn_request_lines mol
5719: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
5720: AND(wdtv.pick_slip_number = v_pick_slip_number
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
5866: , -- inlined wms_person_resource_utt_v, bug 2648133
5867: mtl_item_locations loc
5868: , mtl_secondary_inventories sub
5869: , mtl_txn_request_lines mol
5870: -- mtl_system_items msi -- bug 2648133
5871: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
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
6017: , -- inlined wms_person_resource_utt_v, bug 2648133
6018: mtl_item_locations loc
6019: , mtl_secondary_inventories sub
6020: , mtl_txn_request_lines mol
6021: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
6022: AND(wdtv.pick_slip_number = v_pick_slip_number
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
6167: , -- inlined wms_person_resource_utt_v, bug 2648133
6168: mtl_item_locations loc
6169: , mtl_secondary_inventories sub
6170: , mtl_txn_request_lines mol
6171: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
6172: AND(wdtv.pick_slip_number = v_pick_slip_number
6448: , NVL(loc.z_coordinate, 0)
6449: INTO l_cur_x
6450: , l_cur_y
6451: , l_cur_z
6452: FROM mtl_item_locations loc
6453: , (SELECT transaction_temp_id task_id
6454: , standard_operation_id user_task_type_id
6455: , wms_task_type wms_task_type_id
6456: , organization_id organization_id
6521: , NVL(loc.z_coordinate, 0)
6522: INTO l_cur_x
6523: , l_cur_y
6524: , l_cur_z
6525: FROM mtl_item_locations loc, mtl_material_transactions mmt
6526: WHERE mmt.locator_id = loc.inventory_location_id
6527: AND mmt.organization_id = loc.organization_id
6528: AND mmt.transaction_set_id = l_last_task_id
6529: AND ROWNUM = 1;
6547: , NVL(loc.z_coordinate, 0)
6548: INTO l_cur_x
6549: , l_cur_y
6550: , l_cur_z
6551: FROM mtl_item_locations loc, mtl_cycle_count_entries mcce
6552: WHERE mcce.locator_id = loc.inventory_location_id
6553: AND mcce.organization_id = loc.organization_id
6554: AND mcce.cycle_count_entry_id = l_last_task_id;
6555:
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
7397: , -- inlined wms_person_resource_utt_v, bug 2648133
7398: mtl_item_locations_kfv loc
7399: , --changed to kfv bug#2742611
7400: mtl_secondary_inventories sub
7401: , mtl_txn_request_lines mol
7402: , mtl_txn_request_headers moh
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
7558: , -- inlined wms_person_resource_utt_v, bug 2648133
7559: mtl_item_locations_kfv loc
7560: , --changed to kfv bug#2742611
7561: mtl_secondary_inventories sub
7562: , mtl_txn_request_lines mol
7563: , mtl_txn_request_headers moh
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
7718: , -- inlined wms_person_resource_utt_v, bug 2648133
7719: mtl_item_locations_kfv loc
7720: , --changed to kfv bug#2742611
7721: mtl_secondary_inventories sub
7722: , mtl_txn_request_lines mol
7723: , mtl_txn_request_headers moh
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
7878: , -- inlined wms_person_resource_utt_v, bug 2648133
7879: mtl_item_locations_kfv loc
7880: , --changed to kfv bug#2742611
7881: mtl_secondary_inventories sub
7882: , mtl_txn_request_lines mol
7883: , mtl_txn_request_headers moh
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
8009: , --changed to kfv bug#2742611
8010: mtl_secondary_inventories sub
8011: , mtl_txn_request_lines mol
8012: , mtl_txn_request_headers moh
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
8114: , -- inlined wms_person_resource_utt_v, bug 2648133
8115: mtl_item_locations_kfv loc
8116: , --changed to kfv bug#2742611
8117: mtl_secondary_inventories sub
8118: , mtl_txn_request_lines mol
8119: , mtl_txn_request_headers moh
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
8251: , --changed to kfv bug#2742611
8252: mtl_secondary_inventories sub
8253: , mtl_txn_request_lines mol
8254: , mtl_txn_request_headers moh
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
8346: , -- inlined wms_person_resource_utt_v, bug 2648133
8347: mtl_item_locations_kfv loc
8348: , --changed to kfv bug#2742611
8349: mtl_secondary_inventories sub
8350: , mtl_txn_request_lines mol
8351: , mtl_txn_request_headers moh
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
8481: , --changed to kfv bug#2742611
8482: mtl_secondary_inventories sub
8483: , mtl_txn_request_lines mol
8484: , mtl_txn_request_headers moh
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
8586: , -- inlined wms_person_resource_utt_v, bug 2648133
8587: mtl_item_locations_kfv loc
8588: , --changed to kfv bug#2742611
8589: mtl_secondary_inventories sub
8590: , mtl_txn_request_lines mol
8591: , mtl_txn_request_headers moh
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
8713: , --changed to kfv bug#2742611
8714: mtl_secondary_inventories sub
8715: , mtl_txn_request_lines mol
8716: , mtl_txn_request_headers moh
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
8810: , -- inlined wms_person_resource_utt_v, bug 2648133
8811: mtl_item_locations_kfv loc
8812: , --changed to kfv bug#2742611
8813: mtl_secondary_inventories sub
8814: , mtl_txn_request_lines mol
8815: , mtl_txn_request_headers moh
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
8945: , --changed to kfv bug#2742611
8946: mtl_secondary_inventories sub
8947: , mtl_txn_request_lines mol
8948: , mtl_txn_request_headers moh
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
9048: , -- inlined wms_person_resource_utt_v, bug 2648133
9049: mtl_item_locations_kfv loc
9050: , --changed to kfv bug#2742611
9051: mtl_secondary_inventories sub
9052: , mtl_txn_request_lines mol
9053: , mtl_txn_request_headers moh
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
9182: , --changed to kfv bug#2742611
9183: mtl_secondary_inventories sub
9184: , mtl_txn_request_lines mol
9185: , mtl_txn_request_headers moh
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
9278: , -- inlined wms_person_resource_utt_v, bug 2648133
9279: mtl_item_locations_kfv loc
9280: , --changed to kfv bug#2742611
9281: mtl_secondary_inventories sub
9282: , mtl_txn_request_lines mol
9283: , mtl_txn_request_headers moh
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
9409: , --changed to kfv bug#2742611
9410: mtl_secondary_inventories sub
9411: , mtl_txn_request_lines mol
9412: , mtl_txn_request_headers moh
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
9512: , -- inlined wms_person_resource_utt_v, bug 2648133
9513: mtl_item_locations_kfv loc
9514: , --changed to kfv bug#2742611
9515: mtl_secondary_inventories sub
9516: , mtl_txn_request_lines mol
9517: , mtl_txn_request_headers moh
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
9638: , --changed to kfv bug#2742611
9639: mtl_secondary_inventories sub
9640: , mtl_txn_request_lines mol
9641: , mtl_txn_request_headers moh
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
9734: , -- inlined wms_person_resource_utt_v, bug 2648133
9735: mtl_item_locations_kfv loc
9736: , --changed to kfv bug#2742611
9737: mtl_secondary_inventories sub
9738: , mtl_txn_request_lines mol
9739: , mtl_txn_request_headers moh
10004: , NVL(loc.z_coordinate, 0)
10005: INTO l_cur_x
10006: , l_cur_y
10007: , l_cur_z
10008: FROM mtl_item_locations loc, wms_dispatchable_tasks_v wdtv
10009: WHERE wdtv.locator_id = loc.inventory_location_id
10010: AND wdtv.organization_id = loc.organization_id
10011: AND wdtv.task_id = l_last_task_id
10012: AND wdtv.wms_task_type_id = l_last_task_type;
10034: , NVL(loc.z_coordinate, 0)
10035: INTO l_cur_x
10036: , l_cur_y
10037: , l_cur_z
10038: FROM mtl_item_locations loc, mtl_material_transactions mmt
10039: WHERE mmt.locator_id = loc.inventory_location_id
10040: AND mmt.organization_id = loc.organization_id
10041: AND mmt.transaction_set_id = l_last_task_id
10042: AND ROWNUM = 1;
10059: , NVL(loc.z_coordinate, 0)
10060: INTO l_cur_x
10061: , l_cur_y
10062: , l_cur_z
10063: FROM mtl_item_locations loc, mtl_cycle_count_entries mcce
10064: WHERE mcce.locator_id = loc.inventory_location_id
10065: AND mcce.organization_id = loc.organization_id
10066: AND mcce.cycle_count_entry_id = l_last_task_id;
10067:
12658: , l_init_qty
12659: , l_item_prim_uom_code
12660: , l_lot_control_code
12661: , l_serial_number_control_code
12662: FROM wms_cartonization_temp mmtt, mtl_item_locations mil, mtl_secondary_inventories msi, mtl_system_items item
12663: WHERE mmtt.transaction_temp_id = p_task_id
12664: AND mmtt.locator_id = mil.inventory_location_id(+)
12665: AND mmtt.organization_id = mil.organization_id(+)
12666: AND mmtt.subinventory_code = msi.secondary_inventory_name