[Home] [Help]
349: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
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,
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
509: AND wdtv.organization_id = p_sign_on_org_id
652: and mmtt1.cartonization_id = mmtt.cartonization_id)
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,
730: and mmtt1.cartonization_id = mmtt.cartonization_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,
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
858: AND wdtv.organization_id = p_sign_on_org_id
993: ---------------------------
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,
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
1104: AND wdtv.zone = p_sign_on_zone -- removed NVL, bug 2648133
1257: ---------------------------
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,
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
1416: AND wdtv.organization_id = p_sign_on_org_id
1559: and mmtt1.cartonization_id = mmtt.cartonization_id)
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,
1636: and mmtt1.cartonization_id = mmtt.cartonization_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,
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
1763: AND wdtv.organization_id = p_sign_on_org_id
1890: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
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,
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
2001: AND NVL(wdtv.cartonization_id, -999) = NVL(l_cartonization_id, NVL(wdtv.cartonization_id, -999))
2185:
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,
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
2375: AND ((wdtv.pick_slip_number = v_pick_slip_number AND p_task_method = 'DISCRETE')
2530: and mmtt1.cartonization_id = mmtt.cartonization_id)
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,
2639: and mmtt1.cartonization_id = mmtt.cartonization_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,
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
2796: AND ((wdtv.pick_slip_number = v_pick_slip_number AND p_task_method = 'DISCRETE')
2939: ---------------------------
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,
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
3068: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match
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
4499: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks
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
4653: AND wdtv.organization_id = p_sign_on_org_id
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
4809: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks
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
4962: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks
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
5115: AND wdtv.organization_id = p_sign_on_org_id
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
5269: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks
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
5422: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks
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
5573: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks
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
5721: OR(wdtv.task_id = v_task_id
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
5872: AND(wdtv.pick_slip_number = v_pick_slip_number
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
6023: OR(wdtv.task_id = v_task_id
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
6173: OR(wdtv.task_id = v_task_id
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
7403: , -- mtl_system_items msi -- bug 2648133
7404: wsh_delivery_details_ob_grp_v wdd
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
7564: -- mtl_system_items msi -- bug 2648133
7565: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
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
7724: , -- mtl_system_items msi -- bug 2648133
7725: wsh_delivery_details_ob_grp_v wdd
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
7884: -- mtl_system_items msi -- bug 2648133
7885: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
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
8013: , -- mtl_system_items msi -- bug 2648133
8014: wsh_delivery_details_ob_grp_v wdd
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
8120: , -- mtl_system_items msi -- bug 2648133
8121: wsh_delivery_details_ob_grp_v wdd
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
8255: -- mtl_system_items msi -- bug 2648133
8256: WHERE wdt.transaction_temp_id = wdtv.task_id
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
8352: -- mtl_system_items msi -- bug 2648133
8353: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
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
8485: , -- mtl_system_items msi -- bug 2648133
8486: wsh_delivery_details_ob_grp_v wdd
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
8592: , -- mtl_system_items msi -- bug 2648133
8593: wsh_delivery_details_ob_grp_v wdd
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
8717: -- mtl_system_items msi -- bug 2648133
8718: WHERE wdt.transaction_temp_id = wdtv.task_id
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
8816: -- mtl_system_items msi -- bug 2648133
8817: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
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
8949: , -- mtl_system_items msi -- bug 2648133
8950: wsh_delivery_details_ob_grp_v wdd
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
9054: , -- mtl_system_items msi -- bug 2648133
9055: wsh_delivery_details_ob_grp_v wdd
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
9186: -- mtl_system_items msi -- bug 2648133
9187: WHERE wdt.transaction_temp_id = wdtv.task_id
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
9284: -- mtl_system_items msi -- bug 2648133
9285: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
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
9413: , -- mtl_system_items msi -- bug 2648133
9414: wsh_delivery_details_ob_grp_v wdd
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
9518: , -- mtl_system_items msi -- bug 2648133
9519: wsh_delivery_details_ob_grp_v wdd
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
9642: -- mtl_system_items msi -- bug 2648133
9643: WHERE wdt.transaction_temp_id = wdtv.task_id
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
9740: -- mtl_system_items msi -- bug 2648133
9741: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
11716: or mmtt.serial_allocated_flag is null)
11717: AND(l_bulk_pick_control = WMS_GLOBALS.BULK_PICK_ENTIRE_WAVE
11718: -- 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
11719: OR EXISTS(SELECT 1 -- sub is bulk picking enabled
11720: FROM mtl_secondary_inventories msi
11721: WHERE msi.secondary_inventory_name = mmtt.subinventory_code
11722: AND msi.organization_id = mmtt.organization_id
11723: AND msi.enable_bulk_pick= 'Y')
11724: OR EXISTS(SELECT 1 -- item is bulk picking enabled
11788: or mmtt.serial_allocated_flag is null)
11789: AND(l_bulk_pick_control = WMS_GLOBALS.BULK_PICK_ENTIRE_WAVE
11790: -- 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
11791: OR EXISTS(SELECT 1 -- sub is bulk picking enabled
11792: FROM mtl_secondary_inventories msi
11793: WHERE msi.secondary_inventory_name = mmtt.subinventory_code
11794: AND msi.organization_id = mmtt.organization_id
11795: AND msi.enable_bulk_pick= 'Y')
11796: OR EXISTS(SELECT 1 -- item is bulk picking enabled
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