[Home] [Help]
541: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,
542: mtl_item_locations loc,
543: mtl_secondary_inventories sub,
544: mtl_txn_request_lines mol,
545: mtl_txn_request_headers moh
546: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
547: AND wdtv.organization_id = p_sign_on_org_id
548: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match
549: AND wdtv.zone = p_sign_on_zone -- removed NVL, bug 2648133
890: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,
891: mtl_item_locations loc,
892: mtl_secondary_inventories sub,
893: mtl_txn_request_lines mol,
894: mtl_txn_request_headers moh
895: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
896: AND wdtv.organization_id = p_sign_on_org_id
897: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match
898: AND wdtv.zone = p_sign_on_zone -- removed NVL, bug 2648133
1448: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,
1449: mtl_item_locations loc,
1450: mtl_secondary_inventories sub,
1451: mtl_txn_request_lines mol,
1452: mtl_txn_request_headers moh
1453: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
1454: AND wdtv.organization_id = p_sign_on_org_id
1455: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match
1456: AND NVL(wdtv.cartonization_id, -999) = NVL(l_cartonization_id, NVL(wdtv.cartonization_id, -999))
1795: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,
1796: mtl_item_locations loc,
1797: mtl_secondary_inventories sub,
1798: mtl_txn_request_lines mol,
1799: mtl_txn_request_headers moh
1800: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
1801: AND wdtv.organization_id = p_sign_on_org_id
1802: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match
1803: AND NVL(wdtv.cartonization_id, -999) = NVL(l_cartonization_id, NVL(wdtv.cartonization_id, -999))
2432: GROUP BY utt_emp.standard_operation_id, utt_emp.person_id, utt_emp.effective_start_date, utt_emp.effective_end_date) v,
2433: mtl_item_locations loc,
2434: mtl_secondary_inventories sub,
2435: mtl_txn_request_lines mol,
2436: mtl_txn_request_headers moh
2437: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
2438: AND ((wdtv.pick_slip_number = v_pick_slip_number AND p_task_method = 'DISCRETE')
2439: OR (p_task_method IN ('MANUAL', 'WAVE', 'BULK', 'DISCRETE')
2440: AND wdtv.task_id = v_task_id AND wdtv.wms_task_type_id = v_task_type)
2921: GROUP BY utt_emp.standard_operation_id, utt_emp.person_id, utt_emp.effective_start_date, utt_emp.effective_end_date) v,
2922: mtl_item_locations loc,
2923: mtl_secondary_inventories sub,
2924: mtl_txn_request_lines mol,
2925: mtl_txn_request_headers moh
2926: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
2927: AND ((wdtv.pick_slip_number = v_pick_slip_number AND p_task_method = 'DISCRETE')
2928: OR (p_task_method IN ('MANUAL', 'WAVE', 'BULK', 'DISCRETE')
2929: AND wdtv.task_id = v_task_id AND wdtv.wms_task_type_id = v_task_type)
7737: mtl_item_locations_kfv loc
7738: , --changed to kfv bug#2742611
7739: mtl_secondary_inventories sub
7740: , mtl_txn_request_lines mol
7741: , mtl_txn_request_headers moh
7742: , -- mtl_system_items msi -- bug 2648133
7743: wsh_delivery_details_ob_grp_v wdd
7744: , -- added
7745: wsh_delivery_assignments_v wda --added
7898: mtl_item_locations_kfv loc
7899: , --changed to kfv bug#2742611
7900: mtl_secondary_inventories sub
7901: , mtl_txn_request_lines mol
7902: , mtl_txn_request_headers moh
7903: -- mtl_system_items msi -- bug 2648133
7904: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
7905: AND wdtv.organization_id = p_sign_on_org_id
7906: AND wdtv.wms_task_type_id = 1 -- restrict to picking tasks
8058: mtl_item_locations_kfv loc
8059: , --changed to kfv bug#2742611
8060: mtl_secondary_inventories sub
8061: , mtl_txn_request_lines mol
8062: , mtl_txn_request_headers moh
8063: , -- mtl_system_items msi -- bug 2648133
8064: wsh_delivery_details_ob_grp_v wdd
8065: , -- added
8066: wsh_delivery_assignments_v wda --added
8218: mtl_item_locations_kfv loc
8219: , --changed to kfv bug#2742611
8220: mtl_secondary_inventories sub
8221: , mtl_txn_request_lines mol
8222: , mtl_txn_request_headers moh
8223: -- mtl_system_items msi -- bug 2648133
8224: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
8225: AND wdtv.organization_id = p_sign_on_org_id
8226: AND wdtv.wms_task_type_id = 1 -- restrict to picking tasks
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
8352: , -- mtl_system_items msi -- bug 2648133
8353: wsh_delivery_details_ob_grp_v wdd
8354: , -- added
8355: wsh_delivery_assignments_v wda --added
8454: mtl_item_locations_kfv loc
8455: , --changed to kfv bug#2742611
8456: mtl_secondary_inventories sub
8457: , mtl_txn_request_lines mol
8458: , mtl_txn_request_headers moh
8459: , -- mtl_system_items msi -- bug 2648133
8460: wsh_delivery_details_ob_grp_v wdd
8461: , -- added
8462: wsh_delivery_assignments_v wda --added
8589: , mtl_item_locations_kfv loc
8590: , --changed to kfv bug#2742611
8591: mtl_secondary_inventories sub
8592: , mtl_txn_request_lines mol
8593: , mtl_txn_request_headers moh
8594: -- mtl_system_items msi -- bug 2648133
8595: WHERE wdt.transaction_temp_id = wdtv.task_id
8596: AND wdt.status in ( 2,3) -- Queued and dispatched tasks only bug 4310093
8597: AND wdt.person_id = p_sign_on_emp_id
8686: mtl_item_locations_kfv loc
8687: , --changed to kfv bug#2742611
8688: mtl_secondary_inventories sub
8689: , mtl_txn_request_lines mol
8690: , mtl_txn_request_headers moh
8691: -- mtl_system_items msi -- bug 2648133
8692: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
8693: AND wdtv.organization_id = p_sign_on_org_id
8694: AND wdtv.wms_task_type_id = 1 -- restrict to picking tasks
8819: , mtl_item_locations_kfv loc
8820: , --changed to kfv bug#2742611
8821: mtl_secondary_inventories sub
8822: , mtl_txn_request_lines mol
8823: , mtl_txn_request_headers moh
8824: , -- mtl_system_items msi -- bug 2648133
8825: wsh_delivery_details_ob_grp_v wdd
8826: , -- added
8827: wsh_delivery_assignments_v wda --added
8926: mtl_item_locations_kfv loc
8927: , --changed to kfv bug#2742611
8928: mtl_secondary_inventories sub
8929: , mtl_txn_request_lines mol
8930: , mtl_txn_request_headers moh
8931: , -- mtl_system_items msi -- bug 2648133
8932: wsh_delivery_details_ob_grp_v wdd
8933: , -- added
8934: wsh_delivery_assignments_v wda --added
9051: , mtl_item_locations_kfv loc
9052: , --changed to kfv bug#2742611
9053: mtl_secondary_inventories sub
9054: , mtl_txn_request_lines mol
9055: , mtl_txn_request_headers moh
9056: -- mtl_system_items msi -- bug 2648133
9057: WHERE wdt.transaction_temp_id = wdtv.task_id
9058: AND wdt.status = 2 -- Queued tasks only
9059: AND wdt.person_id = p_sign_on_emp_id
9150: mtl_item_locations_kfv loc
9151: , --changed to kfv bug#2742611
9152: mtl_secondary_inventories sub
9153: , mtl_txn_request_lines mol
9154: , mtl_txn_request_headers moh
9155: -- mtl_system_items msi -- bug 2648133
9156: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
9157: AND wdtv.organization_id = p_sign_on_org_id
9158: AND wdtv.wms_task_type_id = 1 -- restrict to picking tasks
9283: , mtl_item_locations_kfv loc
9284: , --changed to kfv bug#2742611
9285: mtl_secondary_inventories sub
9286: , mtl_txn_request_lines mol
9287: , mtl_txn_request_headers moh
9288: , -- mtl_system_items msi -- bug 2648133
9289: wsh_delivery_details_ob_grp_v wdd
9290: , -- added
9291: wsh_delivery_assignments_v wda --added
9388: mtl_item_locations_kfv loc
9389: , --changed to kfv bug#2742611
9390: mtl_secondary_inventories sub
9391: , mtl_txn_request_lines mol
9392: , mtl_txn_request_headers moh
9393: , -- mtl_system_items msi -- bug 2648133
9394: wsh_delivery_details_ob_grp_v wdd
9395: , -- added
9396: wsh_delivery_assignments_v wda --added
9520: , mtl_item_locations_kfv loc
9521: , --changed to kfv bug#2742611
9522: mtl_secondary_inventories sub
9523: , mtl_txn_request_lines mol
9524: , mtl_txn_request_headers moh
9525: -- mtl_system_items msi -- bug 2648133
9526: WHERE wdt.transaction_temp_id = wdtv.task_id
9527: AND wdt.status in ( 2,3) -- Queued and dispatched tasks only bug 4310093
9528: AND wdt.person_id = p_sign_on_emp_id
9618: mtl_item_locations_kfv loc
9619: , --changed to kfv bug#2742611
9620: mtl_secondary_inventories sub
9621: , mtl_txn_request_lines mol
9622: , mtl_txn_request_headers moh
9623: -- mtl_system_items msi -- bug 2648133
9624: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
9625: AND wdtv.organization_id = p_sign_on_org_id
9626: AND wdtv.wms_task_type_id = 1 -- restrict to picking tasks
9747: , mtl_item_locations_kfv loc
9748: , --changed to kfv bug#2742611
9749: mtl_secondary_inventories sub
9750: , mtl_txn_request_lines mol
9751: , mtl_txn_request_headers moh
9752: , -- mtl_system_items msi -- bug 2648133
9753: wsh_delivery_details_ob_grp_v wdd
9754: , -- added
9755: wsh_delivery_assignments_v wda --added
9852: mtl_item_locations_kfv loc
9853: , --changed to kfv bug#2742611
9854: mtl_secondary_inventories sub
9855: , mtl_txn_request_lines mol
9856: , mtl_txn_request_headers moh
9857: , -- mtl_system_items msi -- bug 2648133
9858: wsh_delivery_details_ob_grp_v wdd
9859: , -- added
9860: wsh_delivery_assignments_v wda --added
9976: , mtl_item_locations_kfv loc
9977: , --changed to kfv bug#2742611
9978: mtl_secondary_inventories sub
9979: , mtl_txn_request_lines mol
9980: , mtl_txn_request_headers moh
9981: -- mtl_system_items msi -- bug 2648133
9982: WHERE wdt.transaction_temp_id = wdtv.task_id
9983: AND wdt.status = 2 -- Queued tasks only
9984: AND wdt.person_id = p_sign_on_emp_id
10074: mtl_item_locations_kfv loc
10075: , --changed to kfv bug#2742611
10076: mtl_secondary_inventories sub
10077: , mtl_txn_request_lines mol
10078: , mtl_txn_request_headers moh
10079: -- mtl_system_items msi -- bug 2648133
10080: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
10081: AND wdtv.organization_id = p_sign_on_org_id
10082: AND wdtv.wms_task_type_id = 1 -- restrict to picking tasks
11120: -- changed for patchset J bulk picking -----------
11121: IF p_move_order_header_id <> -1 THEN
11122: SELECT move_order_type
11123: INTO l_move_order_type
11124: FROM mtl_txn_request_headers
11125: WHERE header_id = p_move_order_header_id;
11126:
11127: if (l_debug = 1) then print_debug('Move order type:'||l_move_order_type,4);
11128: end if;
11596: AND mol.header_id = p_move_order_header_id
11597: AND mmtt.wms_task_type NOT IN(5, 6)
11598: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation
11599: AND( EXISTS(SELECT 1
11600: FROM mtl_txn_request_headers moh, wsh_pick_grouping_rules spg
11601: WHERE spg.pick_grouping_rule_id = moh.grouping_rule_id
11602: AND spg.pick_method = '4'
11603: AND moh.header_id = mol.header_id)
11604: OR EXISTS(SELECT 1
11696: AND mol.header_id = p_move_order_header_id
11697: AND mmtt.wms_task_type NOT IN(5, 6)
11698: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation
11699: AND( EXISTS(SELECT 1
11700: FROM mtl_txn_request_headers moh, wsh_pick_grouping_rules spg
11701: WHERE spg.pick_grouping_rule_id = moh.grouping_rule_id
11702: AND spg.pick_method = '4'
11703: AND moh.header_id = mol.header_id)
11704: OR EXISTS(SELECT 1
11759: x_return_status := fnd_api.g_ret_sts_success;
11760:
11761: SELECT move_order_type
11762: INTO l_move_order_type
11763: FROM mtl_txn_request_headers
11764: WHERE header_id = p_move_order_header_id;
11765:
11766: IF l_move_order_type = g_move_order_mfg_pick THEN
11767: OPEN task_list_wip;