387: AND mcch.organization_id = p_sign_on_org_id -- Bug 13796753
388: AND NVL(mcch.disable_date,sysdate+1)> sysdate
389: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) qt,
390: mtl_txn_request_lines mol,
391: mtl_secondary_inventories sub,
392: mtl_item_locations loc,
393: (SELECT
394: bsor.standard_operation_id,
395: bre.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,
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
690: and mmtt1.cartonization_id = mmtt.cartonization_id)
691: )
692: ) qt,
693: mtl_txn_request_lines mol,
694: mtl_secondary_inventories sub,
695: mtl_item_locations loc,
696: (SELECT
697: bsor.standard_operation_id,
698: bre.resource_id,
768: and mmtt1.cartonization_id = mmtt.cartonization_id)
769: )
770: ) qt,
771: mtl_txn_request_lines mol,
772: mtl_secondary_inventories sub,
773: mtl_item_locations loc,
774: (SELECT
775: bsor.standard_operation_id,
776: bre.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,
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
1031: ---------------------------
1032:
1033: AND NVL(mcch.disable_date,sysdate+1)> sysdate
1034: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) qt,
1035: mtl_secondary_inventories sub,
1036: mtl_item_locations loc,
1037: (SELECT
1038: bsor.standard_operation_id,
1039: bre.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,
1137: mtl_item_locations loc,
1138: mtl_secondary_inventories sub
1139: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
1140: AND wdtv.organization_id = p_sign_on_org_id
1141: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match
1142: AND wdtv.zone = p_sign_on_zone -- removed NVL, bug 2648133
1295: ---------------------------
1296: AND NVL(mcch.disable_date,sysdate+1)> sysdate
1297: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) qt,
1298: mtl_txn_request_lines mol,
1299: mtl_secondary_inventories sub,
1300: mtl_item_locations loc,
1301: (SELECT
1302: bsor.standard_operation_id,
1303: bre.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,
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
1597: and mmtt1.cartonization_id = mmtt.cartonization_id)
1598: )
1599: ) qt,
1600: mtl_txn_request_lines mol,
1601: mtl_secondary_inventories sub,
1602: mtl_item_locations loc,
1603: (SELECT
1604: bsor.standard_operation_id,
1605: bre.resource_id,
1674: and mmtt1.cartonization_id = mmtt.cartonization_id)
1675: )
1676: ) qt,
1677: mtl_txn_request_lines mol,
1678: mtl_secondary_inventories sub,
1679: mtl_item_locations loc,
1680: (SELECT
1681: bsor.standard_operation_id,
1682: bre.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,
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
1930: AND mcce.organization_id = mcch.organization_id -- Bug 13796753
1931: AND mcch.organization_id = p_sign_on_org_id -- Bug 13796753
1932: AND NVL(mcch.disable_date,sysdate+1)> sysdate
1933: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) qt,
1934: mtl_secondary_inventories sub,
1935: mtl_item_locations loc,
1936: (SELECT
1937: bsor.standard_operation_id,
1938: bre.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,
2036: mtl_item_locations loc,
2037: mtl_secondary_inventories sub
2038: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
2039: AND wdtv.organization_id = p_sign_on_org_id
2040: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match
2041: AND NVL(wdtv.cartonization_id, -999) = NVL(l_cartonization_id, NVL(wdtv.cartonization_id, -999))
2227:
2228: AND NVL(mcch.disable_date,sysdate+1)> sysdate
2229: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) qt,
2230: mtl_txn_request_lines mol,
2231: mtl_secondary_inventories sub,
2232: mtl_item_locations loc,
2233: (SELECT
2234: bsor.standard_operation_id,
2235: bre.resource_id,
2430: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)
2431: AND NVL(utt_eqp.inventory_item_id, -999) = NVL(l_sign_on_equipment_id, NVL(utt_eqp.inventory_item_id, -999)) --Modified for Case Picking Project + Picking ER (FP 7709357)
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')
2623: and mmtt1.cartonization_id = mmtt.cartonization_id)
2624: )
2625: ) qt,
2626: mtl_txn_request_lines mol,
2627: mtl_secondary_inventories sub,
2628: mtl_item_locations loc,
2629: (SELECT
2630: bsor.standard_operation_id,
2631: bre.resource_id,
2750: and mmtt1.cartonization_id = mmtt.cartonization_id)
2751: )
2752: ) qt,
2753: mtl_txn_request_lines mol,
2754: mtl_secondary_inventories sub,
2755: mtl_item_locations loc,
2756: (SELECT
2757: bsor.standard_operation_id,
2758: bre.resource_id,
2919: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)
2920: AND NVL(utt_eqp.inventory_item_id, -999) = NVL(l_sign_on_equipment_id, NVL(utt_eqp.inventory_item_id, -999)) --Modified for Case Picking Project + Picking ER (FP 7709357)
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')
3099: ---------------------------
3100:
3101: AND NVL(mcch.disable_date,sysdate+1)> sysdate
3102: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) qt,
3103: mtl_secondary_inventories sub,
3104: mtl_item_locations loc,
3105: (SELECT
3106: bsor.standard_operation_id,
3107: bre.resource_id,
3222: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)
3223: AND NVL(utt_eqp.inventory_item_id, -999) = NVL(l_sign_on_equipment_id, NVL(utt_eqp.inventory_item_id, -999)) --Modified for Case Picking Project + Picking ER (FP 7709357)
3224: GROUP BY utt_emp.standard_operation_id, utt_emp.person_id, utt_emp.effective_start_date, utt_emp.effective_end_date) v,
3225: mtl_item_locations loc,
3226: mtl_secondary_inventories sub
3227: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
3228: AND (wdtv.task_id = v_task_id AND wdtv.wms_task_type_id = v_task_type)
3229: AND wdtv.organization_id = p_sign_on_org_id
3230: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match
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
4832: , -- inlined wms_person_resource_utt_v, bug 2648133
4833: mtl_item_locations loc
4834: , mtl_secondary_inventories sub
4835: , mtl_txn_request_lines mol
4836: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
4837: AND wdtv.organization_id = p_sign_on_org_id
4838: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks
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
4986: , -- inlined wms_person_resource_utt_v, bug 2648133
4987: mtl_item_locations loc
4988: , mtl_secondary_inventories sub
4989: , mtl_txn_request_lines mol
4990: -- mtl_system_items msi -- bug 2648133
4991: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
4992: AND wdtv.organization_id = p_sign_on_org_id
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
5142: , -- inlined wms_person_resource_utt_v, bug 2648133
5143: mtl_item_locations loc
5144: , mtl_secondary_inventories sub
5145: , mtl_txn_request_lines mol
5146: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
5147: AND wdtv.organization_id = p_sign_on_org_id
5148: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks
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
5295: , -- inlined wms_person_resource_utt_v, bug 2648133
5296: mtl_item_locations loc
5297: , mtl_secondary_inventories sub
5298: , mtl_txn_request_lines mol
5299: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
5300: AND wdtv.organization_id = p_sign_on_org_id
5301: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks
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
5448: , -- inlined wms_person_resource_utt_v, bug 2648133
5449: mtl_item_locations loc
5450: , mtl_secondary_inventories sub
5451: , mtl_txn_request_lines mol
5452: -- mtl_system_items msi -- bug 2648133
5453: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
5454: AND wdtv.organization_id = p_sign_on_org_id
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
5602: , -- inlined wms_person_resource_utt_v, bug 2648133
5603: mtl_item_locations loc
5604: , mtl_secondary_inventories sub
5605: , mtl_txn_request_lines mol
5606: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
5607: AND wdtv.organization_id = p_sign_on_org_id
5608: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks
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
5755: , -- inlined wms_person_resource_utt_v, bug 2648133
5756: mtl_item_locations loc
5757: , mtl_secondary_inventories sub
5758: , mtl_txn_request_lines mol
5759: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
5760: AND wdtv.organization_id = p_sign_on_org_id
5761: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks
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
5906: , -- inlined wms_person_resource_utt_v, bug 2648133
5907: mtl_item_locations loc
5908: , mtl_secondary_inventories sub
5909: , mtl_txn_request_lines mol
5910: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
5911: AND wdtv.organization_id = p_sign_on_org_id
5912: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks
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
6054: , -- inlined wms_person_resource_utt_v, bug 2648133
6055: mtl_item_locations loc
6056: , mtl_secondary_inventories sub
6057: , mtl_txn_request_lines mol
6058: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
6059: AND(wdtv.pick_slip_number = v_pick_slip_number
6060: OR(wdtv.task_id = v_task_id
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
6205: , -- inlined wms_person_resource_utt_v, bug 2648133
6206: mtl_item_locations loc
6207: , mtl_secondary_inventories sub
6208: , mtl_txn_request_lines mol
6209: -- mtl_system_items msi -- bug 2648133
6210: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
6211: AND(wdtv.pick_slip_number = v_pick_slip_number
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
6356: , -- inlined wms_person_resource_utt_v, bug 2648133
6357: mtl_item_locations loc
6358: , mtl_secondary_inventories sub
6359: , mtl_txn_request_lines mol
6360: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
6361: AND(wdtv.pick_slip_number = v_pick_slip_number
6362: OR(wdtv.task_id = v_task_id
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
6506: , -- inlined wms_person_resource_utt_v, bug 2648133
6507: mtl_item_locations loc
6508: , mtl_secondary_inventories sub
6509: , mtl_txn_request_lines mol
6510: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
6511: AND(wdtv.pick_slip_number = v_pick_slip_number
6512: OR(wdtv.task_id = v_task_id
7735: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
7736: , -- inlined wms_person_resource_utt_v, bug 2648133
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
7896: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
7897: , -- inlined wms_person_resource_utt_v, bug 2648133
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
8056: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
8057: , -- inlined wms_person_resource_utt_v, bug 2648133
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
8216: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
8217: , -- inlined wms_person_resource_utt_v, bug 2648133
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
8345: AND br.resource_type = 1
8346: AND bsor.resource_id = br.resource_id) e
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
8452: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
8453: , -- inlined wms_person_resource_utt_v, bug 2648133
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
8587: AND br.resource_type = 1
8588: AND bsor.resource_id = br.resource_id) e
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
8684: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
8685: , -- inlined wms_person_resource_utt_v, bug 2648133
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
8817: AND br.resource_type = 1
8818: AND bsor.resource_id = br.resource_id) e
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
8924: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
8925: , -- inlined wms_person_resource_utt_v, bug 2648133
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
9049: AND br.resource_type = 1
9050: AND bsor.resource_id = br.resource_id) e
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
9148: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
9149: , -- inlined wms_person_resource_utt_v, bug 2648133
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
9281: AND br.resource_type = 1
9282: AND bsor.resource_id = br.resource_id) e
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
9386: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
9387: , -- inlined wms_person_resource_utt_v, bug 2648133
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
9518: AND br.resource_type = 1
9519: AND bsor.resource_id = br.resource_id) e
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
9616: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
9617: , -- inlined wms_person_resource_utt_v, bug 2648133
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
9745: AND br.resource_type = 1
9746: AND bsor.resource_id = br.resource_id) e
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
9850: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
9851: , -- inlined wms_person_resource_utt_v, bug 2648133
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
9974: AND br.resource_type = 1
9975: AND bsor.resource_id = br.resource_id) e
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
10072: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
10073: , -- inlined wms_person_resource_utt_v, bug 2648133
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
12154: AND NVL(mmtt.fulfillment_base,'P') = 'P'
12155: AND(l_bulk_pick_control = WMS_GLOBALS.BULK_PICK_ENTIRE_WAVE
12156: -- if bulk picking is not disabled and not pick entire wave only the honor sub/item is left, so no need to check l_bulk_pick_control, only need to check the sub/item flag
12157: OR EXISTS(SELECT 1 -- sub is bulk picking enabled
12158: FROM mtl_secondary_inventories msi
12159: WHERE msi.secondary_inventory_name = mmtt.subinventory_code
12160: AND msi.organization_id = mmtt.organization_id
12161: AND msi.enable_bulk_pick= 'Y')
12162: OR EXISTS(SELECT 1 -- item is bulk picking enabled
12235: AND NVL(mmtt.fulfillment_base,'P') = 'P'
12236: AND(l_bulk_pick_control = WMS_GLOBALS.BULK_PICK_ENTIRE_WAVE
12237: -- if bulk picking is not disabled and not pick entire wave only the honor sub/item is left, so no need to check l_bulk_pick_control, only need to check the sub/item flag
12238: OR EXISTS(SELECT 1 -- sub is bulk picking enabled
12239: FROM mtl_secondary_inventories msi
12240: WHERE msi.secondary_inventory_name = mmtt.subinventory_code
12241: AND msi.organization_id = mmtt.organization_id
12242: AND msi.enable_bulk_pick= 'Y')
12243: OR EXISTS(SELECT 1 -- item is bulk picking enabled
13187: , l_item_prim_uom_code
13188: , l_lot_control_code
13189: , l_serial_number_control_code
13190: , l_item_sec_uom_code
13191: FROM wms_cartonization_temp mmtt, mtl_item_locations mil, mtl_secondary_inventories msi, mtl_system_items item
13192: WHERE mmtt.transaction_temp_id = p_task_id
13193: AND mmtt.locator_id = mil.inventory_location_id(+)
13194: AND mmtt.organization_id = mil.organization_id(+)
13195: AND mmtt.subinventory_code = msi.secondary_inventory_name