[Home] [Help]
2428: CURSOR wct_rows IS
2429: SELECT wct.*
2430: FROM wms_cartonization_temp wct
2431: , mtl_txn_request_lines mtrl
2432: , mtl_secondary_inventories sub
2433: , mtl_parameters mtlp
2434: WHERE wct.move_order_line_id = mtrl.line_id
2435: AND mtrl.header_id = p_move_order_header_id
2436: AND wct.cartonization_id IS NULL
3722: AND ( l_bulk_pick_control = WMS_GLOBALS.BULK_PICK_ENTIRE_WAVE
3723: -- If bulk picking is not disabled and not pick entire wave only the honor sub/item is left,
3724: -- so no need to check l_bulk_pick_control, only need to check the sub/item flag
3725: OR EXISTS( SELECT 1 -- sub is bulk picking enabled
3726: FROM mtl_secondary_inventories msi
3727: WHERE msi.secondary_inventory_name = mmtt.subinventory_code
3728: AND msi.organization_id = mmtt.organization_id
3729: AND msi.enable_bulk_pick= 'Y' )
3730: OR EXISTS( SELECT 1 -- item is bulk picking enabled
3799: AND ( l_bulk_pick_control = WMS_GLOBALS.BULK_PICK_ENTIRE_WAVE
3800: -- if bulk picking is not disabled and not pick entire wave only the honor sub/item is left,
3801: -- so no need to check l_bulk_pick_control, only need to check the sub/item flag
3802: OR EXISTS( SELECT 1 -- sub is bulk picking enabled
3803: FROM mtl_secondary_inventories msi
3804: WHERE msi.secondary_inventory_name = mmtt.subinventory_code
3805: AND msi.organization_id = mmtt.organization_id
3806: AND msi.enable_bulk_pick= 'Y' )
3807: OR EXISTS( SELECT 1 -- item is bulk picking enabled
4330: , l_lot_control_code
4331: , l_serial_number_control_code
4332: FROM mtl_material_transactions_temp mmtt
4333: , mtl_item_locations mil
4334: , mtl_secondary_inventories msi
4335: , mtl_system_items item
4336: WHERE mmtt.transaction_temp_id = p_mmtt_temp_id
4337: AND mmtt.locator_id = mil.inventory_location_id(+)
4338: AND mmtt.organization_id = mil.organization_id(+)